Answered step by step
Verified Expert Solution
Link Copied!

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:

  1. 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:
    1. Working capital
    2. Current ratio
    3. Debt ratio
    4. Earnings per share
    5. Price/earnings ratio
    6. Total asset turnover ratio
    7. Financial leverage
    8. Net profit margin
    9. Return on assets
    10. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Control Procedure For Statutory Financial Audit An Empirical Study

Authors: Siddhartha Sankar Saha, Mitrendu Narayan Roy

1st Edition

1787142272, 9781787142275

More Books

Students also viewed these Accounting questions

Question

How can we use language to enhance skill in perceiving?

Answered: 1 week ago