Financial comparison analysis paper
MJones13
disneyworksheet.xlsxIncome statement
| Income Statements for Disney Corporation year ending on 2020 | ||
| 2020 | 2019 | |
| Revenue | 65,388.00 | 69,607.00 |
| Cost of goods sold | 43,880.00 | 42,061.00 |
| gross profit | 21,508.00 | 27,546.00 |
| Research and development expenses | - 0 | - 0 |
| SG&A Expenses | 12,369.00 | 11,549.00 |
| other operating income or expenses | - 0 | - 0 |
| operating Expenses | 67,329.00 | 58,960.00 |
| operating Income | (1,941.00) | 10,647.00 |
| Total Non-Operating Income/Expenses | 198.00 | 3,276.00 |
| Pre-tax Income | (1,743.00) | 13,923.00 |
| Income taxes | 699.00 | 3,026.00 |
| Income After taxes | (2,442.00) | 10,897.00 |
| Other Income | - 0 | - 0 |
| Income From Continuos Operations | (2,442.00) | 10,897.00 |
| Income From Discontinued Operations | (32.00) | 687.00 |
| Net Income | (2,864.00) | 11,054.00 |
| EBITDA | 8,357.00 | 14,814.00 |
| EBIT | (1,941.00) | 10,647.00 |
| Basic shares Outstanding | 1,808.00 | 1,656.00 |
| Shares Outstanding | 1,808.00 | 1,666.00 |
| Basic EPS | (1.58) | 6.68 |
| EPS- Earnings per share | (1.58) | 6.64 |
| Graphical representetion 2020 | ||
| Graphical representetion 2019 |
Revenue gross profit operating Income Pre-tax Income Income taxes Income After taxes Net Income EBITDA 69607 27546 10647 13923 3026 10897 11054 14814
Balance sheet
| Balance sheets of Disney Corporation for the year ending 2020 | ||
| 2020 | 2019 | |
| Items | ||
| Cash on hand | $ 17,914.00 | 5,418.00 |
| Receivable | $ 12,708.00 | 15,481.00 |
| Inventory | $ 1,583.00 | 1,649.00 |
| Pre-paid expenses | $ - 0 | - 0 |
| Other current assets | $ 875.00 | 979.00 |
| Total current assets | $ 35,251.00 | 28,124.00 |
| Property, plant and equipment | $ 26,594.00 | 26,174.00 |
| Longterm investment | $ 3,903.00 | 3,224.00 |
| Goodwill and intangible assets | $ 96,862.00 | 103,508.00 |
| Other long-term assets | $ 8,433.00 | 4,715.00 |
| Total long-term assets | $ 166,298.00 | 165,860.00 |
| Total assets | $ 201,549.00 | 193,984.00 |
| Total current liabilities | $ 26,628.00 | 31,341.00 |
| longterm Debt | $ 52,917.00 | 38,129.00 |
| Other Non-Current Liabilities | $ 17,204.00 | 13,760.00 |
| Total long term liabilities | $ 86,658.00 | 68,754.00 |
| Total liabilities | $ 113,286.00 | 100,095.00 |
| Common Stock Net | $ 54,497.00 | 53,907.00 |
| Retained Earnings (Accumulated Deficit) | $ 38,315.00 | 42,494.00 |
| Comprehensive income | $ (8,322.00) | (6,617.00) |
| Other Share Hol;ders Equity | $ - 0 | - 0 |
| Share holder Equity | $ 88,263.00 | 93,889.00 |
| Total Liabilities and Share Holders Equity | $ 201,549.00 | 193,984.00 |
| Graphical Representetion 2020 | ||
| Graphical representetion 2019 |
Total current assets Total assets Total current liabilities Total liabilities Share holder Equity Total Liabilities and Share Holders Equity 28124 193984 3134 1 100095 93889 193984
Cashflow statement
| Cashflow statements of Disney Corporation for the year ending 2020 | ||
| ITEMS | 2020 | 2019 |
| Net IncomeLoss | (2,442.00) | 10,897.00 |
| Total depreciation and amortization- Cash flow | 10,298.00 | 4,167.00 |
| Other Non-Cash Items | (633.00) | (3,048.00) |
| Total Non-Cash Items | 9,665.00 | 1,119.00 |
| Change in accounts Receivable | 1,943.00 | 55.00 |
| Change in Inventories | 14.00 | (223.00) |
| Change in accounts payable | - 0 | - 0 |
| Change in assets/Liabilities | 240.00 | 390.00 |
| Total change in Assets/Liabilites | (248.00) | (6,186.00) |
| Cash flow from operating activites | 7,616.00 | 5,984.00 |
| Net change in property, plant and Equipment | (4,022.00) | (4,876.00) |
| Net change in intangible Assets | - 0 | - 0 |
| Net acquisation/Divestitures | - 0 | (9,901.00) |
| Net change in short-term Investments | - 0 | - 0 |
| Net change in long-term investments | - 0 | - 0 |
| Net Change in investments- Total | - 0 | - 0 |
| Investing Activities- Other | 172.00 | (319.00) |
| Cash Flow From Investing Activities | (3,850.00) | (15,096.00) |
| Net Long-term Debt | 14,587.00 | (641.00) |
| Net Current Debt | (3,354.00) | 4,318.00 |
| Debt issuanceRetirement Net -Total | 11,233.00 | 3,677.00 |
| Net common equity issued/repurchased | 305.00 | 318.00 |
| Net Total Equity issued repurchased | 305.00 | 318.00 |
| Total common and preferred stock dividends paid | (1,587.00) | (2,895.00) |
| Financial activities- other | (1,471.00) | (1,564.00) |
| Cash Flow from financial activities | 8,480.00 | (464.00) |
| Net Cash Flow | 12,499.00 | 1,300.00 |
| Stock-Based compensation | 525.00 | 711.00 |
| Common stock dividends paid | (1,587.00) | (2,895.00) |
| Graphical representetion 2020 | ||
| Graphical representetion 2019 |
Cash flow from operating activites Cash Flow From Investing Activities Cash Flow from financial activities Net Cash Flow 5984 -15096 -464 1300
Cash flow from operating activites Cash Flow From Investing Activities Cash Flow from financial activities Net Cash Flow 7616 -3850 8480 12499
Financial ratio
| Profitability Ratio | ||
| Return on assets (ROA) | ||
| 2020 | 2019 | |
| -0.014209944 | 0.0569840812 | |
| Return on Equity | ||
| 2020 | 2019 | |
| -0.0324484778 | 0.1177347719 | |
| Liquidity ratio | ||
| Quick Ratio | ||
| 2020 | 2019 | |
| (1,382.95) | 1,308.61 | |
| Day’s sales outstanding | ||
| 2020 | 2019 | |
| 1.26 | 0.84 | |
| E.) Long-term solvency ratios | ||
| Debt to equity ratio | ||
| 2020 | 2019 | |
| 1.2835049794 | 1.0660993301 | |
| Debt to asset ratio | ||
| 2020 | 2019 | |
| 0.5620767158 | 0.5159961646 | |
| Efficiency/Valuation ratios: | ||
| Accounts receivable turnover ratio | ||
| 2020 | 2019 | |
| 5.1454202077 | 4.4962857697 | |
| Asset turnover ratio | ||
| 2020 | 2019 | |
| 3.7098522028 | 4.9500071114 | |
| Leverage ratios: | ||
| Current ratio | ||
| 2020 | 2019 | |
| 1.3238320565 | 0.8973549025 | |
| Time Interest earned ratio | ||
| EBIT/ Interest expense | ||
| 2020 | 2019 | |
| -2.4935622318 | 4.6011235955 |
