Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 12 O pts Given the AB, for the 11/15/39 T-Bond in response to a 102 bps increase in yields, show: (3pt) a) How much

image text in transcribed
image text in transcribed
Question 12 O pts Given the AB, for the 11/15/39 T-Bond in response to a 102 bps increase in yields, show: (3pt) a) How much of the bond price change is due to duration? Show the formula with inputs and solution in proper percentage format. b) How much of the bond price change is due to convexity? Show the formula with inputs and solution in proper percentage format. Given: The convexity of the 11/15/39 T-Bond - 118.9216 L A Conditional Formatting v Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Idea G14 F G Ask Yield 3.26 d., 3.95 A B C D E 1 Today is 5/15/2018 2 Table 3.3 Treasury Bond 3 Maturity Coupon Bid Asked Chg 5/15/21 4 4.25 102.5585 102.8077 -0.21 5 11/15/39 6.50 137.4301 137.7822 0.12 6 7 8 Table 3.4 Excel Duration Function 9 DURATION( settlement, maturity, coupons, yld, frequemcy, (basis]) 10 Before you write the formula identify all Inputs 11 Settlement: enter today's date as serial date number 43235 12 Maturity: enter maturity date as serial date number 44331 13 Coupons: enter annual coupon rate 14 yld: enter the bond's current annual YTM 15 Frequency: # times interest is paid per year = 16 Basis: Counting Convention # 17 18 19 20 Table 3.5 Convexity Template 21 5 22 PVCF Time-Weight Date CFL CF 23 (1+i)* (t+t)*CF 24 11/15/18 25 5/15/19 26 11/15/19 27 5/15/20 28 11/15/20 29 5/15/21 30 31 32 6 PV of TWCF (4) * (5) Question 12 O pts Given the AB, for the 11/15/39 T-Bond in response to a 102 bps increase in yields, show: (3pt) a) How much of the bond price change is due to duration? Show the formula with inputs and solution in proper percentage format. b) How much of the bond price change is due to convexity? Show the formula with inputs and solution in proper percentage format. Given: The convexity of the 11/15/39 T-Bond - 118.9216 L A Conditional Formatting v Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Idea G14 F G Ask Yield 3.26 d., 3.95 A B C D E 1 Today is 5/15/2018 2 Table 3.3 Treasury Bond 3 Maturity Coupon Bid Asked Chg 5/15/21 4 4.25 102.5585 102.8077 -0.21 5 11/15/39 6.50 137.4301 137.7822 0.12 6 7 8 Table 3.4 Excel Duration Function 9 DURATION( settlement, maturity, coupons, yld, frequemcy, (basis]) 10 Before you write the formula identify all Inputs 11 Settlement: enter today's date as serial date number 43235 12 Maturity: enter maturity date as serial date number 44331 13 Coupons: enter annual coupon rate 14 yld: enter the bond's current annual YTM 15 Frequency: # times interest is paid per year = 16 Basis: Counting Convention # 17 18 19 20 Table 3.5 Convexity Template 21 5 22 PVCF Time-Weight Date CFL CF 23 (1+i)* (t+t)*CF 24 11/15/18 25 5/15/19 26 11/15/19 27 5/15/20 28 11/15/20 29 5/15/21 30 31 32 6 PV of TWCF (4) *

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Control For Construction

Authors: Chris March

1st Edition

0415371155, 978-0415371155

More Books

Students also viewed these Finance questions