Hackspace Scenarios

	A	B	C	D	E	F	G	H	I
1	This scenario is for a traditional light industrial hackspace costing£500/month for 500sqft
2	Costs		tweak the bold figures, some bold cells contain a multiplier of the base rent, tweak the multiplier
3			Monthly		Annual			Size of hackspace (sqft)	500
4	Item		ex VAT	inc VAT	ex VAT	inc VAT		Notes
5	Rent		500.00	600.00	6,000.00	7,200.00		square foot cost per year (standard comparative)	£ 12.00
6	Rates		250.00	300.00	3,000.00	3,600.00
7	Insurance		27.50	33.00	330.00	396.00		Building, maybe we need to add liability also
8	Water & Waste		10.83	13.00	130.00	156.00
9	Service Charge		57.67	69.20	692.00	830.40
10	Broadband		30.00	36.00	360.00	432.00
11	Electricity		133.33	160.00	1,600.00	1,920.00		(feels high to me)
12	Telephone		10.00	12.00	120.00	144.00		(line rental for broadband, no call charges)
13	Dilapidations		41.67	50.00	500.00	600.00		(building maintenance 1month/year)
14	Marketing		0.00	0.00	0.00	0.00
15	Contingency		0.00	0.00	0.00	0.00
16	Consumables		0.00	0.00	0.00	0.00
17	Equipment		0.00	0.00	0.00	0.00
18	Deposit				500.00	600.00		One month in advance (tweak the multiplier)
19	Rennovations (paint/flooring/extra power/network provision)		74.06	88.88	888.75	1,066.50		(mostly a year 1 cost taking the building from a shell to a hackspace, see materials sheet)
20	Legal/survey fees				300.00	360.00		just a year 1 cost, but it is in the first year
21	Accountancy		41.67	50.00	500.00	600.00		re-occuring
22
23	Total		Monthly operating cost	1,412.08	14,920.75	17,904.90		blue figure is the bottom line if not VAT registered
24			Monthly average including year 1 captial costs	1,492.08
25
26	Funding
27					Amount raised	After VAT paid on taxable supplies
28	Donations				0.00	0.00		Personal one off donations	see VAT rules on sponsorship and donations
29	Sponsorships				0.00	0.00		Corporate Sponsorship monies (VAT to be paid if they get a logo somewhere or place/event named)	http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true&_pageLabel=pageVAT_ShowContent&id=HMCE_CL_000937&propertyType=document#P28_1913
30	Fundraising				3,200.00	3,200.00		Fundraising events/raffles etc	http://www.hmrc.gov.uk/charities/vat/income.htm#2
31					3,200.00	3,200.00		*Presumes tax deductable and no VAT
32	Projections
33
34
35		What would actually come out from people's wallets inc vat		Blue figures below are the total revenue for 4 different scenarios, everyone starting at the same time and linear growth, then the same but with some sponsoring members. Blue figures are what it would be if not VAT registered and all the money that comes from fees is collected as revenue
36
37				Annual		Annual Surplus/Deficit
38	Revenue	ex. VAT	inc. VAT	ex. VAT	inc. VAT	ex VAT	inc VAT	Notes
39
40	Monthly Membership fee	25.00	30.00
41	Joining Fee	0.00	0.00
42	Total number of members at the start of year 1	25						I think this is a minimum starting requirement
43	Total number of members at the end of year 1	49						Modest 2 new members a month averaged over first year
44
45	Assuming linear growth	925.00	1,110.00	11,100.00	13,320.00	-620.75	-1,384.90
46
47	lets see what happens if we add some sponsoring members who pay more
48	Number of Sponsoring Members at the start of year 1	2
49	Number of Sponsoring Members at the end of year 1	0
50	Amount each sponsoring member would pay	125.00	150.00
51	Amount above the regular fee they would pay (they have already been counted in the total membership numbers)	100.00	120.00
52
53
54	Annual total assuming linear growth of members and sponsoring members	1,025.00	1,230.00	12,300.00	14,760.00	579.25	55.10
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