Let’s find the term structure of interest rate. Find interest rates in different maturities, 3 month, 3 year, 5year, 10 year, 20 year Treasury yields from January of 2006 and December of 2007 (Select monthly data as a frequency). 1) Plot them in excel, and explain the changes of the term structure interest rates for the periods (copy and paste the graph with your answers).
2) Find a month when the future short term interest rates expected to rise and a month when the future short term interest rates expected to fall. Explain the term structure of interest rates using the liquidity premium theory for the months you chose. 3. Select any 5 stocks, and find their annual rate of return from the end of December 2018 to the end of December 2019. You need to choose at least 2 stocks that had dividends. The data can be found from Yahoo.com and the history price can be found under finance section
Please fix the following input errors:
