Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribed

please help me to do these questions!!!

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Managerial Finance

Authors: Scott Besley, Eugene F. Brigham

14th edition

324422709, 324422702, 978-0324422702

More Books

Students also viewed these Finance questions

Question

=+What conclusions about the additive and car types do you draw?

Answered: 1 week ago

Question

T F Running a business always strengthens marriages.

Answered: 1 week ago