Loading ...
Loading ...
Loading ...
Bond Worksheet 51
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.")
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.
Loading ...
Loading ...
Loading ...