Formulas and Functions

If you would like to know This function may be helpful
The eective annual interest rate for a bond that
pays interest only at its maturity (no periodic
payments, but the bond does have a coupon
rate)
“INTRATE” (page 12 2 )
The expected purchase price of a bond that pays
periodic interest, a bond sold at a discount that
does not pay interest, or a bond that pays interest
only at maturity
“PRICE” (page 137 ) , “PRICEDISC” (page 13 8 ), and
“PRICEMAT” (page 140)
The amount received on a bond that pays
interest only at its maturity (no periodic
payments, but the bond does have a coupon
rate), including interest
“RECEIVED” (page 14 6)
The eective annual interest rate of a bond that
pays periodic interest, a bond sold at a discount
that does not pay interest, or a bond that pays
interest only at maturity
“YIELD” (page 150), “ YIELDDISC” (page 15 2 ), and
“YIELDMAT” (page 15 3 )
Depreciation
The periodic amount of depreciation of an asset
using the xed-declining balance method
“DB” (page 114 )
The periodic depreciation of an asset using a
declining balance method such as “double-
declining balance”
“DDB” (page 116 )
The periodic depreciation of an asset using the
straight-line method
“SLN” (page 147 )
The periodic depreciation of an asset using the
sum-of-the-years-digits method
“SYD” (page 148)
The total depreciation over a given period for
an asset depreciated using a declining balance
method
“VDB” (page 149)
352 Chapter 13 Additional Examples and Topics