FIN 320 Milestone Two
MJones13
DisneyProject.Jones.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 | 07/03/2021 | 04/03/2021 | 01/02/2021 | 06/27/2020 | 03/28/2020 | 12/28/2019 | 06/29/2019 | 03/30/2019 | 12/29/2018 | ||||||||
| 3rd Quarter | 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 | USD | ||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | ||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | ||||||||
| Cash & cash equivalents | 16070000 | 15890000 | 17068000 | 23115000 | 14339000 | 6833000 | 6728000 | 10108000 | 4455000 | ||||||||
| Receivables | 13355000 | 12533000 | 14051000 | 12622000 | 14532000 | 17100000 | 15673000 | 14593000 | 10123000 | ||||||||
| Inventories | 1344000 | 1406000 | 1480000 | 1559000 | 1531000 | 1571000 | 1516000 | 1445000 | 1357000 | ||||||||
| Licensed content costs & advances | 2367000 | 2204000 | 1423000 | 3135000 | 1869000 | 1334000 | 4526000 | 5408000 | 824000 | ||||||||
| Other current assets | 830000 | 844000 | 852000 | 899000 | 1003000 | 938000 | 1035000 | 1257000 | 778000 | ||||||||
| Assets held for sale | - | - | - | - | - | - | 1892000 | 1466000 | - | ||||||||
| Total current assets | 33966000 | 32877000 | 34874000 | 41330000 | 33274000 | 27776000 | 31370000 | 34277000 | 17537000 | ||||||||
| Produced & licensed content costs | 27889000 | 26858000 | 25929000 | 25560000 | 26757000 | 26539000 | 22552000 | 24353000 | 8177000 | ||||||||
| Investments | 4045000 | 4309000 | 4037000 | 3611000 | 3180000 | 3312000 | 3872000 | 4080000 | 2970000 | ||||||||
| Attractions, buildings & equipment | 64023000 | 63037000 | 63017000 | 61130000 | 60929000 | 59910000 | 57457000 | 57991000 | 55385000 | ||||||||
| Accumulated depreciation - attractions, buildings & equipment | 37579000 | 36866000 | 36380000 | 34639000 | 33713000 | 33057000 | 32088000 | 33132000 | 31069000 | ||||||||
| Parks, resorts & other property before projects in progress & land, Total | 26444000 | 26171000 | 26637000 | 26491000 | 27216000 | 26853000 | 25369000 | 24859000 | 24316000 | ||||||||
| Projects in progress | 4856000 | 4891000 | 4547000 | 4380000 | 3916000 | 4023000 | 4853000 | 4984000 | 4336000 | ||||||||
| Land | 1077000 | 1075000 | 1079000 | 1020000 | 1019000 | 1019000 | 1170000 | 1174000 | 1145000 | ||||||||
| Parks, resorts & other property, net | 32377000 | 32137000 | 32263000 | 31891000 | 32151000 | 31895000 | 31392000 | 31017000 | 29797000 | ||||||||
| Intangible assets, net | 17601000 | 18123000 | 18642000 | 19589000 | 22037000 | 22669000 | 25114000 | 26985000 | 6747000 | ||||||||
| Goodwill | 77835000 | 77861000 | 77800000 | 77233000 | 80320000 | 80314000 | 77801000 | 75057000 | 31289000 | ||||||||
| Noncurrent assets held for sale | - | - | - | - | - | - | 12591000 | 13182000 | - | ||||||||
| Other assets | 8508000 | 8085000 | 8343000 | 8435000 | 8575000 | 8443000 | 4783000 | 5391000 | 3424000 | ||||||||
| Total assets | 202221000 | 200250000 | 201888000 | 207649000 | 206294000 | 200948000 | 209475000 | 214342000 | 99941000 | ||||||||
| Accounts payable & other accrued liabilities | 18317000 | 17062000 | 16846000 | 16986000 | 17906000 | 19755000 | 17647000 | 20503000 | 10696000 | ||||||||
| Current portion of borrowings | 4728000 | 5243000 | 5397000 | 10224000 | 12676000 | 10018000 | 21923000 | 19158000 | 3489000 | ||||||||
| Deferred revenue & other current liabilities | 4368000 | 4337000 | 4303000 | 3707000 | 4891000 | 5024000 | 4730000 | 4281000 | 3434000 | ||||||||
| Liabilities held for sale | - | - | - | - | - | - | 293000 | 434000 | - | ||||||||
| Total current liabilities | 27413000 | 26642000 | 26546000 | 30917000 | 35473000 | 34797000 | 44593000 | 44376000 | 17619000 | ||||||||
| Commercial paper borrowings | - | - | - | - | 8483000 | 6534000 | - | - | 699000 | ||||||||
| U.S. & European medium-term notes | - | - | - | - | - | - | - | - | 17947000 | ||||||||
| U.S. dollar denominated notes | - | - | - | - | 44289000 | 39380000 | - | - | - | ||||||||
| Asia International Theme Parks borrowings | - | - | - | - | - | - | - | - | 1160000 | ||||||||
| Asia Theme Parks borrowings | - | - | - | - | 1185000 | 1146000 | - | - | - | ||||||||
| Foreign currency denominated debt & other borrowings | - | - | - | - | 1489000 | 1015000 | - | - | 859000 | ||||||||
| Total borrowings before current portion | - | - | - | - | 55446000 | 48075000 | - | - | 20665000 | ||||||||
| Less: current portion of borrowings | - | - | - | - | 12676000 | 10018000 | - | - | 3489000 | ||||||||
| Borrowings | 51110000 | 50903000 | 52878000 | 54197000 | 42770000 | 38057000 | 36311000 | 37803000 | 17176000 | ||||||||
| Deferred income taxes | 6835000 | 6894000 | 7201000 | 7055000 | 7965000 | 8364000 | 10404000 | 11208000 | 3177000 | ||||||||
| Noncurrent liabilities held for sale | - | - | - | - | - | - | 2353000 | 2659000 | - | ||||||||
| Other long-term liabilities | 16249000 | 16615000 | 17205000 | 15855000 | 16113000 | 15928000 | 10561000 | 12854000 | 6452000 | ||||||||
| Redeemable noncontrolling interests | 9492000 | 9410000 | 9330000 | 9162000 | 9096000 | 9029000 | 8897000 | 1103000 | 1124000 | ||||||||
| Common stock | 55174000 | 55000000 | 54663000 | 54386000 | 54230000 | 53995000 | 53718000 | 53419000 | 36799000 | ||||||||
| Retained earnings (accumulated deficit) | 40311000 | 39365000 | 38456000 | 39004000 | 43721000 | 43202000 | 41382000 | 41212000 | 84887000 | ||||||||
| Market value adjustments for investments | - | - | - | -6000 | - | - | -1000 | -4000 | - | ||||||||
| Market value adjustments for hedges | -213000 | - | -324000 | - | 122000 | -7000 | 33000 | 48000 | 128000 | ||||||||
| Market value adjustments | - | -214000 | - | - | - | - | - | - | - | ||||||||
| Unrecognized pension & postretirement medical expense | -6712000 | -6881000 | -7072000 | -5469000 | -5566000 | -5639000 | -3155000 | -3179000 | -3247000 | ||||||||
| Foreign currency translation & other accumulated comprehensive income (loss) | -912000 | -823000 | -745000 | -1142000 | -1193000 | -887000 | -598000 | -651000 | -663000 | ||||||||
| Accumulated other comprehensive income (loss) | -7837000 | -7918000 | -8141000 | -6617000 | -6637000 | -6533000 | -3721000 | -3786000 | -3782000 | ||||||||
| Shareholders' equity sub-total | - | - | - | - | - | - | - | 90845000 | 117904000 | ||||||||
| Treasury stock, at cost | 907000 | 907000 | 907000 | 907000 | 907000 | 907000 | 907000 | 907000 | 67588000 | ||||||||
| Total disney shareholders' equity | 86741000 | 85540000 | 84071000 | 85866000 | 90407000 | 89757000 | 90472000 | 89938000 | 50316000 | ||||||||
| Noncontrolling interests | 4381000 | 4246000 | 4657000 | 4597000 | 4470000 | 5016000 | 5884000 | 14401000 | 4077000 | ||||||||
| Total equity | 91122000 | 89786000 | 88728000 | 90463000 | 94877000 | 94773000 | 96356000 | 104339000 | 54393000 |
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 | 07/03/2021 | 04/03/2021 | 01/02/2021 | 06/27/2020 | 03/28/2020 | 12/28/2019 | 06/29/2019 | 03/30/2019 | 12/29/2018 | ||||||||
| 3rd Quarter | 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 | USD | ||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | ||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | ||||||||
| Services revenues | 15585000 | 14522000 | 14871000 | 11235000 | 16174000 | 18075000 | 18022000 | 13006000 | 12866000 | ||||||||
| Products revenues | 1437000 | 1091000 | 1378000 | 544000 | 1835000 | 2783000 | 2223000 | 1916000 | 2437000 | ||||||||
| Total revenues | 17022000 | 15613000 | 16249000 | 11779000 | 18009000 | 20858000 | 20245000 | 14922000 | 15303000 | ||||||||
| Cost of services (exclusive of depreciation & amortization) | 10251000 | 8932000 | 10738000 | 7209000 | 10664000 | 11377000 | 11445000 | 7167000 | 7564000 | ||||||||
| Cost of products (exclusive of depreciation & amortization) | 982000 | 850000 | 1037000 | 687000 | 1254000 | 1639000 | 1374000 | 1209000 | 1437000 | ||||||||
| Selling, general, administrative & other expenses | 3168000 | 3113000 | 2917000 | 2455000 | 3388000 | 3703000 | 3362000 | 2327000 | 2152000 | ||||||||
| Depreciation & amortization | 1266000 | 1272000 | 1298000 | 1377000 | 1333000 | 1298000 | 1304000 | 828000 | 732000 | ||||||||
| Total costs & expenses | -15667000 | -14167000 | -15990000 | 11728000 | 16639000 | 18017000 | -17485000 | 11531000 | -11885000 | ||||||||
| Restructuring & impairment charges | - | - | - | - | - | - | - | 662000 | - | ||||||||
| Restructuring & impairment charges | 35000 | 414000 | 113000 | 5047000 | 145000 | 150000 | 207000 | - | - | ||||||||
| DraftKings, Inc. gain (loss) | -217000 | - | - | - | - | - | - | - | - | ||||||||
| German free-to-air (FTA) television network gain (loss) | 126000 | - | - | - | - | - | - | - | - | ||||||||
| Other income (expense), net | -91000 | 305000 | - | 382000 | - | - | -123000 | - | - | ||||||||
| Other income | - | - | - | - | - | - | - | 4963000 | - | ||||||||
| Interest expense | 404000 | 415000 | 404000 | 456000 | 365000 | 362000 | 472000 | 198000 | 163000 | ||||||||
| Interest & investment income | -9000 | 131000 | - | 41000 | 63000 | - | 34000 | 30000 | 75000 | ||||||||
| Net periodic pension & postretirement benefit costs (other than service costs) | -32000 | -36000 | - | 3000 | 2000 | - | 27000 | 25000 | 25000 | ||||||||
| Interest income, investment income & other interest income (expense) | - | - | 80000 | - | - | 79000 | - | - | - | ||||||||
| Interest income (expense), net | -445000 | -320000 | -324000 | -412000 | -300000 | -283000 | -411000 | -143000 | -63000 | ||||||||
| Equity in the income (loss) of investees | 211000 | 213000 | 224000 | 186000 | 135000 | 224000 | -1000 | -312000 | 76000 | ||||||||
| Income from continuing operations before income taxes | 995000 | 1230000 | 46000 | -4840000 | 1060000 | 2632000 | 2018000 | 7237000 | 3431000 | ||||||||
| Income taxes from continuing operations | -133000 | 108000 | 16000 | -331000 | 525000 | 459000 | 395000 | 1647000 | 645000 | ||||||||
| Net income (loss) from continuing operations | 1128000 | 1122000 | 30000 | -4509000 | 535000 | 2173000 | 1623000 | 5590000 | - | ||||||||
| Income (loss) from discontinued operations, net | -5000 | -11000 | -12000 | -3000 | -15000 | -26000 | 359000 | 21000 | - | ||||||||
| Net income (loss) | 1123000 | 1111000 | 18000 | -4512000 | 520000 | 2147000 | 1982000 | 5611000 | 2786000 | ||||||||
| Net income (loss) from continuing operations attributable to noncontrolling interests | -205000 | -210000 | -1000 | -209000 | -60000 | -40000 | - | -159000 | 2000 | ||||||||
| Less: net income from continuing operations attributable to noncontrolling & redeemable noncontrolling interests | - | - | - | - | - | - | -186000 | - | - | ||||||||
| Less: net income from discontinued operations attributable to noncontrolling interests | - | - | - | - | - | - | -36000 | - | - | ||||||||
| Net income (loss) attributable to The Walt Disney Company (Disney) | 918000 | 901000 | 17000 | -4721000 | 460000 | 2107000 | 1760000 | 5452000 | 2788000 | ||||||||
| Weighted average shares outstanding - basic | 1818000 | 1817000 | 1812000 | 1809000 | 1808000 | 1805000 | 1802000 | 1530000 | 1490000 | ||||||||
| Weighted average shares outstanding - diluted | 1830000 | 1829000 | 1823000 | 1809000 | 1816000 | 1817000 | 1814000 | 1537000 | 1498000 | ||||||||
| Year end shares outstanding | 1781000 | 1781000 | 1781000 | 1781000 | 1781000 | 1781000 | 1781000 | 1779000 | 1500000 | ||||||||
| Earnings (loss) per share - continuing operations - basic | 0.51 | 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.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.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.5 | 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
| 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 | 07/03/2021 | 04/03/2021 | 01/02/2021 | 06/27/2020 | 03/28/2020 | 12/28/2019 | 06/29/2019 | 03/30/2019 | 12/29/2018 | ||||||||
| 3rd Quarter | 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 | USD | ||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | ||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | ||||||||
| Net income (loss) | - | - | - | - | - | - | - | - | 2786000 | ||||||||
| Net income (loss) from continuing operations | 2280000 | 1152000 | 30000 | -1813000 | 2708000 | 2173000 | 9999000 | 8376000 | - | ||||||||
| Depreciation & amortization | 3836000 | 2570000 | 1298000 | 4010000 | 2631000 | 1298000 | 2864000 | 1560000 | 732000 | ||||||||
| Net gain/(loss) on investments | - | -481000 | -80000 | - | - | - | - | - | - | ||||||||
| Goodwill & intangible asset impairment | - | - | - | 4953000 | - | - | - | - | - | ||||||||
| Net loss (gain) on investments | -325000 | - | - | - | - | - | - | - | - | ||||||||
| Net loss (gain) on acquisitions & investments | - | - | - | -370000 | - | - | - | - | - | ||||||||
| Loss (gain) on acquisition | - | - | - | - | - | - | -4794000 | -4917000 | - | ||||||||
| Deferred income taxes | -749000 | -556000 | -105000 | -548000 | 297000 | 534000 | 1716000 | 1190000 | 46000 | ||||||||
| Equity in the loss (income) of investees | -648000 | -437000 | -224000 | -545000 | -359000 | -224000 | 234000 | 236000 | -76000 | ||||||||
| Cash distributions received from equity investees | 546000 | 372000 | 193000 | 567000 | 405000 | 219000 | 548000 | 370000 | 170000 | ||||||||
| Net change in produced & licensed content costs & advances | -3192000 | -1685000 | 771000 | -1483000 | -925000 | -77000 | 59000 | -281000 | 468000 | ||||||||
| Net change in operating lease right of use assets / liabilities | 127000 | 146000 | 36000 | 16000 | -96000 | - | - | - | - | ||||||||
| Equity-based compensation | 428000 | 270000 | 134000 | 388000 | 246000 | 115000 | 591000 | 475000 | 92000 | ||||||||
| Other adjustments, net | 728000 | 490000 | 90000 | 471000 | 156000 | 65000 | 152000 | 121000 | 61000 | ||||||||
| Receivables | -301000 | -37000 | -1324000 | 2100000 | 828000 | -1424000 | -1428000 | -386000 | -1078000 | ||||||||
| Inventories | 236000 | 175000 | 94000 | 86000 | 70000 | 81000 | -96000 | -19000 | 32000 | ||||||||
| Other assets | -113000 | -131000 | -136000 | 8000 | -174000 | -33000 | 450000 | 46000 | 25000 | ||||||||
| Accounts payable & other accrued liabilities | - | - | - | - | - | - | - | - | -1289000 | ||||||||
| Accounts payable & other liabilities | 341000 | -780000 | -642000 | -1986000 | -888000 | -841000 | 219000 | -283000 | - | ||||||||
| Income taxes | -260000 | 400000 | -60000 | 95000 | -112000 | -256000 | -6248000 | -474000 | 130000 | ||||||||
| Net cash flows from operations - continuing operations | - | - | - | 5949000 | 4787000 | - | 4266000 | - | - | ||||||||
| Net cash flows from operating activities | 2934000 | 1468000 | 75000 | 5949000 | - | 1630000 | 4266000 | 6014000 | 2099000 | ||||||||
| Investments in parks, resorts & other property | -2468000 | -1530000 | -760000 | -3293000 | -2585000 | -1338000 | -3567000 | -2390000 | -1195000 | ||||||||
| Acquisitions | - | - | - | - | - | - | -9901000 | -9901000 | - | ||||||||
| Other investing activities | 383000 | 203000 | 28000 | -27000 | -21000 | -12000 | -317000 | -392000 | -141000 | ||||||||
| Net cash flows from (used in) investing activities - continuing operations | - | - | - | -3320000 | -2606000 | - | -13785000 | - | - | ||||||||
| Net cash flows from investing activities | -2085000 | -1327000 | -732000 | -3320000 | - | -1350000 | -13785000 | -12683000 | -1336000 | ||||||||
| Commercial paper borrowings/(payments), net | -99000 | -87000 | -179000 | 1373000 | 3138000 | 1172000 | 2973000 | 376000 | -302000 | ||||||||
| Borrowings | 43000 | 37000 | 1000 | 18030000 | 6071000 | 51000 | 31348000 | 31145000 | - | ||||||||
| Reduction of borrowings | -2319000 | -1816000 | -139000 | -2297000 | -1048000 | -46000 | -19039000 | -17398000 | - | ||||||||
| Dividends | - | - | - | -1587000 | -1587000 | - | -1310000 | -1310000 | - | ||||||||
| Proceeds from exercise of stock options | 405000 | 394000 | 209000 | 238000 | 207000 | 126000 | 278000 | 83000 | 37000 | ||||||||
| Acquisition of noncontrolling & redeemable noncontrolling interests | - | - | - | - | - | - | -1430000 | - | - | ||||||||
| Contributions from or sales of noncontrolling interests | - | - | - | - | - | - | 544000 | - | - | ||||||||
| Other financing activities | -801000 | -769000 | -225000 | -838000 | -165000 | -186000 | -831000 | -200000 | -146000 | ||||||||
| Net cash flows from financing activities - continuing operations | - | - | - | 14919000 | 6616000 | - | 12533000 | - | - | ||||||||
| Net cash flows from financing activities | -2771000 | -2241000 | -333000 | 14919000 | - | 1117000 | 12533000 | 12696000 | -411000 | ||||||||
| Cash flows from operating activities of discontinued operations | -2000 | 4000 | - | 2000 | 4000 | - | 320000 | - | - | ||||||||
| Cash flows from financing activities of discontinued operations | - | - | - | - | - | - | -179000 | - | - | ||||||||
| Cash flows from investing activities of discontinued operations | 8000 | 4000 | - | 198000 | 198000 | - | - | - | - | ||||||||
| Cash flows from operations - discontinued operations | 6000 | 8000 | 9000 | 200000 | 202000 | -19000 | 141000 | -35000 | - | ||||||||
| Impact of exchange rates on cash, cash equivalents & restricted cash | 77000 | 70000 | 139000 | -49000 | -76000 | 41000 | 47000 | 75000 | -44000 | ||||||||
| Change in cash, cash equivalents & restricted cash | -1839000 | -2022000 | -842000 | 17699000 | 8923000 | 1419000 | 3202000 | 6067000 | 308000 | ||||||||
| Cash, cash equivalents & restricted cash, beginning of period | 17954000 | 17954000 | 17954000 | 5455000 | 5455000 | 5455000 | 4155000 | 4155000 | 4155000 | ||||||||
| Cash, cash equivalents & restricted cash, end of period | 16115000 | 15932000 | 17112000 | 23154000 | 14378000 | 6874000 | 7357000 | 10222000 | 4463000 |
