fin320 final project
aynela
FinalProjectSpreadsheet.xlsxBalance sheet
| Powered by Clearbit | |||||||||||||||
| Disney (Walt) Co. (The) (NYS: DIS) | |||||||||||||||
| Exchange rate used is that of the Year End reported date | |||||||||||||||
| As Reported Quarterly Balance Sheet | |||||||||||||||
| Report Date | 04/03/2021 | 01/02/2021 | 06/27/2020 | 03/28/2020 | 12/28/2019 | 06/29/2019 | 03/30/2019 | 12/29/2018 | |||||||
| 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | ||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | |||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | |||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||
| Scale | Millions | Millions | Millions | Millions | Millions | Millions | Millions | Millions | |||||||
| Cash & cash equivalents | 15890 | 17068 | 23115 | 14339 | 6833 | 6728 | 10108 | 4455 | |||||||
| Receivables | 12533 | 14051 | 12622 | 14532 | 17100 | 15673 | 14593 | 10123 | |||||||
| Inventories | 1406 | 1480 | 1559 | 1531 | 1571 | 1516 | 1445 | 1357 | |||||||
| Licensed content costs & advances | 2204 | 1423 | 3135 | 1869 | 1334 | 4526 | 5408 | 824 | |||||||
| Other current assets | 844 | 852 | 899 | 1003 | 938 | 1035 | 1257 | 778 | |||||||
| Assets held for sale | - | - | - | - | - | 1892 | 1466 | - | |||||||
| Total current assets | 32877 | 34874 | 41330 | 33274 | 27776 | 31370 | 34277 | 17537 | |||||||
| Produced & licensed content costs | 26858 | 25929 | 25560 | 26757 | 26539 | 22552 | 24353 | 8177 | |||||||
| Investments | 4309 | 4037 | 3611 | 3180 | 3312 | 3872 | 4080 | 2970 | |||||||
| Attractions, buildings & equipment | 63037 | 63017 | 61130 | 60929 | 59910 | 57457 | 57991 | 55385 | |||||||
| Accumulated depreciation - attractions, buildings & equipment | 36866 | 36380 | 34639 | 33713 | 33057 | 32088 | 33132 | 31069 | |||||||
| Parks, resorts & other property before projects in progress & land, Total | 26171 | 26637 | 26491 | 27216 | 26853 | 25369 | 24859 | 24316 | |||||||
| Projects in progress | 4891 | 4547 | 4380 | 3916 | 4023 | 4853 | 4984 | 4336 | |||||||
| Land | 1075 | 1079 | 1020 | 1019 | 1019 | 1170 | 1174 | 1145 | |||||||
| Parks, resorts & other property, net | 32137 | 32263 | 31891 | 32151 | 31895 | 31392 | 31017 | 29797 | |||||||
| Intangible assets, net | 18123 | 18642 | 19589 | 22037 | 22669 | 25114 | 26985 | 6747 | |||||||
| Goodwill | 77861 | 77800 | 77233 | 80320 | 80314 | 77801 | 75057 | 31289 | |||||||
| Noncurrent assets held for sale | - | - | - | - | - | 12591 | 13182 | - | |||||||
| Other assets | 8085 | 8343 | 8435 | 8575 | 8443 | 4783 | 5391 | 3424 | |||||||
| Total assets | 200250 | 201888 | 207649 | 206294 | 200948 | 209475 | 214342 | 99941 | |||||||
| Accounts payable & other accrued liabilities | 17062 | 16846 | 16986 | 17906 | 19755 | 17647 | 20503 | 10696 | |||||||
| Current portion of borrowings | 5243 | 5397 | 10224 | 12676 | 10018 | 21923 | 19158 | 3489 | |||||||
| Deferred revenue & other current liabilities | 4337 | 4303 | 3707 | 4891 | 5024 | 4730 | 4281 | 3434 | |||||||
| Liabilities held for sale | - | - | - | - | - | 293 | 434 | - | |||||||
| Total current liabilities | 26642 | 26546 | 30917 | 35473 | 34797 | 44593 | 44376 | 17619 | |||||||
| Commercial paper borrowings | - | - | - | 8483 | 6534 | - | - | 699 | |||||||
| U.S. & European medium-term notes | - | - | - | - | - | - | - | 17947 | |||||||
| U.S. dollar denominated notes | - | - | - | 44289 | 39380 | - | - | - | |||||||
| Asia International Theme Parks borrowings | - | - | - | - | - | - | - | 1160 | |||||||
| Asia Theme Parks borrowings | - | - | - | 1185 | 1146 | - | - | - | |||||||
| Foreign currency denominated debt & other borrowings | - | - | - | 1489 | 1015 | - | - | 859 | |||||||
| Total borrowings before current portion | - | - | - | 55446 | 48075 | - | - | 20665 | |||||||
| Less: current portion of borrowings | - | - | - | 12676 | 10018 | - | - | 3489 | |||||||
| Borrowings | 50903 | 52878 | 54197 | 42770 | 38057 | 36311 | 37803 | 17176 | |||||||
| Deferred income taxes | 6894 | 7201 | 7055 | 7965 | 8364 | 10404 | 11208 | 3177 | |||||||
| Noncurrent liabilities held for sale | - | - | - | - | - | 2353 | 2659 | - | |||||||
| Other long-term liabilities | 16615 | 17205 | 15855 | 16113 | 15928 | 10561 | 12854 | 6452 | |||||||
| Redeemable noncontrolling interests | 9410 | 9330 | 9162 | 9096 | 9029 | 8897 | 1103 | 1124 | |||||||
| Common stock | 55000 | 54663 | 54386 | 54230 | 53995 | 53718 | 53419 | 36799 | |||||||
| Retained earnings (accumulated deficit) | 39365 | 38456 | 39004 | 43721 | 43202 | 41382 | 41212 | 84887 | |||||||
| Market value adjustments for investments | - | - | -6 | - | - | -1 | -4 | - | |||||||
| Market value adjustments for cash flow hedges | - | -324 | - | 122 | -7 | 33 | 48 | 128 | |||||||
| Market value adjustments | -214 | - | - | - | - | - | - | - | |||||||
| Unrecognized pension & postretirement medical expense | -6881 | -7072 | -5469 | -5566 | -5639 | -3155 | -3179 | -3247 | |||||||
| Foreign currency translation & other accumulated comprehensive income (loss) | -823 | -745 | -1142 | -1193 | -887 | -598 | -651 | -663 | |||||||
| Accumulated other comprehensive income (loss) | -7918 | -8141 | -6617 | -6637 | -6533 | -3721 | -3786 | -3782 | |||||||
| Shareholders' equity sub-total | - | - | - | - | - | - | 90845 | 117904 | |||||||
| Treasury stock, at cost | 907 | 907 | 907 | 907 | 907 | 907 | 907 | 67588 | |||||||
| Total disney shareholders' equity | 85540 | 84071 | 85866 | 90407 | 89757 | 90472 | 89938 | 50316 | |||||||
| Noncontrolling interests | 4246 | 4657 | 4597 | 4470 | 5016 | 5884 | 14401 | 4077 | |||||||
| Total equity | 89786 | 88728 | 90463 | 94877 | 94773 | 96356 | 104339 | 54393 |
Income Statement
| Powered by Clearbit | |||||||||||||||
| Disney (Walt) Co. (The) (NYS: DIS) | |||||||||||||||
| Exchange rate used is that of the Year End reported date | |||||||||||||||
| As Reported Quarterly Income Statement | |||||||||||||||
| Report Date | 04/03/2021 | 01/02/2021 | 06/27/2020 | 03/28/2020 | 12/28/2019 | 06/29/2019 | 03/30/2019 | 12/29/2018 | |||||||
| 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | ||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | |||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | |||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||
| Scale | Millions | Millions | Millions | Millions | Millions | Millions | Millions | Millions | |||||||
| Services revenues | 14522 | 14871 | 11235 | 16174 | 18075 | 18022 | 13006 | 12866 | |||||||
| Products revenues | 1091 | 1378 | 544 | 1835 | 2783 | 2223 | 1916 | 2437 | |||||||
| Total revenues | 15613 | 16249 | 11779 | 18009 | 20858 | 20245 | 14922 | 15303 | |||||||
| Cost of services (exclusive of depreciation & amortization) | 8932 | 10738 | 7209 | 10664 | 11377 | 11445 | 7167 | 7564 | |||||||
| Cost of products (exclusive of depreciation & amortization) | 850 | 1037 | 687 | 1254 | 1639 | 1374 | 1209 | 1437 | |||||||
| Selling, general, administrative & other expenses | 3113 | 2917 | 2455 | 3388 | 3703 | 3362 | 2327 | 2152 | |||||||
| Depreciation & amortization | 1272 | 1298 | 1377 | 1333 | 1298 | 1304 | 828 | 732 | |||||||
| Total costs & expenses | -14167 | -15990 | 11728 | 16639 | 18017 | -17485 | 11531 | -11885 | |||||||
| Restructuring & impairment charges | - | - | - | - | - | - | 662 | - | |||||||
| Restructuring & impairment charges | 414 | 113 | 5047 | 145 | 150 | 207 | - | - | |||||||
| Other income (expense), net | 305 | - | 382 | - | - | -123 | - | - | |||||||
| Other income | - | - | - | - | - | - | 4963 | - | |||||||
| Interest expense | 415 | 404 | 456 | 365 | 362 | 472 | 198 | 163 | |||||||
| Interest & investment income | 131 | - | 41 | 63 | - | 34 | 30 | 75 | |||||||
| Net periodic pension & postretirement benefit costs (other than service costs) | -36 | - | 3 | 2 | - | 27 | 25 | 25 | |||||||
| Interest income, investment income & other interest income (expense) | - | 80 | - | - | 79 | - | - | - | |||||||
| Interest income (expense), net | -320 | -324 | -412 | -300 | -283 | -411 | -143 | -63 | |||||||
| Equity in the income (loss) of investees | 213 | 224 | 186 | 135 | 224 | -1 | -312 | 76 | |||||||
| Income from continuing operations before income taxes | 1230 | 46 | -4840 | 1060 | 2632 | 2018 | 7237 | 3431 | |||||||
| Income taxes from continuing operations | 108 | 16 | -331 | 525 | 459 | 395 | 1647 | 645 | |||||||
| Net income (loss) from continuing operations | 1122 | 30 | -4509 | 535 | 2173 | 1623 | 5590 | - | |||||||
| Income (loss) from discontinued operations, net of tax | -11 | -12 | -3 | -15 | -26 | 359 | 21 | - | |||||||
| Net income (loss) | 1111 | 18 | -4512 | 520 | 2147 | 1982 | 5611 | 2786 | |||||||
| Net income (loss) from continuing operations attributable to noncontrolling interests | -210 | -1 | -209 | -60 | -40 | - | -159 | 2 | |||||||
| Less: net income from continuing operations attributable to noncontrolling & redeemable noncontrolling interests | - | - | - | - | - | -186 | - | - | |||||||
| Less: net income from discontinued operations attributable to noncontrolling interests | - | - | - | - | - | -36 | - | - | |||||||
| Net income (loss) attributable to The Walt Disney Company (Disney) | 901 | 17 | -4721 | 460 | 2107 | 1760 | 5452 | 2788 | |||||||
| Weighted average shares outstanding - basic | 1817 | 1812 | 1809 | 1808 | 1805 | 1802 | 1530 | 1490 | |||||||
| Weighted average shares outstanding - diluted | 1829 | 1823 | 1809 | 1816 | 1817 | 1814 | 1537 | 1498 | |||||||
| Year end shares outstanding | 1781 | 1781 | 1781 | 1781 | 1781 | 1781 | 1779 | 1500 | |||||||
| Earnings (loss) per share - continuing operations - basic | 0.5 | 0.02 | -2.61 | 0.26 | 1.18 | 0.8 | 3.55 | - | |||||||
| Earnings (loss) per share - discontinued operations - basic | -0.01 | -0.01 | - | -0.01 | -0.01 | 0.18 | 0.01 | - | |||||||
| Net earnings (loss) per share - basic | 0.5 | 0.01 | -2.61 | 0.25 | 1.17 | 0.98 | 3.56 | 1.87 | |||||||
| Earnings (loss) per share - continuing operations - diluted | 0.5 | 0.02 | -2.61 | 0.26 | 1.17 | 0.79 | 3.53 | - | |||||||
| Earnings (loss) per share - discontinued operations - diluted | -0.01 | -0.01 | - | -0.01 | -0.01 | 0.18 | 0.01 | - | |||||||
| Net earnings (loss) per share - diluted | 0.49 | 0.01 | -2.61 | 0.25 | 1.16 | 0.97 | 3.55 | 1.86 | |||||||
| Dividends declared per common share | - | - | 0.88 | 0.88 | 0.88 | 0.88 | - | 0.88 |
Cash Flow Statement
| Powered by Clearbit | |||||||||||||||
| Disney (Walt) Co. (The) (NYS: DIS) | |||||||||||||||
| Exchange rate used is that of the Year End reported date | |||||||||||||||
| As Reported Quarterly Cash Flow | |||||||||||||||
| Report Date | 04/03/2021 | 01/02/2021 | 06/27/2020 | 03/28/2020 | 12/28/2019 | 06/29/2019 | 03/30/2019 | 12/29/2018 | |||||||
| 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | ||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | |||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | |||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||
| Scale | Millions | Millions | Millions | Millions | Millions | Millions | Millions | Millions | |||||||
| Net income (loss) | - | - | - | - | - | - | - | 2786 | |||||||
| Net income (loss) from continuing operations | 1152 | 30 | -1813 | 2708 | 2173 | 9999 | 8376 | - | |||||||
| Depreciation & amortization | 2570 | 1298 | 4010 | 2631 | 1298 | 2864 | 1560 | 732 | |||||||
| Net gain/(loss) on investments | -481 | -80 | - | - | - | - | - | - | |||||||
| Goodwill & intangible asset impairment | - | - | 4953 | - | - | - | - | - | |||||||
| Net loss (gain) on acquisitions & investments | - | - | -370 | - | - | - | - | - | |||||||
| Loss (gain) on acquisition | - | - | - | - | - | -4794 | -4917 | - | |||||||
| Deferred income taxes | -556 | -105 | -548 | 297 | 534 | 1716 | 1190 | 46 | |||||||
| Equity in the loss (income) of investees | -437 | -224 | -545 | -359 | -224 | 234 | 236 | -76 | |||||||
| Cash distributions received from equity investees | 372 | 193 | 567 | 405 | 219 | 548 | 370 | 170 | |||||||
| Net change in produced & licensed content costs & advances | -1685 | 771 | -1483 | -925 | -77 | 59 | -281 | 468 | |||||||
| Net change in operating lease right of use assets / liabilities | 146 | 36 | 16 | -96 | - | - | - | - | |||||||
| Equity-based compensation | 270 | 134 | 388 | 246 | 115 | 591 | 475 | 92 | |||||||
| Other net income adjustments | 490 | 90 | 471 | 156 | 65 | 152 | 121 | 61 | |||||||
| Receivables | -37 | -1324 | 2100 | 828 | -1424 | -1428 | -386 | -1078 | |||||||
| Inventories | 175 | 94 | 86 | 70 | 81 | -96 | -19 | 32 | |||||||
| Other assets | -131 | -136 | 8 | -174 | -33 | 450 | 46 | 25 | |||||||
| Accounts payable & other accrued liabilities | - | - | - | - | - | - | - | -1289 | |||||||
| Accounts payable & other liabilities | -780 | -642 | -1986 | -888 | -841 | 219 | -283 | - | |||||||
| Income taxes | 400 | -60 | 95 | -112 | -256 | -6248 | -474 | 130 | |||||||
| Net cash flows from operations - continuing operations | - | - | 5949 | 4787 | - | 4266 | - | - | |||||||
| Net cash flows from operating activities | 1468 | 75 | 5949 | - | 1630 | 4266 | 6014 | 2099 | |||||||
| Investments in parks, resorts & other property | -1530 | -760 | -3293 | -2585 | -1338 | -3567 | -2390 | -1195 | |||||||
| Acquisitions | - | - | - | - | - | -9901 | -9901 | - | |||||||
| Other investing activities | 203 | 28 | -27 | -21 | -12 | -317 | -392 | -141 | |||||||
| Net cash flows from (used in) investing activities - continuing operations | - | - | -3320 | -2606 | - | -13785 | - | - | |||||||
| Net cash flows from investing activities | -1327 | -732 | -3320 | - | -1350 | -13785 | -12683 | -1336 | |||||||
| Commercial paper borrowings/(payments), net | -87 | -179 | 1373 | 3138 | 1172 | 2973 | 376 | -302 | |||||||
| Borrowings | 37 | 1 | 18030 | 6071 | 51 | 31348 | 31145 | - | |||||||
| Reduction of borrowings | -1816 | -139 | -2297 | -1048 | -46 | -19039 | -17398 | - | |||||||
| Dividends | - | - | -1587 | -1587 | - | -1310 | -1310 | - | |||||||
| Proceeds from exercise of stock options | 394 | 209 | 238 | 207 | 126 | 278 | 83 | 37 | |||||||
| Acquisition of noncontrolling & redeemable noncontrolling interests | - | - | - | - | - | -1430 | - | - | |||||||
| Contributions from or sales of noncontrolling interests | - | - | - | - | - | 544 | - | - | |||||||
| Other financing activities | -769 | -225 | -838 | -165 | -186 | -831 | -200 | -146 | |||||||
| Net cash flows from financing activities - continuing operations | - | - | 14919 | 6616 | - | 12533 | - | - | |||||||
| Net cash flows from financing activities | -2241 | -333 | 14919 | - | 1117 | 12533 | 12696 | -411 | |||||||
| Cash flows from operating activities of discontinued operations | 4 | - | 2 | 4 | - | 320 | - | - | |||||||
| Cash flows from financing activities of discontinued operations | - | - | - | - | - | -179 | - | - | |||||||
| Cash flows from investing activities of discontinued operations | 4 | - | 198 | 198 | - | - | - | - | |||||||
| Cash from (used in) operations - discontinued operations | 8 | 9 | 200 | 202 | -19 | 141 | -35 | - | |||||||
| Impact of exchange rate on cash, cash equivalents & restricted cash | 70 | 139 | -49 | -76 | 41 | 47 | 75 | -44 | |||||||
| Change in cash, cash equivalents & restricted cash | -2022 | -842 | 17699 | 8923 | 1419 | 3202 | 6067 | 308 | |||||||
| Cash, cash equivalents & restricted cash, beginning of period | 17954 | 17954 | 5455 | 5455 | 5455 | 4155 | 4155 | 4155 | |||||||
| Cash, cash equivalents & restricted cash, end of period | 15932 | 17112 | 23154 | 14378 | 6874 | 7357 | 10222 | 4463 |
