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 Sales (all on credit) 1,500,000 1,875,000 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 Earnings per Share 60,000 60,000 78,000 $0.39 $0.26 $2.38 2023 2024 2025 2026 2027