ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Market Sizing, TAM & Sensitivity Analysis
2
3
Adapted by:Matthew Zammit
http://knowyoursocial.com
4
Based on original from
https://visible.vc/
5
Last Updated:17/07/2018
6
7
Need Help?
matthew@knowyoursocial.com
8
9
Instructions (inputs in green):
10
1. Click the arrow "Copy This Sheet!" below and copy to your own Google Sheet
11
2. Enter the number of total customers in each of your pricing segments
12
3. Enter the estimate yearly revenue from each customer type
13
4. Get to €100M/yr run rate, become unicorn and retire
14
15
16
Type 1Type 2Type 3Total
17
Customers in Segment
25,00015,0005,00045,000
18
Yearly Customer Revenue
€999€4,999€20,000
19
100% Market Penetration
€24,975,000€74,985,000€100,000,000€199,960,000
20
21
22
Sensitivity Analysis
75%100%125%75%100%125%75%100%125%
23
No. of customers by segment
Market Penetration
25,00015,0005,000
24
Type 1Type 2Type 3Total45,000€749€999€1,249€3,749€4,999€6,249€15,000€20,000€25,000BLENDED 75%BLENDED 100%BLENDED 125%
25
6338131130.25%€46,828€62,438€78,047€140,597€187,463€234,328€187,500€250,000€312,500€374,925€499,900€624,875
26
12575252250.50%€93,656€124,875€156,094€281,194€374,925€468,656€375,000€500,000€625,000€749,850€999,800€1,249,750
27
375225756751.50%€280,969€374,625€468,281€843,581€1,124,775€1,405,969€1,125,000€1,500,000€1,875,000€2,249,550€2,999,400€3,749,250
28
5003001009002.00%€374,625€499,500€624,375€1,124,775€1,499,700€1,874,625€1,500,000€2,000,000€2,500,000€2,999,400€3,999,200€4,999,000
29
7504501501,3503.00%€561,938€749,250€936,563€1,687,163€2,249,550€2,811,938€2,250,000€3,000,000€3,750,000€4,499,100€5,998,800€7,498,500
30
1,0006002001,8004.00%€749,250€999,000€1,248,750€2,249,550€2,999,400€3,749,250€3,000,000€4,000,000€5,000,000€5,998,800€7,998,400€9,998,000
31
1,2507502502,2505.00%€936,563€1,248,750€1,560,938€2,811,938€3,749,250€4,686,563€3,750,000€5,000,000€6,250,000€7,498,500€9,998,000€12,497,500
32
1,5009003002,7006.00%€1,123,875€1,498,500€1,873,125€3,374,325€4,499,100€5,623,875€4,500,000€6,000,000€7,500,000€8,998,200€11,997,600€14,997,000
33
1,7501,0503503,1507.00%€1,311,188€1,748,250€2,185,313€3,936,713€5,248,950€6,561,188€5,250,000€7,000,000€8,750,000€10,497,900€13,997,200€17,496,500
34
2,0001,2004003,6008.00%€1,498,500€1,998,000€2,497,500€4,499,100€5,998,800€7,498,500€6,000,000€8,000,000€10,000,000€11,997,600€15,996,800€19,996,000
35
2,2501,3504504,0509.00%€1,685,813€2,247,750€2,809,688€5,061,488€6,748,650€8,435,813€6,750,000€9,000,000€11,250,000€13,497,300€17,996,400€22,495,500
36
2,5001,5005004,50010.00%€1,873,125€2,497,500€3,121,875€5,623,875€7,498,500€9,373,125€7,500,000€10,000,000€12,500,000€14,997,000€19,996,000€24,995,000
37
2,7501,6505504,95011.00%€2,060,438€2,747,250€3,434,063€6,186,263€8,248,350€10,310,438€8,250,000€11,000,000€13,750,000€16,496,700€21,995,600€27,494,500
38
3,0001,8006005,40012.00%€2,247,750€2,997,000€3,746,250€6,748,650€8,998,200€11,247,750€9,000,000€12,000,000€15,000,000€17,996,400€23,995,200€29,994,000
39
3,2501,9506505,85013.00%€2,435,063€3,246,750€4,058,438€7,311,038€9,748,050€12,185,063€9,750,000€13,000,000€16,250,000€19,496,100€25,994,800€32,493,500
40
3,5002,1007006,30014.00%€2,622,375€3,496,500€4,370,625€7,873,425€10,497,900€13,122,375€10,500,000€14,000,000€17,500,000€20,995,800€27,994,400€34,993,000
41
3,7502,2507506,75015.00%€2,809,688€3,746,250€4,682,813€8,435,813€11,247,750€14,059,688€11,250,000€15,000,000€18,750,000€22,495,500€29,994,000€37,492,500
42
4,0002,4008007,20016.00%€2,997,000€3,996,000€4,995,000€8,998,200€11,997,600€14,997,000€12,000,000€16,000,000€20,000,000€23,995,200€31,993,600€39,992,000
43
4,2502,5508507,65017.00%€3,184,313€4,245,750€5,307,188€9,560,588€12,747,450€15,934,313€12,750,000€17,000,000€21,250,000€25,494,900€33,993,200€42,491,500
44
4,5002,7009008,10018.00%€3,371,625€4,495,500€5,619,375€10,122,975€13,497,300€16,871,625€13,500,000€18,000,000€22,500,000€26,994,600€35,992,800€44,991,000
45
4,7502,8509508,55019.00%€3,558,938€4,745,250€5,931,563€10,685,363€14,247,150€17,808,938€14,250,000€19,000,000€23,750,000€28,494,300€37,992,400€47,490,500
46
5,0003,0001,0009,00020.00%€3,746,250€4,995,000€6,243,750€11,247,750€14,997,000€18,746,250€15,000,000€20,000,000€25,000,000€29,994,000€39,992,000€49,990,000
47
5,2503,1501,0509,45021.00%€3,933,563€5,244,750€6,555,938€11,810,138€15,746,850€19,683,563€15,750,000€21,000,000€26,250,000€31,493,700€41,991,600€52,489,500
48
5,5003,3001,1009,90022.00%€4,120,875€5,494,500€6,868,125€12,372,525€16,496,700€20,620,875€16,500,000€22,000,000€27,500,000€32,993,400€43,991,200€54,989,000
49
5,7503,4501,15010,35023.00%€4,308,188€5,744,250€7,180,313€12,934,913€17,246,550€21,558,188€17,250,000€23,000,000€28,750,000€34,493,100€45,990,800€57,488,500
50
6,0003,6001,20010,80024.00%€4,495,500€5,994,000€7,492,500€13,497,300€17,996,400€22,495,500€18,000,000€24,000,000€30,000,000€35,992,800€47,990,400€59,988,000
51
6,2503,7501,25011,25025.00%€4,682,813€6,243,750€7,804,688€14,059,688€18,746,250€23,432,813€18,750,000€25,000,000€31,250,000€37,492,500€49,990,000€62,487,500
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