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

View only
 
 
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
Loading...
Main menu