Apple iWork '09 User Manual
Page 97
Chapter 6
Financial Functions
97
Function
Description
“COUPDAYSNC” (page 108)
The COUPDAYSNC function returns the number
of days between the settlement date and the end
of the coupon period in which settlement occurs.
The COUPNUM function returns the number
of coupons remaining to be paid between the
settlement date and the maturity date.
The CUMIPMT function returns the total interest
included in loan or annuity payments over a
chosen time interval based on fixed periodic
payments and a fixed interest rate.
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.
The DB function returns the amount of
depreciation of an asset for a specified period
using the fixed-declining balance method.
The DDB function returns the amount of
depreciation of an asset based on a specified
depreciation rate.
The DISC function returns the annual discount
rate of a security that pays no interest and is sold
at a discount to its redemption value.
The EFFECT function returns the effective annual
interest rate from the nominal annual interest
rate based on the number of compounding
periods per year.
The FV function returns the future value of an
investment 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 INTRATE function returns the effective annual
interest rate for a security that pays interest only
at maturity.
The IPMT function returns the interest portion
of a specified loan or annuity payment based on
fixed, periodic payments and a fixed interest rate.
The IRR function returns the internal rate of
return for an investment that is based on a series
of potentially irregular cash flows that occur at
regular time intervals.