The CUMPRINC function calculates the cumulative principal paid on a loan between two periods. It can be a very handy function and is relatively straightforward.

CUMPRINC takes 5 required arguments and 1 optional argument:

Syntax: CUMPRINC(rate, nper, pv, start_period, end_period, [type])

#1)
Using the CUMPRINC function:
#2)
Using the CUMPRINC function to calculate the interest for a single period:
#3)
The arguments for the CUMPRINC function are:
Argument Required? Description
rate Required The interest rate.
nper Required The total number of payment periods.
pv Required The present value.
start_period Required The first period in the calculation. Payment periods are numbered beginning with 1.
end_period Required The last period in the calculation.
type Optional The timing of the payment
#4)
A few more things:
If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMPRINC returns the #NUM! error value.
If start_period < 1, end_period < 1, or start_period > end_period, CUMPRINC returns the #NUM! error value.
If type is any number other than 0 or 1, CUMPRINC returns the #NUM! error value.

Summary

The CUMPRINC function calculates the cumulative principal paid on a loan between two periods.
comments powered by Disqus