12 Month Cashflow Forecast.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
12-MONTH CASH FLOW FORECAST
4
5
Miranda DebenhamKey:
6
Sheffield Local Theatre CICThese cells auto-calculate and are locked so you can't edit them.
7
11 Sep 2018Insert your own text/numbers into these cells as relevant.
8
9
10
Select your starting month:March-2019
11
MONTHS
12
Cash in-flowsDescription (as required)Starting point123456789101112TOTAL
13
Box Office Splits£0£0£1,890£1,575£1,575£1,575£1,575£1,575£1,890£1,890£1,890£1,890£1,890£19,215
14
Value of your Start Up Loan£15,000n/an/an/an/an/an/an/an/an/an/an/an/a£15,000
15
Bar Income£0£1,125£938£938£938£938£938£1,125£1,125£1,125£1,125£1,125£1,125£12,563
16
Desk hire£0£140£140£140£140£140£140£140£140£140£140£140£140£1,680
17
Rehearsal Space£0£0£0£0£0£0£320£320£320£320£320£320£320£2,240
18
Commercial/Events hires£0£0£0£0£600£600£600£600£600£600£600£600£600£5,400
19
Total cash in-flows (A)£15,000£1,265£2,968£2,653£3,253£3,253£3,573£3,760£4,075£4,075£4,075£4,075£4,075£56,098
20
21
MONTHS
22
Cash out-flowsDescription (as required)Starting point123456789101112TOTAL
23
Existing assets for business purposes£0£0£0£0£0£0£0£0£0£0£0£0£0£0
24
Rent or premises costs£3,000£1,000£1,000£1,000£1,000£1,000£1,000£1,000£1,000£1,000£1,000£1,000£1,000£15,000
25
Business rates for your business premisesSmall business rates relief£0£0£0£0£0£0£0£0£0£0£0£0£0£0
26
Utilities (gas, electricity, water)£0£325£325£325£325£325£325£325£325£325£325£325£325£3,900
27
Insurance£420£0£0£0£0£0£0£0£0£0£0£0£0£420
28
Telephone and internet£0£32£32£32£32£32£32£32£32£32£32£32£32£384
29
Marketing and advertising expenses£0£500£500£500£500£500£500£500£500£500£500£500£500£6,000
30
Installation of theatre£3,000£0£0£0£0£0£0£0£0£0£0£0£0£3,000
31
Professional fees (legal, accounting etc.)Planning permission and advice£635£0£0£0£0£0£0£0£0£0£0£0£0£635
32
Bar StockSourced from onlinecashandcarry.co.uk£0£338£282£282£282£282£282£338£338£338£338£338£338
33
Staff costs£0£1,419£1,419£1,419£1,419£1,419£1,419£1,419£1,419£1,419£1,419£1,419£1,419£17,028
34
Start Up Loan monthly repayment*n/a£288£288£288£288£288£288£288£288£288£288£288£288£3,456
35
Total cash out-flows (B)£7,055£3,902£3,846£3,846£3,846£3,846£3,846£3,902£3,902£3,902£3,902£3,902£3,902£53,597
36
37
Your net cash flow (A-B)£7,945-£2,637-£878-£1,193-£593-£593-£273-£142£173£173£173£173£173£2,500
38
39
Your monthly opening business bank account balance£0£7,945£5,308£4,430£3,237£2,644£2,050£1,777£1,635£1,808£1,981£2,154£2,327£2,500
40
41
Your closing cash position£7,945£5,308£4,430£3,237£2,644£2,050£1,777£1,635£1,808£1,981£2,154£2,327£2,500£2,500
42
43
44
YOUR NOTES OR COMMENTARY
45
Use this space to explain any of the information you have provided in the fields above.
46
This forecast assumes that audience figures hit our target of 60% capacity in the first month, but then drop to 50% until month 7. Bar figures are adjusted accordingly
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu