ARR Waterfall [CFOPilot]

	A	B	G	H	I	J	K	L	M	N	P	Q
1	ARR Waterfall
2	More resources at -> CFOPilot
3
4
5		ARR Waterfall	Q1FY25	Q2FY25	Q3FY25	Q4FY25	Q1FY24	Q2FY24	Q3FY24	Q4FY24	FY23	FY24
6		Beginning ARR	28,646,003	29,823,995	31,282,875	32,996,075	34,924,075	39,344,075	41,796,575	45,544,950	28,646,003	34,924,075
7		(+) New Business	3,494,025	4,032,250	4,572,500	5,105,000	7,950,000	6,227,500	7,630,625	9,119,980	17,203,775	30,928,105
8		(+) New Logo	3,000,000	3,500,000	4,000,000	4,500,000	5,000,000	5,500,000	6,050,000	6,655,000	15,000,000	23,205,000
9		(+) Upsell	164,025	182,250	202,500	225,000	250,000	287,500	330,625	2,000,000	773,775	2,868,125
10		(+) Cross-sell	80,000	90,000	100,000	100,000	100,000	120,000	900,000	172,800	370,000	1,292,800
11		(+) Price increase	200,000	200,000	200,000	200,000	2,500,000	200,000	206,000	212,180	800,000	3,118,180
12		(+) Usage increase (by customer)	50,000	60,000	70,000	80,000	100,000	120,000	144,000	80,000	260,000	444,000
13		( -) Churn	-2,316,033	-2,573,370	-2,859,300	-3,177,000	-3,530,000	-3,775,000	-3,882,250	-4,137,818	-10,925,703	-15,325,068
14		(-) Logo Churn	-1,640,250	-1,822,500	-2,025,000	-2,250,000	-2,500,000	-2,575,000	-2,652,250	-2,731,818	-7,737,750	-10,459,068
15		(-) Downgrade	-656,100	-729,000	-810,000	-900,000	-1,000,000	-1,100,000	-1,210,000	-1,331,000	-3,095,100	-4,641,000
16		(-) Usage decrease (by customer)	-19,683	-21,870	-24,300	-27,000	-30,000	-100,000	-20,000	-75,000	-92,853	-225,000
17		Ending ARR	29,823,995	31,282,875	32,996,075	34,924,075	39,344,075	41,796,575	45,544,950	50,527,113	34,924,075	50,527,113
18
19		YoY ARR Growth Rates
20		(+) New Business	47%	51%	55%	60%	73%	76%	82%	89%	49%	89%
21		(+) New Logo	40%	44%	48%	52%	57%	61%	64%	66%	43%	66%
22		(+) Upsell	2%	2%	3%	3%	3%	3%	3%	8%	2%	8%
23		(+) Cross-sell	1%	1%	1%	1%	1%	1%	4%	4%	1%	4%
24		(+) Price increase	3%	3%	3%	3%	10%	10%	9%	9%	2%	9%
25		(+) Usage increase (by customer)	1%	1%	1%	1%	1%	1%	1%	1%	1%	1%
26		( -) Churn	-31%	-33%	-36%	-38%	-41%	-43%	-44%	-44%	-31%	-44%
27		(-) Logo Churn	-22%	-24%	-25%	-27%	-29%	-30%	-30%	-30%	-22%	-30%
28		(-) Downgrade	-9%	-9%	-10%	-11%	-12%	-12%	-13%	-13%	-9%	-13%
29		(-) Usage decrease (by customer)	0%	0%	0%	0%	0%	-1%	-1%	-1%	0%	-1%
30		Ending ARR growth % (y/y)	16%	17%	20%	22%	32%	34%	38%	45%	38%	45%
31
32		Net New ARR	1,177,992	1,458,880	1,713,200	1,928,000	4,420,000	2,452,500	3,748,375	4,982,163	6,278,072	15,603,038
33		New Logo as % of New Business	86%	87%	87%	88%	63%	88%	79%	73%	87%	75%
34		New Logo ACV	96,774	97,222	129,032	97,826	104,167	98,214	140,698	88,733	111,111	116,025
35
36		Beginning Logos	276	276	276	276	276	276	276	276	150	276
37		(+) New Logos	31	36	31	46	48	56	43	75	135	200
38		(-) Churned Logos	-23	-26	-29	-31	-35	-38	-37	-40	-80	-101
39		Ending Logos	284	286	278	291	289	294	282	311	205	375
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