Apple iWork '09 - Manual (Page 96)

96
The financial functions help you work with cash flows,
depreciable assets, annuities, and investments by solving
problems such as the amount of annual depreciation of an
asset, the interest earned on an investment, and the current
market price of a bond.
Listing of Financial Functions
iWork provides these financial functions for use with tables.
Function Description
“ACCRINT” (page 99) The ACCRINT function calculates the accrued
interest added to the purchase price of a security
and paid to the seller when the security pays
periodic interest.
“ACCRINTM” (page 101) The ACCRINTM function calculates the total
accrued interest added to the purchase price of a
security and paid to the seller when the security
pays interest only at maturity.
“BONDDURATION” (page 103) The BONDDURATION function calculates the
weighted average of the present value of the
cash flows for an assumed par value of $100.
“BONDMDURATION” (page 104) The BONDMDURATION function calculates the
modified weighted average of the present value
of the cash flows for an assumed par value of
$100.
“COUPDAYBS” (page 105) The COUPDAYBS function returns the number
of days between the beginning of the coupon
period in which settlement occurs and the
settlement date.
“COUPDAYS” (page 107) The COUPDAYS function returns the number of
days in the coupon period in which settlement
occurs.
6
Financial Functions