Getting to \$100 million calculator
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZ
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
Year112This 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.00100.00
5
6
LINEAR GROWTH
7
Year123456789101112
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 Growth900.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
Year123456789101112
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 Growth51.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
Year123456789101112
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
Year1234567
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 Growth100.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
Years1.002.003.004.005.006.007.008.009.0010.0011.0012.0013.0014.0015.00
43
Y/Y growth year 29900.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