Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
==Description== | ==Description== | ||
− | *This function gives the cumulative interest paid on a loan between <math>SP<math> and <math>EP<math>. | + | *This function gives the cumulative interest paid on a loan between <math>SP</math> and <math>EP</math>. |
*CUMIPMT shows the ERROR value when <math>R\le 0</math>, <math>NPPeriods\le=0</math>, <math>PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>, | *CUMIPMT shows the ERROR value when <math>R\le 0</math>, <math>NPPeriods\le=0</math>, <math>PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>, | ||
*<math>Type</math> should be 0 or 1. | *<math>Type</math> should be 0 or 1. | ||
TYPE TIMIING | TYPE TIMIING | ||
− | |||
0 Payment at the end of the period | 0 Payment at the end of the period | ||
− | |||
1 Payment at the beginning of the period | 1 Payment at the beginning of the period | ||
− | |||
==Examples== | ==Examples== |
Revision as of 07:03, 12 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 first period beginning with 1.
- is the last 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 , , 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 PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>, *<math>Type} 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,B3*12,B4,13,24,0)
CUMIPMT returns -5527.3132.
Consider another example
=CUMIPMT(0.02/12,10*12,200000,10,20,1) CUMIPMT returns -3269.9831.