Chapter 5 Spreadsheet Problem

The Cost of Money (Interest Rates)

The problem requires you to use File C05 on the computer problem spreadsheet.

  1. Assume the expected inflation rates for the next five years are as follows:

Year                          Inflation Rate

1                                       8.0%

2                                       6.0

3                                       4.0

4                                       3.0

5                                       5.0

In Year 6 and thereafter, inflation is expected to be 3 percent. The maturity risk premium (MRP) is 0.1 percent per year to maturity for bonds with maturities greater than six months, with a maximum MRP equal to 2 percent. The real risk-free rate of return is currently 2.5 percent, and it is expected to remain at this level long into the future. Compute the interest rates on Treasury securities with maturities equal to one year, two years, three years, four years, five years, 10 years, 20 years, and 30 years. Draw the yield curve.

  1. Discuss the yield curve that is constructed from the results in part (a).
  2. Rework part (a) assuming one year has passed—that is, today is January 1 of Year 2. All the other information given in part (a) is the same. Rework part (a) again assuming two, three, four, and five years have passed.
  3. Assume that all the information given previously is the same and the default risk premium for corporate bonds rated AAA is 1.5 percent whereas it is 4 percent for corporate bonds rated B. Compute the interest rates on AAA-and B-rated corporate bonds with maturities equal to one year, two years, three years, four years, five years, 10 years, 20 years, and 30 years.

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"