Description
Use the five metrics outlined in the “Is the stock market overvalued?” video to determine if you believe the market is overvalued.
Discuss the S&P 500 current p/e ratio, the Shiller p/e ratio, the earnings yield on the S&P 500, graph the index price level for the past 10-years, and the long-term implied return of the market.
Download the monthly prices at finance.yahoo.com for the s&p 500 index and then graph the price level for the ten-year period 10-28-2011 through 10-29-2021). (https://finance.yahoo.com/quote/%5EGSPC?p=%5EGSPC (Links to an external site.)). What do you see?
Please provide your answer and calculations if necessary in excel. Please comment on your findings in the excel file.
You will want to use the following websites:
i. multipl.com (Links to an external site.)
ii. buffet index https://currentmarketvaluation.com/models/buffett-indicator.php (Links to an external site.)
iv. CNBC https://www.cnbc.com/quotes/US10Y?qsearchterm= (Links to an external site.)