Microsoft Office Tutorials and References
In Depth Information
Using CUMPRINC to Calculate Total Principal Paid in Any Range of Periods
CUMPRINC tto Calculate
Paid iin Any
Range oof Periods
The corollary to CUMIPMT is CUMPRINC, a function to calculate the total
principal paid during any range of periods of a loan.
The CUMPRINC function returns the cumulative principal paid on a loan
between start_periodand end_period. This function takes the following argu-
rate — This is the interest rate.
nper — This is the total number of payment periods.
• ppv — This is the present value.
start_period — This is the first period in the calculation. Payment
periods are numbered beginning with 1.
end_period — This is the last period in the calculation.
type — This is either 0 or 1 to indicate when payments are due. The de-
fault value of 0 assumes that payments are due at the end of the
period. A value of 1 means the payments are due at the beginning of
The nper, start_period, end_period, and typearguments are truncated to in-
tegers. If rateis less than or equal to 0, nperis less than or equal to 0, or pv
is less than or equal to 0, CUMPRINC returns a #NUM! error. If start_period
is less than 1, end_periodis less than 1, or start_periodis greater than
end_period, CUMPRINC returns a #NUM! error. If typeis any number other
than 0 or 1, CUMPRINC returns a #NUM! error.
Refer to Figure 13.8 for an example of CUMPRINC.
The algorithm behind the CUMPRINC function is new and more accurate
in Excel 2013. Be aware that Excel 2007 and Excel 2013 might produce
different results for some uses of CUMPRINC.