Docstoc

Profit and Loss Account Full Template - Excel

Document Sample
Profit and Loss Account Full Template - Excel Powered By Docstoc
					  IF YOU NEED ANY HELP WITH THIS SPREADSHEET - PLEASE CONTACT US: 0333 444 8522, p@ulgreen.co.uk
Cash Flow
Notes

  Welcome to the cash flow spreadsheets.

  These spreadsheets attempt to give you an easy format to
  produce a monthly cash flow and show you what the full
  year profit or loss might be. Remember cash is your life
  line - without it you won't be able to pay your suppliers, or
  even yourself. At this point your business will die. So, be
  cautious, and remember, time spent planning is never
  wasted. It can help you identify problems before they
  arise so that you can do something about them.

  Please don't hesitate to contact us if we can be of any
  assistance to you. We'd like to help you succeed - partly
  because we've been where you are now and struggled
  with similar issues that you are struggling with now. We'll
  try not to charge you for our advice unless it really does
  become necessary.




                            UK Business Advisors Limited, White House, 66 Altwood Road, Maidenhead, SL6 4PZ
                               T: 0870 420 2756 F: 0709 280 8482 E: info@ukba.co.uk W: www.ukba.co.uk
                                              IF YOU NEED ANY HELP WITH THIS SPREADSHEET - PLEASE CONTACT US: 0333 444 8522, p@ulgreen.co.uk


CASH FL OW FORECAST fo r 12 m o n th s en d in g :                                                             B USINESS NAME

MONTH                                         Pre Start      1           2         3         4         5          6        7         8        9       10       11        12       TOTAL S

QUANTITY OF SAL ES                                                                                                                                                                          0
CASH IN                                                                                                                                                                                     0
With VAT
   Customers                                          100                                                                                                                              100
No VAT
   Grants                                                                                                                                                                                0
   Other Business Income                                                                                                                                                                 0
   Own Cash Contribution                                                                                                                                                                 0
   TOTAL CASH IN (A)                                  100          0         0         0         0         0          0         0         0       0        0        0         0        100

CASH OUT - B u s in es s
Co s t o f s ales
   Materials - incl VAT                               500                                                                                                                              500
Staff costs
   Staff Wages                                                                                                                                                                              0
   NHI (Staff & Personal) paid "next month"                                                                                                                                                 0
Premises costs
   Business Rent & Rates                              200                                                                                                                              200
   Heat & Light                                                                                                                                                                          0
   Telephone/Fax/Mobile                                                                                                                                                                  0
   Post/Stationery                                                                                                                                                                       0
   Business Insurance                                                                                                                                                                    0
   Repairs & maintenance                                                                                                                                                                 0
Transport & Travelling                                                                                                                                                                   0
Marketing & Promotion                                                                                                                                                                    0
Other Expenses                                                                                                                                                                           0
                                                                                                                                                                                         0
   TOTAL CASH OUT (B )                                700          0         0         0         0         0          0         0         0       0        0        0         0        700

   Operating Cash Flow In/(out) [A-B]                (600)         0         0         0         0         0          0         0         0       0        0        0         0       (600)

   Opening Balance/(Deficit)                          100    (550)       (550)     (550)     (550)     (550)      (550)     (550)     (550)   (550)   (550)     (550)     (550)        100
   Capital expenditure                                                                                                                                                                    0
   Loan Repayments                                                                                                                                                                        0
   Other Loans received /(repaid)                                                                                                                                                         0
   Bank Loans received / (repaid)                                                                                                                                                         0
   Net VAT Payments                                                                                                                                                                       0
                                                                                                                                                                                          0
   Personal drawings                                  (50)                                                                                                                             (50)

   Closing Balance/(Deficit)                         (550)   (550)       (550)     (550)     (550)     (550)      (550)     (550)     (550)   (550)   (550)     (550)     (550)       (550)


                                                                            White House, 66 Altwood Road, Maidenhead, SL6 4PZ
7/11/2011                                                        T: 0870 420 2756 F: 0709 280 8482 E: info@ukba.co.uk W: www.ukba.co.uk               104fe638-f724-4be8-9f5e-f2bc747d9add.xls
                                            IF YOU NEED ANY HELP WITH THIS SPREADSHEET - PLEASE CONTACT US: 0333 444 8522, p@ulgreen.co.uk

OPERATING BUDGET - PROFIT & LOSS ACCOUNT for 12 months ending
BUSINESS NAME:
All amounts exclude VAT
                                          £

Sales                                                          85

Cost of sales                                               (426)

  Gross Profit                                              (340)
  Gross Profit %                                  -400%

Overheads
  Staff Costs Inc. (NHI Staff & Personal)                       0
  Premises Cost                                             (200)
  Transport & Travelling                                        0
  Marketing & Promotion                                         0
  Other expenses                                                0
  Depreciation (Capital spend *25%)         25%                 0

  Total Overheads                                           (200)

Net Profit / (Loss)                                         (540)

  Corporation Tax                           20%              108

  Personal Drawings                                          (50)

Retained Profit                                             (482)



                                                White House, 66 Altwood Road, Maidenhead, SL6 4PZ
                                     T: 0870 420 2756 F: 0709 280 8482 E: info@ukba.co.uk W: www.ukba.co.uk
                                VAT RATE =        20.0%               IF YOU NEED ANY HELP WITH THIS SPREADSHEET - PLEASE CONTACT US: 0333 444 8522, p@ulgreen.co.uk

VAT workings                                                                                                       BUSINESS NAME

MONTH                                         Pre Start       1          2           3         4          5           6          7          8          9          10         11         12       TOTALS

QUANTITY OF SALES                                                                                                                                                                                         0
CASH IN                                                                                                                                                                                                   0
With VAT
   Customers                                        (17)          0            0         0         0           0          0          0          0           0          0          0          0       (17)
No VAT
   Other Loans                                                                                                                                                                                          0
   Bank Loans (Matched)                                                                                                                                                                                 0
   Grants                                                                                                                                                                                               0
   Other Business Income                                                                                                                                                                                0
   Own Cash Contribution                                                                                                                                                                                0
   TOTAL CASH IN (A)                                (17)          0            0         0         0           0          0          0          0           0          0          0          0       (17)

CASH OUT - Business
Cost of sales
   Materials - incl VAT                              83           0            0         0         0           0          0          0          0           0          0          0          0        83
Staff costs
   Staff Wages                                                                                                                                                                                            0
   NHI (Staff & Personal) paid "next month"                                                                                                                                                               0
Premises costs
   Business Rent & Rates                                                                                                                                                                               0
   Heat & Light                                           0       0            0         0         0           0          0          0          0           0          0          0          0         0
   Telephone/Fax/Mobile                                   0       0            0         0         0           0          0          0          0           0          0          0          0         0
   Post/Stationery                                                                                                                                                                                     0
   Business Insurance                                                                                                                                                                                  0
   Repairs & maintenance                                  0       0            0         0         0           0          0          0          0           0          0          0          0         0
Transport & Travelling                                                                                                                                                                                 0
Marketing & Promotion                                     0       0            0         0         0           0          0          0          0           0          0          0          0         0
Other Expenses                                            0       0            0         0         0           0          0          0          0           0          0          0          0         0
                                                                                                                                                                                                       0
   TOTAL CASH OUT (B)                                83           0            0         0         0           0          0          0          0           0          0          0          0        83

   Operating Cash Flow In/(out) [A-B]              (100)          0            0         0         0           0          0          0          0           0          0          0          0      (100)

   Opening Balance/(Deficit)                                  (100)       (100)      (100)      (100)      (100)      (100)      (100)      (100)       (100)      (100)      (100)      (100)            0
   Capital expenditure                                    0       0           0          0          0          0          0          0          0           0          0          0          0            0
   Loan Repayments                                                                                                                                                                                        0
   Other Loan Repayments                                                                                                                                                                                  0
   Bank Loan Repayments                                                                                                                                                                                   0
   Net VAT Payments                                                                                                                                                                                       0
                                                                                                                                                                                                          0
   Personal drawings                                                                                                                                                                                      0

   Closing Balance/(Deficit)                       (100)      (100)       (100)      (100)      (100)      (100)      (100)      (100)      (100)       (100)      (100)      (100)      (100)      (100)

                                              Each quarter you will need to pay VAT about 40 days after the month end. Its probably safer to put in a VAT payment the month after your quarter
                                              end. That way you will err on the side of safety.




                                                                                        White House, 66 Altwood Road, Maidenhead, SL6 4PZ
7/11/2011                                                                    T: 0870 420 2756 F: 0709 280 8482 E: info@ukba.co.uk W: www.ukba.co.uk                                      104fe638-f724-4be8-9f5e-f2bc747d9add.xls

				
DOCUMENT INFO
Description: Profit and Loss Account Full Template document sample