please help me to do these questions!!!
Interest Rates and Stock Market Performance Instructions: Research the following questions about interest rates and stock market performance. Be sure all parts of the questions (1 a,b.c,d,e and 2 a,b.c). Submit the Excel spreadsheet to Assignments on Canvas no later than 6:05 pm on the due date. Yahoo! Finance, Microsoft Money, and the Daily Treasury Yield Curve are good places to search for this type of information on the web. 1. Treasury yields a. What are treasuries? ans b. Research treasury yields and complete the table to the right. Then use the data to create an excel graph of the treasury yields. Use the current month & nearest day for each year: Treasury Yield (%) year 5 year 10 year 30 year Insert graph of Treasury prices 2007 - 2019 (T-bill) T-note (T-note) (T-bond) 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 c. What has happened to treasury yields (and market interest rates) over the past twelve years? ans d. Why have treasury and interest rates changed? (Are the changes in interest rates good for investors? Are they good for businesses and consumers who want to borrow money?) ans e. Why are long-term rates higher than short-term rates? ans2. Stocks a. What are the following: S&P 500 Index? ans The Dow Jones Index? ans The Wilshire 5000 Index? ans b. Pick three public companies and research their prices, as well as the value of the S&P Index. Complete the table to the right. Then use the data to create an excel graph of the 3 stocks you chose. Use the current month & nearest day for each year: Stock Price ($) Company 1 Company 2 Company 3 Name / Stock Name / Stock Name / Stock S&P 500 Index Insert graph of your 3 stocks' price 2007 - 2019; don't include the S&P index in the graph Symbol Symbol Symbol 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 c. What is the growth rate of each of your stocks and the S&P 500 index over the past 12 years? Did the stocks underperform or beat the market (as measured by the S&P 500 index)? Were your stocks' growth rates better or worse than the S&P 500 Index? Why? d. Why has happened to the prices of each of the companies you chose over the past 12 years? What happened during the financial crisis of 2008? Why? What has happened since then? At the end of 2018 the stock market had its worst year in ten years, was that true of the stocks you picked? Why? Stock 1 Stock 2 Stock 3