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
				2020	2021	2022	2023	2024	2025	2026	2027
Sales (all on credit)				1,200,000	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
Gross Profit
Selling and Administrative Expense
Operating profit (EBIT)
Interest expense
Net Income before Taxes
Taxes
Net Income
Shares
Earnings per Share

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) 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)