Coworking M/M Growth Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOP
1
2
M/M Growth Calculator
Created by Bernhard Mehl
3
Note: To edit the numbers, first make a copy of this sheet (File > Make a copy).at KISI
4
5
6
Begin with
After 12 months
7
Current Member Revenue$9,000.00grow by
Member revenue
$36,000.00
8
beginning of the year4.00xtarget end of the year
9
Membership Fee / Seat $ 450
Membership Fee / Seat
$ 450
10
Available Seats80
Available Seats
0
11
Currently occupied seats20
Currently occupied seats
80
12
Turnover rate / month3
Turnover rate / month
12
13
14
15
5
16
17
Initial ramp up growth
18
Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
19
New members needed each month
8.008.008.008.008.008.008.008.008.008.008.008.00
20
Available Seats beginning of month
60555045403530252015105
21
Member Revenue beginning of month
$ 9,000 $ 11,250 $ 13,500 $ 15,750 $ 18,000 $ 20,250 $ 22,500 $ 24,750 $ 27,000 $ 29,250 $ 31,500 $ 33,750
22
Net new member revenue
Linear growth
$ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250 $ 2,250
23
Member Revenue end of month
Linear growth
$ 11,250 $ 13,500 $ 15,750 $ 18,000 $ 20,250 $ 22,500 $ 24,750 $ 27,000 $ 29,250 $ 31,500 $ 33,750 $ 36,000
24
m/m growth rate25.00%20.00%16.67%14.29%12.50%11.11%10.00%9.09%8.33%7.69%7.14%6.67%
25
26
27
Stable % growth (most likely)
28
Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
29
New members needed each month
5.455.756.096.466.897.367.908.509.179.9310.7811.73
30
Available Seats beginning of month
60585552484440353023179
31
MRR beginning of month $ 9,000 $ 10,102 $ 11,339 $ 12,728 $ 14,287 $ 16,036 $ 18,000 $ 20,204 $ 22,679 $ 25,456 $ 28,573 $ 32,072
32
Net new MRR
Exponential growth
$ 1,102 $ 1,237 $ 1,389 $ 1,559 $ 1,750 $ 1,964 $ 2,204 $ 2,474 $ 2,777 $ 3,117 $ 3,499 $ 3,928
33
MRR end of month
Exponential growth
$ 10,102 $ 11,339 $ 12,728 $ 14,287 $ 16,036 $ 18,000 $ 20,204 $ 22,679 $ 25,456 $ 28,573 $ 32,072 $ 36,000
34
m/m growth rate12.25%12.25%12.25%12.25%12.25%12.25%12.25%12.25%12.25%12.25%12.25%12.25%
35
36
37
Regular growth
38
Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
39
New members needed each month
6.726.877.047.237.447.687.958.258.598.969.399.86
40
Available Seats beginning of month
60565248444035302519137
41
MRR beginning of month $ 9,000 $ 10,676 $ 12,420 $ 14,239 $ 16,143 $ 18,143 $ 20,250 $ 22,477 $ 24,839 $ 27,353 $ 30,037 $ 32,911
42
Net new MRR
Happy Medium
$ 1,676 $ 1,744 $ 1,819 $ 1,904 $ 2,000 $ 2,107 $ 2,227 $ 2,362 $ 2,514 $ 2,684 $ 2,875 $ 3,089
43
MRR end of month
Happy Medium
$ 10,676 $ 12,420 $ 14,239 $ 16,143 $ 18,143 $ 20,250 $ 22,477 $ 24,839 $ 27,353 $ 30,037 $ 32,911 $ 36,000
44
m/m growth rate18.62%16.33%14.65%13.37%12.39%11.61%11.00%10.51%10.12%9.81%9.57%9.39%
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
Disclaimer: Please be aware that his model may be inaccurate, incorrect or misleading, use it at your own risk, yada yada yada.
Feel free to distribute. If you distribute a modified version, please make it clear what you've changed.
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