Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The balance sheet, income statement, and cash flow statement from the most recent fiscal quarter below The Ratios Most Recent Fiscal Qtr worksheet in the
- The balance sheet, income statement, and cash flow statement from the most recent fiscal quarter below
- The Ratios Most Recent Fiscal Qtr worksheet in the Financial Formulasworkbook.
- For example, if the most recent fiscal quarter available is the third quarter in 2022, you'll compare those results to the same financial calculations from the third quarter in 2021.
Use the documents to calculate key financial ratios.
Then open the following documents:
- The balance sheet, income statement, and cash flow statement from the same fiscal quarter one year ago
- The Ratios Same Fiscal Qtr 1 Year Ago worksheet
Use the documents to calculate the same financial ratios. Finally, compare those ratios and analyze your results.
Specifically, address the following rubric criteria:
- Financial Calculations. Calculate accurate financial formulas to assess the business's current financial health. Specifically, calculate the following formulas using the Ratios Most Recent Fiscal Qtr and the Ratios Same Fiscal Qtr 1 Year Ago worksheets in the Project Two Financial Formulas workbook:
- Working capital
- Current ratio
- Debt ratio
- Earnings per share
- Price/earnings ratio
- Total asset turnover ratio
- Financial leverage
- Net profit margin
- Return on assets
- Return on equity
Disney (Walt) Co. (The) (NYS: DIS) | |||||||||
Exchange rate used is that of the Year End reported date | |||||||||
As Reported Annual Balance Sheet | |||||||||
Report Date | 10/01/2022 | 10/02/2021 | 10/03/2020 | 09/28/2019 | 09/29/2018 | ||||
Currency | USD | USD | USD | USD | USD | ||||
Audit Status | Not Qualified | Not Qualified | Not Qualified | Not Qualified | Not Qualified | ||||
Consolidated | Yes | Yes | Yes | Yes | Yes | ||||
Scale | Thousands | Thousands | Thousands | Thousands | Thousands | ||||
Cash & cash equivalents | 11615000 | 15959000 | 17914000 | 5418000 | 4150000 | ||||
Accounts receivable | 10811000 | - | - | 12882000 | 8268000 | ||||
Other receivables | 1999000 | - | - | 2894000 | 1258000 | ||||
Allowance for doubtful accounts | 158000 | - | - | 295000 | 192000 | ||||
Receivables, net | 12652000 | 13367000 | 12708000 | 15481000 | 9334000 | ||||
Inventories | 1742000 | 1331000 | 1583000 | 1649000 | 1392000 | ||||
Content advances | 1890000 | 2183000 | - | - | - | ||||
Licensed content costs & advances | - | - | 2171000 | 4597000 | 1314000 | ||||
Prepaid expenses | - | - | - | - | 476000 | ||||
Other current assets | - | - | - | - | 159000 | ||||
Other current assets | 1199000 | 817000 | 875000 | 979000 | 635000 | ||||
Total current assets | 29098000 | 33657000 | 35251000 | 28124000 | 16825000 | ||||
Produced & licensed content costs | 35777000 | 29549000 | 25022000 | 22810000 | 7888000 | ||||
Investments | 3218000 | 3935000 | 3903000 | 3224000 | 2899000 | ||||
Attractions, buildings & improvements | 33795000 | 32765000 | 31279000 | 29509000 | 28995000 | ||||
Furniture, fixtures & equipment | 24409000 | 24008000 | 22976000 | 21265000 | 19400000 | ||||
Land improvements | 7757000 | 7061000 | 6828000 | 6649000 | 5911000 | ||||
Leasehold improvements | 1037000 | 1058000 | 1028000 | 1166000 | 932000 | ||||
Attractions, buildings & equipment, at cost | 66998000 | 64892000 | 62111000 | 58589000 | 55238000 | ||||
Accumulated depreciation | 39356000 | 37920000 | 35517000 | 32415000 | 30764000 | ||||
Parks, resorts & other property, before projects in progress & land | 27642000 | 26972000 | 26594000 | 26174000 | 24474000 | ||||
Projects in progress | 4814000 | 4521000 | 4449000 | 4264000 | 3942000 | ||||
Land | 1140000 | 1131000 | 1035000 | 1165000 | 1124000 | ||||
Parks, resorts & other property, net | 33596000 | 32624000 | 32078000 | 31603000 | 29540000 | ||||
Intangible assets, net | 14837000 | 17115000 | 19173000 | 23215000 | 6812000 | ||||
Goodwill | 77897000 | 78071000 | 77689000 | 80293000 | 31269000 | ||||
Receivables | - | - | - | - | 1928000 | ||||
Prepaid expenses | - | - | - | - | 919000 | ||||
Other non-current assets | - | - | - | - | 518000 | ||||
Other assets | 9208000 | 8658000 | 8433000 | 4715000 | 3365000 | ||||
Total assets | ######## | ######## | ######## | ######## | 98598000 | ||||
Accounts payable | - | - | 12663000 | 13778000 | 6503000 | ||||
Accounts & accrued payables | 16205000 | 16357000 | - | - | - | ||||
Payroll & employee benefits | 3447000 | 3482000 | 2925000 | 3010000 | 2189000 | ||||
Other accounts payable & accrued liabilities | 561000 | 1055000 | 1213000 | 974000 | 787000 | ||||
Accounts payable & other accrued liabilities | 20213000 | 20894000 | 16801000 | 17762000 | 9479000 | ||||
Current portion of borrowings | 3070000 | 5866000 | 5711000 | 8857000 | 3790000 | ||||
Deferred revenue & other current liabilities | 5790000 | 4317000 | 4116000 | 4722000 | 4591000 | ||||
Total current liabilities | 29073000 | 31077000 | 26628000 | 31341000 | 17860000 | ||||
Commercial paper | 1662000 | 1992000 | 2023000 | 5342000 | 1005000 | ||||
U.S. & european medium-term notes | - | - | - | - | 17942000 | ||||
Capital Cities/ABC, Inc. debt | - | - | - | - | 103000 | ||||
U.S. dollar denominated notes | 45091000 | 49090000 | 52736000 | 39424000 | - | ||||
Foreign currency denominated debt | 1844000 | 2011000 | 1983000 | 1044000 | 955000 | ||||
Other borrowings | -1653000 | -18000 | 583000 | 62000 | -276000 | ||||
Total long-term borrowings - Disney Co. | 46944000 | 53075000 | 57325000 | 45872000 | 19729000 | ||||
Asia Theme Parks borrowings | 1425000 | 1331000 | 1303000 | 1114000 | 1145000 | ||||
Total borrowings | 48369000 | 54406000 | 58628000 | 46986000 | 20874000 | ||||
Less current portion | 3070000 | 5866000 | 5711000 | 8857000 | 3790000 | ||||
Borrowings | 45299000 | 48540000 | 52917000 | 38129000 | 17084000 | ||||
Deferred income taxes | 8363000 | 7246000 | 7288000 | 7902000 | 3109000 | ||||
Pension & postretirement medical plan liabilities | 1940000 | 4132000 | 6451000 | 4783000 | 2712000 | ||||
Operating & financing lease liabilities | 3239000 | 3229000 | - | - | - | ||||
Other long-term liabilities | 7339000 | 7161000 | 10753000 | 8977000 | 3878000 | ||||
Other long-term liabilities | 12518000 | 14522000 | 17204000 | 13760000 | 6590000 | ||||
Redeemable noncontrolling interests | 9499000 | 9213000 | 9249000 | 8963000 | 1123000 | ||||
Common stock | 56398000 | 55471000 | 54497000 | 53907000 | 36779000 | ||||
Retained earnings (accumulated deficit) | 43636000 | 40429000 | 38315000 | 42494000 | 82679000 | ||||
Market value adjustments for investments | - | - | - | -2000 | 15000 | ||||
Market value adjustments for cash flow hedges | 625000 | -110000 | - | 102000 | 145000 | ||||
Market value adjustments | - | - | -151000 | - | - | ||||
Unrecognized pension & postretirement medical expense | -2869000 | -5372000 | -7222000 | -5746000 | -2633000 | ||||
Foreign currency translation & other accumulated other comprehensive income (loss) | - | - | - | -971000 | -624000 | ||||
Foreign currency translation adjustments | -1875000 | -958000 | -949000 | - | - | ||||
Accumulated other comprehensive income (loss) | -4119000 | -6440000 | -8322000 | -6617000 | -3097000 | ||||
Stockholders' equity subtotal | - | - | - | - | ######## | ||||
Treasury stock, at cost | 907000 | 907000 | 907000 | 907000 | 67588000 | ||||
Total The Walt Disney Company shareholders' equity | 95008000 | 88553000 | 83583000 | 88877000 | 48773000 | ||||
Noncontrolling interests | 3871000 | 4458000 | 4680000 | 5012000 | 4059000 | ||||
Total equity | 98879000 | 93011000 | 88263000 | 93889000 | 52832000 |
Disney (Walt) Co. (The) (NYS: DIS) | |||||||||||
Exchange rate used is that of the Year End reported date | |||||||||||
As Reported Annual Income Statement | |||||||||||
Report Date | 10/01/2022 | 10/02/2021 | 10/03/2020 | ||||||||
Currency | USD | USD | USD | ||||||||
Audit Status | Not Qualified | Not Qualified | Not Qualified | ||||||||
Consolidated | Yes | Yes | Yes | ||||||||
Scale | Thousands | Thousands | Thousands | ||||||||
Revenues - services | 74200000 | 61768000 | 59265000 | ||||||||
Revenues - products | 8522000 | 5650000 | 6123000 | ||||||||
Total revenues | 82722000 | 67418000 | 65388000 | ||||||||
Cost of services (exclusive of depreciation & amortization) | 48962000 | 41129000 | 39406000 | ||||||||
Cost of products (exclusive of depreciation & amortization) | 5439000 | 4002000 | 4474000 | ||||||||
Selling, general, administrative & other expenses | 16388000 | 13517000 | 12369000 | ||||||||
Depreciation & amortization | 5163000 | 5111000 | 5345000 | ||||||||
Total costs & expenses | -75952000 | -63759000 | -61594000 | ||||||||
Restructuring & impairment charges | 237000 | 654000 | 5735000 | ||||||||
DraftKings gain (loss) | -663000 | -111000 | 973000 | ||||||||
fuboTV gain | - | 186000 | - | ||||||||
German FTA gain | - | 126000 | - | ||||||||
Gain on sale of an investment | - | - | 65000 | ||||||||
Other income (expense), net | -4000 | - | - | ||||||||
Other income (expense), net | -667000 | 201000 | 1038000 | ||||||||
Interest expense | 1549000 | 1546000 | 1647000 | ||||||||
Interest & investment income | 152000 | 140000 | 156000 | ||||||||
Interest income (expense), net | -1397000 | -1406000 | -1491000 | ||||||||
Equity in the income (loss) of investees | 816000 | 761000 | 651000 | ||||||||
Income (loss) before income taxes - domestic (including U.S. exports) | 5955000 | 5241000 | 4706000 | ||||||||
Income (loss) before income taxes - foreign subsidiaries | -670000 | -2680000 | -6449000 | ||||||||
Income (loss) from continuing operations before income taxes | 5285000 | 2561000 | -1743000 | ||||||||
Current income tax expense (benefit) - federal | 436000 | 594000 | 95000 | ||||||||
Current income tax expense (benefit) - state | 282000 | 129000 | 148000 | ||||||||
Current income tax expense (benefit) - foreign | 846000 | 554000 | 731000 | ||||||||
Total current income tax expense (benefit) | 1564000 | 1277000 | 974000 | ||||||||
Deferred income tax expense (benefit) - federal | 407000 | -526000 | 279000 | ||||||||
Deferred income tax expense (benefit) - state | 26000 | -220000 | -29000 | ||||||||
Deferred income tax expense (benefit) - foreign | -265000 | -506000 | -525000 | ||||||||
Total deferred income tax expense (benefit) | 168000 | -1252000 | -275000 | ||||||||
Income taxes on continuing operations | 1732000 | 25000 | 699000 | ||||||||
Net income (loss) from continuing operations | 3553000 | 2536000 | -2442000 | ||||||||
Income (loss) from discontinued operations | -48000 | -29000 | -32000 | ||||||||
Net income (loss) | 3505000 | 2507000 | -2474000 | ||||||||
Less: net income (loss) from continuing operations attributable to noncontrolling & redeemable noncontrolling interests | -360000 | -512000 | -390000 | ||||||||
Net income attributable to The Walt Disney Company (Disney) | 3145000 | 1995000 | -2864000 | ||||||||
Weighted average common & common equivalent shares outstanding - basic | 1822000 | 1816000 | 1808000 | ||||||||
Weighted average common & common equivalent shares outstanding - diluted | 1827000 | 1828000 | 1808000 | ||||||||
Year end shares outstanding | 1781000 | 1781000 | 1781000 | ||||||||
Earnings (loss) per share from continuing operations - basic | 1.75 | 1.11 | -1.57 | ||||||||
Earnings (loss) per share from discontinued operations - basic | -0.03 | -0.02 | -0.02 | ||||||||
Net earnings (loss) per share - basic | 1.73 | 1.1 | -1.58 | ||||||||
Earnings (loss) per share from continuing operations - diluted | 1.75 | 1.11 | -1.57 | ||||||||
Earnings (loss) per share from discontinued operations - diluted | -0.03 | -0.02 | -0.02 | ||||||||
Net earnings (loss) per share - diluted | 1.72 | 1.09 | -1.58 | ||||||||
Dividends per share | - | - | 0.88 | ||||||||
Total number of employees | 220000 | 190000 | 203000 | ||||||||
Number of common stockholders | 793000 | 813000 | 826250 | ||||||||
Foreign currency translation adjustments | -1060000 | 77000 | 115000 |
Disney (Walt) Co. (The) (NYS: DIS) | |||||
Exchange rate used is that of the Year End reported date | |||||
As Reported Annual Cash Flow | |||||
Report Date | 10/01/2022 | 10/02/2021 | 10/03/2020 | ||
Currency | USD | USD | USD | ||
Audit Status | Not Qualified | Not Qualified | Not Qualified | ||
Consolidated | Yes | Yes | Yes | ||
Scale | Thousands | Thousands | Thousands | ||
Net income (loss) from continuing operations | 3553000 | 2536000 | -2442000 | ||
Depreciation & amortization | 5163000 | 5111000 | 5345000 | ||
Goodwill & intangible asset impairment | - | - | 4953000 | ||
Net loss (gain) on investments | 714000 | - | - | ||
Net loss (gain) on investments, acquisitions & dispositions | - | -332000 | -920000 | ||
Deferred income taxes | 200000 | -1241000 | -392000 | ||
Equity in the loss (income) of investees | -816000 | -761000 | -651000 | ||
Cash distributions received from equity investees | 779000 | 754000 | 774000 | ||
Net change in produced & licensed content costs & advances | -6271000 | -4301000 | 397000 | ||
Net change in operating lease right of use assets / liabilities | - | 46000 | 31000 | ||
Equity-based compensation | 977000 | 600000 | 525000 | ||
Pension & postretirement medical amortization | 620000 | 816000 | - | ||
Other adjustments | 595000 | 144000 | 641000 | ||
Receivables | 605000 | -357000 | 1943000 | ||
Inventories | -420000 | 252000 | 14000 | ||
Other assets | -707000 | 171000 | -157000 | ||
Accounts payable & other liabilities | 964000 | 2410000 | -2293000 | ||
Income taxes | 46000 | -282000 | -152000 | ||
Net cash flows from operating activities - continuing operations | 6002000 | 5566000 | - | ||
Net cash flows from operating activities | 6002000 | 5566000 | 7616000 | ||
Investments in parks, resorts & other property | -4943000 | -3578000 | -4022000 | ||
Other investing activities, net | -65000 | 407000 | 172000 | ||
Net cash flows from investing activities - continuing operations | -5008000 | -3171000 | - | ||
Net cash flows from investing activities | -5008000 | -3171000 | -3850000 | ||
Commercial paper borrowings (payments), net | -334000 | -26000 | -3354000 | ||
Borrowings | 333000 | 64000 | 18120000 | ||
Reduction of borrowings | -4016000 | -3737000 | -3533000 | ||
Dividends | - | - | -1587000 | ||
Proceeds from exercise of stock options | 127000 | 435000 | 305000 | ||
Contributions from or sales of noncontrolling interests | - | 91000 | 94000 | ||
Acquisitions of noncontrolling & redeemable noncontrolling interests | - | -350000 | - | ||
Other financing activities | -839000 | -862000 | -1565000 | ||
Net cash flows from financing actvities - continuing operations | -4729000 | -4385000 | - | ||
Net cash flows from financing actvities | -4729000 | -4385000 | 8480000 | ||
Cash flows from operating activities of discontinued operations | 8000 | 1000 | 2000 | ||
Cash flows from investing activities of discontinued operations | - | 8000 | 213000 | ||
Cash flows from financing activities of discontinued operations | -12000 | - | - | ||
Cash from (used in) discontinued operations | -4000 | 9000 | 215000 | ||
Impact of exchange rates on cash, cash equivalents & restricted cash | -603000 | 30000 | 38000 | ||
Change in cash, cash equivalents & restricted cash | -4342000 | -1951000 | 12499000 | ||
Cash, cash equivalents & restricted cash, beginning of year | 16003000 | 17954000 | 5455000 | ||
Cash, cash equivalents & restricted cash, end of year | 11661000 | 16003000 | 17954000 | ||
Interest paid | 1685000 | 1892000 | 1559000 | ||
Income taxes paid | 1097000 | 1638000 | 738000 |
Fill In
ACCOUNTING & FINANCIAL RATIOS Most Recent Fiscal QTR | |||||||||||||||
CURRENT RATIO (Current Assets / Current Liabilities) 2022 | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||||
Current Assets | Total Revenue | ||||||||||||||
Current Liabilities | #DIV/0! | Total Assets | #DIV/0! | ||||||||||||
WORKING CAPITAL (Current Assets - Current Liabilities) | FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | ||||||||||||||
Current Assets | Total Assets | ||||||||||||||
Current Liabilities | 0 | Shareholder's Equity | #DIV/0! | ||||||||||||
DEBT RATIO (Total Liabilities / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||||
Total Liabilities | Net Income | ||||||||||||||
Total Assets | #DIV/0! | Total Revenue | #DIV/0! | ||||||||||||
EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||||
Net Income | Net Income | ||||||||||||||
Shares Outstanding | #DIV/0! | Total Assets | #DIV/0! | ||||||||||||
PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||||
Stock Price | NI - Pref. Div. | ||||||||||||||
EPS | #DIV/0! | Shareholder's Equity | #DIV/0! | ||||||||||||
ACCOUNTING & FINANCIAL RATIOS SAME FISCAL QTR 1 YR AGO | |||||||||||||||
CURRENT RATIO (Current Assets / Current Liabilities)2021 | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||||
Current Assets | Total Revenue | ||||||||||||||
Current Liabilities | #DIV/0! | Total Assets | #DIV/0! | ||||||||||||
WORKING CAPITAL (Current Assets - Current Liabilities) | FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | ||||||||||||||
Current Assets | Total Assets | ||||||||||||||
Current Liabilities | 0 | Shareholder's Equity | #DIV/0! | ||||||||||||
DEBT RATIO (Total Liabilities / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||||
Total Liabilities | Net Income | ||||||||||||||
Total Assets | #DIV/0! | Total Revenue | #DIV/0! | ||||||||||||
EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||||
Net Income | Net Income | ||||||||||||||
Shares Outstanding | #DIV/0! | Total Assets | #DIV/0! | ||||||||||||
PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||||
Stock Price | NOT AVAILABLE | NI - Pref. Div. | |||||||||||||
EPS | #VALUE! | Shareholder's Equity | #DIV/0! | ||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started