1. Create a market multiple analysis for Disney (5 years historical)
2. Calculate the price of the stock at 9/30/2021 based on the 3 market multiples. You will have to incorporate growth rates from sales, cfps and sps from the historical data in order to do this.
Price = Average P/EPS ratio x current EPS(2019)* (1+g)2
Price = Average P/CFPS ratio x current CFPS (2019)*(1+g)2
Price = Average P/SPS ratio x current SPS (2019)*(1+g)2
use Yahoo Finance to find data for the 5 years suggest using the 2015-2019 data as 2020 is skewed due to the coronavirus effects.
Create and upload an excel spreadsheet showing your inputs and results
