beautypg.com

Cumprinc, 112 cumprinc – Apple iWork '09 User Manual

Page 112

background image

Related Topics
For related functions and additional information, see:

“CUMPRINC” on page 112

“IPMT” on page 123

“PMT” on page 134

“PPMT” on page 135

“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 fixed periodic payments and a fixed
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: Specifies whether payments are due at the beginning or end of each
period.

112

Chapter 6

Financial Functions