Integrated income statement, balance sheet, and cash flow projections
| Revenue | |
| Cost of Goods Sold | |
| Gross Profit | Calculated |
| SG&A Expenses | |
| Depreciation & Amortization | |
| Operating Income (EBIT) | Calculated |
| Interest Expense | |
| Income Before Taxes | Calculated |
| Income Tax Expense | |
| Net Income | Calculated |
| Assets | Value |
|---|---|
| Cash & Cash Equivalents | |
| Accounts Receivable | |
| Inventory | |
| Other Current Assets | |
| Total Current Assets | Calculated |
| Property, Plant & Equipment | |
| Accumulated Depreciation | |
| Net PP&E | Calculated |
| Other Long-Term Assets | |
| Total Assets | Calculated |
| Liabilities & Equity | Value |
|---|---|
| Accounts Payable | |
| Short-Term Debt | |
| Other Current Liabilities | |
| Total Current Liabilities | Calculated |
| Long-Term Debt | |
| Other Long-Term Liabilities | |
| Total Liabilities | Calculated |
| Common Stock | |
| Retained Earnings | |
| Total Shareholders' Equity | Calculated |
| Total Liabilities & Equity | Calculated |
| Item | Historical | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|---|
| Revenue | Calculated | Calculated | Calculated | Calculated | Calculated | |
| Cost of Goods Sold | Calculated | Calculated | Calculated | Calculated | Calculated | |
| Gross Profit | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated |
| SG&A Expenses | Calculated | Calculated | Calculated | Calculated | Calculated | |
| Depreciation & Amortization | Calculated | Calculated | Calculated | Calculated | Calculated | |
| Operating Income (EBIT) | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated |
| Interest Expense | Calculated | Calculated | Calculated | Calculated | Calculated | |
| Income Before Taxes | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated |
| Income Tax Expense | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated |
| Net Income | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated |