(2018, 2019, 2020)'s Income statement, balance sheet, cash flow for Walt Disney
gmona377
order_156548_427729-Questions-Yellowhighlights.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 | |
| Can you please let me know where you received yellow amounts from? | ||||
| 11,541,000 is 11,549,000 in 10-K report | selling general and administration expense | |||
| 4,160,000 is 4,167,000 in 10-K report | Depreciation and Amortization | |||
| 13,944,000 is 13,923,000 in 10-k report | Income (loss) from continuing operations before income taxes | |||
| Where did you receive Speical Income Charges and Other Income expense from? |
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 | |
| I could not find the yellow ones. Can you please tell me how did you receive those? | ||||
