Please assist with problem 19. My teacher provided the spreadsheet that we need to use, but I'm not sure what formulas I need to utilize it.

6-19 INFLATION AND INTEREST RATES In late 1980, the U.S. Commerce Department released new data showing inflation was 15%. At the time, the prime rate of interest was 21%, a record high. However, many investors expected the new Reagan administration to be more effective in controlling inflation than the Carter administration had been. Moreover, many observers believed that the extremely high interest rates and generally tight credit, which resulted from the Federal Reserve System's attempts to curb the inflation rate, would lead to a recession, which, in turn, would lead to a decline in inflation and interest rates. Assume that, at the beginning of 1981, the expected inflation rate for 1981 was 13%; for 1982, 9%; for 1983, 7%; and for 1984 and thereafter, 6%. a. What was the average expected inflation rate over the 5-year period 1981-1985? (Use the arithmetic average.) b. Over the 5-year period, what average nominal interest rate would be expected to pro- duce a 2% real risk-free return on 5-year Treasury securities? Assume MRP = 0. c. Assuming a real risk-free rate of 2% and a maturity risk premium that equals 0.1 X (t)%, where t is the number of years to maturity, estimate the interest rate in January 1981 on bonds that mature in 1, 2, 5, 10, and 20 years. Draw a yield curve based on these data. d. Describe the general economic conditions that could lead to an upward-sloping yield curve. e. If investors in early 1981 expected the inflation rate for every future year to be 10% (i.e., I, = I, ,= 10% for t = 1 to co), what would the yield curve have looked like? Consider all the factors that are likely to affect the curve. Does your answer here make you ques- tion the yield curve you drew in part c?A B C D E F G H Chapter 6 Problem 19 Inflation and Interest Rates US Commerce Department 1980 Inflation 0.1500 Prime rate interest 0.2100 r = r* + IP + DRP + LP + MRP r* 0.0200 MRP =.001* t 0.0010 Years to Expected Inflation maturity Year annual r* premium MRP rt inflation 1981 0.13 1982 0.09 1983 0.07 1984 0.06 1985 0.06 1986 0.06 1 00 1987 0.06 1988 0.06 1989 0.06 10 1990 0.06 11 1991 0.06 12 1992 0.06 13 1993 0.06 14 1994 0.06 15 1995 0.06 16 1996 0.06 17 1997 0.06 18 1998 0.06 19 1999 0.06 20 2000 0.06 After you have finished this analysis and provided your interpretation, clone this worksheet and complete part e on the cloned sheet