Business Plan - MrPropTek - Dec 04 '24.xlsx

	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	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM
1
2		Starting Month	Dec-24
3		US Dollar Rate	₹ 83.38
4
5	1	Prop Tech (Aggregator) Model
6	A.	Particulars	Avg. Ticket Size	Avg. Commission	Net Revenue	Gross Profit	Gross Margin %																																												4,909
7
8	A	UAE	50,000,000	7.0%	3,500,000	3,500,000	100%
9	B	India	30,000,000	4.0%	1,200,000	1,200,000	100%
10	C	Other International Market	45,000,000	4.0%	1,800,000	1,800,000	100%
11
12	2	GTM
13	A.	Online Performance Marketing
14	i.	Particulars	Amt. Spent	No. of Leads	Conv. %	No. of closures	CAC - Y1	CAC - Y2	CAC - Y3	CAC - Y4	CAC - Y5
15		Google Ads	100,000	200	1.0%	2	50,000	50,000	48,250	46,561	44,932
16		Meta Ads	100,000	150	1.0%	2	66,667	66,667	64,333	62,082	59,909
17						Average	58,333	58,333	56,292	54,321	52,420
18	ii.	Marketing Spends
19		Particulars	Launch Month	M0	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	M49	M50	M51	M52	M53	M54	M55	M56	M57	M58	M59	M60
20		Google Ads	M3							127,000	254,000	508,000	1,016,000	1,524,000	1,981,200	2,278,380	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	6,283,772	6,283,772	6,283,772	6,283,772	6,283,772	6,283,772	8,797,281	8,797,281	8,797,281	8,797,281	8,797,281	8,797,281	12,316,193	12,316,193	12,316,193	12,316,193	12,316,193	12,316,193	12,932,003	12,932,003	12,932,003	12,932,003	12,932,003	12,932,003	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205
21		Meta Ads	M3							127,000	254,000	508,000	1,016,000	1,524,000	1,981,200	2,278,380	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	4,488,409	6,283,772	6,283,772	6,283,772	6,283,772	6,283,772	6,283,772	8,797,281	8,797,281	8,797,281	8,797,281	8,797,281	8,797,281	12,316,193	12,316,193	12,316,193	12,316,193	12,316,193	12,316,193	12,932,003	12,932,003	12,932,003	12,932,003	12,932,003	12,932,003	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205	20,691,205
22		Total		-	-	-	-	-	-	254,000	508,000	1,016,000	2,032,000	3,048,000	3,962,400	4,556,760	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	8,976,817	12,567,544	12,567,544	12,567,544	12,567,544	12,567,544	12,567,544	17,594,562	17,594,562	17,594,562	17,594,562	17,594,562	17,594,562	24,632,386	24,632,386	24,632,386	24,632,386	24,632,386	24,632,386	25,864,006	25,864,006	25,864,006	25,864,006	25,864,006	25,864,006	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409	41,382,409
23
24	iii.	No. of closures - Performance Marketing
25		Particulars	Launch Month	M0	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	M49	M50	M51	M52	M53	M54	M55	M56	M57	M58	M59	M60
26		Google Ads	M3	-	-	-	-	-	-	3	5	10	20	30	40	46	90	90	90	90	90	90	90	90	90	90	90	90	130	130	130	130	130	130	182	182	182	182	182	182	265	265	265	265	265	265	278	278	278	278	278	278	461	461	461	461	461	461	461	461	461	461	461	461
27		Meta Ads	M3	-	-	-	-	-	-	2	4	8	15	23	30	34	67	67	67	67	67	67	67	67	67	67	67	67	98	98	98	98	98	98	137	137	137	137	137	137	198	198	198	198	198	198	208	208	208	208	208	208	345	345	345	345	345	345	345	345	345	345	345	345
28		Total inorganic closures - Performance Marketing		-	-	-	-	-	-	4	9	18	36	53	69	80	157	157	157	157	157	157	157	157	157	157	157	157	228	228	228	228	228	228	319	319	319	319	319	319	463	463	463	463	463	463	486	486	486	486	486	486	806	806	806	806	806	806	806	806	806	806	806	806
29		Add: Organic		-	-	-	-	-	-	-	-	-	-	-	-	-	3	3	3	3	3	3	3	3	3	3	3	3	9	9	9	9	9	9	12	12	12	12	12	12	26	26	26	26	26	26	28	28	28	28	28	28	60	60	60	60	60	60	60	60	60	60	60	60
30		Orgainc Rate %					0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	2%	4%	4%	4%	4%	4%	4%	4%	4%	4%	4%	4%	4%	6%	6%	6%	6%	6%	6%	6%	6%	6%	6%	6%	6%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%
31		Total no. of closures - Performance Marketing		-	-	-	-	-	-	4	9	18	36	53	69	80	160	160	160	160	160	160	160	160	160	160	160	160	237	237	237	237	237	237	331	331	331	331	331	331	489	489	489	489	489	489	514	514	514	514	514	514	866	866	866	866	866	866	866	866	866	866	866	866
32		Cummulative no. of closures
33
34	B.	Offline Sales Funnel
35	i.	Sales Funnel	Y1	Y2	Y3	Y4	Y5
36		No. of events/gatherings organised in the month	2	4	6	8	10
37		Avg. no. of attendees per event/gathering	40	50	60	80	100
38		Conv. %	10%	10%	12%	14%	15%
39		No. of closures per event/gathering	4	5	7	11	15
40
41	ii.	No. of closures	Launch Month	M0	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	M49	M50	M51	M52	M53	M54	M55	M56	M57	M58	M59	M60
42		No. of events/gathering	M3						2	2	2	2	2	2	2	2	4	4	4	4	4	4	4	4	4	4	4	4	6	6	6	6	6	6	6	6	6	6	6	6	8	8	8	8	8	8	8	8	8	8	8	8	10	10	10	10	10	10	10	10	10	10	10	10
43		No. of closures - Offline Funnel		-	-	-	-	-	8	8	8	8	8	8	8	8	20	20	20	20	20	20	20	20	20	20	20	20	42	42	42	42	42	42	42	42	42	42	42	42	88	88	88	88	88	88	88	88	88	88	88	88	150	150	150	150	150	150	150	150	150	150	150	150
44
45	C.	Total no. of closures	Launch Month	M0	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	M49	M50	M51	M52	M53	M54	M55	M56	M57	M58	M59	M60
46		Total no. of closures - Performance Marketing		-	-	-	-	-	-	4	9	18	36	53	69	80	160	160	160	160	160	160	160	160	160	160	160	160	237	237	237	237	237	237	331	331	331	331	331	331	489	489	489	489	489	489	514	514	514	514	514	514	866	866	866	866	866	866	866	866	866	866	866	866
47		No. of closures - Offline Funnel		-	-	-	-	-	8	8	8	8	8	8	8	8	20	20	20	20	20	20	20	20	20	20	20	20	42	42	42	42	42	42	42	42	42	42	42	42	88	88	88	88	88	88	88	88	88	88	88	88	150	150	150	150	150	150	150	150	150	150	150	150
48		Total no. of closures		-	-	-	-	-	8	12	17	26	44	61	77	88	180	180	180	180	180	180	180	180	180	180	180	180	279	279	279	279	279	279	373	373	373	373	373	373	577	577	577	577	577	577	602	602	602	602	602	602	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016
49		TAT	T+20 days
50		Total no. of closures (T+0)		-	-	-	-	-	3	4	6	9	15	20	26	29	60	60	60	60	60	60	60	60	60	60	60	60	93	93	93	93	93	93	124	124	124	124	124	124	192	192	192	192	192	192	201	201	201	201	201	201	339	339	339	339	339	339	339	339	339	339	339	339
51		Total no. of closures (T+1)		-	-	-	-	-	-	5	8	11	17	29	41	52	58	120	120	120	120	120	120	120	120	120	120	120	120	186	186	186	186	186	186	249	249	249	249	249	249	385	385	385	385	385	385	401	401	401	401	401	401	677	677	677	677	677	677	677	677	677	677	677
52		Total no. of closures (T+20 Days)		-	-	-	-	-	3	9	14	20	32	49	67	81	119	180	180	180	180	180	180	180	180	180	180	180	213	279	279	279	279	279	310	373	373	373	373	373	441	577	577	577	577	577	585	602	602	602	602	602	740	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016	1,016
53
54		Bifurcation Rate %							75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	75%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%
55		No. of closures for UAE Market		-	-	-	-	-	2	7	11	15	24	37	50	61	89	135	135	135	135	135	135	135	135	135	135	135	160	209	209	209	209	209	233	280	280	280	280	280	304	398	398	398	398	398	404	415	415	415	415	415	511	701	701	701	701	701	701	701	701	701	701	701
56		Add: Repeat Customers (T+18)																				-	-	-	-	-	0	0	1	1	1	2	3	3	4	7	7	7	7	7	7	7	7	7	7	7	8	10	11	11	11	11	12	14	14	14	14	14	16	20	20	20	20	20
57		Repeat Rate %																				5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%
58		Add: Repeat Customers (T+30)																																-	-	-	-	-	0	0	1	1	1	2	3	3	4	7	7	7	7	7	7	7	7	7	7	7	8	10	11	11	11	11
59		Repeat Rate %																																5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%
60		Total no. of closures for UAE Market		-	-	-	-	-	2	7	11	15	24	37	50	61	89	135	135	135	135	135	135	135	135	135	135	135	161	210	210	211	212	212	237	287	287	287	287	287	311	406	406	407	407	408	416	432	432	432	432	432	530	722	722	722	722	722	725	732	732	732	732	732
61
62		Bifurcation Rate %							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%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%	24%
63		No. of closures for India Market		-	-	-	-	-	1	2	4	5	8	12	17	20	30	45	45	45	45	45	45	45	45	45	45	45	53	70	70	70	70	70	78	93	93	93	93	93	106	138	138	138	138	138	140	144	144	144	144	144	178	244	244	244	244	244	244	244	244	244	244	244
64		Add: Repeat Customers (T+18)																				-	-	-	-	-	0	0	0	0	0	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2	3	4	4	4	4	4	4	5	5	5	5	5	5	7	7	7	7	7
65		Repeat Rate %																				5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%
66		Add: Repeat Customers (T+30)																																-	-	-	-	-	0	0	0	0	0	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2	3	4	4	4	4	4
67		Repeat Rate %																																5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%
68		Total no. of closures for India Market		-	-	-	-	-	1	2	4	5	8	12	17	20	30	45	45	45	45	45	45	45	45	45	45	45	53	70	70	71	71	71	80	95	95	95	95	95	108	141	141	141	141	141	144	150	150	150	150	150	184	251	251	251	251	251	252	255	255	255	255	255
69
70		Bifurcation Rate %																																							7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%	7%
71		No. of closures for Other International Market		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	31	40	40	40	40	40	41	42	42	42	42	42	52	71	71	71	71	71	71	71	71	71	71	71
72		Add: Repeat Customers (T+18)																				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2	2	2	2	2	2
73		Repeat Rate %																				5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%
74		Add: Repeat Customers (T+30)																																-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
75		Repeat Rate %																																5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%	5%
76		Total no. of closures for other International Market		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	31	40	40	40	40	40	41	42	42	42	42	42	52	71	71	71	71	71	73	73	73	73	73	73
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100