Question;This has to be done in excel.a- Suppose you are considering two possible investment opportunities: a 12-year Treasury bond and a 7 year, A-rated corporate bond. The current real risk-free rate is 4 percent, and inflammation is expected to be 2 percent for the next two years, 3 percent for the following 4 years, and 4 percent thereafter. The maturity risk premium is estimated by this formula: MRP = 0.1% (t ? 1). The liquidity premium for the corporate bond is estimated to be 0.7 percent. Finally, you may determine the default risk premium, given the company?s bond rating, from the default risk premium table in the text. What yield would you predict for each of these two investments?b- Given the following Treasury bond yield information from the March 27, 2003, Federal Reserve Statistical Release, construct a graph of the yield curve as of that date.Maturity Yield3 months 1.16 %6 months 1.171 year 1.252 years 1.623 years 2.055 years 2.927 years 3.5010 years 3.9520 years 4.96c- Based on the information about the corporate bond that was given in part a, calculate yields and then construct a new yield curve graph that shows both the Treasury and the corporate bonds.
Paper#47606 | Written in 18-Jul-2015Price : $32