Financial Model - Team 2.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Illumi
2	Sales & Marketing Expenses
3
4	Marketing activities	Aug	Sept	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	2024	2025	2026

5	General sales & marketing expense
6	Activities support the company and existing customers but do not lead to new customers
7	Email Newsletter	$ 1.87	$ 2.30	$ 2.94	$ 3.81	$ 5.10	$ 4.81	$ 4.52	$ 4.23	$ 4.23	$ 4.23	$ 4.23	$ 4.23	$ 46.52	$ 169.33	$ 477.37
8	Webinars & Online Workshops	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 3,000.00	$ 36,000.00	$ 43,200.00	$ 54,000.00
9														$ -
10														$ -
11														$ -
12
13	Total general sales & marketing	$ 3,001.87	$ 3,002.30	$ 3,002.94	$ 3,003.81	$ 3,005.10	$ 3,004.81	$ 3,004.52	$ 3,004.23	$ 3,004.23	$ 3,004.23	$ 3,004.23	$ 3,004.23	$ 36,046.52	$ 43,369.33	$ 54,477.37
14
15	Conversion activity #1 - Advertising
16	Brings new users from social media to Illumi and boost our sales
17	Advertising through digital channels (awareness)	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 12,400.00	$ 148,800.00	$ 193,440.00	$ 267,840.00
18	Prospects	179,000	179,000	179,000	179,000	290,000	290,000	290,000	290,000	290,000	290,000	290,000	290,000	3,036,000	3,946,800	5,464,800
19	Conversion rate	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	3.20%	4.16%	5.76%
20	Website (evaluate)	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 16.00	$ 192.00	$ 192.00	$ 192.00
21	Prospects	5,728	5,728	5,728	5,728	9,280	9,280	9,280	9,280	9,280	9,280	9,280	9,280	97,152	164,187	314,772
22	Conversion rate	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	5%	7%
23	Bought Illumi (sales part 1)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
24	New customers that bought Illumi	143	172	172	172	278	278	278	278	278	278	278	278	2,886	8,209	22,034
25	Total customers that bought the Illumi through Activity #1	143	315	487	659	937	1,216	1,494	1,772	2,051	2,329	2,608	2,886	2,886	11,095	33,129
26	Bought Mirror Subscription (sales part 2)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 13,791.70	$ 37,017.24
27	Prospects	143	172	172	172	278	278	278	278	278	278	278	278	2,886	8,209	22,034
28	Conversion rate	1%	1%	2%	3%	3%	3%	4%	4%	4%	4%	4%	4%	3%	6%	8%
29	New customers that bought the subscription	1	2	3	5	8	8	11	11	11	11	11	11	95	493	1,763
30	Total customers that subscribed through advertisement	1	3	7	12	20	28	40	51	62	73	84	95	95	588	2,351
31
32	Conversion activity #2 - Partnerships
33	-> Collaborate with licensed Dermatologists to promote Illumi to their patients
34	Dermatologist office (awareness)	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 120,000.00	$ 156,000.00	$ 216,000.00
35	Prospects	5,800	5,800	5,800	5,800	5,800	5,800	5,800	5,800	5,800	5,800	5,800	5,800	69,600	90,480	125,280
36	Conversion rate	15%	20%	30%	40%	40%	35%	30%	25%	25%	25%	25%	25%	28%	30%	35%
37	Website (evaluate)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
38	Prospects	870	1,160	1,740	2,320	2,320	2,030	1,740	1,450	1,450	1,450	1,450	1,450	19,430	27,144	43,848
39	Conversion rate	5%	5%	7%	9%	10%	10%	10%	10%	10%	10%	10%	10%	9%	15%	20%
40	Bought Illumi (sales part 1)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
41	New customers that bought the illumi	44	58	122	209	232	203	174	145	145	145	145	145	1,766	4,072	8,770
42	Total customers that bought the collar through Activity #2	44	102	223	432	664	867	1,041	1,186	1,331	1,476	1,621	1,766	1,766	5,838	14,607
43	Bought Mirror Subscription (sales part 2)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
44	Prospects	44	58	122	209	232	203	174	145	145	145	145	145	1,766	4,072	8,770
45	Conversion rate	2%	2%	3%	4%	5%	5%	5%	8%	10%	10%	10%	10%	6%	20%	25%
46	New customers that bought the subscription	1	1	4	8	12	10	9	12	15	15	15	15	114	814	2,192
47	Total customers that subscribed through partnerships	1	2	6	14	26	36	44	56	71	85	100	114	114	928	3,121
48
49	New customers that bought the mirror	187	230	294	381	510	481	452	423	423	423	423	423	4,652	12,281	30,804
50	Total customers that are subscribed	2	5	12	26	46	64	84	107	132	158	184	209	209	1,516	5,471
51
52
53	Total Conversion sales & Marketing Expense	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 22,416.00	$ 268,992.00	$ 363,423.70	$ 521,049.24
54
55	Total Sales & Marketing Expenses	$ 25,417.87	$ 25,418.30	$ 25,418.94	$ 25,419.81	$ 25,421.10	$ 25,420.81	$ 25,420.52	$ 25,420.23	$ 25,420.23	$ 25,420.23	$ 25,420.23	$ 25,420.23	$ 305,038.52	$ 406,793.03	$ 575,526.61
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