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₍₂₀₁₉₎* (1+g)²

Price = Average P/CFPS ratio x current CFPS ₍₂₀₁₉₎*(1+g)²

Price = Average P/SPS ratio x current SPS ₍₂₀₁₉₎*(1+g)²

You can use Yahoo Finance to find data for the 5 years (2015-2019) data as 2020 is skewed due to the coronavirus effects.

Please create and upload an excel spreadsheet showing your inputs and results.

Thank you!!