Difference between revisions of "Manuals/calci/cumipmt"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
<div style="font-size:30px">'''CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)'''</div><br/>
+
<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 05: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.

See Also

References

CUMIPMT