Profit and Loss Statement - Excel by khwCT860

VIEWS: 0 PAGES: 1

									                          Date: 12/13/2011




Profit & Loss Statement - 12 Months
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.




Profit & Loss 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                                           24         32          44           68            92        108       116        88        84                             656
              Other                                                                                                                                                                       0
Total Sales                                        0         24         32          44            68            92       108       116        88         84          0          0       656


Less Cost of Goods Sold
              Materials                                        6          8          11           17            23         27        29        22        21                             164
              Labor                                                                                                                                                                       0
              Overhead                                                                                                                                                                    0
              Other                                                                                                                                                                       0
Total Cost of Goods Sold                           0          6          8          11            17            23        27        29        22         21          0          0       164


Gross Profit                                       0         18         24          33            51            69        81        87        66         63          0          0       492


Operating Expenses
              Salaries and wages                                                                                                                                                          0
              Employee benefits                                                                                                                                                           0
              Payroll taxes                                                                                                                                                               0
              Rent                                                                                                                                                                        0
              Utilities (Heat & Light etc.)                                                                                                                                               0
              Repairs and maintenance                                                                                                                                                     0
              Insurance                                                                                                                                                                   0
              Travel                                                                                                                                                                      0
              Telephone                                                                                                                                                                   0
              Postage                                                                                                                                                                     0
              Office supplies                                                                                                                                                             0
              Advertising                                                                                                                                                                 0
              Marketing/promotion                             40                                                                                                                         40
              Professional fees                                                                                                                                                           0
              Training and development                                                                                                                                                    0
              Bank charges                                                                                                                                                                0
              Depreciation                          6          6          6           6             6            6          6         6         6         6          6          6        72
              Miscellaneous                                                                                                                                                               0
              Other                                                                                                                                                                       0
Total Operating Expenses                           6         46          6            6            6             6         6         6         6          6          6          6       112


Net Profit                                         (6)       (28)       18          27            45            63        75        81        60         57         (6)        (6)      380


              Interest income (expense)                                                                                                                                                   0
              Other income (expense)                                                                                                                                                      0
Total Non-operating Income (Expense)               0          0          0            0            0             0         0         0         0          0          0          0         0


Profit (Loss) Before Taxes                         (6)       (28)       18          27            45            63        75        81        60         57         (6)        (6)      380


Income Taxes                                                                                                                                                                   76        76


Net Income (Loss)                                  (6)       (28)       18          27            45            63        75        81        60         57         (6)       (82)      304


Cumulative Net Income (Loss)                       (6)       (34)       (16)        11            56          119        194       275       335        392        386        304       304

								
To top