
Microsoft Business Planner
Go to Article:
Income Statement - 12 Months
Period Starting: Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Totals
Sales
Sales 0
Other 0
Total Sales
0 0 0 0 0 0 0 0 0 0 0 0 0
Materials 0
Labor 0
Overhead 0
Other 0
Total Cost of Goods Sold
0 0 0 0 0 0 0 0 0 0 0 0 0
Gross Profit 0 0 0 0 0 0 0 0 0 0 0 0 0
Operating Expenses
Salaries and wages 0
Employee benefits 0
Payroll taxes 0
Rent 0
Utilities 0
Repairs and maintenance 0
Insurance 0
Travel 0
Telephone 0
Postage 0
Office supplies 0
Advertising 0
Marketing/promotion 0
Professional fees 0
Training and development 0
Bank charges 0
Depreciation 0
Miscellaneous 0
Other 0
Total Operating Expenses
0 0 0 0 0 0 0 0 0 0 0 0 0
Operating Income
0 0 0 0 0 0 0 0 0 0 0 0 0
Interest income (expense) 0
Other income (expense) 0
Total Nonoperating Income (Expense)
0 0 0 0 0 0 0 0 0 0 0 0 0
Income (Loss) Before Taxes
0 0 0 0 0 0 0 0 0 0 0 0 0
Income Taxes
0
Net Income (Loss)
0 0 0 0 0 0 0 0 0 0 0 0 0
Cumulative Net Income (Loss)
0 0 0 0 0 0 0 0 0 0 0 0 0
Introduction to Financial Statements
This template provides a pro forma income statement. Please note that this type of layout is for management purposes
only, rather than for the year-end filing of accounts. You can customize the form by changing the row labels or adding
rows.
To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click Rows. You will
then need to use the fill handle (see Excel Help) to fill in the formula in the "Totals" column. The cells displaying zeros
contain formulas to perform automatic calculations on your data. Do not enter data into these cells because doing so will
erase the formulas in them.
Income Statement - 12 Months
Note: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook
next time, you must open it using Excel. Every time you open this template from Microsoft Business Planner, a new
workbook is created.