Profit And Loss

Document Sample
Profit And Loss Powered By Docstoc
					Template Financial Forecasts

Please note

These are templates that you can use to create you financial forecasts for the BUG Competition

We have created these templates to make it easier for those of you who may not be familiar with financial forecasting and for those

Do not worry if you have already started your forecasts and they are not quite the same, this is only a template and the forecasts an

You may not have the same categories of cost as shown in the P&L and cash flow templates - feel free to overtype the name of the

Cells in blue font require you to enter something, cells in black have formulae which will calculate automatically - you sho




Tips

To insert a row - Click on a cell on the row below where you would like the new row to go. Right click and select insert. Then selec
To make the totals column work in this new row, select the blank cell in your row which is in column "N" In this cell type in =sum(B?

Please fill in the sheets in this order "Sales Forecast" "Profit And Loss" and finally "Cash flow". This is the easiest
way to progress your thinking about your business and you should also complete them in this order for the formulae




Warning
If you are inserting or deleting rows into the templates be careful. The templates include formulae to help you. If you
delete the wrong row or insert a new one into the wrong place the formulae may not then work as expected and you
may find your forecasts becoming inaccurate or you may become confused. Try to insert rows into the middle of the
section that you wish rather than the top or bottom. This should ensure that the formulae re-adjust and remain
nancial forecasting and for those who do not have a good knowledge of Microsoft Excel.

y a template and the forecasts and entries will vary depending on your business.



culate automatically - you should not need to change any black cells




ck and select insert. Then select "entire row" you will now have a new row.
n "N" In this cell type in =sum(B??:N??) and replace ?? with the new row number.
                                                                                                                   Sales Forecast
Year 1

                      Price of Product
Product               (net of VAT)                         Month 1       Month 2       Month 3       Month 4         Month 5       Month 6       Month 7       Month 8       Month 9       Month 10       Month 11       Month 12       Total


Product 1             £             -    Number of Sales             0             0             0             0               0             0             0             0             0              0              0              0           0


                                         Revenue                     0             0             0             0               0             0             0             0             0              0              0              0           0


Cost of Unit          £             -    Cost of Sales               0             0             0             0               0             0             0             0             0              0              0              0           0


Product 2             £             -    Number of Sales             0             0             0             0               0             0             0             0             0              0              0              0           0


                                         Revenue                     0             0             0             0               0             0             0             0             0              0              0              0           0


Cost of Unit          £             -    Cost of Sales               0             0             0             0               0             0             0             0             0              0              0              0           0


Product 3             £             -    Number of Sales             0             0             0             0               0             0             0             0             0              0              0              0           0


                                         Revenue                     0             0             0             0               0             0             0             0             0              0              0              0           0


Cost of Unit          £             -    Cost of Sales               0             0             0             0               0             0             0             0             0              0              0              0           0


Total Sales                                                          0             0             0             0               0             0             0             0             0              0              0              0           0 Total Sales


Total Revenue                                                        0             0             0             0               0             0             0             0             0              0              0              0           0 Total Revenue


Total Cost of Sales                                                  0             0             0             0               0             0             0             0             0              0              0              0           0 Total Cost of Sales
Year 1
Profit and Loss Account 2009-2010                           Month 1   Month 2   Month 3   Month 4   Month 5   Month 6   Month 7   Month 8   Month 9   Month 10   Month 11   Month 12   Total

Total Sales Revenue (net of VAT)                                  0         0         0         0         0         0         0         0         0          0          0          0      0

Variable Costs
Cost of Sales                                                     0         0         0         0         0         0         0         0         0          0          0          0      0
Variable Cost 2                                                   0         0         0         0         0         0         0         0         0          0          0          0      0
Variable Cost 3                                                   0         0         0         0         0         0         0         0         0          0          0          0      0

Total Variable Costs                                              0         0         0         0         0         0         0         0         0          0          0          0      0

Gross Profit (Total Sales Revenue - Total Variable Costs)         0         0         0         0         0         0         0         0         0          0          0          0      0

Fixed Costs
Salaries                                                          0         0         0         0         0         0         0         0         0          0          0          0      0
Employer's NI @12.8%                                              0         0         0         0         0         0         0         0         0          0          0          0      0
Rent                                                              0         0         0         0         0         0         0         0         0          0          0          0      0
Rates                                                             0         0         0         0         0         0         0         0         0          0          0          0      0
Insurances                                                        0         0         0         0         0         0         0         0         0          0          0          0      0
Utilities                                                         0         0         0         0         0         0         0         0         0          0          0          0      0
Transport                                                         0         0         0         0         0         0         0         0         0          0          0          0      0
Telephone                                                         0         0         0         0         0         0         0         0         0          0          0          0      0
Back-Up Systems                                                   0         0         0         0         0         0         0         0         0          0          0          0      0
Stationery                                                        0         0         0         0         0         0         0         0         0          0          0          0      0
Advertising                                                       0         0         0         0         0         0         0         0         0          0          0          0      0
Leasing                                                           0         0         0         0         0         0         0         0         0          0          0          0      0
Maintenance                                                       0         0         0         0         0         0         0         0         0          0          0          0      0
Sundry expenses                                                   0         0         0         0         0         0         0         0         0          0          0          0      0
Professional and Accountancy fees                                 0         0         0         0         0         0         0         0         0          0          0          0      0
Bank charges                                                      0         0         0         0         0         0         0         0         0          0          0          0      0
Bank loan interest                                                0         0         0         0         0         0         0         0         0          0          0          0      0
Bank overdraft interest                                           0         0         0         0         0         0         0         0         0          0          0          0      0
Depreciation                                                      0         0         0         0         0         0         0         0         0          0          0          0      0

Total Fixed Costs                                                 0         0         0         0         0         0         0         0         0          0          0          0      0

Net Profit (Total Sales Revenue - Total Costs)                    0         0         0         0         0         0         0         0         0          0          0          0      0

Cumulative Net Profit                                             0         0         0         0         0         0         0         0         0          0          0          0      0
Year 1
Cash Flow 2009-2010                         Month 1   Month 2   Month 3   Month 4   Month 5   Month 6   Month 7   Month 8   Month 9   Month 10   Month 11   Month 12   Total

Cash Inflows
Total Sales Revenue                              0         0         0         0         0         0         0         0         0          0          0          0       0
Other Income                                     0         0         0         0         0         0         0         0         0          0          0          0       0
VAT on Sales                                     0         0         0         0         0         0         0         0         0          0          0          0       0
Capital Injection                                0         0         0         0         0         0         0         0         0          0          0          0       0
Bank Loan                                        0         0         0         0         0         0         0         0         0          0          0          0       0
Total Inflow                                     0         0         0         0         0         0         0         0         0          0          0          0       0

Cash Outflows
Materials                                        0         0         0         0         0         0         0         0         0          0          0          0       0
Stock Purchase                                   0         0         0         0         0         0         0         0         0          0          0          0       0
Salaries                                         0         0         0         0         0         0         0         0         0          0          0          0       0
Employer's NI @12.8%                             0         0         0         0         0         0         0         0         0          0          0          0       0
Rent                                             0         0         0         0         0         0         0         0         0          0          0          0       0
Rates                                            0         0         0         0         0         0         0         0         0          0          0          0       0
Insurances                                       0         0         0         0         0         0         0         0         0          0          0          0       0
Utilities                                        0         0         0         0         0         0         0         0         0          0          0          0       0
Transport                                        0         0         0         0         0         0         0         0         0          0          0          0       0
Telephone                                        0         0         0         0         0         0         0         0         0          0          0          0       0
Website Development                              0         0         0         0         0         0         0         0         0          0          0          0       0
Back-up Systems                                  0         0         0         0         0         0         0         0         0          0          0          0       0
Stationery                                       0         0         0         0         0         0         0         0         0          0          0          0       0
Advertising                                      0         0         0         0         0         0         0         0         0          0          0          0       0
Leasing                                          0         0         0         0         0         0         0         0         0          0          0          0       0
Purchase of equipment                            0         0         0         0         0         0         0         0         0          0          0          0       0
Maintenance                                      0         0         0         0         0         0         0         0         0          0          0          0       0
Sundry expenses                                  0         0         0         0         0         0         0         0         0          0          0          0       0
Professional and Accountancy fees                0         0         0         0         0         0         0         0         0          0          0          0       0
Bank charges                                     0         0         0         0         0         0         0         0         0          0          0          0       0
Premises refurbishment / conversion costs        0         0         0         0         0         0         0         0         0          0          0          0       0
Bank loan interest                               0         0         0         0         0         0         0         0         0          0          0          0       0
Bank loan repayment                              0         0         0         0         0         0         0         0         0          0          0          0       0
Bank overdraft interest                          0         0         0         0         0         0         0         0         0          0          0          0       0

VAT on Purchases                                 0         0         0         0         0         0         0         0         0          0          0          0       0
VAT Settlement                                                                 0                             0                              0                             0

Total Outflow                                    0         0         0         0         0         0         0         0         0          0          0          0       0

Net Cash flow                                    0         0         0         0         0         0         0         0         0          0          0          0       0

Bank Balance
Opening                                          0         0         0         0         0         0         0         0         0          0          0          0
Closing                                          0         0         0         0         0         0         0         0         0          0          0          0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:8/14/2011
language:English
pages:5