Break Even Point Calculator - GameDev

	A	B	C	E	G	H	I	J	K	L	M	N	O
1	Calc:			Costs:	Monthly	Yearly		Wishlist Estimates
2	Price Point:		$ 20.00	Living Expenses	$ 2,000.00	$ 24,000.00
3	Discounts	20.00%	$ 16.00	Dev Costs	$ 14,762.50	$ 177,150.00		Avg. Discount:	0.00%	20.00%	30.00%	50.00%	80.00%
4		30.00%	$ 14.00	Sum	$ 16,762.50	$ 201,150.00
5		50.00%	$ 10.00	VATS	20.00%			Conversion Rate
6		80.00%	$ 4.00	Steam-Share	30.00%			1.00%	2,052,551	2,565,689	2,932,216	4,105,102	10,262,755
7				Tax	30.00%			2.50%	821,020	1,026,276	1,172,886	1,642,041	4,105,102
8					Monthly	Yearly		5.00%	410,510	513,138	586,443	821,020	2,052,551
9		Yearly	Monthly	Gross Revenue (Pre VATS)	$ 42,761.48	$ 513,137.76		10.00%	205,255	256,569	293,222	410,510	1,026,276
10	Dev Costs:	$ 177,150.00	$ 14,762.50	Gross Revenue (Pre Steam Cut)	$ 34,209.18	$ 410,510.20		20.00%	102,628	128,284	146,611	205,255	513,138
11	Designer	$ 1,000.00	$ 83.33	Gross Revenue (Post Steam Cut)	$ 23,946.43	$ 287,357.14
12	Ads	$ 3,650.00	$ 304.17	Net Revenue (Pre Tax)	$ 23,946.43	$ 287,357.14
13	Assets	$ 5,000.00	$ 416.67	Net Revenue (Post Tax)	$ 16,762.50	$ 201,150.00		Legend:
14	VoiceArtist	$ 10,000.00	$ 833.33					Only change the values in the fields with red borders. The rest is auto-calculated.
15	Office Help	$ 5,000.00	$ 416.67	Items sold at Discount				- Grey/Light blue are just highlighted, because I think they are 'more likely' and to make it easy to see. Nothing else.
16	Programmer x3	$ 150,000.00	$ 12,500.00	0.00%	1,710	20,526		- The basis is a yearly calculation cycle. So if you need 2 years to develop the game, you have to double the numbers, etc. This is cost per year, and sales per year
17	Whatever	$ 2,000.00	$ 166.67	20.00%	2,138	25,657		- Average Wishlist conversion seems to be around 6-20%. I picked 2,5% to highlight, because I'm very conservative and fearful and want a huge error margin.
18			$ -	30.00%	2,444	29,322
19	Stuff	$ 500.00	$ 41.67	50.00%	3,421	41,051
20			$ -	80.00%	8,552	102,628
21	*Always pick yearly costs, monthly is auto-calculated.
22				*For a million around 170.000 Sold Items (at 50%)
23
24
25	Make a copy in your own drive. This file can't be changed!						Disclaimer:
26							Please look into your regional rules for taxes and how to deduct costs! The rules can be quite different.
27							This is no legal or tax advice. It's just a little tool to help get a feel. You still need to talk to an expert about your specific situation!
28							Yeah, I know technically it's not a break even point. But who cares?
29
30	Explain video:	https://youtu.be/fzm2ZCYSQtE
31
32
33
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