Getting to $100 million calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Getting to $100M calculator				To play around with different assumptions, get an editable version of this sheet by going to "File > Make a copy"!
2
3	Year	1	12		This calculator lets you play around with different growth paths that take you to $100M in ARR after x years. You can play around with different values for x and compare three different growth models – linear, exponential, and "declining exponential". For the first two models, you can also enter differents starting ARR and ending ARR values.
4	ARR EoY ($M)	1.00	100.00
5
6	LINEAR GROWTH
7	Year	1	2	3	4	5	6	7	8	9	10	11	12
8	ARR EoY	$1.00M	$10.00M	$19.00M	$28.00M	$37.00M	$46.00M	$55.00M	$64.00M	$73.00M	$82.00M	$91.00M	$100.00M
9	Net new ARR		$9.00M	$9.00M	$9.00M	$9.00M	$9.00M	$9.00M	$9.00M	$9.00M	$9.00M	$9.00M	$9.00M
10	Y/Y Growth		900.00%	90.00%	47.37%	32.14%	24.32%	19.57%	16.36%	14.06%	12.33%	10.98%	9.89%
11
12	EXPONENTIAL GROWTH
13	Year	1	2	3	4	5	6	7	8	9	10	11	12
14	ARR EoY ($M)	$1.00M	$1.52M	$2.31M	$3.51M	$5.34M	$8.11M	$12.33M	$18.74M	$28.48M	$43.29M	$65.79M	$100.00M
15	Net new ARR		$0.52M	$0.79M	$1.20M	$1.83M	$2.77M	$4.22M	$6.41M	$9.74M	$14.81M	$22.51M	$34.21M
16	Y/Y Growth		51.99%	51.99%	51.99%	51.99%	51.99%	51.99%	51.99%	51.99%	51.99%	51.99%	51.99%
17
18	DECLINING EXPONENTIAL GROWTH (80% of previous year)
19	Year	1	2	3	4	5	6	7	8	9	10	11	12
20	ARR EoY	$1.00M	$2.35M	$4.90M	$9.13M	$15.46M	$24.01M	$34.65M	$46.94M	$60.24M	$73.91M	$87.32M	$100.00M
21	Net new ARR		$1.35M	$2.54M	$4.24M	$6.32M	$8.56M	$10.64M	$12.28M	$13.31M	$13.67M	$13.41M	$12.68M
22	Y/Y Growth (ARR)		135.21%	108.16%	86.53%	69.23%	55.38%	44.30%	35.44%	28.35%	22.68%	18.15%	14.52%
23
24
25	For comparison: "T2D3"
26	Year	1	2	3	4	5	6	7
27	ARR EoY	$1.00M	$2.00M	$6.00M	$18.00M	$36.00M	$72.00M	$144.00M
28	Net new ARR		$1.00M	$4.00M	$12.00M	$18.00M	$36.00M	$72.00M
29	Y/Y Growth		100.00%	200.00%	200.00%	100.00%	100.00%	100.00%
30
31	Created by Christoph Janz of Point Nine Capital
32	www.pointninecap.com
33
34
35
36
37
38
39
40
41
42	Years	1.00	2.00	3.00	4.00	5.00	6.00	7.00	8.00	9.00	10.00	11.00	12.00	13.00	14.00	15.00
43	Y/Y growth year 2		9900.00%	1005.60%	453.57%	299.22%	231.59%	194.99%	172.67%	157.99%	147.83%	140.56%	135.21%	131.20%	128.15%	125.80%
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