Excel for Startups - Stats and Bots

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Your Startup
2
3
4	Salaries:
5	Title	Annual Salary	Fringe benefits	Salary + Fringe	Date Hired	Jan-18	Feb-18	Mar-18	Q1 2018	Apr-18	May-18	Jun-18	Q2 2018	Jul-18	Aug-18	Sep-18	Q3 2018	Oct-18	Nov-18	Dec-18	Q4 2018	FY 2018
6	CEO	$ 80,000.00	9%	$ 87,200.00	January 1, 2018	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 87,200.00
7	CTO	$ 80,000.00	9%	$ 87,200.00	January 1, 2018	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 87,200.00
8	Engineer 1	$ 80,000.00	9%	$ 87,200.00	April 1, 2018	$ -	$ -	$ -	$ -	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 65,400.00
9	Engineer 2	$ 80,000.00	9%	$ 87,200.00	April 1, 2018	$ -	$ -	$ -	$ -	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 65,400.00
10	Designer	$ 80,000.00	9%	$ 87,200.00	May 1, 2018	$ -	$ -	$ -	$ -	$ -	$ 7,266.67	$ 7,266.67	$ 14,533.33	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 7,266.67	$ 7,266.67	$ 7,266.67	$ 21,800.00	$ 58,133.33
11	Add more	$ -	9%	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
12	Add more	$ -	9%	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
13	Add more	$ -	9%	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
14	Add more	$ -	9%	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
15	Add more	$ -	9%	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
16	Total:	$ 400,000.00				$ 14,533.33	$ 14,533.33	$ 14,533.33	$ 43,600.00	$ 29,066.67	$ 36,333.33	$ 36,333.33	$ 101,733.33	$ 36,333.33	$ 36,333.33	$ 36,333.33	$ 109,000.00	$ 36,333.33	$ 36,333.33	$ 36,333.33	$ 109,000.00	$ 363,333.33
17	Number of people in team					2	2	2	2	4	5	5	5	5	5	5	5	5	5	5	5	5
18
19
20	Office:
21	Title	Annual			Start Date	Jan-18	Feb-18	Mar-18	Q1 2018	Apr-18	May-18	Jun-18	Q2 2018	Jul-18	Aug-18	Sep-18	Q3 2018	Oct-18	Nov-18	Dec-18	Q4 2018	FY 2018
22	Rent	$ 18,000.00			January 1, 2018	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 18,000.00
23	Other OpEx related to office	$ 3,600.00			January 1, 2018	$ 300.00	$ 300.00	$ 300.00	$ 900.00	$ 300.00	$ 300.00	$ 300.00	$ 900.00	$ 300.00	$ 300.00	$ 300.00	$ 900.00	$ 300.00	$ 300.00	$ 300.00	$ 900.00	$ 3,600.00
24	Add more	$ -			January 1, 2018	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
25	Add more	$ -			January 1, 2018	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
26	Total:	$ 21,600.00				$ 1,800.00	$ 1,800.00	$ 1,800.00	$ 5,400.00	$ 1,800.00	$ 1,800.00	$ 1,800.00	$ 5,400.00	$ 1,800.00	$ 1,800.00	$ 1,800.00	$ 5,400.00	$ 1,800.00	$ 1,800.00	$ 1,800.00	$ 5,400.00	$ 21,600.00
27
28
29	AWS and other services:
30	Title	Annual			Start Date	Jan-18	Feb-18	Mar-18	Q1 2018	Apr-18	May-18	Jun-18	Q2 2018	Jul-18	Aug-18	Sep-18	Q3 2018	Oct-18	Nov-18	Dec-18	Q4 2018	FY 2018
31	AWS	$ 4,200.00			January 1, 2018	$ 350.00	$ 350.00	$ 350.00	$ 1,050.00	$ 350.00	$ 350.00	$ 350.00	$ 1,050.00	$ 350.00	$ 350.00	$ 350.00	$ 1,050.00	$ 350.00	$ 350.00	$ 350.00	$ 1,050.00	$ 4,200.00
32	Other	$ 1,800.00			January 1, 2018	$ 150.00	$ 150.00	$ 150.00	$ 450.00	$ 150.00	$ 150.00	$ 150.00	$ 450.00	$ 150.00	$ 150.00	$ 150.00	$ 450.00	$ 150.00	$ 150.00	$ 150.00	$ 450.00	$ 1,800.00
33	Legal services	$ 2,000.00			January 1, 2018	$ 166.67	$ 166.67	$ 166.67	$ 500.00	$ 166.67	$ 166.67	$ 166.67	$ 500.00	$ 166.67	$ 166.67	$ 166.67	$ 500.00	$ 166.67	$ 166.67	$ 166.67	$ 500.00	$ 2,000.00
34	Add more	$ -			January 1, 2018	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
35	Total:	$ 8,000.00				$ 500.00	$ 500.00	$ 500.00	$ 1,500.00	$ 500.00	$ 500.00	$ 500.00	$ 1,500.00	$ 500.00	$ 500.00	$ 500.00	$ 1,500.00	$ 500.00	$ 500.00	$ 500.00	$ 1,500.00	$ 6,000.00
36
37
38
39	Marketing:
40	Title	Annual			Start Date	Jan-18	Feb-18	Mar-18	Q1 2018	Apr-18	May-18	Jun-18	Q2 2018	Jul-18	Aug-18	Sep-18	Q3 2018	Oct-18	Nov-18	Dec-18	Q4 2018	FY 2018
41	Acquisition campaigns	$ 18,000.00			April 1, 2018	$ -	$ -	$ -	$ -	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 13,500.00
42	Add more	$ -				$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
43	Total:	$ 18,000.00				$ -	$ -	$ -	$ -	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 1,500.00	$ 1,500.00	$ 1,500.00	$ 4,500.00	$ 13,500.00
44
45	Total costs:
46	Title	Annual			Start Date	Jan-18	Feb-18	Mar-18	Q1 2018	Apr-18	May-18	Jun-18	Q2 2018	Jul-18	Aug-18	Sep-18	Q3 2018	Oct-18	Nov-18	Dec-18	Q4 2018	FY 2018
47	Total costs	$ 447,600.00				$ 16,833.33	$ 16,833.33	$ 16,833.33	$ 50,500.00	$ 32,866.67	$ 40,133.33	$ 40,133.33	$ 113,133.33	$ 40,133.33	$ 40,133.33	$ 40,133.33	$ 120,400.00	$ 40,133.33	$ 40,133.33	$ 40,133.33	$ 120,400.00	$ 404,433.33
48
49
50	No monetization
51	Average Monthly Burn	-$ 33,702.78
52	Cash Available (Capital)	$ 300,000.00
53	How many months you have until cash will be burned totally	9
54
55	SaaS
56	Average Monthly Burn	-$ 33,702.78
57	Cash Available (Capital)	$ 300,000.00
58	Total Revenue from SaaS model	$ 169,848.30
59	Capital + Revenue	$ 469,848.30
60	How many months you have until cash will be burned totally in Saas Model	14
61
62	E-commerce
63	Average Monthly Burn	-$ 33,702.78
64	Cash Available (Capital)	$ 300,000.00
65	Total Revenue from E-commerce model	$ 126,532.49
66	Capital + Revenue	$ 426,532.49
67	How many months you have until cash will be burned totally in Saas Model	13
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