CUMPRINC(rate, nper, pv, start_period, end_period, type)

Returns the cumulative principal paid on a loan between two dates.

rateThe fixed interest rate per period.
nperThe total number of payments.
pvThe present value of the loan.
start_periodThe first period in the calculation.
end_periodThe last period in the calculation.
typeThe number indicating when the payments are due:
0 = the end of the period
1 = the start of the period

Remarks

* The "rate" and "nper" must have the same units.
* Payment periods are numbered beginning with 1.
* If "rate" <= 0 then #NUM! is returned.
* If "nper" is not an integer, it is truncated.
* If "nper" <= 0, then #NUM! is returned.
* If "pv" <= 0, then #NUM! is returned.
* If "start_period" is not an integer, it is truncated.
* If "start_period" < 1, then #NUM! is returned.
* If "end_period" is not an integer, it is truncated.
* If "end_period" < 1, then #NUM! is returned.
* If "start_period" > "end_period", then #NUM! is returned.
* If "type" is not an integer, it is truncated.
* If "type" is any number other than 0 or 1, then #NUM! is returned.
* In Excel 2010 the accuracy of this function was improved.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=CUMPRINC(0.0075,360,125000,13,24,0) = -934.107
2=CUMPRINC(0.0075,360,125000,1,1,0) = -68.278

1 - If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top