Difference between revisions of "Manuals/calci/cumprinc"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
*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 | *CUMIPMT shows the ERROR value when | ||
| − | <math>R\le 0</math> | + | 1. Interest Rate<math>(R)\le 0</math> |
| − | <math> | + | 2. Payment Periods <math>(PP)\le 0</math> |
| − | <math> | + | 3. Present Value<math>(PV)\le 0</math> |
| − | <math> | + | 4. Start Period<math>(SP)\lt 1</math> |
| − | <math>EP\lt 1</math> | + | 5. End Period<math>(EP)\lt 1</math> |
| − | <math>SP \gt EP</math> | + | 6. <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 04:57, 24 February 2014
CUMPRINC(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.
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
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}
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
=CUMPRINC(0.03/12,B3*12,B4,13,24,0)
CUMPRINC returns -11046.6464.
Consider another example
=CUMPRINC(0.02/12,10*12,200000,10,20,1)
CUMPRINC returns -16939.2946.