Event Budgeting Spreadsheet - Countertalk Spaces

	B	D	E	G	I	J	K	M	N	O	P	Q	R
1	COUNTERTALK SPACES BUDGET CALCULATOR
2	COUNTERTALK SPACES BUDGET CALCULATOR
3	To use this sheet please - MAKE A COPY - (File --> Make a copy) Once you've made a copy of the sheet, you're ready to go. Below is the ONLY section you'll be editing. Input all your event pricing and costs, and your expenses and revenue will be automatically calculated in the boxes to the right.
4
5
6
7
8
9
10
11
12
13
14
15	Fill in column E only			Results - Expenses				Results - Revenue
16					Expenses incl. VAT
17											% of total tickets sold
18								Description	Qty	Price	75%	80%	100%
19	Event information	Change here only		Tickets sold	65%	80%	100%
20	Total tickets		40	Variable cost				Total tickets	40	40	1,200.00	1,280.00	1,600.00
21	Drink tickets sold		0	Food cost	£260.00	£320.00	£400.00	Free Tickets	0
22	Food ticket price		£40.00	Drink cost	£0.00	£0.00	£0.00	Drink ticket sales	0	0	-	-	-
23	Drink ticket price		0	Fixed Cost				Sold Tickets incl. VAT			30	32	40
24	VAT %		20%	Travel	£0.00	£0.00	£0.00
25	Currency		GBP	Staffing fee	£0.00	£0.00	£0.00
26	Expenses			Venue	£0.00	£0.00	£0.00
27	% Food cost		25%	Misc equipment	£0.00	£0.00	£0.00
28	% Drink cost		25%					Paid guests	40
29	Travel		0	Total incl. VAT	£260.00	£320.00	£400.00	Total incl. VAT			1,200.00	1,280.00	1,600.00
30	Staffing fee		0	VAT	£43.33	£53.33	£66.67	VAT			200.00	213.33	266.67
31	Venue fee		0	Total excl. VAT	£216.67	£266.67	£333.33	Total excl. VAT			1,000.00	1,066.67	1,333.33
32	Misc equipment		0					Profit excl. VAT			783.33	800.00	1,000.00
33	Free tickets		0
34
35
36
37
38
39
40
41
42
43
44
45
46
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