CUMPRINC(rate, nper, pv, start_period, end_period, type) 
Returns the cumulative principal paid on a loan between two dates. 
rate  The fixed interest rate per period. 
nper  The total number of payments. 
pv  The present value of the loan. 
start_period  The first period in the calculation. 
end_period  The last period in the calculation. 
type  The 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 addin loaded. * For the Microsoft documentation refer to support.office.com 

1  If you make monthly payments on a fouryear 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