I need help with a Excel question. All explanations and answers will be used to help me learn.
For the Yield Curve tab
1.Plot a yield curve for each year between 2004 – 2020 and display on one graph.
2.Indicate the shape of the yield curve for each year, i.e., Normal, Inverted, or Flat.
For the Zero-Coupon tab
1.Calculate the series of one-year forward rates for each year between 2004 – 2020, i.e., 2f1, 3f1, 4f1, 5f1, 6f1, 7f1, 8f1, 9f1, 10f1.
2.Plot the series of one-year forward rates and display on one graph. 3.Indicate for each forward-rate curve, the expected direction of future short-term rates, i.e., Increasing, Decreasing, Constant.