Pro-Forma Income Stmt[1]

Pro-Forma Income Statement 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. 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. Copyright © KMT Software, Inc. All Rights Reserved.Pro-Forma Income Statement <--Enter company name in cell to the left <--Enter range of years in cell to the left (all numbers in $000) REVENUE 2000 2001 2002 2003 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 Selling Salaries 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)