Calculating Profit or Loss of a Business by rhw85743

VIEWS: 34 PAGES: 29

More Info
									 ENTER YOUR BUSINESS DETAILS - which are then transferred to the Self-employment Tax Return

      Your name                                                     Your unique taxpayer reference (UTR)




Business details

  1   Business name - unless it is in your own name             5   If the details in boxes 1,2,3 or 4 have changed in the
                                                                    12 months put 'X' in the box and give details in the
                                                                     'Any other information' box


  2   Description of business                                   6   If your business started after       ##################
                                                                    enter the start date DD/MM/YYYY




                                                                7   If your business ceased before       Sunday, April 06, 2008
                                                                    enter the final date of trading
  3   First line of your business address - unless you work
      from home

                                                                8   Date your books or accounts start - the beginning of
                                                                    your accounting period



  4   Postcode of your business                                 9   Date your books or accounts are made up to or the end
                                                                    of your accounting period - read page SEFN 3 of the
                                                                    notes if you have filled in box 6 or 7
                                                                            05/04/2008

Other information
 10   If your accounting period has changed permanently        12   If special arrangements apply put 'X' in the box - read
      put 'X' in the box                                            page SEFN 3 of the notes




 11   If your accounting period has changed more than once     13   If you have provided the information about your 2007-08
      since 2002 put 'X' in the box                                 profit on last year's Tax Return put 'X' in the box - read
                                                                    page SEFN 3 of the notes




 26   ENTER: Total losses brought forward from earlier years   24   ENTER: Value of goods and services for your own use
                                                                    - read page SESN 7 of the notes
       £                               . 0 0                         £                                 . 0 0
      Loss used this year                                           Total loss carried forward to future years
      Calculated no entry required                                  Calculated no entry required

       £                             0 . 0 0                         £                                0 . 0 0
ment Tax Return




 s 1,2,3 or 4 have changed in the
 the box and give details in the




                ##################




                Sunday, April 06, 2008
of trading



accounts start - the beginning of




accounts are made up to or the end
 eriod - read page SEFN 3 of the




 nts apply put 'X' in the box - read




 the information about your 2007-08
Tax Return put 'X' in the box - read




 ods and services for your own use
                                       COPY DETAILS TO HMRC FORM
     HM Revenue                          Submit HMRC paper return            Self-employment (full)
                                            by 31st October 2008
      & Customs                       OR PRINT & FILE RETURN ONLINE
                                                                               Tax year ############ to ###########
                                            by 31st January 2009



     Your name                                                        Your unique taxpayer reference (UTR)




Business details

  1 Business name - unless it is in your own name                 5 If the details in boxes 1,2,3 or 4 have changed in the
                                                                      12 months put 'X' in the box and give details in the
                                                                       'Any other information' box



  2 Description of business                                       6 If your business started after             ###############
                                                                      enter the start date DD/MM/YYYY




                                                                  7 If your business ceased before             ###############
                                                                      enter thefinal date of trading
  3 First line of your business address - unless you work
     from home

                                                                  8 Date your books or accounts start - the beginning of
                                                                    your accounting period



  4 Postcode of your business                                     9 Date your books or accounts are made up to or the end
                                                                      of your accounting period - read page SEFN 3 of the
                                                                      notes if you have filled in box 6 or 7
                                                                              05/04/2008

Other information
 10 If your accounting period has changed permanently            12 If special arrangements apply put 'X' in the box - read
    put 'X' in the box                                              page SEFN 3 of the notes




 11 If your accounting period has changed more than once         13 If you have provided the information about your 2007-08
    since 2002 put 'X' in the box                                   profit on last year's Tax Return put 'X' in the box - read
                                                                      page SEFN 3 of the notes




Business income

 14 Your turnover - the takings, fees, sales or money earned     15 Any other business income not included in box 14
      by your business                                                       - excluding Business Start-up Allowance

        £                          0 . 0 0                                    £                            0 . 0 0

Business expenses
Read pages SEFN 5 to SEFN 7 of the notes to see what expenses are allowed for tax purposes.

      Total expenses                                                         Disallowable expenses
      If your annual turnover was below £30,000 you may                      Use this column if the figures in boxes 16 to 29
      just put your total expenses in box 30                                 include disallowable amounts

  16 Cost of goods bought for re-sale or goods used                     31

        £                          0 . 0 0                                    £                               . 0 0
  17 Construction industry - payments to subcontractors                 32

        £                          0 . 0 0                                    £                               . 0 0

  18 Wages, salaries and other staff costs                              33

        £                          0 . 0 0                                    £                               . 0 0
  19 Car, van and other travel expenses                                 34

        £                          0 . 0 0                                    £                               . 0 0
  20 Rent, rates, power and insurance costs                             35

        £                          0 . 0 0                                    £                               . 0 0
  21 Repairs and renewals pf property and equipment                     36

        £                          0 . 0 0                                    £                               . 0 0
  22 Telephone, fax, stationery and other office costs                  37

        £                          0 . 0 0                                    £                               . 0 0
  23 Advertising and business entertainment costs                       38

        £                          0 . 0 0                                    £                               . 0 0
  24 Interest on bank and other loans                                   39

        £                          0 . 0 0                                    £                               . 0 0
  25 Bank, credit card and other financial charges                      40

        £                          0 . 0 0                                    £                               . 0 0
  26 Irrecoverable debts written off                                    41

        £                          0 . 0 0                                    £                               . 0 0
  27 Accountancy, legal and other professional fees                     42
        £                           0 . 0 0                                        £                               . 0 0
  28 Depreciation and loss/profit on sale of assets                          43

        £                           0 . 0 0                                        £                           0 . 0 0

  29 Other business expenses                                                 44

        £                           0 . 0 0                                        £                               . 0 0
  30 Total expenses in boxes 16 to 29                                        45 Total disallowable expenses in boxes 31 to 44

        £                           0 . 0 0                                        £                           0 . 0 0

Net profit or loss

  46 Net profit - if your business income is more then your                  47 Or, net loss - if your expenses exceed your business
     expenses (box 14 + box 15 minus box 30)                                    income (box 14 + box 15 minus box 30 is negative)

        £                           0 . 0 0                                        £                           0 . 0 0

Tax allowances for vehicles and equipment (capital allowances)
There are 'capital' tax allowances for vehicles, equipment and certain buildings used in your business (you should not have
included the cost of these in your business expenses) Read pages SEFN 8 to SEFN 11 of the notes and use the example and
Working Sheets to work out your capital allowances.

  48 Annual allowances at              25% on cars costing £12,000           53 Enhanced 100% and other capital allowances - read
     or less, and equipment                                                     page SEFN 0 of the notes

        £                           0 . 0 0                                        £                               . 0 0

  49 First year allowances at             50%                                54 Allowances on sale or cessation of business use (where
                                                                                you have disposed of assets for less than their tax value)

        £                           0 . 0 0                                        £                           0 . 0 0

  50 Restricted annual allowances for cars costing more                      55 Total allowances (total of boxes 48 to 54)
     than £12,000

        £                           0 . 0 0                                        £                           0 . 0 0

  51 Agricultural or Industrial Buildings Allowance                          56 Charges on cessation of business use (only where Business
                                                                                Premises Renovation Allowance has been claimed before

        £                              . 0 0                                       £                               . 0 0
  52 Business Premises Renovation Allowance (Assisted Areas                  57 Other charges on sale or cessation of business use
     only) - read page SEFN 9 of the notes                                      (where you have disposed of assets for more than their
                                                                                tax value)

        £                              . 0 0                                       £                           0 . 0 0

Calculating your taxable profit or loss
You may have to adjust your net profit or loss for disallowable expenses or capital allowances to arrive at your taxable profit or
your loss for tax purposes. Read page SEFN 12 of the notes and fill in the boxes below that apply.

  58 Goods and services for your own use - read page SEFN 12                   61 Total deductions from net profit or additions to
     of the notes                                                                 net loss (box 55 + box 60)

         £                            0 . 0 0                                         £                             0 . 0 0

  59 Total additions to net profit or deductions from net loss                 62 Net business profit for tax purposes (box 46 or box 47 +
     (box 45 + box 56 + box 57 + box 58)                                          box 59 minus box 61)

         £                            0 . 0 0                                         £                             0 . 0 0

  60 Income, receipts and other profits included in business                   63 Net business loss for tax purposes (if box 46 or box 47 +
     income or expense but not taxable as business profits                        box 59 minus box 61 is negative)

         £                               . 0 0                                        £                             0 . 0 0

Calculating your taxable profit or loss (continued)
If you start or finish self-employment and your accounting period is not the same as your basis period (or there are overlaps, or
gaps in your basis periods), or in certain situations or trades or professions, you may need to make further adjustments
- read pages SEFN 13 to SEFN 15 of the notes.

  64 Date your basis period began DD/MM/YYYY                                   70 Averaging adjustment (only for farmers, market gardeners
                                                                                    and creators of literary or artistic works) - if the
                                                                                    adjustment needs to be taken off the profit figure put a
  65 Date your basis period ended                                                   minus sign (-) in the box
                                                                                      £    —                            . 0 0

  66 If your basis period is not the same as your accounting                   71 Adjusted profit for 2007-08 (box 62 or 63 +box 66 minus
     period, enter the adjustment needed to arrive at the                         box 67 +box 69 +box 70) - if a loss, enter it in box 75
       profit or loss for the basis period - if the adjustment                        £                             0 . 0 0
       needs to be taken off the profit figure put a minus
       sign (-) in the box                                                     72 Loss brought forward from earlier years set-off against
         £    —                          . 0 0                                      this year's profits - up to the amount in box 62 or box 71


  67 Overlap relief used this year - read page SEFN 13 of the notes                   £                             0 . 0 0

         £                               . 0 0                                 73 Any other business income not included in boxes 14, 15
                                                                                  or 58 - for example, Business Start -up Allowance
  68 Overlap profit carried forward - overlap profit brought
       forward minus any relief used this year (in box 67)                            £                             0 . 0 0

         £                               . 0 0                                 74 Total taxable profits from this business (box 71 minus
                                                                                  box 72 + box 73 - or use the Working Sheet on
  69 Adjustment for change of accounting practise - read                            page SEFN 14)
     page SEFN 13 of the notes
         £                               . 0 0                                        £                             0 . 0 0

Losses
If you have made a net loss for tax purposes (in box 63), or if you have losses from previous years, read page SEFN 15 of the notes
and fill in boxes 75 to 78 as appropriate.

  75 Adjusted loss 2007-08         (box 62 or 63 + box 66                       77 Loss to be carried back to previous year(s) and set off
     ,minus box 67 + box 69 + box 70)                                              against income (or capital gains)

         £                           0 . 0 0                                           £                               . 0 0
  76 Loss from this tax year set off against other income                       78 Total loss to carry forward after all other set-offs
       for   2007-08                                                                  - including unused losses brought forward

         £                               . 0 0                                         £                            0 . 0 0

Deductions and tax taken off
  79 Deductions on payment and deduction statements from                        80 Other tax taken off trading income
     contractors - construction industry subcontractors only

         £                           0 . 0 0                                           £                               . 0 0

Balance Sheet
If your business accounts include a Balance Sheet showing the assets, liabilities, and capital of the business, fill in the relevant
boxes below. If you do not have a Balance Sheet, go to box 98.


       Assets                                                                        Liabilities
  81 Equipment, machinery and vehicles                                          89 Trade creditors

         £                               . 0 0                                         £                               . 0 0
  82 Other fixed assets                                                         90 Loans and overdrawn bank account balances

         £                               . 0 0                                         £                               . 0 0
  83 Stock and work in progress                                                 91 Other liabilities and accruals

         £                               . 0 0                                         £                               . 0 0

  84 Trade debtors                                                                   Net business assets
         £                               . 0 0                                  92 Net business assets (box 88 minus (boxes 89 to 91))


  85 Bank/building society balances                                                    £    —                              . 0 0
         £                               . 0 0                                       Capital account

  86 Cash in hand                                                               93 Balance at start of period

         £                               . 0 0                                         £    —                              . 0 0
  87 Other current assets and prepayments                                       94 Net profit or loss (box 46 or box 47)

         £                               . 0 0                                         £    —                              . 0 0
  88 Total assets (total of boxes 81 to 87)                                     95 Capital introduced
        £                              . 0 0                                     £                             . 0 0
                                                                          96 Drawings

                                                                                 £                             . 0 0
                                                                          97 Balance at end of period


                                                                                 £   —                            . 0 0

Class 4 National Insurance contributions (NICs)
If your self employed profits are more than £     5225    you must pay Class 4 NICs (unless you are exempt or your contributions
have been deferred) - read page SEFN 16 of the notes.

  98 If you are exempt from paying Class 4 NICs put 'X' in the           100 Adjustment to profits chargeable to Class 4 NICs - this
     box - read page SEFN 16 of the notes                                    will not apply to most people

                                                                                 £                             . 0 0
  99 If you have been given a            2007-08 Class 4 NICs deferment
     certificate, put 'X' in the box - read page SEFN 16 of
       the notes




Any other information

 101 Please give any other information in this page
nt (full)
        ###########




up to or the end




out your 2007-08
e
e and




ness use (where
an their tax value)




only where Business
en claimed before




more than their
fit or




x 46 or box 47 +




ox 46 or box 47 +




ps, or




 market gardeners




 or 63 +box 66 minus




box 62 or box 71




d in boxes 14, 15




f the notes
evant
ontributions
                                            COPY DETAILS TO HMRC FORM
       HM Revenue                             Submit HMRC paper return                      Self-employment (short)
                                                 by 31st October 2008
       & Customs                           OR PRINT & FILE RETURN ONLINE
                                                                                            Tax year ############ to
                                                 by 31st January 2009



       Your name                                                                 Your unique taxpayer reference (UTR)




Business details

   1   Description of business                                               4   If you are a foster carer or adult placement carer, put 'X'
                                                                                 in the box - read page SESN 2 of the notes




                                                                             5   If your business started sifter ##################
                                                                                 enter the start date DD/MM/YYYY

   2   Postcode of your business



                                                                             6   If your business ceased before       Sunday, April 06, 2008
   3   If your business name, description, address or postcode                   enter the final date of trading
       have changed in the last 12 months, put 'X' in the box
       and give details in the 'Any other information' box of
       of your Tax Return
                                                                             7   Date your books or accounts are made up to - read
                                                                                 page SESN 2 of the notes

                                                                                            05/04/2008

Business income - if your annual turnover was below £64000

   8   Your turnover - the takings, fees, sales or money earned              9   Any other business income not included in box 8
       by your business                                                          - excluding Business Start-up Allowance

         £                            0 . 0 0                                     £                             0 . 0 0

Allowable business expenses
Read pages SESN 3 of the notes to see which expenses are allowed for tax purposes. If your annual turnover was below £30,000
you may just put your total expenses in box 19, rather than filling in the whole section.

  10   Cost of goods bought for re-sale or goods used                       15   Accountancy, legal and other professional fees

         £                               . 0 0                                    £                                . 0 0
  11   Car, van and other travel expenses - after private                   16   Interest and bank and credit card etc. financial charges
       use proportion

         £                               . 0 0                                    £                                . 0 0

  12   Wages, salaries and other staff costs                                17   Telephone, fax, stationery and other office costs

         £                               . 0 0                                    £                                . 0 0
  13   Rent, rates, power and insurance costs                                18   Other allowable business expenses - client entertaining
                                                                                  costs are not an allowable expense

         £                                . 0 0                                     £                              . 0 0
  14   Repairs and renewals of property and equipment                        19   Total allowable expenses - total of boxes 10 to 18

         £                                . 0 0                                     £                           0 . 0 0

Net profit or loss

  20   Net profit - if your business income is more then your                21   Or, net loss - if your expenses exceed your business
       expenses (box 8 + box 9 minus box 19)                                      income (box 8 + box 9 minus box 19 is negative)

         £                            0 . 0 0                                       £                           0 . 0 0

Tax allowances for vehicles and equipment (capital allowances)
There are 'capital' tax allowances for vehicles and equipment used in your business (you should not have included the cost of
these in your business expenses) Read pages SESN 3 to SEFN 6 of the notes and use the example and Working Sheets to work out
your capital allowances.

  22   Total capital allowances                                              23   Total balancing charges - where you have disposed of
                                                                                  items for more than their value - read page SESN 4 of
         £                            0 . 0 0                                     the notes

                                                                                    £                           0 . 0 0

Calculating your taxable profits
Your taxable profit may not be the same as your net profit. Read page SESN 7 of the notes to see if you need to make any
adjustments and fill in the boxes which apply to arrive at your taxable profit for the year.

  24   Goods and services for your own use - read page                       26   Loss brought forward from earlier years set-off against
       SESN 7 of the notes                                                        this year's profits - up to the amount in box 25

         £                            0 . 0 0                                       £                           0 . 0 0

  25   Net business loss for tax purposes (if box 20 or box 21 +             27   Any other business income not included in boxes 8 or 9
       box 23 + box 24 minus box 22)                                              - for example, Business Start-up Allowance

         £                            0 . 0 0                                       £                           0 . 0 0

Total taxable profits or net business loss

  28   Total taxable profits from this business (taxable profit              29   Net business loss for tax purposes (if box 20 or box 21 +
       + box 27 minus box 26)                                                     box 23 + box 24 minus box 22 is negative)

         £                            0 . 0 0                                       £                           0 . 0 0

Losses, Class 4 NICs and deductions
If you have made a loss for tax purposes (box 29), read page SESN 7 of the notes and fill in boxes 30 to 32 as appropriate.

  30   Loss from this tax year set-off against other income                  33   If you are exempt from paying Class 4 NICs, put 'X' in the
       for 2007-08                                                                box - read page SESN 8 of the notes

         £                                . 0 0
  31   Loss to be carried back to previous year(s) and set-off               34   If you have been given a        2007-08    Class 4 NICs
     against income (or capital gains)                           deferment certificate, put 'X' in the box - read page SESN 8
                                                                 of the notes
      £                                  . 0 0
32   Total loss to carry forward after all other set-offs   35   Deductions on payment and deduction statements from
     - including unused losses brought forward                   contractors - construction industry subcontractors only

      £                              0 . 0 0                      £                           0 . 0 0
employment (short)
                              ###########




 rer or adult placement carer, put 'X'




                ##################
DD/MM/YYYY




                Sunday, April 06, 2008




accounts are made up to - read




 ncome not included in box 8




ual turnover was below £30,000



and other professional fees




nd credit card etc. financial charges




 onery and other office costs
 ness expenses - client entertaining




enses - total of boxes 10 to 18




 expenses exceed your business
 9 minus box 19 is negative)




ot have included the cost of
 ple and Working Sheets to work out



 ges - where you have disposed of
their value - read page SESN 4 of




 if you need to make any



d from earlier years set-off against




 ncome not included in boxes 8 or 9




r tax purposes (if box 20 or box 21 +




s 30 to 32 as appropriate.

om paying Class 4 NICs, put 'X' in the




                        Class 4 NICs
 , put 'X' in the box - read page SESN 8




ment and deduction statements from
uction industry subcontractors only
                                                                                  Financial accounts for the period
                                                                                     6 April 2007 to 5 April 2008



                                    Total Year
Monthly Management Accounts                       Apr-07       May-07       Jun-07       Jul-07        Aug-07       Sep-07       Oct-07       Nov-07       Dec-07       Jan-08       Feb-08       Mar-08
                                    5 April 08
  Profit and Loss Account
                                        £           £            £            £            £             £            £            £            £            £            £            £            £
Sales Product A                               0            0            0            0            0             0            0            0            0            0            0            0            0
Sales Product B                               0            0            0            0            0             0            0            0            0            0            0            0            0
Sales Product C                               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
                  Sales Turnover              0            0            0            0            0             0            0            0            0            0            0            0            0
Investment Grants received                   0             0            0            0            0             0            0            0            0            0            0            0            0
Direct Costs
Purchases after stock adjustment             0             0            0            0            0             0            0            0            0            0            0            0            0
Sub contractors                              0             0            0            0            0             0            0            0            0            0            0            0            0
Other Direct Cost of Sales                   0             0            0            0            0             0            0            0            0            0            0            0            0
                    Cost of Sales            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
Administrative Expenses
Wages and Salaries                           0             0            0            0            0             0            0            0            0            0            0            0            0
Premises Rent Rates Power                    0             0            0            0            0             0            0            0            0            0            0            0            0
Repairs & Maintenance                        0             0            0            0            0             0            0            0            0            0            0            0            0
General Administrative Expenses              0             0            0            0            0             0            0            0            0            0            0            0            0
Motor Expenses                               0             0            0            0            0             0            0            0            0            0            0            0            0
Travel Hotel & Subsistence                   0             0            0            0            0             0            0            0            0            0            0            0            0
Advertising & Promotion                      0             0            0            0            0             0            0            0            0            0            0            0            0
Legal & Professional Fees                    0             0            0            0            0             0            0            0            0            0            0            0            0
Bad Debts written off                        0             0            0            0            0             0            0            0            0            0            0            0            0
Bank Interest Paid                           0             0            0            0            0             0            0            0            0            0            0            0            0
HP Interest Lease Bank Charges               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
Loss (profit) disposal of assets             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
       Administrative Expenses               0             0            0            0            0             0            0            0            0            0            0            0            0

                 Operating Profit            0             0            0            0            0             0            0            0            0            0            0            0            0
Interest received                            0             0            0            0            0             0            0            0            0            0            0            0            0
         Profit (Loss) before Tax            0             0            0            0            0             0            0            0            0            0            0            0            0

Financial Business Health Check
Self Employed Drawings                       0             0            0            0            0             0            0            0            0            0            0            0            0
CIS Tax deducted                             0             0            0            0            0             0            0            0            0            0            0            0            0
Income Tax & NI Liability                    0             0            0            0            0             0            0            0            0            0            0            0            0
Financial Health Check                       0             0            0            0            0             0            0            0            0            0            0            0            0
Capital introduced                           0             0            0            0            0             0            0            0            0            0            0            0            0




       12/1/2010 12:23 PM                                                                             23 of 29               42b51b7a-3ab6-43c1-a191-be4ac76504a7.xls Profit & Loss Account
                                                    Provisional tax calculation
                                    precise figures will depend upon personal circumstances



                                                                   This section an indication and for your
           TAXATION CALCULATION 2007/2008
                                                                              information only


           Profit from Self employment                                                       0.00
           Minus 0708 Personal Allowance                                                       0
           Total income on which tax is due                                                  0.00
           Income Tax first 2230 at 10%                                                      0.00
           Income Tax band (2231-34600) at 22%                                               0.00
           Income Tax band (34601+) at 40%                                                   0.00
           Income Tax payable                                                                0.00
           Deductions by contractors                                                         0.00

           Amounts Payable by 31 January 2009

           Class 4 NI Contribution (Profit x 8%)                                             0.00

           TOTAL Income Tax & NI Liability                                                   0.00



           FUTURE TAX LIABILITY (if over £500)                     This section for your information only



                                                                  Due Date            Amount Payable
           Tax & NI Assessment 2008 - 2009                      Previous Year             0.00
           50% Payable                                            31-Jan-09               0.00
           50% Payable                                            31-Jul-09               0.00

           NOTES:
           Working Tax Credit
           Not taxable and not added to self employment income for tax purposes
           Class 2 National Insurance
           Payable at £2.10 per week =£109.20 p.a
           To receive Full Pension entitlement NI has to be paid 44 years out of 49 years (16 - 65)
           UK residents aged 60 - 65 get 5 years bonus.
           To confirm current NI / Pension entitlement years the helpline number is 0845 3000 168




12/1/2010 12:23 PM                                                      4
                                                                 24 of 292b51b7a-3ab6-43c1-a191-be4ac76504a7.xls Income Tax
                                    Employees
                                                                            Employers    Recoverable
        Gross Wages   Income Tax     National      Other       Net Wages
Month                                                                        National     Statutory
            paid       deducted     Insurance    Deductions      Paid
                                                                            Insurance     Payments
                                     deducted
EMPLOYEES
Apr-07         0.00          0.00         0.00          0.00         0.00         0.00          0.00
May-07         0.00          0.00         0.00          0.00         0.00         0.00          0.00
 Jun-07        0.00          0.00         0.00          0.00         0.00         0.00          0.00
 Jul-07        0.00          0.00         0.00          0.00         0.00         0.00          0.00
Aug-07         0.00          0.00         0.00          0.00         0.00         0.00          0.00
Sep-07         0.00          0.00         0.00          0.00         0.00         0.00          0.00
 Oct-07        0.00          0.00         0.00          0.00         0.00         0.00          0.00
Nov-07         0.00          0.00         0.00          0.00         0.00         0.00          0.00
Dec-07         0.00          0.00         0.00          0.00         0.00         0.00          0.00
 Jan-08        0.00          0.00         0.00          0.00         0.00         0.00          0.00
Feb-08         0.00          0.00         0.00          0.00         0.00         0.00          0.00
Mar-08         0.00          0.00         0.00          0.00         0.00         0.00          0.00
             WAGES INTERFACE



1. If you are using a DIY Accounting payroll
package then no action is required for the pay
periods during which that payroll package is relevant
April to March each year.
2. Non DIY Accounting Payroll employers should
overwrite the formulae with the actual monthly
payroll totals
                                             Calculation Of Stock Sold           Calculation Of Stock Sold
                               Direct                              Direct                              Direct
               Calculated                Stock %     Net Sales               Stock %     Net Sales
  Date                        Material                            Material                            Material
               Stock value               Prod A      Product A               Prod B      Product B
                             BOUGHT                                SOLD                                SOLD

Enter % to change % materials sold         0%                                  0%

6-Apr-07                0

30-Apr-07               0            0     0%                0           0     0%                0           0

31-May-07               0            0     0%                0           0     0%                0           0

30-Jun-07               0            0     0%                0           0     0%                0           0

31-Jul-07               0            0     0%                0           0     0%                0           0

31-Aug-07               0            0     0%                0           0     0%                0           0

30-Sep-07               0            0     0%                0           0     0%                0           0

31-Oct-07               0            0     0%                0           0     0%                0           0

30-Nov-07               0            0     0%                0           0     0%                0           0

31-Dec-07               0            0     0%                0           0     0%                0           0

31-Jan-08               0            0     0%                0           0     0%                0           0

29-Feb-08               0            0     0%                0           0     0%                0           0

5-Apr-08                0            0     0%                0           0     0%                0           0
    Calculation Of Stock Sold
                          Direct                 ACTUAL
Stock %     Net Sales               Stock Loss
                         Material                 STOCK                     Stock Control User Notes
Prod C      Product C               Adjustment
                          SOLD                   VALUE
                                                              1. Enter the average percemtage stock value in cell H4.
  0%                                                          This is the average % of direct materials included in the
                                                              net sales value of each product type. The table will
                                                              repeat this same % for each month unless a new
                                                              percentage is entered in a specific month which will
  0%                0           0           0             0   then overwrite the originally % entered for that and the
                                                              remaining months
  0%                0           0           0             0
                                                              2. Optional: manually calculate the % of direct
  0%                0           0           0             0   materials included in net sales value and enter this
                                                              percentage in Column H against each month
  0%                0           0           0             0
                                                              3. Column F automatically collects the value of direct
  0%                0           0           0             0   materisl purchased from the monthly purchases
                                                              worksheet
  0%                0           0           0             0
                                                              4. Column L automatically calculates the value of direct
  0%                0           0           0             0   materials sold by applying the stock sales % to the net
                                                              sales value from the sales worksheet
  0%                0           0           0             0
                                                              5. Optional: At the end of each month conduct a
  0%                0           0           0             0   physical stock check and value the items counted at cost
                                                              price. Enter this actual physical value in column P at
  0%                0           0           0             0   the appropriate month end date

  0%                0           0           0             0   6. If the % of stock sold in net sales is correct then
                                                              Column Z should be zero unless stock has been lost..
  0%                0           0           0             0   Investigate significant Stock Loss Adjustments
                                                             Forecast Monthly Profit Loss Account year to 050408




                            Total Year
  Actual Profit and Loss                  Apr-07       May-07       Jun-07       Jul-07        Aug-07       Sep-07       Oct-07       Nov-07       Dec-07       Jan-08       Feb-08       Mar-08
                            5 April 08
         Account
                                £           £            £            £            £              £           £            £            £            £            £            £            £
         Sales Turnover               0            0            0            0            0             0            0            0            0            0            0            0            0
  Investment Grants                  0             0            0            0            0             0            0            0            0            0            0            0            0
            Cost of Sales            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
       General Expenses              0             0            0            0            0             0            0            0            0            0            0            0            0
         Operating Profit            0             0            0            0            0             0            0            0            0            0            0            0            0
  Interest received                  0             0            0            0            0             0            0            0            0            0            0            0            0
Profit (Loss) before Tax             0             0            0            0            0             0            0            0            0            0            0            0            0

                            Total Year
 Forecast Profit and Loss                 Apr-07       May-07       Jun-07       Jul-07        Aug-07       Sep-07       Oct-07       Nov-07       Dec-07       Jan-08       Feb-08       Mar-08
                            5 April 08
        Account
                                0
         Sales Turnover               0            0            0            0            0             0            0            0            0            0            0            0            0
  Investment Grants                  0             0            0            0            0             0            0            0            0            0            0            0            0
            Cost of Sales            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
       General Expenses              0             0            0            0            0             0            0            0            0            0            0            0            0
         Operating Profit            0             0            0            0            0             0            0            0            0            0            0            0            0
  Interest received                  0             0            0            0            0             0            0            0            0            0            0            0            0
Profit (Loss) before Tax             0             0            0            0            0             0            0            0            0            0            0            0            0
  FORECAST TAX CALCULATION
  Add Depreciation            0
  Less Capital Allowances     0
  Profit before Tax           0
  Personal Allowance      5,225
  Profit after Allowance      0
  Tax at reduced rate         0
  Tax at standard rate        0
  Tax at higher rate          0
  National Insurance          0
  TAX & NI LIABILITY                 0




  12/1/2010 12:23 PM                                                                          29 of 29                   42b51b7a-3ab6-43c1-a191-be4ac76504a7.xls Profit Forecast

								
To top