Formulas and Functions

96
The nancial functions help you work with cash ows,
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 nancial 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 ows for an assumed par value of $100.
“BONDMDURATION” (page 104) The BONDMDURATION function calculates the
modied weighted average of the present value
of the cash ows 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