Bask Health Projection Template

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Price Per Month	$110		Input your E-Prescribing Business in the Blue				Dispense Fee	$10
2	Marketing Budget Per Month	$10,000						Medication Cost	$45
3								Dr Cost	$25
4	Customer Metrics	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
5	Acquisition cost per customer	$500	$222	$200	$182	$167	$154	$143	$143	$143	$143	$143	$143	$143
6	# of New Customers	20	45	50	55	60	65	70	70	70	70	70	70	70
7	# of churned Customers	-4	-9	-10	-11	-12	-13	-14	-14	-14	-14	-14	-14	-14
8	Net New Customers	16	36	40	44	48	52	56	56	56	56	56	56	56
9	Total Customers	66	102	142	186	234	286	342	398	454	510	566	622	678
10
11	% Customer Churn		13.64%	9.80%	7.75%	6.45%	5.56%	4.90%	4.09%	3.52%	3.08%	2.75%	2.47%	2.25%
12	% MRR Churn		13.64%	9.80%	7.75%	6.45%	5.56%	4.90%	4.09%	3.52%	3.08%	2.75%	2.47%	2.25%
13	% MRR Expansion		0	0	0	0	0	0	0	0	0	0	0	0
14	% Net MRR Churn
15
16	New MRR	$1,760	$3,960	$4,400	$4,840	$5,280	$5,720	$6,160	$6,160	$6,160	$6,160	$6,160	$6,160	$6,160
17	Ending MRR	$7,260	$11,220	$15,620	$20,460	$25,740	$31,460	$37,620	$43,780	$49,940	$56,100	$62,260	$68,420	$74,580
18	Annualized Run Rate	$87,120	$134,640	$187,440	$245,520	$308,880	$377,520	$451,440	$525,360	$599,280	$673,200	$747,120	$821,040	$894,960
19	ARPA (Average MRR Per Customer)	$110	$110	$110	$110	$110	$110	$110	$110	$110	$110	$110	$110	$110
20
21	Unit Economics (new customers)	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
22	LTV		$419	$582	$737	$885	$1,028	$1,166	$1,394	$1,623	$1,851	$2,079	$2,308	$2,536
23	CAC		222	200	182	167	154	143	143	143	143	143	143	143
24	LTV to CAC Ratio		1.88	2.91	4.05	5.31	6.68	8.16	9.76	11.36	12.96	14.56	16.15	17.75
25	Months to Recover CAC		3.9	3.5	3.2	2.9	2.7	2.5	2.5	2.5	2.5	2.5	2.5	2.5
26
27	Summary Financial Metrics	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
28	Revenue	$7,260	$ 11,220	$ 15,620	$ 20,460	$ 25,740	$ 31,460	$ 37,620	$ 43,780	$ 49,940	$ 56,100	$ 62,260	$ 68,420	$ 74,580
29	Cost of Goods Sold _COGS		$ 5,823	$ 8,106	$ 10,618	$ 13,358	$ 16,326	$ 19,523	$ 22,719	$ 25,916	$ 29,113	$ 32,309	$ 35,506	$ 38,703
30	Gross Margin		$ 5,398	$ 7,514	$ 9,843	$ 12,383	$ 15,134	$ 18,098	$ 21,061	$ 24,024	$ 26,988	$ 29,951	$ 32,914	$ 35,878
31	Average Month COGS		$57.08	$57.08	$57.08	$57.08	$57.08	$57.08	$57.08	$57.08	$57.08	$57.08	$57.08	$57.08
32	Gross Margin %		52%	52%	52%	52%	52%	52%	52%	52%	52%	52%	52%	52%
33
34	Total Expenses		$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000	$ 12,000
35	Sales & Marketing		$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000	$ 10,000
36	Development		$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000
37	General & Administrative		$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000
38
39	EBITDA		$ (6,603)	$ (4,486)	$ (2,158)	$ 383	$ 3,134	$ 6,098	$ 9,061	$ 12,024	$ 14,988	$ 17,951	$ 20,914	$ 23,878
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