Case Analysis

profileArod229
ForecastandPro-FormaIncomeStatement.xlsx

ECONOMIC FORECAST US

HISTORY Forecast
% Change, year over year unless noted otherwise 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
GDP and Components
Real GDP 2.5 2.9 1.6 2.4 2.9 2.3 -8.3 2.9 7.6 3.3
Real Consumer spending 3 3.7 2.7 2.6 3 2.6 -4.7 1.9 5.1 3.5
Real Consumer spending, durable goods 1.2 7.5 6.1 6.9 6.3 4.7 -21 -3.8 6 3.6
Real consumer spending, nondurable goods 2.6 3.4 2.4 2.5 3 3.3 -2.7 3.5 5.2 3
Real consumer spending, services 2.4 3.2 2.3 2 2.5 2.1 1.3 1.7 1.8 2
Real investment in private housing 3.8 10.2 6.5 3.5 -1.5 -1.5 -33.7 0.4 43.2 8.6
Real fixed business investment 7.2 1.8 0.7 4.4 6.4 2.1 -24.6 5.9 19.4 7.4
Real inventory accumulation 86 132 23 32 48 65 -207 -10 150 95
Real exports of goods and services 4.2 0.5 0 3.5 3 0 -3.7 3.5 3.4 3
Real imports of goods and services 5 5.3 2 4.7 4.4 1 -5.1 4.3 4.5 3.9
Real government consumption and investment -0.9 1.9 1.8 0.7 1.7 2.3 1.7 -0.1 0.2 0.4
Real federal government consumption and investment -2.6 -0.1 0.4 0.8 2.9 3.5 2.5 -1 -0.4 -0.4
Real state and local government consumption and investment 0.2 3.2 2.6 0.6 1.6 1.2 0.4 0.8 0.8 0.8
Prices
Consumer Price index 1.6 0.1 1.3 2.1 2.4 1.8 1 1.7 3.8 2
Chained price index for personal consumption expenditures 1.5 0.2 1 1.8 2.1 1.4 0.7 1.5 3.7 2
Chained GDP price index 1.8 1 1 1.9 2.4 1.8 1.4 1.8 4.4 2
Employment cost index 2.1 2.1 2.2 2.5 2.8 2.8 0.9 0.2 5.5 4.3
Labor markets
Average monthly charge in employment (thousands) 214 240 210 188 192 170 -212 -88 382 207
Unemployment rate (percent) 6.2 5.3 4.9 4.3 3.9 3.7 6.5 7.5 4.9 3.8
Employment to population (percent) 59 59.3 59.7 60.1 60.4 60.8 59.3 58.3 56.7 60.2
Income and wealth
Real disposable income 4.1 4.1 1.8 2.9 4 3 -0.9 0.8 3.4 2.7
Net household wealth (US $ trillions) 88 91 97 105 106 119 92 101 110 101
Personal saving rate (percent of disposable income) 7.3 7.6 6.8 7 7.7 8 11.2 10.3 9.1 8.6
After-tax corporate profits with corporate with inventory valuation and capital consumption adjustments 5.4 -2.8 -2.4 -0.3 3.4 -0.2 -42.4 10.6 48.6 3.1
Housing
Housing starts (thousands) 1000 1107 1178 1209 1250 1298 868 829 1165 1247
Stock of owner-occupied homes (millions) 134 135 136 137 138 140 141 141 142 143
Interest rate on 30-year fixed rate mortgages (percent) 4.17 3.85 3.65 3.99 4.54 3.94 3.59 3.4 3.45 4.22
Foreign trade
Current account balance, share of GDP (Percent) -2.1 -2.2 -2.3 -2.3 -2.4 -2.3 -1.8 -1.5 -1.9 -2.2
Merchandize trade balance (US $ billions) -727 -737 -735 -797 -878 -862 -791 -885 -1034 -1131
Relative unit labor costs (index,2008=100) 89.3 100.4 102.7 104.2 102.6 106.2 115.1 107.7 102.6 103.5
Financial
Federal funds(percent) 0.13 0.14 0.39 0.97 1.78 2.16 0.42 0.13 0.13 0.75
Yield on 10-year Treasury note (percent) 2.54 2.14 1.84 2.33 2.91 2.14 1.22 1.56 1.99 2.5
Government
Federal budget balance, unified basis (share of GDP, Percent) -2.9 -2.6 -2.9 -3.5 -3.9 -4.5 -6.2 -7.8 -6.5 -5.6
Sources: Historical data: US government agencies and Oxford Economics. Forecast: Deloitte, using Oxford Global Economic Model
References
https://www2.deloitte.com/us/en/insights/economy/us-economic-forecast/united-states-outlook-analysis.html

Entertainment Industry Forecast

Entertainment Industry Forecast in the United States
Year Market Value in US Trillion $
2014 1.7
2015 1.8
2016 1.9
2017 2
2018 2.1
2019 2.2
2020 2.3
2021 2.4
2022 2.5
2023 2.6
References
https://www.sec.gov/Archives/edgar/data/1001039/000100103914000228/fy2014_q4x10k.htm
https://www.sec.gov/Archives/edgar/data/1001039/000100103916000516/fy2016_q4x10k.htm
https://www.sec.gov/Archives/edgar/data/1001039/000100103917000198/fy2017_q4x10k.htm
https://www.sec.gov/Archives/edgar/data/1001039/000100103918000187/fy2018_q4x10k.htm

Disney Company

Sales forecast
Year Sales ($ in millions)
2014 48813
2015 52465
2016 55632
2017 55137
2018 59434
2019 69570
2020 75813.333333334
2021 84651.7777777798
2022 91760.1481481511
2023 100021.901234573
PROFORMA INCOME STATEMENT
Year 2014 2015 2016 2017 2018 2019
Sales ($ in millions) 48813 52465 55632 55137 59434 69570
Cost of revenues, exclusive of depreciation and amortization 28731 31099 32619 33152 35660 46298
Gross profit 20082 21366 23013 21985 23774 23272
Expenses 12581 12984 13622 13005 11176 12218
Income after tax 7501 8382 9391 8980 12598 11054
PROFORMA BALANCE SHEET
Year 2014 2015 2016 2017 2018 2019
Current Assets 15169 16758 16966 15889 16825 28124
Investments 2696 2643 4280 3202 2899 3224
Longterm Assets 68972 71424 75067 79900 81773 165860
Total Assets 84141 88182 92033 95789 98598 193984
Liabilities and Stock Holders Equity
Total Liabilities 36008 39527 44710 49637 44643 91132
Total Equity 48178 48655 47323 45004 52832 93889
Total Liabilities and equity 84141 88182 92033 95789 98598 193984
References
https://www.sec.gov/Archives/edgar/data/1001039/000100103914000228/fy2014_q4x10k.htm
https://www.sec.gov/Archives/edgar/data/1001039/000100103916000516/fy2016_q4x10k.htm
https://www.sec.gov/Archives/edgar/data/1001039/000100103917000198/fy2017_q4x10k.htm
https://www.sec.gov/Archives/edgar/data/1001039/000100103918000187/fy2018_q4x10k.htm