Calculate the price of the stock at 9/30/2021 based on the 3 market multiples. Incorporate growth rates from sales, cfps and sps from the historical data in order to do this.

Market Multiple Analysis

Create a market multiple analysis for Disney (5 years historical)

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

 

Calculate the price of the stock at 9/30/2021 based on the 3 market multiples. Incorporate growth rates from sales, cfps and sps from the historical data in order to do this.
Scroll to top