Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''CUMIPMT(R, | + | <div style="font-size:30px">'''CUMIPMT(R,PP,PV,SP,EP,Type)'''</div><br/> |
*<math>R</math> is the interest rate. | *<math>R</math> is the interest rate. | ||
*<math>PP</math> is the total number of payment periods. | *<math>PP</math> is the total number of payment periods. |
Revision as of 04:59, 24 February 2014
CUMIPMT(R,PP,PV,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 (unknown function "\gt"): {\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.