SAAS Financial Model - Sales Team and Cust Acquisition.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11	Column12	Column13	Column14	Column15	Column16	Column17	Column18	Column19	Column20	Column21	Column22	Column23	Column24	Column25	Column26	Column27	Column28	Column29	Column30	Column31	Column32	Column33	Column34	Column35	Column36	Column37	Column38	Column39	Column40	Column41	Column42	Column43	Column44	Column45	Column46	Column47	Column48	Column49	Column50
2	SAAS BSB FINANCIAL MODEL	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12	M13	M14	M15	M16	M17	M18	M19	M20	M21	M22	M23	M24	M25	M26	M27	M28	M29	M30	M31	M32	M33	M34	M35	M36	M37	M38	M39	M40	M41	M42	M43	M44	M45	M46	M47	M48
3
4	Active Customers
5
6	New Clients																									2	2	2	5	5	5	9	9	9	9	9	9	21	21	21	21	21	21	45	45	45	45	45	45
7	Existing Clients																										2	4	6	11	15	19	27	34	41	48	55	62	81	97	113	129	145	161	201	235	269	303	337
8	Churned																													-1	-1	-1	-2	-2	-2	-2	-2	-2	-5	-5	-5	-5	-5	-5	-11	-11	-11	-11	-11
9	Total Clients																									2	4	6	11	15	19	27	34	41	48	55	62	81	97	113	129	145	161	201	235	269	303	337	371
10	Bookings
11
12	New bookings																									420000	420000	420000	420000	420000	420000	900000	900000	900000	900000	900000	900000	1800000	1800000	1800000	1800000	1800000	1800000	3000000	3000000	3000000	3000000	3000000	3000000
13
14	Recurring bookings
15	Renewals																									40000	40000	40000	80000	80000	80000	140000	140000	140000	140000	140000	140000	420000	420000	420000	420000	420000	420000	900000	900000	900000	900000	900000	900000
16	Expansion Revenue																									12000	12000	12000	24000	24000	24000	42000	42000	42000	42000	42000	42000	126000	126000	126000	126000	126000	126000	270000	270000	270000	270000	270000	270000
17	Total Recurring																									52000	52000	52000	104000	104000	104000	182000	182000	182000	182000	182000	182000	546000	546000	546000	546000	546000	546000	1170000	1170000	1170000	1170000	1170000	1170000
18
19	Total bookings																									472000	472000	472000	524000	524000	524000	1082000	1082000	1082000	1082000	1082000	1082000	2346000	2346000	2346000	2346000	2346000	2346000	4170000	4170000	4170000	4170000	4170000	4170000
20
21	Revenue
22	Average Contract Length																									12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12
23	Revenue(Monthly Recurring Rev, MRR)																									39333	78666.7	118000.0	161666.7	205333.3	249000.0	339166.7	429333.3	519500.0	609666.7	699833.3	790000.0	985500.0	1181000.0	1376500.0	1572000.0	1767500.0	1963000.0	2310500.0	2658000.0	3005500.0	3353000.0	3700500.0	4048000.0
24
25	Annual; Rec Rev , ARR																									472000	944000	1416000	1940000	2464000	2988000	4070000	5152000	6234000	7316000	8398000	9480000	11826000	14172000	16518000	18864000	21210000	23556000	27726000	31896000	36066000	40236000	44406000	48576000
26
27
28
29	Sales Funnel
30
31	New Clients
32
33	Advertising Spend													R25,000.00	R25,000.00	R25,000.00	R75,000.00	R75,000.00	R75,000.00	R150,000.00	R150,000.00	R150,000.00	R150,000.00	R150,000.00	R150,000.00	R350,000.00	R350,000.00	R350,000.00	R350,000.00	R350,000.00	R350,000.00	R750,000.00	R750,000.00	R750,000.00	R750,000.00	R750,000.00	R750,000.00	R1,500,000.00	R1,500,000.00	R1,500,000.00	R1,500,000.00	R1,500,000.00	R1,500,000.00	R2,500,000.00	R2,500,000.00	R2,500,000.00	R2,500,000.00	R2,500,000.00	R2,500,000.00
34
35	Costs/Leads													R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00	R500.00
36
37	Leads													50	50	50	150	150	150	300	300	300	300	300	300	700	700	700	700	700	700	1500	1500	1500	1500	1500	1500	3000	3000	3000	3000	3000	3000	5000	5000	5000	5000	5000	5000
38
39	Leads/Sales Agent/Month													25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25
40
41	Sales Team													2	2	2	6	6	6	12	12	12	12	12	12	28	28	28	28	28	28	60	60	60	60	60	60	120	120	120	120	120	120	200	200	200	200	200	200
42
43	Conversion Rate,Lead to Sale													3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%
44
45	New Sales( Contracts)													2	2	2	5	5	5	9	9	9	9	9	9	21	21	21	21	21	21	45	45	45	45	45	45	90	90	90	90	90	90	150	150	150	150	150	150
46	Duration of Contract (months)													12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12	12
47	Annual Cost													20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000
48
49	New bookings													40000	40000	40000	100000	100000	100000	180000	180000	180000	180000	180000	180000	420000	420000	420000	420000	420000	420000	900000	900000	900000	900000	900000	900000	1800000	1800000	1800000	1800000	1800000	1800000	3000000	3000000	3000000	3000000	3000000	3000000
50	Churn & Expansion Revenue
51	Recurring Contracts																								2	2	2	2	4	4	4	7	7	7	7	7	7	21	21	21	21	21	21	45	45	45	45	45	45
52	Churned																												-1	-1	-1	-2	-2	-2	-2	-2	-2	-5	-5	-5	-5	-5	-5	-11	-11	-11	-11	-11	-11
53	Annual Churn Rate																									20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%	20%
54	Renewal Recurring																									40000	40000	40000	80000	80000	80000	140000	140000	140000	140000	140000	140000	420000	420000	420000	420000	420000	420000	900000	900000	900000	900000	900000	900000
55
56	Expansion Revenue																									12000	12000	12000	24000	24000	24000	42000	42000	42000	42000	42000	42000	126000	126000	126000	126000	126000	126000	270000	270000	270000	270000	270000	270000
57	% Expansion Added																									30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%
58
59	Total Recurring Bookings																									52000	52000	52000	104000	104000	104000	182000	182000	182000	182000	182000	182000	546000	546000	546000	546000	546000	546000	1170000	1170000	1170000	1170000	1170000	1170000
60
61	Sales Commissions
62	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11	Column12	Column13	Column14	Column15	Column16	Column17	Column18	Column19	Column20	Column21	Column22	Column23	Column24	Column25	Column26	Column27	Column28	Column29	Column30	Column31	Column32	Column33	Column34	Column35	Column36	Column37	Column38	Column39	Column40	Column41	Column42	Column43	Column44	Column45	Column46	Column47	Column48	Column49	Column50
63
64	Commission
65	New bookings																									42000	42000	42000	42000	42000	42000	90000	90000	90000	90000	90000	90000	180000	180000	180000	180000	180000	180000	300000	300000	300000	300000	300000	300000
66	Renewals																									1000	1000	1000	2000	2000	2000	3500	3500	3500	3500	3500	3500	10500	10500	10500	10500	10500	10500	22500	22500	22500	22500	22500	22500
67	Expansion(cross sells,upsells)																									2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%
68	Total																									R43,000	R43,000	R43,000	R44,000	R44,000	R44,000	R93,500	R93,500	R93,500	R93,500	R93,500	R93,500	R190,500	R190,500	R190,500	R190,500	R190,500	R190,500	R322,500	R322,500	R322,500	R322,500	R322,500	R322,500
69
70	Commission- %
71	New bookings													10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%
72	Renewals													2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%	2.50%
73	Expansion(cross sells , upsells)													8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%
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