) S 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 (20 points: 5 for showing work, 15 for accuracy) Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share 2020 1,200,000 (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 10,986,328 13,732,910 3,867,188 4,833,984 6,042,480 7.553,101 10,898,438 13,623,047 17,028,809 21,286,011

Fill in the yellow highlighted cells with your forecasted figures. SHOW AL YOUR SUPPORTING CALCULATIONSI 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 (20 points: 5 for showing work, 15 for accuracy) DURA-CLAR WINDOWS, tLC Forecasted Balance Sheet ( 30 points: 5 for showing work, 25 for accuracy)