Financial Ratios assigned to complete/calculate in Excel:
Financial Analysis on Walt Disney Company and Six Flags Entertainment Corp. For the fiscal year 2018.
Disney Data
Six Flags Data
File Home Insert Draw Page Layout Formulas Data Review View Automate Help 11 ~ A Calibri BIV Dab TIL MIT General Paste aby Wrap Text Merge & Center A e V CA $ %> 40 .00 .000 Conditional Formatting Undo Clipboard Font Alignment Number D13 v fx D E F H M N R C YEAR: 2018 Disney Ratio Six Flags Ratio Working Capital Current Assets Current Liabilities Current Assets Current Liabilities #DIV/0! #DIV/0! Current Ratio TTL Current Assets TTL Current Liabilities TTL Current Assets TTL Current Liabilities #DIV/0! #DIV/0! 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Acide-Test Radia Cash and Cash Equivalent Short Term Investments Receivables Inventories Other Current Assets Total Assets Total Liabilities Cash and Cash Equivalent Short Term Investments Receivables Inventories Other Current Assets Tatal Assets Total Liabilities Acid-Test Ratia #DIV/0! Acid-Test Ratio #DIV/0! Total Revenue Cast of Goods Total Revenue Cast of Goods Margin (Gross) Margin #DIV/0! Margin #DIV/0! 31 32 33 34 35 36 37 38 39 40 Turnover (E...) Session Employees Employees End Turnover Seperation Employees Employees End Start #DIV/0! Turnover Start) #DIV/0! AVG Total AVG Total = Sheet1 + Calculation Mode: Automatic Workbook Statistics ITEM 6. Selected Financial Data (in millions, except per share data) 2018) 59,434 13,066 12,598 S 8.36 8.40 1.68 Statements of income Revenues Net income Net income attributable to Disney Per common share Earnings attributable to Disney Diluted Basic Dividends (6) Balance sheets Total assets Long-term obligations Disney shareholders' equity Statements of cash flows Cash provided (used) by: Operating activities Investing activities Financing activities $ 98,598 24,797 48,773 $ 14,295 (5,336) (8,843) ITEM 7. Management's Discussion and Analysis of Financial Condition and Results of Operations CONSOLIDATED RESULTS (in millions, except per share data) % Change Better Worse) 2018 2017 VS. 2018 2017 2016 2017 2016 Revenues Services s $ 46,843 $ 9% (1 50.869 8.565 47,130 8,502 8,294 (2)% 59,434 55,137 55,632 8 % (1y% (27.528) (25,320) (24,653) (9)% (37% (5.198) (4,986) (5.340) (4)% 7% (87% 7% Products Total revenues Costs and expenses: Cost of services (exclusive of depreciation and amortization) Cost of products (exclusive of depreciation and amortization) Selling, general, administrative and other Depreciation and amortization Total costs and expenses Restructuring and impairment charges Other income, net Interest expense, net Equity in the income (loss) of investees, net Income before income taxes (8.860) (3,011) (44.597) (10% (8,176) (2,782) (41,264) (98) (8,754) (2,527) (41.274) (156) (8)% (8)% - % (33) 66 % 37% 601 78 >100 % (574) (385) (260) (491% (48)% 320 926 (102) 14,729 (65)% (7)% 13,788 14,868 7% Income taxes (4,422) (5,078) 62 % (1.663) 13,066 9,366 9,790 40 % (49% (468) Net income Less: Net income attributable to noncontrolling interests Net income attributable to The Walt Disney Company (Disney) (386) (399) (21)% 3% 12.598 $ 8,980 9,391 40 % (49% Earnings per share attributable to Disney Diluted Basic 8.36 $ 5.69 5.73 8.40 5.73 5.76 (17% Weighted average number of common and common equivalent shares outstanding Diluted 1.507 1,578 1,639 Basic 1,499 1,568 1.629 2015 810,064 353,527 100,116 1.463,707 574,724 132.168 121,803 (And it sounds, exceperakan data Statement of Operations Data: Park Admissions Park food, merchandise and other Sponsorship, international agreements and accommodations Total revenue Operating expenses (excluding depreciation and amortization shown separately helow) Selling, general and administrative expenses (excluding depreciation and amortization shown separately below) Costs of products sold Othernet periodic pension (henefit) expense Depreciation and amortization Loss on disposal of assets Gain on sale of investee Interest expense, net Loss on det extinguishment, net Other expertise.net Income from continuing operations before income taxes and discontinued operations Income tax expense Income from continuing operations before discontinued operations Income from discontinued operations Net income Net income attributable to noncontrolling interests Net income attributable to Six Flags Entertainment Corporation (5.169 115,693 1.879 107,243 3.SON 411,858 95,855 $16.003 316,003 (40,007) 275.996 275.996 Amounts attributable to Six Flags Entertainment Corporation common stockholders: Income from continuing operations Income from discontinued operations Net income 275.996 Weighted average common shares outstanding Basic 84,100 85,445 Diluted: 3.28 Net income per average common share outstanding basic: Income from continuing operations Income from discontinued operations Net income Net income per average common share outstanding diluted: Income from continuing operations Income from discontinued operations Net income Cash dividends declared per common share 3.16 2015 44.60 (And it sousada) Balance Sheet Data: Cash and cash equivalents! Total assets Deferred revenue Total long-term debt (excluding current matunities) Total debt, net Redeemable no controlling interests Stockholders' (deficit) equity 2.517.328 146,222 2,065,512 2.106,512 325,271 (643,093) 2018 (And it thousanda) Other DATA: Net cash provided by operating activities Stock repurchases Payment of cash dividends 415,152 (110,990 (267,044) (1) Excludes restricted cash in 2016, 2015 and 2014 File Home Insert Draw Page Layout Formulas Data Review View Automate Help 11 ~ A Calibri BIV Dab TIL MIT General Paste aby Wrap Text Merge & Center A e V CA $ %> 40 .00 .000 Conditional Formatting Undo Clipboard Font Alignment Number D13 v fx D E F H M N R C YEAR: 2018 Disney Ratio Six Flags Ratio Working Capital Current Assets Current Liabilities Current Assets Current Liabilities #DIV/0! #DIV/0! Current Ratio TTL Current Assets TTL Current Liabilities TTL Current Assets TTL Current Liabilities #DIV/0! #DIV/0! 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Acide-Test Radia Cash and Cash Equivalent Short Term Investments Receivables Inventories Other Current Assets Total Assets Total Liabilities Cash and Cash Equivalent Short Term Investments Receivables Inventories Other Current Assets Tatal Assets Total Liabilities Acid-Test Ratia #DIV/0! Acid-Test Ratio #DIV/0! Total Revenue Cast of Goods Total Revenue Cast of Goods Margin (Gross) Margin #DIV/0! Margin #DIV/0! 31 32 33 34 35 36 37 38 39 40 Turnover (E...) Session Employees Employees End Turnover Seperation Employees Employees End Start #DIV/0! Turnover Start) #DIV/0! AVG Total AVG Total = Sheet1 + Calculation Mode: Automatic Workbook Statistics ITEM 6. Selected Financial Data (in millions, except per share data) 2018) 59,434 13,066 12,598 S 8.36 8.40 1.68 Statements of income Revenues Net income Net income attributable to Disney Per common share Earnings attributable to Disney Diluted Basic Dividends (6) Balance sheets Total assets Long-term obligations Disney shareholders' equity Statements of cash flows Cash provided (used) by: Operating activities Investing activities Financing activities $ 98,598 24,797 48,773 $ 14,295 (5,336) (8,843) ITEM 7. Management's Discussion and Analysis of Financial Condition and Results of Operations CONSOLIDATED RESULTS (in millions, except per share data) % Change Better Worse) 2018 2017 VS. 2018 2017 2016 2017 2016 Revenues Services s $ 46,843 $ 9% (1 50.869 8.565 47,130 8,502 8,294 (2)% 59,434 55,137 55,632 8 % (1y% (27.528) (25,320) (24,653) (9)% (37% (5.198) (4,986) (5.340) (4)% 7% (87% 7% Products Total revenues Costs and expenses: Cost of services (exclusive of depreciation and amortization) Cost of products (exclusive of depreciation and amortization) Selling, general, administrative and other Depreciation and amortization Total costs and expenses Restructuring and impairment charges Other income, net Interest expense, net Equity in the income (loss) of investees, net Income before income taxes (8.860) (3,011) (44.597) (10% (8,176) (2,782) (41,264) (98) (8,754) (2,527) (41.274) (156) (8)% (8)% - % (33) 66 % 37% 601 78 >100 % (574) (385) (260) (491% (48)% 320 926 (102) 14,729 (65)% (7)% 13,788 14,868 7% Income taxes (4,422) (5,078) 62 % (1.663) 13,066 9,366 9,790 40 % (49% (468) Net income Less: Net income attributable to noncontrolling interests Net income attributable to The Walt Disney Company (Disney) (386) (399) (21)% 3% 12.598 $ 8,980 9,391 40 % (49% Earnings per share attributable to Disney Diluted Basic 8.36 $ 5.69 5.73 8.40 5.73 5.76 (17% Weighted average number of common and common equivalent shares outstanding Diluted 1.507 1,578 1,639 Basic 1,499 1,568 1.629 2015 810,064 353,527 100,116 1.463,707 574,724 132.168 121,803 (And it sounds, exceperakan data Statement of Operations Data: Park Admissions Park food, merchandise and other Sponsorship, international agreements and accommodations Total revenue Operating expenses (excluding depreciation and amortization shown separately helow) Selling, general and administrative expenses (excluding depreciation and amortization shown separately below) Costs of products sold Othernet periodic pension (henefit) expense Depreciation and amortization Loss on disposal of assets Gain on sale of investee Interest expense, net Loss on det extinguishment, net Other expertise.net Income from continuing operations before income taxes and discontinued operations Income tax expense Income from continuing operations before discontinued operations Income from discontinued operations Net income Net income attributable to noncontrolling interests Net income attributable to Six Flags Entertainment Corporation (5.169 115,693 1.879 107,243 3.SON 411,858 95,855 $16.003 316,003 (40,007) 275.996 275.996 Amounts attributable to Six Flags Entertainment Corporation common stockholders: Income from continuing operations Income from discontinued operations Net income 275.996 Weighted average common shares outstanding Basic 84,100 85,445 Diluted: 3.28 Net income per average common share outstanding basic: Income from continuing operations Income from discontinued operations Net income Net income per average common share outstanding diluted: Income from continuing operations Income from discontinued operations Net income Cash dividends declared per common share 3.16 2015 44.60 (And it sousada) Balance Sheet Data: Cash and cash equivalents! Total assets Deferred revenue Total long-term debt (excluding current matunities) Total debt, net Redeemable no controlling interests Stockholders' (deficit) equity 2.517.328 146,222 2,065,512 2.106,512 325,271 (643,093) 2018 (And it thousanda) Other DATA: Net cash provided by operating activities Stock repurchases Payment of cash dividends 415,152 (110,990 (267,044) (1) Excludes restricted cash in 2016, 2015 and 2014
