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.