MILESTONE 1 SALES & GROSS PROFIT FORECAST 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. DURA-CLEAR WINDOWS, LLC Proforma Income Statement 20202021202220232024202520262027 Sales (all on credit) 1,200,000 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 Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share

MILESTONE 1 QUESTIONS 1(5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) How reliable is your Sales Forecast? Explain your answer. 2(5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) You used a weighted moving average to forecast your sales figures. Name two other methods of forecasting that may produce a more accurate result, and explain why you think the results would be better with these two selected methods. (HINT: See Week 1 and Week 3 Lessons) 3(5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) Looking at your Gross Profits across the forecasted years, do you think the sharks will provide the funding you are requesting? Explain why or why not.