This template is a financial planning tool for businesses. It is especially useful for estimating long-term financing needs. Enter the starting year heading manually; the subsequent year headings are calculated automatically. Pro-Forma Income Statement To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.Pro-Forma Income Statement <<_CompanyName_>> Enter the range of years here (all dollar amounts are in the $1,000's) REVENUE 2007 2008 2009 2010 Gross sales Less sales returns and allowances Net Sales COST OF SALES Beginning inventory Plus goods purchased /manufactured Total Goods Available Less ending inventory Total Cost of Goods Sold Gross Profit (Loss) OPERATING EXPENSES SellingSalaries and wages Commissions Advertising Depreciation Other Total Selling Expenses General/Administrative Salaries and wages Employee benefits Payroll taxes Insurance Rent Utilities Depreciation & amortization Office supplies Travel & entertainment Postage Equipment maintenance & rental Interest Furniture & equipment Total General/Administrative Expenses Total Operating Expenses Net Income Before Taxes Taxes on income Net Income After Taxes Extraordinary gain or loss Income tax on extraordinary gain NET INCOME (LOSS)