Using the Project Two Financial Formulas spreadsheet the balance sheet, income statement, and cash flow statement from Mergent Online (see attached) for DISNEY company, calculate the financial ratios for the most recent fiscal quarter. Then, compare those ratios with the same ratios for the same fiscal quarter from one year prior in Mergent Online, (already attached, it's the balance sheet , income sheet and cash flow statement) and analyze your results.

_{PLEASE DON'T FORGET THE EXCEL FORMULAS FROM THE RESULTS.}

Specifically, you must address the following rubric criteria:

• Financial Calculations: Calculate accurate financial ratios to assess the businesss current financial health. Specifically, calculate the following ratios:
  • 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

• Fiscal Quarter Comparison: Using Mergent Online, summarize the differences between the results from your financial calculations of the most recent fiscal quarter and the results of the same financial calculations of the same fiscal quarter from a year before for your chosen business.
  • For example, if the most recent fiscal quarter available is the 3rd quarter in 2020, then you will compare those results to the same financial calculations from the 3rd quarter in 2019.

• Comparison Analysis: Explain what the results of your calculations and your comparison indicate about the businesss current financial health, providing examples to support your explanation. You might consider the following questions:
  • Do the results indicate the business is financially healthy or financially unhealthy? Which results indicate this?
  • What might be the cause(s) of the businesss financial success or failure?
  • Is more information needed to determine the businesss financial health? If so, which pieces of information might still be needed?

• Short-Term Financing: Explain how potential short-term financing sources could help the business raise needed funds to improve its financial health. Base your response on the businesss current financial information.

B9 WORKING CAPITAL (Current Assets - Current Liabilities) B D E F M N 0 P ACCOUNTING & FINANCIAL RATIOS CURRENT RATIO (Current Assets / Current Liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) ( Current Assets Current Liabilities #DIV/0! # Total Revenue Total Assets #DIV/0! WORKING CAPITAL (Current Assets - Current Liabilities FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) () 21 10 11 12 13 14 Current Assets Current Liabilities Total Assets Shareholder's Equity #! #DIV/0! DEBT RATIO (Total Debt / Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue) 15 16 17 Total Debt Net Income Total Assets #DIV/0! Total Revenue #DIV/0! #! 18 19 20 21 EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding RETURN ON ASSETS (Net Income / Total Assets) 24 Net Income Shares Outstanding Net Income Total Assets #DIV/0! #DIV/0! PRICE EARNINGS RATIO (Share Price (end of quarter/EPS) RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) 26 27 28 29 30 31 32 Stock Price EPS #DIV/0! NI - Pref. Div. Shareholder's Equity #DIV/0! Disney (Walt) Co. (The) (NYS: DIS) C Standardized Annual Balance Sheet Report Date Currency Audit Status Consolidated Scale Standardized Annual Income Statement Report Date Currency Audit Status 10/02/2021 USD Not Standardized Annual Cash Flows Report Date Currency Audit Status Qualified Yes Thousands 67418000 67418000 45131000 22287000 13517000 5111000 654000 29000 0 19282000 3005000 10/03/2020 USD Not Qualified Yes Th. Thousands co 65388000 65388000 43880000 21508000 1900 12369000 5345000 5735000 0 10/02/2021 USD Not Qualified Yes Thousands 2536000 836000 2194000 5566000 -3578000 Consolidated Scale Sales Revenue Total Revenue Direct Costs Gross Profit Sale Selling General & Admin Depreciation & Amortization Restruct Remediation & Impair ce Other Operating Expense . Total Indirect Operating costs Operaune income Interest Income Gains on Sale of Assets Other Non-Operating Income Total Non-Operating Income Earnings Before Tax 10/03/2020 USD Not Qualified Yes Thousands -2442000 10703000 -645000 7616000 -4022000 Cash & Equivalents Cash & Equivs & ST Investments Receivables (ST) Inventories Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Long Term Investments Intangible Assets Other Assets Total Assets Accounts Payable & Accrued Exps Accounts Payable Accrued Expenses Current Debt Other Current Liabilities Total Current Liabilities LT Debt & Leases Pensions & OPEB Deferred LT Liabilities Minority Interests Other Liabilities Total Liabilities Common Share Capital Retained Earnings Accum Other Comprehensive Income Treasury Stock For Curr Trans (BS) Other Equity Total Equity Total Liabilities & Equity -1406000 10/02/2021 USD Not Qualified Yes Thousands 15959000 15959000 13367000 1331000 3000000 33657000 70544000 37920000 32624000 3935000 95186000 38207000 203609000 20894000 17412000 3482000 5866000 4317000 31077000 48540000 4132000 7246000 13671000 10390000 115056000 55471000 40429000 -6440000 907000 -958000 958000 88553000 203609000 10/03/2020 USD Not Qualified Yes Thousands 17914000 17914000 12708000 1583000 3046000 35251000 67595000 35517000 32078000 3903000 96862000 33455000 201549000 16801000 13876000 2925000 5711000 4116000 26628000 52917000 6451000 7288000 13929000 10753000 117966000 54497000 38315000 -8322000 907000 -949000 949000 83583000 201549000 201000 0 - 1205000 1800000 Taxation 23449000 -1941000 -1491000 1038000 0 -453000 -2394000 699000 390000 651000 -32000 0 0 -2864000 0 407000 -3171000 -3699000 435000 25000 Consolidated Scale Net Income Adjustments from Inc to Cash Change in Working Capital Cash Flow from Operations Purchase of Pty Plant & Equip Change in Business Activities Other Investing Cash Flows Cash Flow from Investing Change in LT Debt Change in Equity Payment of Dividends Other Financing Cash Flows Cash Flow from Financing Effect of Exchange Rate Cash from Discontinued Ops Change in Cash Opening Cash Closing Cash Depn & Amortn (CF) Net Purch of Pty Plant & Equip 512000 761000 - 29000 0 0 1995000 Minority Interests Equity Earnings Discontinued Operations Extraordinary Items Accounting Changes Net Income Freterence Preference Dividends & Similar Net Income to Common Average Shares Basic EPS Net Basic NDOSI EPS Continuing Basic Average Shares Diluted EPS Net Diluted EPS Continuing Diluted Shares Outstanding 0 172000 -3850000 11233000 305000 -1587000 -1471000 8480000 38000 215000 12499000 5455000 17954000 5345000 -4022000 -2864000 - 1121000 -4385000 30000 9000 -1951000 17954000 16003000 5927000 -3578000 1995000 1816000 1.1 1.11 102 1828000 1.09 1.11 1781000 1808000 -1.58 -1.57 1808000 -1.58 -1.57 1781000 B9 WORKING CAPITAL (Current Assets - Current Liabilities) B D E F M N 0 P ACCOUNTING & FINANCIAL RATIOS CURRENT RATIO (Current Assets / Current Liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) ( Current Assets Current Liabilities #DIV/0! # Total Revenue Total Assets #DIV/0! WORKING CAPITAL (Current Assets - Current Liabilities FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) () 21 10 11 12 13 14 Current Assets Current Liabilities Total Assets Shareholder's Equity #! #DIV/0! DEBT RATIO (Total Debt / Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue) 15 16 17 Total Debt Net Income Total Assets #DIV/0! Total Revenue #DIV/0! #! 18 19 20 21 EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding RETURN ON ASSETS (Net Income / Total Assets) 24 Net Income Shares Outstanding Net Income Total Assets #DIV/0! #DIV/0! PRICE EARNINGS RATIO (Share Price (end of quarter/EPS) RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) 26 27 28 29 30 31 32 Stock Price EPS #DIV/0! NI - Pref. Div. Shareholder's Equity #DIV/0! Disney (Walt) Co. (The) (NYS: DIS) C Standardized Annual Balance Sheet Report Date Currency Audit Status Consolidated Scale Standardized Annual Income Statement Report Date Currency Audit Status 10/02/2021 USD Not Standardized Annual Cash Flows Report Date Currency Audit Status Qualified Yes Thousands 67418000 67418000 45131000 22287000 13517000 5111000 654000 29000 0 19282000 3005000 10/03/2020 USD Not Qualified Yes Th. Thousands co 65388000 65388000 43880000 21508000 1900 12369000 5345000 5735000 0 10/02/2021 USD Not Qualified Yes Thousands 2536000 836000 2194000 5566000 -3578000 Consolidated Scale Sales Revenue Total Revenue Direct Costs Gross Profit Sale Selling General & Admin Depreciation & Amortization Restruct Remediation & Impair ce Other Operating Expense . Total Indirect Operating costs Operaune income Interest Income Gains on Sale of Assets Other Non-Operating Income Total Non-Operating Income Earnings Before Tax 10/03/2020 USD Not Qualified Yes Thousands -2442000 10703000 -645000 7616000 -4022000 Cash & Equivalents Cash & Equivs & ST Investments Receivables (ST) Inventories Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Long Term Investments Intangible Assets Other Assets Total Assets Accounts Payable & Accrued Exps Accounts Payable Accrued Expenses Current Debt Other Current Liabilities Total Current Liabilities LT Debt & Leases Pensions & OPEB Deferred LT Liabilities Minority Interests Other Liabilities Total Liabilities Common Share Capital Retained Earnings Accum Other Comprehensive Income Treasury Stock For Curr Trans (BS) Other Equity Total Equity Total Liabilities & Equity -1406000 10/02/2021 USD Not Qualified Yes Thousands 15959000 15959000 13367000 1331000 3000000 33657000 70544000 37920000 32624000 3935000 95186000 38207000 203609000 20894000 17412000 3482000 5866000 4317000 31077000 48540000 4132000 7246000 13671000 10390000 115056000 55471000 40429000 -6440000 907000 -958000 958000 88553000 203609000 10/03/2020 USD Not Qualified Yes Thousands 17914000 17914000 12708000 1583000 3046000 35251000 67595000 35517000 32078000 3903000 96862000 33455000 201549000 16801000 13876000 2925000 5711000 4116000 26628000 52917000 6451000 7288000 13929000 10753000 117966000 54497000 38315000 -8322000 907000 -949000 949000 83583000 201549000 201000 0 - 1205000 1800000 Taxation 23449000 -1941000 -1491000 1038000 0 -453000 -2394000 699000 390000 651000 -32000 0 0 -2864000 0 407000 -3171000 -3699000 435000 25000 Consolidated Scale Net Income Adjustments from Inc to Cash Change in Working Capital Cash Flow from Operations Purchase of Pty Plant & Equip Change in Business Activities Other Investing Cash Flows Cash Flow from Investing Change in LT Debt Change in Equity Payment of Dividends Other Financing Cash Flows Cash Flow from Financing Effect of Exchange Rate Cash from Discontinued Ops Change in Cash Opening Cash Closing Cash Depn & Amortn (CF) Net Purch of Pty Plant & Equip 512000 761000 - 29000 0 0 1995000 Minority Interests Equity Earnings Discontinued Operations Extraordinary Items Accounting Changes Net Income Freterence Preference Dividends & Similar Net Income to Common Average Shares Basic EPS Net Basic NDOSI EPS Continuing Basic Average Shares Diluted EPS Net Diluted EPS Continuing Diluted Shares Outstanding 0 172000 -3850000 11233000 305000 -1587000 -1471000 8480000 38000 215000 12499000 5455000 17954000 5345000 -4022000 -2864000 - 1121000 -4385000 30000 9000 -1951000 17954000 16003000 5927000 -3578000 1995000 1816000 1.1 1.11 102 1828000 1.09 1.11 1781000 1808000 -1.58 -1.57 1808000 -1.58 -1.57 1781000