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 C and C of the spreadsheet. Insert their respective YTMs in cells J and J From the Treasury Notes and Bonds Quotes, find the Notes and Bonds that mature on or closest to the dates in cells C C For each of them, type their coupon rates into cells D D and thir prices into cells F F 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 coupon rateyear Treasury Note? b What is the YTM of the Treasury Note in question a c Price a year corporate bond so that it has a basis point credit spread over the Treasury note you bootstrapped. d Using the zerocoupon rates the semiannual z values that were found in the bootstrapping spreadsheet, find what the YTM would be for a previouslyissued Treasury bond that matures in exactly two years and is currently selling at par value. e Repeat ad above for a Treasury Note and a corporate bond with a 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
