Begin by downloading the Excel file containing the spot rates for various maturities. These are yields on Treasury STRIPS as quoted by the Wall Street Journal at http://www.wsj.com/mdc/public/page/2_3020- tstrips.html. The goal of this assignment will be to analyze a bond issued by Proctor & Gamble. The bond has a 5% coupon (paid semiannually), $1000 par amount, and matures in February of 2030. Assume that the coupon in February 2017 has already passed, and the next coupon is exactly 6 months away. The Word file should be a standalone document that fully answers the following questions, while the Excel file should contain all associated calculations. The Excel file should be constructed in a way that you can easily change the characteristics of the bond, and all subsequent calculations will reflect the change (in other words, use cell references). 1. Plot the Spot rate curve against the rates for Treasury curve found at https://www.treasury.gov/resource-center/data-chart-center/interestrates/Pages/TextView.aspx?data=yield. The curve only needs to include maturities up to 10 years. You can assume that the maturities of the quoted Treasuries align perfectly with the maturities of the quoted spot rates (so, for example, the 10-year treasury matures on 2/1/2027). a. Include the [clearly labeled] plot in the Word document. b. Discuss the two curves. Specifically: i. What is driving the current shape of the curves? ii. How are the spot rates different from the yields, and why? 2. Using the spot rate curve, find the price and yield to maturity of the above bond issued by PG. You may assume that the bond is of similar risk to Treasury securities. a. Include a [clearly labeled] table in the Word document that contains the price, YTM, and, from the following question, Macaulay and Modified Durations, and the price impact of the change in rates. b. Discuss the bonds price and yield. Specifically, i. If it is trading at a premium or discount, explain why. ii. Explain the conditions under which an investor would realize the yield to maturity for this particular bond. 3. Find the Macauley and Modified Durations of the bond, using the present values derived in question 2. a. Interpret the durations, clearly explaining what information an investor should take from each. b. Use the duration to estimate the impact to the bonds price of a 75 bp decrease in interest rates. Explain in the text the accuracy of this number. c. Plot the price impacts of changes in yield ranging from -200 bp to +200 bp (you can do this at intervals of 10bp). Include the plot in the Word document. Discuss the plot. Specifically, i. What is the shape of the plot? ii. Is this an accurate representation of price impact? Why or why not?

***I know this is against the rules of multiple question, but I am completly lost and any help would be amazing***