Get documents about "Projections
Document Sample
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
