ACCT 370 - Week 2 question
gmona377
Missingtab3-Excel1.xlsxCompany Information
| Acct 370 Excel Project | |
| Walt Disney (DIS) | |
| University | |
| Name | |
| Company Name | Walt Disney Company (DIS) |
| Ticker Symbol | DIS |
| Industry | Mass media Entertainment |
| Products and Services Offered | Apparel, Toys, Home Décor, Books,Magazines, Foods,Beverage, Stationary,Electronics,Fine arts, |
| Major Competitors | Comcast, Time Warner, 21st Century Fox, CBS Corp., and Discovery Communications |
Historical Income Statements
| Walt Disney Company (DIS) | |||||||
| Income Statements | |||||||
| As of September 29, 2020, September 29, 2019, and September 29, 2018 | |||||||
| USD ($) shares in Thousands, $ in Thousands | |||||||
| Sep. 29, 2020 | Sep. 29, 2019 | Sep. 29, 2018 | |||||
| Income Statement [Abstract] | |||||||
| Net revenues | $ 1,966,492 | $ 1,473,413 | $ 1,079,874 | ||||
| Cost of net revenues | 518,625 | 356,466 | 264,580 | ||||
| Gross profit | 1,447,867 | 1,116,947 | 815,294 | ||||
| Operating expenses: | |||||||
| Selling, general and administrative | 852,404 | 665,777 | 490,653 | ||||
| Research and development | 128,899 | 97,559 | 75,720 | ||||
| Total operating expenses | 981,303 | 763,336 | 566,373 | ||||
| Income from operations | 466,564 | 353,611 | 248,921 | ||||
| Interest income | 8,576 | 6,948 | 4,213 | ||||
| Other income (expense), net | (8,489) | 4,240 | (10,568) | ||||
| Net income before provision for income taxes and equity in losses of investee | 466,651 | 364,799 | 242,566 | ||||
| Provision for income taxes | 57,723 | 130,162 | 51,200 | ||||
| Equity in losses of investee, net of tax | 8,693 | 3,219 | 1,684 | ||||
| Net income | $ 400,235 | $ 231,418 | $ 189,682 | ||||
| Net income per share: | |||||||
| Basic (usd per share) | $ 5 | $ 2.89 | $ 2.38 | ||||
| Diluted (usd per share) | $ 4.92 | $ 2.83 | $ 2.33 | ||||
| Shares used in computing net income per share: | |||||||
| Basic (shares) | 80,064 | 80,085 | 79,856 | ||||
| Diluted (shares) | 81,357 | 81,832 | 81,484 | ||||
| 2.6220627511 |
Historical Balance Sheets
| Walt Disney (DIS) | ||||
| Consolidated Balance Sheets | ||||
| As of September 29, 2020, September 29, 2019, and September 29, 2018 | ||||
| USD ($) shares in Thousands, $ in Thousands | ||||
| CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions | Oct. 03, 2020 | Sep. 28, 2019 | ||
|
tc={E5C66C27-C7E3-40A3-96CC-4D1E15A800DC}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Missing 2018 information here | Current assets | |||
| Cash and cash equivalents | $ 17,914 | $ 5,418 | ||
| Receivables | 12,708 | 15,481 | ||
| Inventories | 1,583 | 1,649 | ||
| Licensed content costs and advances | 2,171 | 4,597 | ||
| Other current assets | 875 | 979 | ||
| Total current assets | 35,251 | 28,124 | ||
| Produced and licensed content costs | 25,022 | 22,810 | ||
| Investments | 3,903 | 3,224 | ||
| Attractions, buildings and equipment | 62,111 | 58,589 | ||
| Accumulated depreciation | (35,517) | (32,415) | ||
| Parks, resorts and other property, before projects in progress and land, Total | 26,594 | 26,174 | ||
| Projects in progress | 4,449 | 4,264 | ||
| Land | 1,035 | 1,165 | ||
| Parks, resorts and other property | 32,078 | 31,603 | ||
| Intangible assets, net | 19,173 | 23,215 | ||
| Goodwill | 77,689 | 80,293 | ||
| Other assets | 8,433 | 4,715 | ||
| Total assets | 201,549 | 193,984 | ||
| Current liabilities | ||||
| Accounts payable and other accrued liabilities | 16,801 | 17,762 | ||
| Current portion of borrowings | 5,711 | 8,857 | ||
| Deferred revenue and other | 4,116 | 4,722 | ||
| Total current liabilities | 26,628 | 31,341 | ||
| Borrowings | 52,917 | 38,129 | ||
| Deferred income taxes | 7,288 | 7,902 | ||
| Other long-term liabilities | 17,204 | 13,760 | ||
| Commitments and contingencies | ||||
| Redeemable noncontrolling interest | 9,249 | 8,963 | ||
| Equity | ||||
| Preferred stock | 0 | 0 | ||
| Common stock, $.01 par value, Authorized – 4.6 billion shares, Issued – 1.8 billion shares | 54,497 | 53,907 | ||
| Retained earnings | 38,315 | 42,494 | ||
| Accumulated other comprehensive loss | (8,322) | (6,617) | ||
| Treasury stock, at cost, 19 million shares | (907) | (907) | ||
| Total Disney Shareholders’ equity | 83,583 | 88,877 | ||
| Noncontrolling interests | 4,680 | 5,012 | ||
| Total equity | 88,263 | 93,889 | ||
| Total liabilities and equity | $ 201,549 | $ 193,984 |
Statement of Cash Flows
| Walt Disney (DIS) | |||
| Statement of Cash Flows | |||
| As of September 29, 2020, September 29, 2019, and September 29, 2018 | |||
| USD ($) shares in Thousands, $ in Thousands | |||
| CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($) $ in Millions | 12 Months Ended | ||
| Oct. 03, 2020 | Sep. 28, 2019 | Sep. 29, 2018 | |
| Net income (loss) from continuing operations | $ (2,442) | $ 10,897 | $ 13,066 |
| OPERATING ACTIVITIES | |||
| Depreciation and amortization | 5,345 | 4,167 | 3,011 |
| Goodwill and Intangible Asset Impairment | 4,953 | 0 | 0 |
| Net gain on investments, acquisitions and dispositions | (920) | (4,733) | (560) |
| Deferred income taxes | (392) | 117 | (1,573) |
| Equity in the (income) loss of investees | (651) | 103 | 102 |
| Cash distributions received from equity investees | 774 | 754 | 775 |
| Net change in produced and licensed content costs and advances | 397 | (542) | (523) |
| Net change in operating lease right of use assets / liabilities | 31 | 0 | 0 |
| Equity-based compensation | 525 | 711 | 393 |
| Other | 641 | 154 | 441 |
| Changes in operating assets and liabilities, net of business acquisitions: | |||
| Receivables | 1,943 | 55 | (720) |
| Inventories | 14 | (223) | (17) |
| Other assets | (157) | 932 | (927) |
| Accounts payable and other liabilities | (2,293) | 191 | 235 |
| Income taxes | (152) | (6,599) | 592 |
| Cash provided by operations - continuing operations | 7,616 | 5,984 | 14,295 |
| INVESTING ACTIVITIES | |||
| Investments in parks, resorts and other property | (4,022) | (4,876) | (4,465) |
| Acquisitions | 0 | (9,901) | (1,581) |
| Other | 172 | (319) | 710 |
| Cash used in investing activities - continuing operations | (3,850) | (15,096) | (5,336) |
| FINANCING ACTIVITIES | |||
| Commercial paper borrowings (payments), net | (3,354) | 4,318 | (1,768) |
| Borrowings | 18,120 | 38,240 | 1,056 |
| Reduction of borrowings | (3,533) | (38,881) | (1,871) |
| Dividends | (1,587) | (2,895) | (2,515) |
| Repurchases of common stock | 0 | 0 | (3,577) |
| Proceeds from exercise of stock options | 305 | 318 | 210 |
| Contributions from/sales of noncontrolling interests | 94 | 737 | 399 |
| Acquisitions of noncontrolling and redeemable noncontrolling interests | 0 | (1,430) | 0 |
| Other | (1,565) | (871) | (777) |
| Cash used in financing activities - continuing operations | 8,480 | (464) | (8,843) |
| CASH FLOWS FROM DISCONTINUED OPERATIONS | |||
| Cash Provided by Operating Activities, Discontinued Operations | 2 | 622 | 0 |
| Cash Provided by Investing Activities, Discontinued Operations | 213 | 10,978 | 0 |
| Cash Used in Financing Activities, Discontinued Operations | 0 | (626) | 0 |
| Cash provided by discontinued operations | 215 | 10,974 | 0 |
| Impact of exchange rates on cash, cash equivalents and restricted cash | 38 | (98) | (25) |
| Change in Cash, Cash Equivalents and Restricted Cash | 12,499 | 1,300 | 91 |
| Cash, cash equivalents and restricted cash, beginning of year | 5,455 | 4,155 | 4,064 |
| Cash, cash equivalents and restricted cash, end of year | 17,954 | 5,455 | 4,155 |
| Supplemental disclosure of cash flow information: | |||
| Interest Paid | 1,559 | 1,142 | 631 |
| Income taxes paid | $ 738 | $ 9,259 | $ 2,503 |
