Question

As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future

As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future macroeconomic conditions as wells as the course of future short-term interest rates, your presentation will consist of the following:


-Plot the yield curve for each year between 2006 – 2020 and display these data on one graph.


-For each year indicate the shape of the yield curve, i.e., Normal, Inverted, or Flat.


-Calculate and plot the series of one-year forward rates for each year between 2006 –2020, i.e., 2f13f1, 4f15f16f17f18f19f110f1 – the presentation must include your forward rate estimates.


-For each forward-rate curve indicate the expected direction of future short-term rates, i.e., Increasing, Decreasing, Constant.


To complete this assignment, one of your colleagues has provided you with the attached spreadsheet that contains year-end, constant-maturity and zero-coupon yields from 2006 –2020. These data are published by the board go governors of the federal reserve system and represents “constant maturity” and zero coupon yields that are interpolated by the U.S.Treasury from the daily yield curve for non-inflation-indexed Treasury securities. These yields are based on the closing market bid yields on actively traded Treasury securities in the over-the-counter market. These market yields are calculated from composites of quotations obtained by the Federal Reserve Bank of New York.


Yield Curve


DATE1-mo3-mo1-yr2-yr5-yr7-yr10-yr20-yr30-yr
20065.025.105.114.974.914.934.995.175.07
20075.13
4.964.854.564.604.674.785.004.92
20081.551.682.272.523.25
3.563.994.634.59
20090.140.180.481.132.533.133.524.294.31
20100.140.150.290.551.602.302.943.743.98
20110.160.100.200.361.352.092.823.774.12
20120.070.110.160.230.600.981.512.212.56
20130.030.040.11
0.311.382.002.603.343.64
20140.010.030.120.531.762.242.583.073.32
20150.040.80.330.671.541.932.202.612.92
20160.190.280.500.671.031.291.461.782.18
20171.001.071.231.341.842.112.302.662.89
20181.942.032.442.672.852.922.963.033.08
20192.012.082.001.89
1.841.922.022.312.53
2020
0.090.09
0.11
0.11
0.21
0.39
0.55
0.98
1.20
20210.050.060.070.190.691.001.241.811.89
20222.202.42
2.932.852.692.692.683.233.02
 


Zero Coupon

DATE1-yr2-yr3-yr4-yr5-yr6-yr7-yr8-yr9-yr10-yr
2006

5.1635

5.18355.13775.08645.05205.03975.04835.07415.11325.1622
20074.8784
4.90024.88344.86824.86864.88714.92174.96925.02635.0901
20082.26622.65212.95433.20363.41823.60883.78203.94174.09054.2304
20090.5512

1.1007

1.64712.14282.57682.95293.27903.56393.81524.0390
20100.27970.6227
1.04801.47101.86062.20922.51852.79333.03903.2602
20110.15030.4936
0.94581.40261.82482.20202.53532.82983.09153.3258
20120.19430.3222
0.48080.65140.82500.99711.16551.32931.48801.6416
20130.14970.4218
0.75911.09901.41771.70851.97202.21082.42852.6282
20140.17710.5144
0.87801.22581.54421.83132.08992.32382.53692.7324
20150.33440.7300
1.05901.34081.58861.81102.01412.20172.3768
2.5413
20160.48190.6571
0.77920.88550.99121.10131.21651.33581.45781.5812
20171.26851.4671
1.60211.71471.82231.93142.04372.15872.27552.3929
20182.33222.5592
2.63152.65292.66782.69292.73262.78622.85132.9252
20191.95691.8037
1.72021.69231.70631.75101.81761.89941.99142.0902
20200.19180.1988
0.20070.22090.26480.3303041340.50980.61550.7275
20210.1279

0.2882

0.46090.63690.81180.98351.15081.31341.47101.6236
20222.70633.10883.19133.15773.09813.04873.02123.01703.03323.0662


Help ASAP please and thank you so much in advance 

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
As the junior analyst for an investment management firm, you have been assigned to prepare a presentation for clients regarding the term structure of interest rates. Because the shape of the term structure of interest rates is often used to predict future
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT