$23,510 $23,689 $23,264 18,415 16,974 16,162 Revenues Media Networks Parks and Resorts Studio Entertainment Third parties Intersegment 7,887 6,838 8,701 740 492 528 7,366 8,379 9,441 Consumer Products Third parties Intersegment 5,325 (492) 4,833 6,268 (740) 5,528 6,201 (528) 5,673 $6,902 $7,755 $7,793 3,774 3,298 3,031 2,355 2,703 1,973 1,744 1,965 1,884 $14,775 $15,721 $14,681 (582) $14,775 $15,721 $14,681 (640) (643) (98) (156) (53) 78 (385) (260) (117) - 332 (129) $13,788 $14,868 $13,868 $75 $86 $127 64 80 71 2,375 2,180 2,035 1,457 2,147 816 86 107 85 30 53 87 Segment operating income (loss) Media Networks Parks and Resorts Studio Entertainment Consumer Products & Interactive Media Total segment operating income Reconciliation of segment operating income to income before income taxes Segment operating income Corporate and unallocated shared expenses Restructuring and impairment charges Other income, net Interest expense, net Vice gain Infinity charge Income before income taxes Capital expenditures Media Networks Cable Networks Broadcasting Parks and Resorts Domestic International Studio Entertainment Consumer Products & Interactive Media Corporate Total capital expenditures Depreciation expense Media Networks Parks and Resorts Domestic International Studio Entertainment Consumer Products & Interactive Media Corporate Total depreciation expense Amortization of intangible assets Media Networks Parks and Resorts Studio Entertainment Consumer Products & Interactive Media Total amortization of intangible assets Identifiable assets Media Networks Parks and Resorts Studio Entertainment Consumer Products & Interactive Media Corporate Unallocated Goodwill Total consolidated assets 178 253 269 $3,623 $4,773 $4,265 $225 $237 $245 1,336 1,169 1,273 445 660 345 50 51 55 69 63 63 252 251 249 $2,586 $2,320 $2,132 $12 $18 $21 3 3 3 65 74 84 116 112 114 $196 $207 $222 $32,475 $32,706 29,492 28,275 16,307 15,359 8,996 9,332 4,919 6,361 3,600 $95,789 $92,033 a. For 2017, confirm that each of Disney's segments exceeds one or more of the quantitative thresholds. a Calculate the quantitative threshold tests for 2017 Round answers to the nearest percent (ex: 0.2345 = 23%). Operating Revenues 0% X % revenues Media Networks Parks and Resorts Studio Entertainment Consumer Products & Interactive Media Income 21 % 20 19 M 18 M Assets 046 x 0% X 20% x 20% X OX 0% X 0% X Using your calculations, indicate whether the segment exceeds each quantitative threshold test or not. Select Yes or No using the drop-down answer menu. Operating Revenues Income Assets Media Networks Yes Parks and Resorts Yes Studio Entertainment Yes Consumer Products & Interactive Media No Yes Yes Yes Yes Yes Yes Yes Yes b. Using the breakdown revenues and profit by segment, rank Disney's operating segments by the proportion of profit contributed in relation to its proportion of revenues. Select the answer that shows the segments in the correct order of highest to lowest. Media Networks, Parks and Resorts, Studio Entertainment, Consumer Products & Interactive Media OParks and Resorts, Media Networks, Studio Entertainment, Consumer Products & Interactive Media Media Networks, Parks and Resorts, Consumer Products, Studio Entertainment & Interactive Media OParks and Resorts, Media Networks, Consumer Products, Studio Entertainment & Interactive Media , , Mark 1.00 out of 1.00 c. Compute a rough DuPont analysis for 2017 of the operating segments (i.e., profit/revenues, revenues/total assets, and return on assets as the product of the profit and turnover ratios). Round profit margin to nearest percent (ex: 0.2345 = 23%). Round asset turnover to two decimal places. For ROA, use previous rounded figures to compute and round final to the nearest percent. PM AT ROA Media Networks 29% 0% x 21 % Parks and Resorts 20% 0% x 12% Studio Entertainment 28 % 0% X 14% Consumer Products & Interactive Media 36% 0% X 19% d. Compute the free cash flow for each operating segment over the three-year period using the following definition: free cash flow = operating profit + depreciation and amortization - Capital expenditures, Use negative signs with answers, when appropriate. Free cash flow 2017 2016 2015 Media Networks 7,755 X $ Parks and Resorts 3,298 X Studio Entertainment 0 % Ox 0 OX Consumer Products & Interactive Media 0 X 0 x OX Total 0 X $ 0 x $ OX $ OX$ OX OX OX $
