Below are the segment financial data reported by Disney: (1) Forecast Revenues for FY 2022E using the 2014-2018 CAGR. Hint: Forecasting 2022E Revenues 4 years out may be calculated as Last Year x (1+CAGR)^4. (2) Forecast the EBIT Margin for FY 2022E by applying the average expansion rate to the FY 2018 actual figures. Hint: The expansion rate is the average increase or decrease in the percentage each year. Hint: If the Margin is 10% for the last actual year and the expansion rate is +1%, the margin two years later would be (2 x 1%) + 10% = 12%. (3) Forecast EBIT for FY 2022E by multiplying the Revenue forecast by the EBIT Margin Forecast. (4) Calculate the EBIT percentages (easy!). Voila! You have created a forecast like a working financial analyst. (On Wall Street, a Disney analyst might not simply apply the recent trend but would add a perspective that might accelerate, decelerate or reverse the trend.) EXHIBIT: DISNEY CORP. BY SEGMENT FY 2018 FY 2017 FY 2016 FY 2015 FY 2014 2014-2018 CAGR FY 2022E Revenues Revenues Media Networks Cable Networks Broadcasting Parks and Resorts Studio Entertainment Consumer Products Total 24,500 17,063 7,437 20,296 9,987 4,651 83,934 23,510 16,527 6,983 18,415 8,379 4,833 78,647 23,689 16,632 7,057 16,974 9,441 5,528 79,321 23,264 16,581 6,683 16,162 7,366 5,673 75,729 21,152 15,110 6,042 15,099 7,278 5,284 69,965 3.7% 3.1% 5.3% 7.7% 8.2% -3.1% -100.0% EBIT EBIT 6,494 6,558 7,321 Media Networks Cable Networks Broadcasting Parks and Resorts Studio Entertainment Consumer Products 5,126 1,368 4,469 2,980 1,632 5,353 1,205 3,774 2,355 1,744 7,158 5,965 1,193 3,298 2,703 1,965 7,793 6,787 1,006 3,031 1,973 1,884 6,467 854 2,663 1,549 1,472 2014-2018 CAGR -3.0% -5.6% 12.5% 13.8% 17.8% 2.6% Below are the segment financial data reported by Disney: (1) Forecast Revenues for FY 2022E using the 2014-2018 CAGR. Hint: Forecasting 2022E Revenues 4 years out may be calculated as Last Year x (1+CAGR)^4. (2) Forecast the EBIT Margin for FY 2022E by applying the average expansion rate to the FY 2018 actual figures. Hint: The expansion rate is the average increase or decrease in the percentage each year. Hint: If the Margin is 10% for the last actual year and the expansion rate is +1%, the margin two years later would be (2 x 1%) + 10% = 12%. (3) Forecast EBIT for FY 2022E by multiplying the Revenue forecast by the EBIT Margin Forecast. (4) Calculate the EBIT percentages (easy!). Voila! You have created a forecast like a working financial analyst. (On Wall Street, a Disney analyst might not simply apply the recent trend but would add a perspective that might accelerate, decelerate or reverse the trend.) EXHIBIT: DISNEY CORP. BY SEGMENT FY 2018 FY 2017 FY 2016 FY 2015 FY 2014 2014-2018 CAGR FY 2022E Revenues Revenues Media Networks Cable Networks Broadcasting Parks and Resorts Studio Entertainment Consumer Products Total 24,500 17,063 7,437 20,296 9,987 4,651 83,934 23,510 16,527 6,983 18,415 8,379 4,833 78,647 23,689 16,632 7,057 16,974 9,441 5,528 79,321 23,264 16,581 6,683 16,162 7,366 5,673 75,729 21,152 15,110 6,042 15,099 7,278 5,284 69,965 3.7% 3.1% 5.3% 7.7% 8.2% -3.1% -100.0% EBIT EBIT 6,494 6,558 7,321 Media Networks Cable Networks Broadcasting Parks and Resorts Studio Entertainment Consumer Products 5,126 1,368 4,469 2,980 1,632 5,353 1,205 3,774 2,355 1,744 7,158 5,965 1,193 3,298 2,703 1,965 7,793 6,787 1,006 3,031 1,973 1,884 6,467 854 2,663 1,549 1,472 2014-2018 CAGR -3.0% -5.6% 12.5% 13.8% 17.8% 2.6%