Project Two Milestone: Comparison Analysis - Disney
lavnflo41
Fin320ModuleTwoDisneyFinancialStatement.xlsxBalance sheet
| Date | Total Assets | Total Liabilities Net Minority Interest | Total Equity Gross Minority Interest | Total Capitalization | Common Stock Equity | Net Tangible Assets | Working Capital | Invested Capital | Tangible Book Value | Total Debt | Net Debt | Share Issued | Ordinary Shares Number | Treasury Shares Number |
| 12/30/2020 | 201,888,000 | 113,160,000 | 88,728,000 | 136,949,000 | 84,071,000 | -12,371,000 | 8,328,000 | 142,346,000 | -12,371,000 | 58,275,000 | 41,207,000 | 1,800,000 | 1,781,000 | 19,000 |
| 9/29/2020 | 201,549,000 | 113,286,000 | 88,263,000 | 136,500,000 | 83,583,000 | -13,279,000 | 8,623,000 | 142,211,000 | -13,279,000 | 58,628,000 | 40,714,000 | 1,826,063 | 1,807,063 | 19,000 |
| 6/29/2020 | 207,649,000 | 117,186,000 | 90,463,000 | 140,063,000 | 85,866,000 | -10,956,000 | 10,413,000 | 150,287,000 | -10,956,000 | 64,421,000 | 41,306,000 | 1,800,000 | 1,781,000 | 19,000 |
| 3/30/2020 | 206,294,000 | 111,417,000 | 94,877,000 | 133,177,000 | 90,407,000 | -11,950,000 | -2,199,000 | 145,853,000 | -11,950,000 | 55,446,000 | 41,107,000 | 1,800,000 | 1,781,000 | 19,000 |
Income statement
| Breakdown | Total Revenue | Cost of Revenue | Gross Profit | Operating Expense | Operating Income | Net Non Operating Interest Income Expense | Other Income Expense | Pretax Income | Tax Provision | Net Income Common Stockholders | Diluted NI Available to Com Stockholders | Basic EPS | Diluted EPS | Basic Average Shares | Diluted Average Shares | Total Expenses | Net Income from Continuing & Discontinued Operation | Normalized Income | Interest Income | Interest Expense | Net Interest Income | EBIT | EBITDA | Reconciled Cost of Revenue | Reconciled Depreciation | Net Income from Continuing Operation Net Minority Interest | Total Unusual Items Excluding Goodwill | Total Unusual Items | Normalized EBITDA | Tax Rate for Calcs | Tax Effect of Unusual Items |
| TTM | 60,760,000 | 42,621,000 | 18,139,000 | 16,921,000 | 1,218,000 | -1,496,000 | -4,045,000 | -4,323,000 | 257,000 | -4,954,000 | -4,954,000 | - | - | - | - | 59,542,000 | -4,954,000 | -2,096,000 | 193,000 | 1,689,000 | -1,496,000 | -2,634,000 | 2,710,000 | 42,621,000 | 5,344,000 | -4,931,000 | -4,725,000 | -4,725,000 | 7,435,000 | 0 | -1,890,000 |
| 9/29/2020 | 65,388,000 | 43,880,000 | 21,508,000 | 17,714,000 | 3,794,000 | -1,491,000 | -4,046,000 | -1,743,000 | 699,000 | -2,864,000 | -2,864,000 | -1.58 | -1.58 | 1,808,000 | 1,808,000 | 61,594,000 | -2,864,000 | 596,810 | 156,000 | 1,647,000 | -1,491,000 | -96,000 | - | 43,880,000 | 5,345,000 | -2,832,000 | -4,697,000 | -4,697,000 | 9,946,000 | 0 | -1,268,190 |
Cash Flow
| Breakdown | TTM | 9/29/2020 |
| Operating Cash Flow | 6,091,000 | 7,618,000 |
| Investing Cash Flow | -3,019,000 | -3,637,000 |
| Financing Cash Flow | 7,030,000 | 8,480,000 |
| Cash Flow from Discontinued Operation | 603,000 | 2,000 |
| End Cash Position | 16,976,000 | 17,954,000 |
| Income Tax Paid Supplemental Data | - | 738,000 |
| Interest Paid Supplemental Data | - | 1,559,000 |
| Capital Expenditure | -3,444,000 | -4,022,000 |
| Issuance of Debt | 18,070,000 | 18,120,000 |
| Repayment of Debt | -3,626,000 | -3,533,000 |
| Repurchase of Capital Stock | - | 0 |
| Free Cash Flow | 2,647,000 | 3,596,000 |
