Filter
Top Products
Bond Worksheet 51
4
Bond Worksheet
Note: Pressing # or " to navigate through the Bond worksheet before
you enter values causes an error (Error 6). To clear the error, press P.
(See “Error Messages
” on page 94.)
The Bond worksheet lets you compute bond price, yield to
maturity or call, and accrued interest.
You can also use the date functions to price bonds
purchased on dates other than the coupon anniversary.
• To access the Bond worksheet, press & l.
• To access bond variables, press " or #.
• To change the options for day-count methods (
ACT
and 360) and coupons per year (2/Y and 1/Y), press &
V once for each option.