Apple iWork '09 - Manual (Page 135)

Chapter 6 Financial Functions 135
Related Topics
For related functions and additional information, see:
“FV” on page 120
“IPMT” on page 123
“NPER” on page 130
“PPMT” on page 135
“PV” on page 141
“RATE” on page 144
“Example of a Loan Amortization Table” on page 353
“Choosing Which Time Value of Money Function to Use” on page 348
“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
PPMT
The PPMT function returns the principal portion of a specified loan or annuity
payment based on fixed periodic payments and a fixed interest rate.
PPMT(periodic-rate, period, num-periods, present-value, future-value, 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%).
 period: The payment period for which you want to calculate the amount of
principal or interest. period is a number and must be greater than 0.
 num-periods: The number of periods. num-periods is a number value and must be
greater than or equal to 0.