Microsoft Office Tutorials and References
In Depth Information
Using CUMPRINC to Calculate Total Principal Paid in Any Range of Periods
Using
Using CUMPRINC
CUMPRINC tto Calculate
Calculate Total
Total Principal
Principal Paid
Paid iin Any
Any Range
Range oof Periods
Periods
The corollary to CUMIPMT is CUMPRINC, a function to calculate the total
principal paid during any range of periods of a loan.
Syntax
CUMPRINC(rate,nper,pv,start_period,end_period,type)
The CUMPRINC function returns the cumulative principal paid on a loan
between start_periodand end_period. This function takes the following argu-
ments:
rate
rate This is the interest rate.
nper
nper This is the total number of payment periods.
ppv This is the present value.
start_period
start_period This is the first period in the calculation. Payment
periods are numbered beginning with 1.
end_period
end_period This is the last period in the calculation.
type
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
each period.
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.
Caution
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.
Search JabSto ::

Custom Search