RESERVEST MODEL - Phase 1 SaaS 2026.xlsx

	B	C	D	E	F	G	I	J	K	L	M	N
1
2	FORECAST INPUTS						RESERVEST FORECAST
3								SaaS	SaaS / MP	SaaS / MP / ES	SaaS / MP / ES	SaaS / MP / ES
4	PRODUCT AND TRIP METRICS			TARGET AGENT PROFILE				Year 1	Year 2	Year 3	Year 4	Year 5
5	ADR Single Product	$550		TA Commission	12%	ADR
6	Single Product Commission	4%		Trips booked per TA	30	per year	USERS
7	ADR Trip Product	$2,000		Trip length average	5	nights	Registered Travel Agents	2257	5348	11639	21269	31996
8	ATR (Hotels, villas, experiences etc)	$10,000		Nights booked per year	200-500	nights	Subscription %	21%	21%	22%	23%	25%
9	Trip Platform Fee	2%		Annual Revenue	$500,000	USD	Subscribed Travel Agents	475	1,150	2,595	4,994	8,085
10	User Tools Subscription Fee	$780					Subscribed Agencies	158	287	649	1,248	2,021
11	White label / Agency Platform Fee / Enterprise	$750					Subscribed DMCs / Tour Operators	30	200	300	400	500
12
13	REGISTERED AGENTS CONVERSION	Travel Agents	Leads / month	Agent Registration	Sales Cycle (months)	Booking Cycle (months)	BOOKINGS
14	Individual Advisor	1	10	30%	1	3	Number of Trips Booked	51	484	2,775	7,022	15,879
15	Medium Agency	10	10	20%	3	3	Total Trip Value	511,108	4,839,861	27,749,740	70,215,833	158,785,453
16	Host Agency	50	2	10%	3	3	Number of Single Products Booked	1,752	15,572	39,998	82,722	198,764
17
18	SALES REPS ATTRIBUTIONS	Year 1	Year 2	Year 3	Year 4	Year 5
19	Number of agents registered per Rep	396	396	396	396	396	Single Product Booking Value	593,536	8,564,579	21,998,698	45,497,146	109,320,114
20	Number of agents subscribed per Rep	158	192	324	422	577
21	Number of agency platform subscribed per Rep	40	48	81	106	144	Total Booking Value	1,104,644	13,404,440	49,748,438	115,712,978	268,105,567
22	Revenue Attribution per Rep	153080	185363	313825	408292	558711
23							REVENUE
24	SUBSCRIBED AGENT CONVERSION	Year 1	Year 2	Year 3	Year 4	Year 5	Single Product Commission	23,741	342,583	879,948	1,819,886	4,372,805
25	Instant conversion (On registered agents)	10%	10%	15%	15%	15%	Trip Platform Fee	10,222	96,797	554,995	1,404,317	3,175,709
26	Trailing conversion (On registered agents)	30%	15%	10%	10%	10%	User Subscription Revenue	159,574	617,753	1,435,229	2,951,758	5,148,091
27	Annual Churn (On subscribed agents)	0%	10%	10%	10%	10%	Platform Subscription Revenue	69,967	236,215	419,620	674,531	981,353
28							Total Revenue	263,504	1,293,349	3,289,793	6,850,491	13,677,958
29	COST OF ACQUISITION	Year 1	Year 2	Year 3	Year 4	Year 5
30	Registered Agent	127	89	97	106	102	Trip Sales / Subscribed Agent (Avg)	1,077	4,210	10,694	14,061	19,640
31	Digital Acqusition cost	85	90	95	110	120	Single Product Bookings / Registered Agent (Avg)	263	1,601	1,890	2,139	3,417
32	Cost of Registered Reps	45	45	45	45	45
33	Subscribed Agent	260	275	214	209	206
34	Sales Conversion	133	187	116	104	104	CLV / LTV	USD
35		0.3	0.7				Registered Agent Value	372
36	USING RESERVEST ECOSYSTEM	Penetration	Trips Booked / TA	Penetration	Products Booked / TA		Subscribed Agent Value	4,894
37	0-12 months	1%	0.3	1%	1.5
38	13-24 months	5%	1.5	5%	7.5
39	25-36 months	20%	6	5%	7.5
40	37-48 months	25%	7.5	8%	12
41	49-60 months	30%	9	25%	37.5
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