Income Statement - 12 Months - Free Download
4.6,
4272
votes
Please vote for this template if it helps you.
Date: 2014 12 17／ ／
Microsoft Business Planner
Go to Article:
Income Statement - 12 Months
© Microsoft, 1998.
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.
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.
Less
Cost of Goods Sold
