Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
Line 22: | Line 22: | ||
==Examples== | ==Examples== | ||
− | |||
=CUMIPMT(0.03/12,12*12,12000,13,24,0) | =CUMIPMT(0.03/12,12*12,12000,13,24,0) | ||
-322.8066039 | -322.8066039 | ||
− | |||
=CUMIPMT(0.02/12,10*12,200000,10,20,1) | =CUMIPMT(0.02/12,10*12,200000,10,20,1) | ||
-3269.9831. | -3269.9831. | ||
+ | ==See Also== | ||
+ | *[[Manuals/calci/cumprinc | CUMPRINC]] | ||
+ | *[[Manuals/calci/couppcd | COUPPCD]] | ||
+ | *[[Manuals/calci/coupncd | COUPNCD]] | ||
==References== | ==References== | ||
[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_function CUMIPMT] | [https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_function CUMIPMT] |
Revision as of 04:41, 24 February 2014
CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)
- is the interest rate.
- is the total number of payment periods.
- is the present value.
- is the Start period beginning with 1.
- is the End period.
- is the timing of the payment.
Description
- This function gives the cumulative interest paid on a loan between and .
- CUMIPMT shows the ERROR value when
1. Interest Rate 2. Payment Periods 3. Present Value 4. Start PeriodFailed to parse (unknown function "\lt"): {\displaystyle (SP)\lt 1} 5. End PeriodFailed to parse (unknown function "\lt"): {\displaystyle (EP)\lt 1} 6. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SP \gt EP}
- should be 0 or 1.
TYPE TIMIING 0 Payment at the end of the period 1 Payment at the beginning of the period
Examples
=CUMIPMT(0.03/12,12*12,12000,13,24,0)
-322.8066039
=CUMIPMT(0.02/12,10*12,200000,10,20,1)
-3269.9831.