12 Month Cashflow Forecast.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3	12-MONTH CASH FLOW FORECAST
4
5	Miranda Debenham													Key:
6	Sheffield Local Theatre CIC														These cells auto-calculate and are locked so you can't edit them.
7	11 Sep 2018														Insert your own text/numbers into these cells as relevant.
8
9
10	Select your starting month:	March-2019
11				MONTHS
12	Cash in-flows	Description (as required)	Starting point	1	2	3	4	5	6	7	8	9	10	11	12	TOTAL
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,000	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/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-flows	Description (as required)	Starting point	1	2	3	4	5	6	7	8	9	10	11	12	TOTAL
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 premises	Small 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 Stock	Sourced 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