Apple iWork '09 User Manual
Page 98
Function
Description
The ISPMT function returns the interest portion
of a specified loan or annuity payment based
on fixed, periodic payments and a fixed interest
rate. This function is provided for compatibility
with tables imported from other spreadsheet
applications.
The MIRR function returns the modified internal
rate of return for an investment that is based on
a series of potentially irregular cash flows that
occur at regular time intervals. The rate earned on
positive cash flows and the rate paid to finance
negative cash flows can differ.
The NOMINAL function returns the nominal
annual interest rate from the effective
annual interest rate based on the number of
compounding periods per year.
The NPER function returns the number of
payment periods for a loan or annuity based on a
series of regular periodic cash flows (payments of
a constant amount and all cash flows at constant
intervals) and a fixed interest rate.
The NPV function returns the net present value
of an investment based on a series of potentially
irregular cash flows that occur at regular time
intervals.
The PMT function returns the fixed periodic
payment for a loan or annuity based on a series
of regular periodic cash flows (payments of a
constant amount and all cash flows at constant
intervals) and a fixed interest rate.
The PPMT function returns the principal portion
of a specified loan or annuity payment based on
fixed periodic payments and a fixed interest rate.
The PRICE function returns the price of a
security that pays periodic interest per $100 of
redemption (par) value.
“PRICEDISC” (page 138)
The PRICEDISC function returns the price of a
security that is sold at a discount to redemption
value and does not pay interest per $100 of
redemption (par) value.
“PRICEMAT” (page 140)
The PRICEMAT function returns the price of a
security that pays interest only at maturity per
$100 of redemption (par) value.
98
Chapter 6
Financial Functions