Table 1 Forecast Forecast Forecast Forecast Forecast 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2025 12/31/2026 Actual Fiscal Year...

Transcribed Image Text:

Table 1 Forecast Forecast Forecast Forecast Forecast 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2025 12/31/2026 Actual Fiscal Year End Income Statement Sales (Net) Cost of goods sold 20,000 (12,000) 24,000 25,200 (14,400) (15,120) 26,460 (15,876) 27,783 29,172 (16,670) (17,503) Gross Profit 8,000 9,600 10,080 10,584 11,113 11,669 EBITDA 8,000 9,600 10,080 10,584 11,113 11,669 Depreciation & Amortization (2,000) (2,200) (2,460) (2,583) (2,712) (2,848) EBIT 6,000 7,400 7,620 8,001 8,401 8,821 Interest Expense (1,000) (1,100) (1,230) (1,292) (1,357) (1,424) EBT 5,000 6,300 6,390 6,710 7,046 7,398 Income Taxes (2,000) (2,520) (2,556) (2,684) (2,818) (2,959) Other Income (Loss) Net Income Before Ext. Item 3,000 3,780 3,834 4,026 4,227 4,439 Net Income 3,000 3,780 3,834 4,026 4,227 4,439 Balance Sheet Operating Cash 1,000 1,000 Total Current Assets 1,000 1,000 PP&E (net) 20,000 24,000 25,200 26,460 27,783 29,172 Pother Assets - Total Assets 21,000 25,000 25,200 26,460 27,783 29,172 Long-term debt 10,000 12,000 12,600 13,230 13,892 14,586 Total Liabilities 10,000 12,000 12,600 13,230 13,892 14,586 Paid in common capital 10,000 8,220 3,986 590 620 650 Retained earnings 1,000 4,780 8,614 12,640 13,272 13,936 Total common equity 11,000 13,000 12,600 13,230 13,892 14,586 Total liabilities and equity 21,000 25,000 25,200 26,460 27,783 29,172 Table 1 Forecast Forecast Forecast Forecast Forecast 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2025 12/31/2026 Actual Fiscal Year End Income Statement Sales (Net) Cost of goods sold 20,000 (12,000) 24,000 25,200 (14,400) (15,120) 26,460 (15,876) 27,783 29,172 (16,670) (17,503) Gross Profit 8,000 9,600 10,080 10,584 11,113 11,669 EBITDA 8,000 9,600 10,080 10,584 11,113 11,669 Depreciation & Amortization (2,000) (2,200) (2,460) (2,583) (2,712) (2,848) EBIT 6,000 7,400 7,620 8,001 8,401 8,821 Interest Expense (1,000) (1,100) (1,230) (1,292) (1,357) (1,424) EBT 5,000 6,300 6,390 6,710 7,046 7,398 Income Taxes (2,000) (2,520) (2,556) (2,684) (2,818) (2,959) Other Income (Loss) Net Income Before Ext. Item 3,000 3,780 3,834 4,026 4,227 4,439 Net Income 3,000 3,780 3,834 4,026 4,227 4,439 Balance Sheet Operating Cash 1,000 1,000 Total Current Assets 1,000 1,000 PP&E (net) 20,000 24,000 25,200 26,460 27,783 29,172 Pother Assets - Total Assets 21,000 25,000 25,200 26,460 27,783 29,172 Long-term debt 10,000 12,000 12,600 13,230 13,892 14,586 Total Liabilities 10,000 12,000 12,600 13,230 13,892 14,586 Paid in common capital 10,000 8,220 3,986 590 620 650 Retained earnings 1,000 4,780 8,614 12,640 13,272 13,936 Total common equity 11,000 13,000 12,600 13,230 13,892 14,586 Total liabilities and equity 21,000 25,000 25,200 26,460 27,783 29,172