Projections

Document Sample
Projections Powered By Docstoc
					                                                                                                              Moon Productions LLP
                                                                                        Forecast for two years ending 30th April 2010
                                                                                                                        Introduction


                                                                                                                   Summary P&L +                Page 4
                                                                                                                     Sensitivity
                                                                                                                   Balance Sheet +              Page 5
                                                                                                                   Cashflow Chart




     Welcome to an example model of a simple business                                                Monthly                      Monthly Balance Sheet
                                                                                                   Profit & Loss                      & Cashflow
     The high level and monthly summaries are in the dark blue sheets.
                                                                                                    Page 6                             Pages 7 - 10
     We aim to allow you to control the assumptions while the model does the work
                                                                                                        Sales             P 11              Model          P 14
     Also on the summary page we have placed the most important assumptions                          Assumptions                          Assumptions
     under the control of slider bars. Alongside is a graph of cash so that you
     can determine the impact of changes in assumptions very quickly.
                                                                                                         Model
                                                                                                       Assumptions                         Capex           P 15
     The assumptions are entered in marked cells in the light blue sheets.                                                 P 12
                                                                                                             (1)                          Workings

     For ease of distribution we have not added a print macro but each page is set
     up to produce a clear presentation and print format.                                                 Model
                                                                                                       Assumptions         P 13
     You can use the page numbers on the printed pages to guide you, or go to the                          (2)

     assumptions page and follow the Hyperlink arrows and you will go straight there.




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                  Page 1 of 17
                                                                                                      Moon Productions LLP
                                                                                Forecast for two years ending 30th April 2010
                                                                                                                        Index

                                                                       Page


      Assumptions Narrative                                              3
                                                                                                        Summary P&L +
      Summary Financials                                                                                  Sensitivity
      Summary P&L and Sensitivity                                        4                              Balance Sheet +
      Balance Sheet + Cashflow Chart                                     5                              Cashflow Chart


      Detailed Monthly Profit/Loss
      Monthly Profit & Loss                                              6
                                                                                                                      Monthly Balance Sheet
                                                                                          Monthly
                                                                                                                          & Cashflow
      Monthly Balance Sheet &Cash Flow                                                  Profit & Loss
                                                                                                                          + Workings
      Balance Sheet                                                      7
      Cash Flow
                                                                                                                          Model Assumptions
      Detailed Balance Sheet & Cash flow Workings                      8 - 10               Sales                         ( 3 ) VAT, Interest &
      Fixed Assets                                                                       Assumptions                       Depreciation, etc.
      Debtors
      Creditors                                                                                Model
                                                                                           Assumptions                       Capex Workings
      Sales Assumptions                                                 11              ( 1 ) Op Bal + Exps

      Model Assumptions (General)
      Model Assumptions 1 - Opening Balance Sheet + Expenses            12                    Model
      Model Assumptions 2 - Salaries                                    13                Assumptions
                                                                                          ( 2 ) Salaries
      Model Assumptions 3 - VAT, Interest, Depreciation, Days Credit    14

      Capital Expenditure                                               15




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                   Page 2 of 17
                                                                                                                                    Moon Productions LLP
                                                                                                              Forecast for two years ending 30th April 2010
                                                                                                                                    Assumptions Narrative
                                                                                                Index
      Sales
      £80k per month based on first 5 months of 08-09
      Sensitivity of additional sales on Summary sheet                                          link

      Professional salaries
      Estimates taken from current payroll. Nathan has been included.                           link



      Overheads
      Based on a combination of 07-08 actual expenditure,
      adjusted for known variances in current year.
      These costs are set out on the assumptions page.                                          link

      Capex
      No Capex planned for next 2 years.                                                        link

      Balance Sheet
      The main balance sheet assumptions are in the Assumptions page
                                                                                 Debtor days            60
                                                                               Creditor days
                                                                                 Direct costs            30
                                                                                  Overheads             120
                                                                        Capex - Fixed Assets              5

      Disputed liabilities
      Old Debt 1 / Old Debt 2 / Old Debt 3 / Old Debt 4 / Old rent                              link
      These have been assumed not to be paid in the next 2 years

      Bank
      No provision yet made for repayment                                                       link

      Investments
      Sensitivity of share sales set out on Summary sheet                                       link




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                           Page 3 of 17
                                                                                              Moon Productions LLP
                                                                        Forecast for two years ending 30th April 2010
                                                                            Summary Profit & Loss and Sensitivities
                                                                                                     (All figures are £000)
                                                                 Sensitivity
                                     Year     Year      Year                              Original Value Sensitivity Revised
                                   Apr-08    Apr-09    Apr-10                                 per month per month per month
                                     draft    f'cast    f'cast   Impact on model of:

Fees                               1,643      946       960      Fees income                     80.0          -       80.0

Direct costs                         374      357       377      Fee earners                     28.2          -       28.2

Gross Profit                       1,269      589       583      Share sales receipts                -         -             -
Gross Profit %                      77%       62%       61%

People Costs                         264      206       204      Support staff costs             10.9          -       10.9
Premises Costs                       160      225       256      Premises costs                  18.8          -       18.8
General Costs                        775      420       465      Legal fee costs                   8.3         -        8.3
Finance                              457       25        27
                                                                 Version Control              Y/E 4/08   Y/E 4/09   Y/E 4/10
PBIT                                (387)     (286)     (369)    Base PBIT                       (387)     (286)       (369)

Interest Income / (Expense)            9       (17)      (60)
                                                                 IMPACT of Changes                   -         -             -
Corporation Tax                                   -         -    (re. above)


PAT                                 (378)     (303)     (429)

Headcount @ Year End                  16       16        17




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                      Page 4 of 16
                                                                                                                Moon Productions LLP
                                                                                          Forecast for two years ending 30th April 2010
                                                                                         Summary Balance Sheet + Bank Balance chart
                                                                                                                     (All figures are £000)
                                                                         Index

                                 Sep 08        Apr 09       Apr 10


Fixed Assets                               -            -            -
                                                                                    -

Current Assets
                                                                                 (100)
         Investments               1,139        1,139         1,139
         Trade Debtors               221          181           181                          Bank balance £000
         Sundry Debtors               12            4            10              (200)


                                   1,372        1,324         1,330              (300)


Current Liabilities                                                              (400)
         Trade Creditors             356          246           308
         Disputed creditors          242          242           242              (500)
         Bank Loan                   102          102           102
         Leasing Creditor             30           30            30              (600)
         Payroll Creditors            15           17            16
         Old payroll                  50            -             -
                                                                                 (700)
         Accruals                     17           17            17
                                     812          654           716
                                                                                 (800)

Working Capital                      560          670           614

Bank & Cash                         (119)        (362)         (735)

Net Assets                           441          308          (121)
check                                 OK            OK           OK




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                     Page 5 of 16
                                                                                                                                                                                                             Moon Productions LLP
                                                                                                                                                                                       Forecast for two years ending 30th April 2010
                                                                                                                                                                                                              Detailed Profit & Loss
                                        Year to   Year to   5 mths to                                                                                                                                           (All figures are £000)
                                        Apr-09    Apr-10      Sep-08    Oct-08    Nov-08    Dec-08 Jan-09      Feb-09    Mar-09    Apr-09    May-09    Jun-09    Jul-09   Aug-09    Sep-09    Oct-09    Nov-09    Dec-09    Jan-10     Feb-10    Mar-10    Apr-10


Fees                                     946.4     960.0       386.4     80.0      80.0      80.0     80.0      80.0      80.0      80.0      80.0      80.0      80.0     80.0      80.0      80.0      80.0      80.0      80.0       80.0      80.0      80.0

Direct costs
                      Opening WIP            -         -           -        -         -         -        -         -         -         -         -         -         -        -         -         -         -         -         -          -         -         -
                       Fee earners       357.8     377.0       149.6     28.2      28.2      28.2     30.0      30.0      31.8      31.8      31.8      31.8      31.8     31.8      31.8      31.8      31.8      31.8      31.8       31.8      29.6      29.6
      Client disbursement recharges       (0.5)                 (0.5)       -         -         -        -         -         -         -         -         -         -        -         -         -         -         -         -          -         -         -
                       Closing WIP           -         -           -        -         -         -        -         -         -         -         -         -         -        -         -         -         -         -         -          -         -         -

Total Direct costs                       357.4     377.0       149.1     28.2      28.2      28.2     30.0      30.0      31.8      31.8      31.8      31.8      31.8     31.8      31.8      31.8      31.8      31.8      31.8       31.8      29.6      29.6
Gross Profit                             589.0     583.0       237.2     51.8      51.8      51.8     50.0      50.0      48.2      48.2      48.2      48.2      48.2     48.2      48.2      48.2      48.2      48.2      48.2       48.2      50.4      50.4
Gross Profit %                             62%       61%         61%      65%       65%       65%      62%       62%       60%       60%       60%       60%       60%      60%       60%       60%       60%       60%       60%        60%       63%       63%
                       Support staff     135.7     130.3        59.7     10.9      10.9      10.9     10.9      10.9      10.9      10.9      10.9      10.9      10.9     10.9      10.9      10.9      10.9      10.9      10.9       10.9      10.9      10.9
                       Staff training     15.0      15.8         5.0      1.4       1.4       1.4      1.4       1.4       1.4       1.4       1.3       1.3       1.3      1.3       1.3       1.3       1.3       1.3       1.3        1.3       1.3       1.3
                         Temp staff       40.0      42.0        19.6      2.9       2.9       2.9      2.9       2.9       2.9       2.9       3.5       3.5       3.5      3.5       3.5       3.5       3.5       3.5       3.5        3.5       3.5       3.5
                       Consultancy         5.0       5.3         5.0        -         -         -        -         -         -         -       0.4       0.4       0.4      0.4       0.4       0.4       0.4       0.4       0.4        0.4       0.4       0.4
                       Staff welfare      10.0      10.5         3.8      0.9       0.9       0.9      0.9       0.9       0.9       0.9       0.9       0.9       0.9      0.9       0.9       0.9       0.9       0.9       0.9        0.9       0.9       0.9
People Costs                             205.7     203.9        93.1     16.1      16.1      16.1     16.1      16.1      16.1      16.1      17.0      17.0      17.0     17.0      17.0      17.0      17.0      17.0      17.0       17.0      17.0      17.0

     Rent, rates & service charge        222.0     233.1        84.6     19.6      19.6      19.6     19.6      19.6      19.6      19.6      19.4      19.4      19.4     19.4      19.4      19.4      19.4      19.4      19.4       19.4      19.4      19.4
                  Rent receivable        (34.0)    (16.0)      (24.6)    (1.3)     (1.3)     (1.3)    (1.3)     (1.3)     (1.3)     (1.3)     (1.3)     (1.3)     (1.3)    (1.3)     (1.3)     (1.3)     (1.3)     (1.3)     (1.3)      (1.3)     (1.3)     (1.3)
               Building insurance          3.0       3.2           -      0.4       0.4       0.4      0.4       0.4       0.4       0.4       0.3       0.3       0.3      0.3       0.3       0.3       0.3       0.3       0.3        0.3       0.3       0.3
                          Repairs         24.0      25.2        19.7      0.6       0.6       0.6      0.6       0.6       0.6       0.6       2.1       2.1       2.1      2.1       2.1       2.1       2.1       2.1       2.1        2.1       2.1       2.1
                   Light and heat         10.0      10.5           -      1.4       1.4       1.4      1.4       1.4       1.4       1.4       0.9       0.9       0.9      0.9       0.9       0.9       0.9       0.9       0.9        0.9       0.9       0.9
Premises Costs                           225.0     256.0        79.7     20.8      20.8      20.8     20.8      20.8      20.8      20.8      21.3      21.3      21.3     21.3      21.3      21.3      21.3      21.3      21.3       21.3      21.3      21.3

            Travel and subsistence        24.0      25.2         2.6      3.1       3.1       3.1      3.1       3.1       3.1       3.1       2.1       2.1       2.1      2.1       2.1       2.1       2.1       2.1       2.1        2.1       2.1       2.1
           Communications and IT          36.0      37.8        24.7      1.6       1.6       1.6      1.6       1.6       1.6       1.6       3.2       3.2       3.2      3.2       3.2       3.2       3.2       3.2       3.2        3.2       3.2       3.2
                    Office expenses        6.0       6.3         0.5      0.8       0.8       0.8      0.8       0.8       0.8       0.8       0.5       0.5       0.5      0.5       0.5       0.5       0.5       0.5       0.5        0.5       0.5       0.5
           Operating lease charges           -         -           -        -         -         -        -         -         -         -         -         -         -        -         -         -         -         -         -          -         -         -
   Printing, stationery and postage       16.0      16.8         6.7      1.3       1.3       1.3      1.3       1.3       1.3       1.3       1.4       1.4       1.4      1.4       1.4       1.4       1.4       1.4       1.4        1.4       1.4       1.4
                   Sundry expenses        30.0      31.5        15.0      2.1       2.1       2.1      2.1       2.1       2.1       2.1       2.6       2.6       2.6      2.6       2.6       2.6       2.6       2.6       2.6        2.6       2.6       2.6
      Subscriptions and donations          6.0       6.3         1.4      0.7       0.7       0.7      0.7       0.7       0.7       0.7       0.5       0.5       0.5      0.5       0.5       0.5       0.5       0.5       0.5        0.5       0.5       0.5
       Advertising and entertaining       48.0      50.4        35.9      1.7       1.7       1.7      1.7       1.7       1.7       1.7       4.2       4.2       4.2      4.2       4.2       4.2       4.2       4.2       4.2        4.2       4.2       4.2
        Legal and professional fees      100.0     105.0        93.9      0.9       0.9       0.9      0.9       0.9       0.9       0.9       8.8       8.8       8.8      8.8       8.8       8.8       8.8       8.8       8.8        8.8       8.8       8.8
                FD and bookkeeper         50.0      50.6        25.0      3.6       3.6       3.6      3.6       3.6       3.6       3.6       4.4       4.2       4.2      4.2       4.2       4.2       4.2       4.2       4.2        4.2       4.4       4.4
                            PI cover      77.0     110.4        16.0      8.7       8.7       8.7      8.7       8.7       8.7       8.7       0.4      10.0      10.0     10.0      10.0      10.0      10.0      10.0      10.0       10.0      10.0      10.0
                        Law Society        5.0       6.4         0.3      0.7       0.7       0.7      0.7       0.7       0.7       0.7       1.8       0.4       0.4      0.4       0.4       0.4       0.4       0.4       0.4        0.4       0.4       0.4
             Audit and accountancy        20.0      18.5           -      2.9       2.9       2.9      2.9       2.9       2.9       2.9         -       1.7       1.7      1.7       1.7       1.7       1.7       1.7       1.7        1.7       1.8       1.8
                        Depreciation       2.0         -         2.0        -         -         -        -         -         -         -         -         -         -        -         -         -         -         -         -          -         -         -
General Costs                            420.0     465.3       224.0     28.0      28.0      28.0     28.0      28.0      28.0      28.0      29.8      39.5      39.5     39.5      39.5      39.5      39.5      39.5      39.5       39.5      39.8      39.8

                        Bad debts            -         -           -        -          -         -        -         -         -         -         -         -        -         -         -        -          -         -         -          -         -         -
                    Bank charges          20.0      20.1        12.3      1.1        1.1       1.1      1.1       1.1       1.1       1.1       1.8       1.7      1.7       1.7       1.7      1.7        1.7       1.7       1.7        1.7       1.7       1.7
                 Bank loan interest        2.0       1.8           -      0.3        0.3       0.3      0.3       0.3       0.3       0.3         -       0.2      0.2       0.2       0.2      0.2        0.2       0.2       0.2        0.2       0.2       0.2
                           Interest        2.8       4.8           -      0.4        0.4       0.4      0.4       0.4       0.4       0.4       0.4       0.4      0.4       0.4       0.4      0.4        0.4       0.4       0.4        0.4       0.4       0.4
Finance                                   24.8      26.7        12.3      1.8        1.8       1.8      1.8       1.8       1.8       1.8       2.1       2.2      2.2       2.2       2.2      2.2        2.2       2.2       2.2        2.2       2.2       2.2


Total Expenses                           875.4     951.8       409.0     66.6      66.6      66.6     66.6      66.6      66.6      66.6      70.3      80.1      80.1     80.1      80.1      80.1      80.1      80.1      80.1       80.1      80.4      80.4

PBIT                                    (286.5)   (368.9)     (171.8)   (14.9)     (14.9)    (14.9)   (16.6)    (16.6)    (18.4)    (18.4)    (22.1)    (31.9)   (31.9)    (31.9)    (31.9)   (31.9)     (31.9)    (31.9)    (31.9)     (31.9)    (30.0)    (30.0)

                            Interest     (16.7)    (60.1)        1.4      (1.2)     (2.3)     (2.5)    (2.7)     (2.9)     (3.1)     (3.4)     (3.6)     (3.6)    (3.7)     (4.0)     (4.3)     (4.7)     (5.1)     (5.5)     (5.8)      (6.2)     (6.6)     (6.9)

PBT                                     (303.2)   (429.0)     (170.4)   (16.0)     (17.2)    (17.4)   (19.3)    (19.5)    (21.6)    (21.9)    (25.7)    (35.5)   (35.5)    (35.9)    (36.2)   (36.5)     (37.0)    (37.3)    (37.7)     (38.1)    (36.6)    (36.9)

                     Corporation Tax         -         -           -         -         -         -        -         -         -         -         -         -        -         -         -         -         -         -         -          -         -         -
PAT                                     (303.2)   (429.0)     (170.4)   (16.0)     (17.2)    (17.4)   (19.3)    (19.5)    (21.6)    (21.9)    (25.7)    (35.5)   (35.5)    (35.9)    (36.2)   (36.5)     (37.0)    (37.3)    (37.7)     (38.1)    (36.6)    (36.9)




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                                                             Page 6 of 17
                                                                                                                                                            Moon Productions LLP
                                                                                                                                      Forecast for two years ending 30th April 2010
                                                                                                                                                                    Balance Sheet
                                                                                                                                                                                (All figures are £000)
                                Oct-08   Nov-08   Dec-08   Jan-09   Feb-09   Mar-09   Apr-09   May-09   Jun-09   Jul-09   Aug-09   Sep-09   Oct-09   Nov-09   Dec-09   Jan-10   Feb-10   Mar-10   Apr-10
Balance Sheet
Fixed Assets
                       Cost         -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -
                       Depn         -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -
           Net Book Value           -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -

Current Assets
               Investments      1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139
             Trade Debtors        200      200      181      181      181      181      181      181      181      181      181      181      181      181      181      181      181      181      181
         Bad Debt Provision         -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -
            Sundry Debtors         12       12       12       12       12       12       12       12       12       12       12       12       12       12       12       12       12       12       12
                       VAT         (4)      (9)      (4)      (9)     (13)      (4)      (9)     (11)      (3)      (5)      (8)     (11)      (3)      (5)      (8)      (3)      (5)      (8)      (3)
              Bank & Cash        (229)    (252)    (265)    (290)    (315)    (344)    (362)    (363)    (368)    (401)    (434)    (468)    (512)    (547)    (581)    (624)    (660)    (693)    (735)
                                1,118    1,091    1,063    1,034    1,005      984      962      958      962      926      890      854      817      780      743      705      667      632      595

Current Liabilities
             Trade Creditors      246      246      246      246      246      246      246      268      307     307       307      307      307      307      307      307      307      308      308
           Disputed creditors     242      242      242      242      242      242      242      242      242     242       242      242      242      242      242      242      242      242      242
                  Bank Loan       102      102      102      102      102      102      102      102      102     102       102      102      102      102      102      102      102      102      102
            Leasing Creditor       30       30       30       30       30       30       30       30       30      30        30       30       30       30       30       30       30       30       30
            Payroll Creditors      16       16       16       16       16       17       17       17       17      17        17       17       17       17       17       17       17       17       16
                  Old payroll      40       30       20       10        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
                    Accruals       17       17       17       17       17       17       17       17       17      17        17       17       17       17       17       17       17       17       17
                                  693      683      673      663      654      654      654      676      715     715       715      715      715      715      715      715      715      716      716


                Net Assets        425      408      390      371      351      330      308      282      247     211       175      139      103       66       28       (9)     (48)     (84)    (121)

Represented By
        Shareholders Loans        739      739      739      739      739      739      739      739      739      739      739      739      739      739      739      739      739      739      739
               Balance B/F       (298)    (298)    (298)    (298)    (298)    (298)    (298)    (431)    (431)    (431)    (431)    (431)    (431)    (431)    (431)    (431)    (431)    (431)    (431)
              Profit & Loss       (16)     (33)     (51)     (70)     (89)    (111)    (133)     (26)     (61)     (97)    (133)    (169)    (205)    (242)    (280)    (317)    (355)    (392)    (429)
     Shareholders Funds           425      408      390      371      351      330      308      282      247      211      175      139      103       66       28       (9)     (48)     (84)    (121)

Cash Flow
Receipts
              Sales Receipts      111       91      110       91       91       91       91       91       91      91        91       91       91       91       91       91       91       91       91
                 Share sales        -        -        -        -        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
                        VAT         -        -       (9)       -        -      (13)       -        -      (11)      -         -        -      (11)       -        -       (8)       -        -       (8)
Payments
  Creditors Including Cap Ex      172       62       62       62       62       62       62       46       38      77        77       77       77       77       77       77       77       76       77
                      Payroll      38       39       39       41       41       42       42       42       43      43        43       43       43       43       43       43       43       41       41
                  Old payroll      10       10       10       10       10        -        -        -        -       -         -        -        -        -        -        -        -        -        -
          Leasing Payments          0        0        0        0        0        0        0        0        0       0         0        0        0        0        0        0        0        0        0

   Net Receipt/(Payment)         (109)     (21)     (10)     (22)     (22)     (27)     (14)       2       (1)     (29)     (29)     (29)     (40)     (29)     (29)     (37)     (29)     (26)     (36)

           Opening Balance       (119)    (229)    (252)    (265)    (290)    (315)    (344)    (362)    (363)    (368)    (401)    (434)    (468)    (512)    (547)    (581)    (624)    (660)    (693)
                   Interest        (1)      (2)      (3)      (3)      (3)      (3)      (3)      (4)      (4)      (4)      (4)      (4)      (5)      (5)      (5)      (6)      (6)      (7)      (7)
         Closing Balance         (229)    (252)    (265)    (290)    (315)    (344)    (362)    (363)    (368)    (401)    (434)    (468)    (512)    (547)    (581)    (624)    (660)    (693)    (735)




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                            Page 7 of 17
                                                                                                                                                        Moon Productions LLP
                                                                                                                                  Forecast for two years ending 30th April 2010
                                                                                                                               Workings Sheet 1 - Fixed Assets + Trade Debtors
                                                                                                                                                                             (All figures are £000)
                            Oct-08   Nov-08   Dec-08   Jan-09   Feb-09   Mar-09   Apr-09   May-09   Jun-09   Jul-09   Aug-09    Sep-09   Oct-09   Nov-09   Dec-09   Jan-10   Feb-10   Mar-10   Apr-10
Fixed Assets
Leasehold improvements
                    Cost        -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
                Additions       -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
       Brought forward          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -

                   Dep'n        -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
                Provision       -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
       Brought forward          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -

        Net Book Value          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -

Fixtures, fittings & equipment
                    Cost        -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
                Additions       -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
        Leasing Additions       -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
       Brought forward          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -

                   Dep'n        -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
                Provision       -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
       Brought forward          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -

        Net Book Value          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -

Total Fixed Assets
                   Cost         -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
                   Depn         -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
        Net Book Value          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -




Trade Debtors
        Opening Balance       221      200      200      181      181      181      181      181      181     181       181       181      181      181      181      181      181      181      181
                  Sales        80       80       80       80       80       80       80       80       80      80        80        80       80       80       80       80       80       80       80
                    VAT        11       11       11       11       11       11       11       11       11      11        11        11       11       11       11       11       11       11       11
       Bad Debt Write off       -        -        -        -        -        -        -        -        -       -         -         -        -        -        -        -        -        -        -
         Cash Received       (111)     (91)    (110)     (91)     (91)     (91)     (91)     (91)     (91)    (91)      (91)      (91)     (91)     (91)     (91)     (91)     (91)     (91)     (91)
       Closing Balance        200      200      181      181      181      181      181      181      181     181       181       181      181      181      181      181      181      181      181


             Debtor Days       60       60       60       60       60       60       60       60       60      60        60        60       60       60       60       60       60       60       60

Bad Debt Provision
        Opening Balance         -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
               Provision        -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -
               Write Off
       Closing Balance          -        -        -        -        -        -        -        -        -        -        -         -        -        -        -        -        -        -        -




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                         Page 8 of 17
                                                                                                                                                   Moon Productions LLP
                                                                                                                             Forecast for two years ending 30th April 2010
                                                                                                                 Workings Sheet 2 - Sundry Debtors, Creditors + Bank Loan
                                                                                                                                                                               (All figures are £000)
                               Oct-08   Nov-08   Dec-08   Jan-09   Feb-09   Mar-09   Apr-09   May-09   Jun-09   Jul-09   Aug-09   Sep-09   Oct-09   Nov-09   Dec-09   Jan-10   Feb-10   Mar-10   Apr-10
Sundry debtors
         Opening Balance          12       12       12       12       12       12       12       12       12      12        12       12       12       12       12       12       12       12       12
                 Provision                                                      -
   Release to Profit & Loss        -        -        -        -        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
        Closing Balance           12       12       12       12       12       12       12       12       12      12        12       12       12       12       12       12       12       12       12

Trade Creditors
          Opening Balance        356      246      246      246      246      246      246      246      268     307       307      307      307      307      307      307      307      307      308
                Direct costs       -        -        -        -        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
           Direct costs VAT        -        -        -        -        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
                 Overheads        55       55       55       55       55       55       55       59       69      69        69       69       69       69       69       69       69       69       69
            Overheads VAT          6        6        6        6        6        6        6        8        8       8         8        8        8        8        8        8        8        8        8
        Capital Expenditure        -        -        -        -        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
   Capital Expenditure VAT         -        -        -        -        -        -        -        -        -       -         -        -        -        -        -        -        -        -        -
                  Payments      (172)     (62)     (62)     (62)     (62)     (62)     (62)     (46)     (38)    (77)      (77)     (77)     (77)     (77)     (77)     (77)     (77)     (76)     (77)
        Closing Balance          246      246      246      246      246      246      246      268      307     307       307      307      307      307      307      307      307      308      308

Days O/S
                Direct costs      30       30       30       30       30       30       30       30       30      30        30       30       30       30       30       30       30       30       30
                 Overheads       120      120      120      120      120      120      120      120      120     120       120      120      120      120      120      120      120      120      120
        Capital Expenditure        5        5        5        5        5        5        5        5        5       5         5        5        5        5        5        5        5        5        5

Disputed creditors
          Opening balance        242      242      242      242      242      242      242      242      242     242       242      242      242      242      242      242      242      242      242
           Payments made
                Provision
         Closing balance         242      242      242      242      242      242      242      242      242     242       242      242      242      242      242      242      242      242      242

Bank Loan
          Opening balance        102      102      102      102      102      102      102      102      102     102       102      102      102      102      102      102      102      102      102
           Payments made
                Provision
         Closing balance         102      102      102      102      102      102      102      102      102     102       102      102      102      102      102      102      102      102      102




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                           Page 9 of 17
                                                                                                                                                  Moon Productions LLP
                                                                                                                            Forecast for two years ending 30th April 2010
                                                                                              Workings Sheet 3 - Payroll Creditors, Leasing, Accruals, Investments + VAT
                                                                                                                                                                                  (All figures are £000)
                               Oct-08   Nov-08   Dec-08   Jan-09   Feb-09   Mar-09   Apr-09     May-09    Jun-09   Jul-09   Aug-09   Sep-09   Oct-09   Nov-09   Dec-09   Jan-10   Feb-10   Mar-10   Apr-10
Payroll Creditors
          Opening Balance         15       16       16       16       16       16       17          17       17       17       17       17       17       17       17       17       17       17       17
              Fee earners         28       28       28       30       30       32       32          32       32       32       32       32       32       32       32       32       32       30       30
             Support staff        11       11       11       11       11       11       11          11       11       11       11       11       11       11       11       11       11       11       11
                 Payment         (38)     (39)     (39)     (41)     (41)     (42)     (42)        (42)     (43)     (43)     (43)     (43)     (43)     (43)     (43)     (43)     (43)     (41)     (41)
       Closing Balance            16       16       16       16       16       17       17          17       17       17       17       17       17       17       17       17       17       17       16

Old payroll
          Opening balance         50       40       30       20       10        -        -           -        -        -        -        -        -        -        -        -        -        -        -
           Payments made         (10)     (10)     (10)     (10)     (10)
       Closing Balance            40       30       20       10        -        -        -           -        -        -        -        -        -        -        -        -        -        -        -


Days Outstanding
              Salaries Net         -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
              PAYE, NI etc        30       30       30       30       30       30       30         30        30      30        30       30       30       30       30       30       30       30       30

Leasing
          Opening Balance         30       30       30       30       30       30       30         30        30      30        30       30       30       30       30       30       30       30       30
               Purchased           -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
            Capital Repaid         -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
                   Deposit         -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
       Closing Balance            30       30       30       30       30       30       30         30        30      30        30       30       30       30       30       30       30       30       30
                    Interest       0        0        0        0        0        0        0          0         0       0         0        0        0        0        0        0        0        0        0
              Total Payable        0        0        0        0        0        0        0          0         0       0         0        0        0        0        0        0        0        0        0

Accruals
          Opening Balance         17       17       17       17       17       17       17         17        17      17        17       17       17       17       17       17       17       17       17
                 Provision         -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
                  Release
       Closing Balance            17       17       17       17       17       17       17         17        17      17        17       17       17       17       17       17       17       17       17

Investments
         Opening Balance       1,139    1,139    1,139    1,139    1,139    1,139    1,139       1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139
                  Additions
      Sales of investments         -        -        -        -        -        -        -           -        -        -        -        -        -        -        -        -        -        -        -
       Closing Balance         1,139    1,139    1,139    1,139    1,139    1,139    1,139       1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139    1,139


VAT
          Opening Balance          -        4        9        4        9       13        4          9        11       3         5        8       11        3        5        8        3        5        8
                    Sales         11       11       11       11       11       11       11         11        11      11        11       11       11       11       11       11       11       11       11
                        -          -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
                        -         (6)      (6)      (6)      (6)      (6)      (6)      (6)        (8)       (8)     (8)       (8)      (8)      (8)      (8)      (8)      (8)      (8)      (8)      (8)
                        -          -        -        -        -        -        -        -          -         -       -         -        -        -        -        -        -        -        -        -
                Payments                            (9)                       (13)                          (11)                                (11)                        (8)                        (8)
       Closing Balance             4        9        4        9       13        4        9         11         3        5        8       11        3        5        8        3        5        8        3




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                             Page 10 of 17
                                                                                                                                                                                               Moon Productions LLP
                                                                                                                                                                         Forecast for two years ending 30th April 2010
                                                                                                                                                                                                  Sales Assumptions
                           Year to        Year to         5 mths to   Oct-08   Nov-08   Dec-08   Jan-09   Feb-09   Mar-09   Apr-09   May-09   Jun-09   Jul-09   Aug-09   Sep-09   Oct-09   Nov-09   Dec-09   Jan-10   Feb-10     Mar-10   Apr-10
                              Apr-09        Apr-10           Sep-08



Sales Turnover
Fees    £'s                 866,361        960,000          386,361   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000     80,000   80,000

Additional fees                     -              -                       -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -        -          -        -




Total                       866,361        960,000          386,361   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000   80,000     80,000   80,000


Note:
                  ONLY shaded cells with BLUE text to be altered




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                                                       Page 11 of 17
                                                                                                                                  Moon Productions LLP
                                                                                                     Model Assumptions ( 1 ) - Op. Bal. Sheet & Expenses
  Opening Balance Sheet                            30 Sep 08              Expenses                             Year end      Increase/   Year end
                                                                                                                                                         Vat
  Fixed Assets                                                            Overheads                                Apr-09 Decrease         Apr-10      Element
  Cost                                                                    Staff                                   £          %              £             %
  Leasehold improvements                                   -              Staff training                           15,000   5%             15,800         100%
  Fixtures, fittings & equipment                           -              Temp staff                               40,000   5%             42,000         100%
  Depn                                                                    Consultancy                               5,000   5%              5,300            0%
  Leasehold improvements                                   -              Staff welfare                            10,000   5%             10,500            0%
  Fixtures, fittings & equipment                           -
  NBV                                                      -              Premises
  Current Assets                                                          Rent, rates & service charge            222,000       5%        233,100          80%
  Investments                                      1,139,255              Rent receivable                         (34,000)                (16,000)        100%
  Trade Debtors                                      220,634              Building insurance                        3,000       5%          3,200           0%
  Provision                                                -              Repairs                                  24,000       5%         25,200         100%
  Sundry Debtors                                      12,267              Light and heat                           10,000       5%         10,500         100%
  Bank & Cash                                       (119,222)                                                     225,000                 256,000
                                                   1,252,934              General
  Current Liabilities                                                     Travel and subsistence                   24,000       5%         25,200          50%
  Trade Creditors                                    356,486              Communications and IT                    36,000       5%         37,800         100%
  Disputed creditors                                 241,975              Office expenses                           6,000       5%          6,300         100%
  Barclays                                           102,037              Operating lease charges                       -       5%              -          25%
  Finance leases                                      29,839              Printing, stationery and postage         16,000       5%         16,800           0%
  Old payroll                                         50,000              Sundry expenses                          30,000       5%         31,500         100%
  Payroll Creditors                                   14,600              Subscriptions and donations               6,000       5%          6,300         100%
  Accruals                                            17,276              Advertising and entertaining             48,000       5%         50,400           0%
  Accruals                                                 -              Legal and professional fees             100,000       5%        105,000         100%
  VAT                                                      -              FD and bookkeeper                        50,000       5%         52,500         100%
                                                                          PI cover                                 77,000                 120,000           0%
                                                     812,213              Law Society                               5,000       5%          5,300         100%
                                                                          Audit and accountancy                    20,000       5%         21,000         100%
  Net Assets                                         440,721              Depreciation                                  -                       -           0%
  Represented By                                                                                                  418,000                 478,100
  Shareholders Loans                                 738,746              Finance
  Balance B/F                                       (298,025)             Bad debts                                                                       100%
  Profit & Loss                                            -              Bank charges                             20,000       5%         21,000           0%
                                                     440,721              Bank loan interest                        2,000                       -           0%
                                                           -              Interest                                                                          0%
                               Note:                                                                               22,000                  21,000
                                       ONLY shaded cells with BLUE text to be altered




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                             Page 12 of 17
                                                                                                                                  Moon Productions LLP
                                                                                                                        Model Assumptions ( 2 ) - Salaries
  Salaries                                     Increase          5%     May 08
                                           Employer's NI      12.8%
  Fee earners                                                                                Support staff
  Job                              Name           Start    End Date    Salaries    Bonus     Job                  Name          Start   End Date    Salaries    Bonus
  Fee earner 1                  Name 1         1 Feb 00                 70,000         -     Support 1    Name 13           1 Jan 00                 46,000         -
  Fee earner 2                  Name 2         1 Feb 00                 40,000         -     Support 2    Name 14           1 Nov 01                 36,000         -
  Fee earner 3                  Name 3         1 Nov 01                 22,000         -     Support 3    Name 15           1 Mar 04                 16,000         -
  Fee earner 4                  Name 4         1 Dec 01                 22,000         -     Support 4    Name 16            1 Jul 06                 6,000         -
  Fee earner 5                  Name 5         1 Sep 02    28 Feb 10    22,000         -     Support 5    Name 17           1 Jan 08                  6,000         -
  Fee earner 6                  Name 6         1 Jan 04                 22,000         -
  Fee earner 7                  Name 7         1 Apr 04                 22,000         -
  Fee earner 8                  Name 8         1 Sep 04                 22,000         -
  Fee earner 9                  Name 9         1 Dec 04                 22,000         -           Note:
  Fee earner 10                 Name 10        1 Feb 05                 22,000         -                   ONLY shaded cells with BLUE text to be altered
  Fee earner 11                 Name 11        1 Jan 09                 18,000         -
  Fee earner 11                 Name 12        1 Mar 09                 18,000         -


  Salaries Workings                                Y/E 30/4/09                                      Y/E 30/4/2010
                                Salaries       Bonus      Gross              NI   Salaries        Bonus           Gross            NI
  Fee earner 1                    70,000             -      70,000       8,960     73,500              -        73,500         9,408
  Fee earner 2                    40,000             -      40,000       5,120     42,000              -        42,000         5,376
  Fee earner 3                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 4                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 5                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 6                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 7                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 8                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 9                    22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 10                   22,000             -      22,000       2,816     23,100              -        23,100         2,957
  Fee earner 11                   18,000             -      18,000       2,304     18,900              -        18,900         2,419
  Fee earner 11                   18,000             -      18,000       2,304     18,900              -        18,900         2,419

                                                   Y/E 30/4/09                                      Y/E 30/4/2010
                                Salaries       Bonus      Gross              NI   Salaries        Bonus           Gross            NI
  Support 1                       46,000             -      46,000       5,888     48,300              -        48,300         6,182
  Support 2                       36,000             -      36,000       4,608     37,800              -        37,800         4,838
  Support 3                       16,000             -      16,000       2,048     16,800              -        16,800         2,150
  Support 4                         6,000            -       6,000         768      6,300              -          6,300          806
  Support 5                         6,000            -       6,000         768      6,300              -          6,300          806




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                    Page 13 of 17
d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls   Page 14 of 17
                                                                                                                   Moon Productions LLP
                                                                   Model Assumptions ( 3 ) - VAT, Interest, Depreciation + Working Capital

  VAT %                             17.5%                                                                             Vat Share
                                                                                                               Days          %
                                   Deposit   Overdraft                               Debtor Days                60         75%

  Interest rate                      3.0%        12.0%                               Direct costs               30        100%
                                               Leasing                               Overheads                 120
                         Used?                      yes                              Capex - Fixed Assets        5        100%
                     Percentage                    16%
                         Months                     36
                        Deposit                    25%

  Depreciation                                                                       Employers Payroll costs          Proportion
  Leasehold improvements            17.5%                                            Salaries Net                -         60%
  Fixtures                          33.3%                                            PAYE, NI etc               30         40%


                           Note: ONLY shaded cells with BLUE text to be altered




d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                           Page 15 of 17
                                                                                                                                                                                                                           Moon Productions LLP
                                                                                                                                                                                                                 Capital Expenditure Assumptions
                                        Oct-08       Nov-08       Dec-08    Jan-09   Feb-09   Mar-09   Apr-09       May-09       Jun-09       Jul-09       Aug-09       Sep-09       Oct-09       Nov-09       Dec-09       Jan-10   Feb-10      Mar-10       Apr-10
Capital Expenditure                       £           £            £         £        £        £        £       £            £            £            £            £            £            £            £            £

Leasehold improvements
          Building Costs                      -            -            -        -        -        -        -            -            -           -             -            -           -             -            -            -        -           -           -




Total                                         -           -            -         -        -        -        -           -            -            -            -            -            -            -            -            -        -           -            -

Fixtures, fittings & equipment
              Computers                       -            -            -        -        -        -        -            -            -           -             -            -           -             -            -            -        -           -           -
        Office equipment                      -            -            -        -        -        -        -            -            -           -             -            -           -             -            -            -        -           -           -
                  Leased                      -            -            -        -        -        -        -            -            -           -             -            -           -             -            -            -        -           -           -


Total                                         -           -            -         -        -        -        -           -            -            -            -            -            -            -            -            -        -           -            -


Note:
                           ONLY shaded cells with BLUE text to be altered




 d3ca46ee-54dd-4e6b-8eb5-06d17df98877.xls                                                                                                                                                                                                     Page 16 of 17