4 Bond Worksheet
К оглавлению1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1617 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
51 52 53 54
Note: Pressing # or " to navigate through the Bond worksheet before
you enter values causes an error (Error 6). To clear the error, press P.
The Bond worksheet lets you compute bond price, yield to
maturity or call, accrued interest, and modified duration.
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.
54 Bond Worksheet
Bond Worksheet Variables
Resetting Bond Worksheet Variables
• To reset the Bond worksheet variables to default values, press &
z while in the Bond worksheet.
• To reset all calculator variables and formats to default values,
including the Bond worksheet variables, press &}!.
Variable Key Display Variable Type
Settlement date & l SDT Enter only
Annual coupon rate in percent # CPN Enter only
Redemption date # RDT Enter only
Redemption value (percentage of
par value)
# RV Enter only
Actual/actual day-count method # ACT Setting
30/360 day-count method & V 360 Setting
Two coupons per year # 2/Y Setting
One coupon per year & V 1/Y Setting
Yield to redemption # YLD Enter/compute
Dollar price # PRI Enter/compute
Accrued interest # AI Auto-compute
Modified duration # DUR Auto-compute
Variable Default Variable Default
SDT 12-31-1990 ACT/360 ACT
CPN 0 2/Y, 1/Y 2/Y
RDT 12-31-1990 YLD 0
RV 100 PRI 0
DUR 0 AI 0
Entering Dates
• Use the following convention to key in dates: mm.ddyy or dd.mmyy.
After keying in the date, press !.
Note: You can display dates in either US or European format. (See
“Setting Calculator Formats ” on page 4.)
• You can enter dates from January 1, 1950 through December 31,
2049.
• The calculator assumes that the redemption date (RDT) coincides
with a coupon date:
– To compute to maturity, enter the maturity date for RDT.
– To compute to call, enter the call date for RDT.
Note: Pressing # or " to navigate through the Bond worksheet before
you enter values causes an error (Error 6). To clear the error, press P.
The Bond worksheet lets you compute bond price, yield to
maturity or call, accrued interest, and modified duration.
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.
54 Bond Worksheet
Bond Worksheet Variables
Resetting Bond Worksheet Variables
• To reset the Bond worksheet variables to default values, press &
z while in the Bond worksheet.
• To reset all calculator variables and formats to default values,
including the Bond worksheet variables, press &}!.
Variable Key Display Variable Type
Settlement date & l SDT Enter only
Annual coupon rate in percent # CPN Enter only
Redemption date # RDT Enter only
Redemption value (percentage of
par value)
# RV Enter only
Actual/actual day-count method # ACT Setting
30/360 day-count method & V 360 Setting
Two coupons per year # 2/Y Setting
One coupon per year & V 1/Y Setting
Yield to redemption # YLD Enter/compute
Dollar price # PRI Enter/compute
Accrued interest # AI Auto-compute
Modified duration # DUR Auto-compute
Variable Default Variable Default
SDT 12-31-1990 ACT/360 ACT
CPN 0 2/Y, 1/Y 2/Y
RDT 12-31-1990 YLD 0
RV 100 PRI 0
DUR 0 AI 0
Entering Dates
• Use the following convention to key in dates: mm.ddyy or dd.mmyy.
After keying in the date, press !.
Note: You can display dates in either US or European format. (See
“Setting Calculator Formats ” on page 4.)
• You can enter dates from January 1, 1950 through December 31,
2049.
• The calculator assumes that the redemption date (RDT) coincides
with a coupon date:
– To compute to maturity, enter the maturity date for RDT.
– To compute to call, enter the call date for RDT.