Question: First find the Treasury Bills ( note you will need to select the link on the page to see them ) that mature on ,

First find the Treasury Bills (note you will need to select the link on the page to see them) that mature on, or closest to the dates in cells C4 and C5 of the spreadsheet. Insert their respective YTMs in cells J4 and J5. From the Treasury Notes and Bonds Quotes, find the Notes and Bonds that mature on or closest to the dates in cells C6 C23. For each of them, type their coupon rates into cells D6 D26 and thir prices into cells F6 F23. If more than one Treasury can be used, choose the one which is priced closest to par value. From the data on your spreadsheet, please answer the following questions: a. What is the price of a bootstrapped 2.2%(coupon rate)10-year Treasury Note? b. What is the YTM of the Treasury Note in question a? c. Price a 10-year 2.2% corporate bond so that it has a 50-basis point credit spread over the Treasury note you bootstrapped. d. Using the zero-coupon rates (the semiannual z values) that were found in the bootstrapping spreadsheet, find what the YTM would be for a previously-issued Treasury bond that matures in exactly two years and is currently selling at par value. e. Repeat a-d above for a Treasury Note and a corporate bond with a 3.5% coupon rate. f. Look at the Zero BEYs in column J. They could easily be plotted into a yield curve (you do not have to do that here but you can see how it would look based on the values). How would you describe the shape of this yield curve? g. Based on the Unbiased Expectations Theory of the term structure, what does this yield curve tell us about investors expectations over the next ten years?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!