Fill in the yellow highlighted cells with your forecasted figures.
SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work.
All your work must be shown on this sheet, not on a separate tab.
Forecasted Income Statement (25 points)
DURA-CLEAR WINDOWS, LLC
Proforma Income Statement
2020 2021 2022 2023 2024 2025 2026 2027
Sales (all on credit) ########## 1,500,000 1,875,000 1,800,000 1,812,000 1,812,000 1,812,600 1,812,480
Cost of Goods Sold (800,000) (1,040,000) (1,105,000)
Gross Profit 400,000 460,000 770,000
Selling and Administrative Expense (304,900) (350,500) (443,700)
Operating profit (EBIT) 95,100 109,500 326,300
Interest expense (35,000) (45,000) (85,000)
Net Income before Taxes 60,100 64,500 241,300
Taxes (36,900) (49,200) (55,600)
Net Income 23,200 15,300 185,700
Shares 60,000 60,000 78,000
Earnings per Share $0.39 $0.26 $2.38