# CUMPRINC

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 period1 = 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.* You can use the CUMIPMT function to return the cumulative interest paid on a loan between two dates.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.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.