Formulas and Functions

Chapter 6 Financial Functions 135
Related Topics
For related functions and additional information, see:
“FV” on page 12 0
“IPMT” on page 12 3
“NPER” on page 13 0
“PPMT” on page 13 5
“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 specied loan or annuity
payment based on xed periodic payments and a xed 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.