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 orn 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? Treasuries are the funds or revenue of a government, corporation, or institution Research treasury yields and complete the table to the right. Then use the data to create an Yield xcel graph of the treasury yields. Use the current month & nearest day for each year rea 10 year 1 year (T-bill)1 year(T-not (T-note)10 (T-bond)30 5 year 30 year year year Insert graph of Treasury prices 2007-2019 note note 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? ans 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 orn 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? Treasuries are the funds or revenue of a government, corporation, or institution Research treasury yields and complete the table to the right. Then use the data to create an Yield xcel graph of the treasury yields. Use the current month & nearest day for each year rea 10 year 1 year (T-bill)1 year(T-not (T-note)10 (T-bond)30 5 year 30 year year year Insert graph of Treasury prices 2007-2019 note note 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? ans
