Nominal interest rates and yield curves a recent study of inflationary expectations has revealed that the consensus among economic forecasters yields the following. Average annual rates of inflation expected over the periods noted. (Note: Assume that the risk that future interest rate movements will affect longer maturities more than shorter maturities is zero; that is, assume that there is no maturity risk.

Period	Average Annual Rate Of Inflation
3 Months	5%
2 Months	6%
5 Months	8%
10 Months	8.5%
20 Months	9%

a. If the real rate of interest is currently 2.5%, find the nominal rate of interest on each of the following U.S. Treasury issues: 20-year bond, 3-month bill, 2-yearnote, and 5-year bond.

b. If the real rate of interest suddenly dropped to 2% without any change in inflationary expectations, what effect, if any, would it have on your answers in part a? Explain.

c. Using your findings in part a, draw a yield curve for U.S. Treasury securities. Describe the general shape and expectations reflected by the curve. Most Important Part Is Drawling the Curve

d. What would a follower of the liquidity preference theory say about how the preferences of lenders and borrowers tend to affect the shape of the yield curve drawn in part c?

Illustrate that effect by placing on your graph a dotted line that approximates the yield curve without the effect of liquidity preference. - Most Important Part Is Drawling the Curve With A Dotted Line

e. What would a follower of the market segmentation theory say about the supply and demand for long-term loans versus the supply and demand for short-term loans given the yield curve constructed for part c of this problem?

I need help with drawing out the curves from part C and D in excel.