ACCT 370 - WEEK 4
gmona377
Customerquestions-order-156630-428094.xlsxCompany Information
| ACCT 370 Excel Project | ||||
| Company Information | ||||
| Student Name | ||||
| Company Name : | The Walt Disney Company | |||
| Ticker Symbol: | DIS | |||
| Industry: | Mass Media | |||
| Products or Services Offered: | ||||
| 1. Cable Networks | Broadcasting Services | Parks & Experiences | Consumer Products | |
| Disney Brand:Disney Channel, Disney Junior, Disney XD | WABC , KABC, WLS, WPVI, KTRK, KGO, WTVD, KFSN | Walt Disney World Resort ,Disneyland Resort, Disneyland Paris; Hong Kong Disneyland Resort and Shanghai Disney Resort | Licensure of brand characters and names | |
| ESPN Brand: ESPN, ESPN2, ESPNU, ESPNEWS, SEC Network, | ||||
| Freeform Brand: FX, FXM, FXX, | ||||
| National Geographic Brand: National Geographic, National Geographic Wild | ||||
| A+E Brand: A&E, HISTORY, Lifetime, LMN, FYI,Viceland | ||||
| Major Competitors | Comcast, Time Warner, 21st Century Fox, CBS Corp., and Discovery Communications |
Historical Income Statement
| The Walt Disney Company | ||||
| Historical Income Statements | ||||
| Denominations are in: (in $ thousands except per share data) | ||||
| Oct. 03, 2020 | Sep. 28, 2019 | Sep. 29, 2018 | ||
| Total Revenue | $ 65,388,000 | $ 69,570,000 | $ 59,434,000 | |
| cost of revenue | $ 43,880,000 | $ 42,018,000 | $ 32,726,000 | |
| Gross Profit | $ 21,508,000 | $ 27,552,000 | $ 26,708,000 | |
| selling general and administration expense | $ 12,369,000 | $ 11,541,000 | $ 8,860,000 | |
| Depreciation and Amortization | $ 5,345,000 | $ 4,160,000 | $ 3,011,000 | |
| total operating expense | $ 17,714,000 | $ 15,701,000 | $ 11,871,000 | |
| Operating Income | $ 3,794,000 | $ 11,851,000 | $ 14,837,000 | |
| Net non operatinng interest | $ -1,491,000 | $ -978,000 | $ -574,000 | |
| Gain on sale of security | $ 65,000 | |||
| Earnings from Equity Interest | $ 651,000 | $ -103,000 | $ -102,000 | |
| Speical Income Charges | $ -4,762,000 | $ 3,174,000 | $ 568,000 | |
| Other Income expense | $ -4,046,000 | $ 3,071,000 | $ 466,000 | |
| Pre-tax income | $ -1,743,000 | $ 13,944,000 | $ 14,729,000 | |
| Tax Provision | $ 699,000 | $ 3,031,000 | $ 1,663,000 | |
| Net Income | $ -2,442,000 | $ 10,913,000 | $ 13,066,000 |
Historical Balance sheet
| The Walt Disney Company | |||
| Historical Balance Sheets | |||
| Denominations are in: (in $ thousands except per share data) | |||
| Fiscal Year | Oct. 03, 2020 | Sep. 28, 2019 | Sep. 29, 2018 |
| Current Assets | |||
| Cash and cash equivalents | $ 17,914,000 | $ 5,418,000 | $ 4,150,000 |
| Receivables | $ 12,708,000 | $ 15,481,000 | $ 9,334,000 |
| Inventory | $ 1,583,000 | $ 1,649,000 | $ 1,392,000 |
| Prepaid Assets | $ 2,171,000 | $ 4,597,000 | $ 1,790,000 |
| Current Deferred Assets | $ - 0 | $ 4,597,000 | $ 1,314,000 |
| Other current assets | $ 875,000 | $ 979,000 | $ 159,000 |
| Current Assets | $ 35,251,000 | $ 28,124,000 | $ 16,825,000 |
| Non current assets | |||
| PPE | $ 32,078,000 | $ 31,603,000 | $ 29,540,000 |
| Goodwill | $ 77,689,000 | $ 80,293,000 | $ 31,269,000 |
| Other Intangible Assets | $ 19,173,000 | $ 23,215,000 | $ 6,812,000 |
| Goodwill and Other intangible assets | $ 96,862,000 | $ 103,508,000 | $ 38,081,000 |
| long-Term Equity Investment | $ 2,632,000 | $ 2,922,000 | $ 2,768,000 |
| Investment in financial assets | $ 1,271,000 | $ 302,000 | $ 131,000 |
| Investment and advances | $ 3,903,000 | $ 3,224,000 | $ 2,899,000 |
| Non current accounts receivable | - | - | $ 1,928,000 |
| Non current deferred assets | $ 25,022,000 | $ 22,810,000 | $ 7,888,000 |
| Non current prepaid assets | - | - | $ 919,000 |
| Other current assets | $ 8,433,000 | $ 4,715,000 | $ 518,000 |
| total Non current assets | $ 166,298,000 | $ 165,860,000 | $ 81,773,000 |
| Total assets | $ 201,549,000 | $ 193,984,000 | $ 98,598,000 |
| Payables | $ 12,663,000 | $ 13,778,000 | $ 6,503,000 |
| Accrued Expenses | $ 4,138,000 | $ 3,984,000 | $ 2,976,000 |
| Payables and Accrued expenses | $ 16,801,000 | $ 17,762,000 | $ 9,479,000 |
| Current Debt | $ 5,711,000 | $ 8,857,000 | $ 3,790,000 |
| Current deferred revenue | $ 4,116,000 | $ 4,722,000 | $ 4,591,000 |
| current liabilities | $ 26,628,000 | $ 31,341,000 | $ 17,860,000 |
| long term debt | $ 52,917,000 | $ 38,129,000 | $ 17,084,000 |
| Non-current deferred tax liability | $ 7,288,000 | $ 7,902,000 | $ 3,109,000 |
| non current pension and other post benefit plans | $ 6,451,000 | $ 4,783,000 | $ 2,712,000 |
| Preferred securities outside stock equity | $ 9,249,000 | $ 8,963,000 | $ 1,123,000 |
| Other non-current liabilities | $ 10,753,000 | $ 8,977,000 | $ 3,878,000 |
| Total non-current liabilities Net minority interest | $ 86,658,000 | $ 68,754,000 | $ 27,906,000 |
| Stochholders equity | $ 83,583,000 | $ 88,877,000 | $ 48,733,000 |
| Minority interest | $ 4,680,000 | $ 5,012,000 | $ 4,059,000 |
| total equity gross minority interest | $ 88,263,000 | $ 93,889,000 | $ 52,792,000 |
| Total Equity and liabilities | $ 201,549,000 | $ 193,984,000 | $ 98,558,000 |
Statement of cashflows
| The Walt Disney Company | ||||
| Historical Statement of Cash Flows | ||||
| Denominations are in: (in $ thousands except per share data) | ||||
| Fiscal Year | Oct. 03, 2020 | Sep. 28, 2019 | Sep. 29, 2018 | |
| Net income from continuing operations | $ -2,442,000 | $ 10,913,000 | $ 13,066,000 | |
| Operating gain losses | $ -1,571,000 | $ -4,691,000 | $ -458,000 | |
| Depreciation amortization depletion | $ 5,345,000 | $ 4,160,000 | $ 3,011,000 | |
| Deferred tax | $ -392,000 | $ 117,000 | $ -1,573,000 | |
| Asset Impairment charge | $ 4,953,000 | $ - 0 | $ - 0 | |
| Stock based compensation | $ 525,000 | $ 711,000 | $ 393,000 | |
| Other non-cash items | $ 641,000 | $ 206,000 | $ 441,000 | |
| change in receivables | $ 1,943,000 | $ 55,000 | $ -720,000 | |
| change in inventory | $ 14,000 | $ -223,000 | $ -17,000 | |
| change in payables and accrued expenses | $ -2,293,000 | $ 191,000 | $ 235,000 | |
| changes in other current assets | $ -157,000 | $ 390,000 | $ -1,450,000 | |
| changes in other working capital | $ 276,000 | $ -6,599,000 | $ 592,000 | |
| changes in working capital | $ -217,000 | $ -6,186,000 | $ -1,360,000 | |
| dividend received CFO | $ 774,000 | $ 754,000 | $ 775,000 | |
| Net income from continuing operating activities | $ 7,616,000 | $ 5,984,000 | $ 14,295,000 | |
| cash from discounting operating activites | $ 2,000 | $ 622,000 | $ - 0 | |
| Operating cash flow | $ 7,618,000 | $ 6,606,000 | $ 14,295,000 | |
| Purchase of PPE | $ -4,022,000 | $ -4,876,000 | $ -4,465,000 | |
| Purchase of Business | $ - 0 | $ -9,901,000 | $ -1,581,000 | |
| Net other investing charges | $ 172,000 | $ -319,000 | $ 710,000 | |
| cash flow from investing activities | $ -3,850,000 | $ -15,096,000 | $ -5,336,000 | |
| Cash from discounting investments | $ 213,000 | $ 10,978,000 | $ - 0 | |
| Investing cash flow | $ -3,637,000 | $ -4,118,000 | $ -5,336,000 | |
| Net long-term debt issuance | $ 14,587,000 | $ -641,000 | $ -815,000 | |
| Net short term debt issuance | $ -3,354,000 | $ 4,318,000 | $ -1,768,000 | |
| Net issuance payment of debt | $ 11,233,000 | $ 3,677,000 | $ -2,583,000 | |
| Net common stock issuance | $ - 0 | $ - 0 | $ -3,577,000 | |
| Common stock dividend paid | $ -1,587,000 | $ -2,895,000 | $ -2,515,000 | |
| Proceeds from stock option exercised | $ 305,000 | $ 318,000 | $ 210,000 | |
| Net other financing charges | $ -1,471,000 | $ -1,564,000 | $ -378,000 | |
| cash flow from continuing financing activities | $ 8,480,000 | $ -464,000 | $ -8,843,000 | |
| cash from discounting financing activitites | $ - 0 | $ -626,000 | $ - 0 | |
| financing cash flow | $ 8,480,000 | $ -1,090,000 | $ -8,843,000 | |
| cash from discounted operations | $ 2,000 | $ 622,000 | $ - 0 | |
| changes in cash | $ 12,461,000 | $ 1,398,000 | $ 116,000 | |
| Effect of exchange rates changes | $ 38,000 | $ -98,000 | $ -25,000 | |
| Beginning cash position | $ 5,455,000 | $ 4,155,000 | $ 4,064,000 | |
| End cash position | $ 17,954,000 | $ 5,455,000 | $ 4,155,000 | |
Sheet1
| Questions are for sheet1 to sheet 7: | |||
| 1. Can you make it look more organized with details and formulas added here for all tabs please? I know you did organize the first assignment, can you do same here? Reason I am asking here is as they look different than second (income statement), third (balance sheet) and forth (statement of cash flows) tab. I did not find any proofs for numbers. Lastly, can you include all links for all tabs to show where we got these numbers from? | |||
| For example make making Bold letters For the sub totals, and highlighting totals | |||
| Discovery Inc. | |||
| Historical Income Statement | |||
| Denominations in $ millions | |||
| 2020 | 2019 | 2018 | |
| Net income | $1,355 | $2,213 | $681 |
| Other comprehensive income (loss) adjustments, net of tax: | |||
| Currency translation | 292 | -15 | -189 |
| Pension plan and SERP | -8 | -10 | 3 |
| Derivatives | -113 | 18 | 12 |
| Comprehensive income | 1,526 | 2,206 | 507 |
| Comprehensive income attributable to noncontrolling interests | -124 | -127 | -67 |
| Comprehensive income attributable to redeemable noncontrolling | |||
| interests | -12 | -17 | -20 |
| Comprehensive income attributable to Discovery, Inc. | $1,390 | $2,062 | $420 |
| The accompanying notes are an integral part of these consolidated financial statements. |
Sheet2
| Discovery Inc. | |||
| Historical Balance Sheet | |||
| Denominations in $ millions | |||
| Fiscal Year | 2020 | 2019 | 2018 |
| 2020 2019 | |||
| ASSETS | |||
| Current assets: | |||
| Cash and cash equivalents | $2,091 | $1,552 | $986 |
| Receivables, net | 2,537 | 2,633 | 2,620 |
| Content rights and prepaid license fees, net | 532 | 579 | 313 |
| Prepaid expenses and other current assets | 970 | 453 | 312 |
| Total current assets | 6,130 | 5,217 | 4,231 |
| Noncurrent content rights, net | 3,439 | 3,129 | 3,069 |
| Property and equipment, net | 1,206 | 951 | 800 |
| Goodwill | 13,070 | 13,050 | 13,006 |
| Intangible assets, net | 7,640 | 8,667 | 9,674 |
| Equity method investments | 507 | 568 | 935 |
| Other noncurrent assets | 2,095 | 2,153 | 835 |
| Total assets | $34,087 | $33,735 | $32,550 |
| LIABILITIES AND EQUITY | |||
| Current liabilities: | |||
| Accounts payable | $397 | $463 | $325 |
| Accrued liabilities | 1,793 | 1,678 | 1,604 |
| Deferred revenues | 557 | 489 | 249 |
| Current portion of debt | 335 | 609 | 1,819 |
| Total current liabilities | 3,082 | 3,239 | 3,997 |
| Noncurrent portion of debt | 15,069 | 14,810 | 14,974 |
| Deferred income taxes | 1,534 | 1,691 | 1,811 |
| Other noncurrent liabilities | 2,019 | 2,029 | 1,251 |
| Total liabilities | 21,704 | 21,769 | 22,033 |
| Commitments and contingencies (See Note 22) | |||
| Redeemable noncontrolling interests | 383 | 442 | 415 |
| Equity: | |||
| Discovery, Inc. stockholders’ equity: | |||
| Series A-1 convertible preferred stock: $0.01 par value; 8 shares authorized, issued and | |||
| outstanding | — | — | — |
| Series C-1 convertible preferred stock: $0.01 par value; 6 shares authorized; 5 shares issued | |||
| and outstanding | — | — | — |
| Series A common stock: $0.01 par value; 1,700 shares authorized; 163 and 161 shares issued; | |||
| and 162 and 158 shares outstanding | 2 | 2 | 2 |
| Series B convertible common stock: $0.01 par value; 100 shares authorized; 7 shares issued | |||
| and outstanding | — | — | — |
| Series C common stock: $0.01 par value; 2,000 shares authorized; 547 shares issued; and 318 | |||
| and 360 shares outstanding | 5 | 5 | 5 |
| Additional paid-in capital | 10,809 | 10,747 | 10,647 |
| Treasury stock, at cost: 230 and 190 shares | -8,244 | -7,374 | -6,737 |
| Retained earnings | 8,543 | 7,333 | 5,254 |
| Accumulated other comprehensive loss | -651 | -822 | -785 |
| Total Discovery, Inc. stockholders’ equity | 10,464 | 9,891 | 8,386 |
| Noncontrolling interests | 1,536 | 1,633 | 1,716 |
| Total equity | 12,000 | 11,524 | 10,102 |
| Total liabilities and equity | $34,087 | $33,735 | $32,550 |
Sheet3
| Discovery Inc. | |||
| Historical Cashflow Statements | |||
| Denominations in $ millions | |||
| Fiscal Year | 2020 | 2019 | 2018 |
| Operating Activities | |||
| Net income | $1,355 | $2,213 | $681 |
| Adjustments to reconcile net income to cash provided by operating activities: | |||
| Content rights amortization and impairment | 2,956 | 2,853 | 3,288 |
| Depreciation and amortization | 1,359 | 1,347 | 1,398 |
| Deferred income taxes | -186 | -504 | -131 |
| Equity in losses of equity method investee companies, including cash distributions | 167 | 62 | 138 |
| Loss on extinguishment of debt | 76 | 28 | — |
| Share-based compensation expense | 110 | 142 | 80 |
| Impairment of goodwill and other intangible assets | 124 | 155 | — |
| (Gain) loss from derivative instruments, net | -36 | 48 | -15 |
| Realized gain on sale of investments | -103 | -10 | — |
| Remeasurement gain on previously held equity interests | — | -14 | — |
| Loss (gain) on disposition | 2 | — | -84 |
| Other, net | 14 | 52 | 141 |
| Changes in operating assets and liabilities, net of acquisitions and dispositions: | |||
| Receivables, net | 105 | -7 | -84 |
| Content rights and payables, net | -3,053 | -3,060 | -2,883 |
| Accounts payable and accrued liabilities | -131 | 122 | -74 |
| Foreign currency, prepaid expenses and other assets, net | -20 | -28 | 121 |
| Cash provided by operating activities | 2,739 | 3,399 | 2,576 |
| Investing Activities | |||
| Purchases of property and equipment | -402 | -289 | -147 |
| Purchases of investments | -250 | — | — |
| Investments in and advances to equity investments | -181 | -254 | -61 |
| Proceeds from dissolution of joint venture and sale of investments | 69 | 125 | — |
| Business acquisitions, net of cash acquired | -39 | -73 | -8,565 |
| Proceeds from dispositions, net of cash disposed | — | — | 107 |
| Other investing activities, net | 100 | 53 | 73 |
| Cash used in investing activities | -703 | -438 | -8,593 |
| Financing Activities | |||
| Principal repayments of debt, including discount payment | -2,193 | -2,658 | -16 |
| Borrowings from debt, net of discount and issuance costs | 1,979 | 1,479 | — |
| Repurchases of stock | -969 | -633 | — |
| Principal repayments of revolving credit facility | -500 | -225 | -200 |
| Borrowings under revolving credit facility | 500 | — | — |
| Distributions to noncontrolling interests and redeemable noncontrolling interests | -254 | -250 | -76 |
| Borrowings under term loan facilities | — | — | 2,000 |
| Principal repayments of term loans | — | -2,000 | |
| Other financing activities, net | -112 | -70 | 9 |
| Cash used in financing activities | -1,549 | -2,357 | -283 |
| Effect of exchange rate changes on cash, cash equivalents, and restricted cash | 83 | -38 | -23 |
| Net change in cash, cash equivalents, and restricted cash | 570 | 566 | -6,323 |
| Cash, cash equivalents, and restricted cash, beginning of period | 1,552 | 986 | 7,309 |
| Cash, cash equivalents, and restricted cash, end of period | $2,122 | $1,552 | $986 |
Sheet4
| Comcast Corporation | |||
| Historical Income Statements | |||
| Denominations in $ millions | |||
| Fiscal Year | 2020 | 2019 | 2018 |
| Net income | $10,701 | $13,323 | $11,862 |
| Currency translation adjustments, net of deferred taxes of $(331), $(66) and $9 1 | 213 | 1,375 | -916 |
| Cash flow hedges: | |||
| Deferred gains (losses), net of deferred taxes of $26, $(4) and $(3) | -101 | 19 | 50 |
| Realized (gains) losses reclassified to net income, net of deferred taxes of $31, $(10) and | |||
| ($4) | -147 | 65 | -6 |
| Employee benefit obligations and other, net of deferred taxes of $20, $16 and $(3) | -68 | -57 | 8 |
| Comprehensive income | 11,598 | 14,725 | 10,998 |
| Less: Net income attributable to noncontrolling interests and redeemable subsidiary preferred | |||
| stock | 167 | 266 | 131 |
| Less: Other comprehensive income (loss) attributable to noncontrolling interests | 60 | -13 | -41 |
| Comprehensive income attributable to Comcast Corporation | $11,371 | $14,472 | $10,908 |
Sheet5
| Comcast Corporation | |||
| Historical Balance Sheets | |||
| Denominations in $ millions | |||
| Fiscal Year | 2020 | 2019 | 2018 |
| Assets | |||
| Current Assets: | |||
| Cash and cash equivalents | $11,740 | $5,500 | $3,814 |
| Receivables, net | 11,466 | 11,292 | 11,104 |
| Programming rights | — | 3,877 | 3,746 |
| Other current assets | 3,535 | 4,723 | 3,184 |
| Total current assets | 26,741 | 25,392 | 21,848 |
| Film and television costs | 13,340 | 8,933 | 7,837 |
| Investments | 7,820 | 6,989 | 7,883 |
| Investment securing collateralized obligation | 447 | 694 | — |
| Property and equipment, net | 51,995 | 48,322 | 44,437 |
| Goodwill | 70,669 | 68,725 | 66,154 |
| Franchise rights | 59,365 | 59,365 | 59,365 |
| Other intangible assets, net | 35,389 | 36,128 | 38,358 |
| Other noncurrent assets, net | 8,103 | 8,866 | 5,802 |
| Total assets | $273,869 | $263,414 | $251,684 |
| Liabilities and Equity | |||
| Current Liabilities: | |||
| Accounts payable and accrued expenses related to trade creditors | $11,364 | $10,826 | $8,494 |
| Accrued participations and residuals | 1,706 | 1,730 | 1,808 |
| Deferred revenue | 2,963 | 2,768 | 2,182 |
| Accrued expenses and other current liabilities | 9,617 | 10,516 | 10,721 |
| Current portion of long-term debt | 3,146 | 4,452 | 4,398 |
| Total current liabilities | 28,796 | 30,292 | 27,603 |
| Long-term debt, less current portion | 100,614 | 97,765 | 107,345 |
| Collateralized obligation | 5,168 | 5,166 | — |
| Deferred income taxes | 28,051 | 28,180 | 27,589 |
| Other noncurrent liabilities | 18,222 | 16,765 | 15,329 |
| Commitments and contingencies | |||
| Redeemable noncontrolling interests and redeemable subsidiary preferred stock | 1,280 | 1,372 | 1,316 |
| Equity: | |||
| Preferred stock—authorized, 20,000,000 shares; issued, zero | — | — | — |
| Class A common stock, $0.01 par value—authorized, 7,500,000,000 shares; issued, 5,444,002,825 and | |||
| 5,416,381,298; outstanding, 4,571,211,797 and 4,543,590,270 | 54 | 54 | 54 |
| Class B common stock, $0.01 par value—authorized, 75,000,000 shares; issued and outstanding, 9,444,375 | — | — | _ |
| Additional paid-in capital | 39,464 | 38,447 | 37,461 |
| Retained earnings | 56,438 | 50,695 | 41,983 |
| Treasury stock, 872,791,028 Class A common shares | -7,517 | -7,517 | -7,517 |
| Accumulated other comprehensive income (loss) | 1,884 | 1,047 | -368 |
| Total Comcast Corporation shareholders’ equity | 90,323 | 82,726 | 71,613 |
| Noncontrolling interests | 1,415 | 1,148 | 889 |
| Total equity | 91,738 | 83,874 | 72,502 |
| Total liabilities and equity | $273,869 | $263,414 | $251,684 |
Sheet6
| Comcast Coporation | |||
| Historical Cashflows | |||
| Denominations in $ millions | |||
| Fiscal Year | 2020 | 2019 | 2018 |
| Operating Activities | |||
| Net income | $10,701 | $13,323 | $11,862 |
| Adjustments to reconcile net income to net cash provided by operating activities: | |||
| Depreciation, amortization and other operating gains | 13,100 | 12,953 | 10,676 |
| Share-based compensation | 1,193 | 1,021 | 826 |
| Noncash interest expense (income), net | 697 | 417 | 364 |
| Net (gain) loss on investment activity and other | -970 | -20 | 576 |
| Deferred income taxes | -550 | 563 | 290 |
| Changes in operating assets and liabilities, net of effects of acquisitions and divestitures: | |||
| Current and noncurrent receivables, net | -20 | -57 | -802 |
| Film and television costs, net | -244 | -929 | -395 |
| Accounts payable and accrued expenses related to trade creditors | -266 | -347 | -394 |
| Other operating assets and liabilities | 1,096 | -1,227 | 1,294 |
| Net cash provided by operating activities | 24,737 | 25,697 | 24,297 |
| Investing Activities | |||
| Capital expenditures | -9,179 | -9,953 | -9,774 |
| Cash paid for intangible assets | -2,455 | -2,475 | -1,935 |
| Construction of Universal Beijing Resort | -1,498 | -1,116 | -460 |
| Purchase of spectrum | -459 | — | — |
| Acquisitions, net of cash acquired | -233 | -370 | -38,219 |
| Proceeds from sales of businesses and investments | 2,339 | 886 | 141 |
| Purchases of investments | -812 | -1,899 | -1,257 |
| Other | 250 | 86 | 650 |
| Net cash provided by (used in) investing activities | -12,047 | -14,841 | -50,854 |
| Financing Activities | |||
| Proceeds from (repayments of) short-term borrowings, net | — | -1,288 | 379 |
| Proceeds from borrowings | 18,644 | 5,479 | 44,781 |
| Proceeds from collateralized obligation — | — | 5,175 | — |
| Repurchases and repayments of debt | -18,777 | -14,354 | -8,798 |
| Repurchases of common stock under repurchase program and employee plans | -534 | -504 | -5,320 |
| Dividends paid | -4,140 | -3,735 | -3,352 |
| Other | -1,706 | 46 | -550 |
| Net cash provided by (used in) financing activities | -6,513 | -9,181 | 27,140 |
| Impact of foreign currency on cash, cash equivalents and restricted cash | 2 | 5 | -245 |
| Increase (decrease) in cash, cash equivalents and restricted cash | 6,179 | 1,680 | 338 |
| Cash, cash equivalents and restricted cash, beginning of year | 5,589 | 3,909 | 3,571 |
| Cash, cash equivalents and restricted cash, end of year | $11,768 | $5,589 | $3,909 |
Sheet7
| Historical and Competitor Ratios | |||||
| The Walt Disney Company | The Walt Disney Company | The Walt Disney Company | Discovery Inc. | Comcast Corporation | |
| Fiscal Year | 2020 | 2019 | 2018 | 2020 | 2020 |
| · Liquidity Ratios | |||||
| o Current Ratio | 1.56 | 1.04 | 0.95 | 2.00 | 0.93 |
| o Quick Ratio | 1.1 | 0.6 | 0.7 | 0.87 | 1 |
| · Leverage Ratios | |||||
| o Debt to Total Assets Ratio | 0.26 | 0.19 | 47.84 | 120.6 | |
| o Debt Equity Ratio | 0.57 | 0.44 | 0.41 | 1.28 | 2.07 |
| o Long-Term Debt to Equity | 1.84 | 1.70 | 1.77 | 151.42 | 117.12 |
| o Times Interest Earned Ratio | _ | _ | |||
| · Activity Ratios | |||||
| o Inventory Turnover | 27.72 | 25.48 | 23.51 | _ | _ |
| o Fixed Assets Turnover | 1.90 | 2.30 | 2.10 | 0.32 | _ |
| o Total Assets Turnover | 0.31 | 0.37 | 0.32 | 0.31 | 0.39 |
| o Accounts Receivable Turnover | 5.15 | 4.49 | 6.37 | 4.21 | 9.10 |
| o Average Collection Period | 82.00 | 76.00 | 73.00 | _ | _ |
| · Profitability Ratios | |||||
| o Gross Profit Margin | 32.89% | 39.60% | 44.94% | 63.80% | 68.02% |
| o Operating Profit Margin | 7.28% | 14.38% | 13.39% | 23.60% | 16.89% |
| o Net Profit Margin | -7.61% | 16.92% | 19.82% | 11.40% | 10.33% |
| o Return on Total Assets (ROA) | -2.45% | 6.05% | 11.66% | 4.00% | 3.98% |
| o Return on Stockholders’ Equity (ROE) | -4.51% | 10.31% | 20.62% | 11.30% | 12.17% |
| o Earnings Per Share (EPS) | -1.58% | 6.27% | 8.36% | 24.60% | 2.30% |
| o Price Earnings Ratio | -166.1 | 19.60% | 14.50% | 22.64% | 23.42% |
