Fill in the yellow highlighted cells with your forecasted figures. 4 SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - clear 5 All your work must be shown on this sheet, not on a separate tab. 6 7 Forecasted Income Statement (20 points: 5 for showing work, 15 for accuracy) 8 9 10 11 12 13 14 Sales (all on credit) 15 Cost of Goods Sold 16 Gross Profit 17 Selling and Administrative Expense 18 Rent Expense 19 Depreciation Expense 20 Operating profit (EBIT) 21 Interest expense 22 Net Income before Taxes 23 Taxes 24 Net Income 25 Shares 26 Earnings per Share 27 28 2020 (800,000) 400,000 (224,900) (15,000) (65,000) 95,100 (35,000) 60,100 (36,900) 23,200 60,000 $0.39 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2021 1,500,000 (1,040,000) 460,000 (270,500) (15,000) (76,500) 98,000 (45,000) 53,000 (49,200) 3,800 60,000 $0.26 2022 2023 1,875,000 5,625,000 (1,105,000) 3,093,750 770,000 8,718,750 (363,700) (15,000) (139,000) 252,300 (85,000) 167,300 (55,600) 111,700 78,000 $2.38 2024 2025 2026 2027 7,031,250 8,789,063 ######### ] ######### 3,867,188 4,833,984 6,042,480 7,553,101 10,898,438 ######### #########| #########

Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORING CALCULATIONSI You may do this either within the cell by using formulas, out to the right, or both - clea All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (20 points: 5 for showing work, 15 for accuracy) Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORING CALCULATIONSI You may do this either within the cell by using formulas, out to the right, or both - clea All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (20 points: 5 for showing work, 15 for accuracy)