Formulas and Functions

Related Topics
For related functions and additional information, see:
“CUMPRINC” on page 11 2
“IPMT” on page 12 3
“PMT” on page 134
“PPMT” on page 13 5
“Example of a Loan Amortization Table” on page 353
“Common Arguments Used in Financial Functions” on page 341
“Listing of Financial Functions” on page 96
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
CUMPRINC
The CUMPRINC function returns the total principal included in loan or annuity
payments over a chosen time interval based on xed periodic payments and a xed
interest rate.
CUMPRINC(periodic-rate, num-periods, present-value, starting-per, ending-per, cum-when-due)
 periodic-rate: The interest rate per period. periodic-rate is a number value and is
either entered as a decimal (for example, 0.08) or with a percent sign (for example, 8%).
 num-periods: The number of periods. num-periods is a number value and must be
greater than or equal to 0.
 present-value: The value of the initial investment, or the amount of the loan or
annuity. present-value is a number value. At time 0, an amount received is a positive
amount and an amount invested is a negative amount. For example, it could be an
amount borrowed (positive) or the initial payment made on an annuity contract
(negative).
 starting-per: First period to include in the calculation. starting-per is a number value.
 ending-per: Last period to include in the calculation. ending-per is a number value
and must be greater than 0 and greater than starting-per.
 when-due: Species whether payments are due at the beginning or end of each
period.
11 2 Chapter 6 Financial Functions