A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 1 | Type 2 | Type 3 | Total | ||||||||||||||||||||||||||
17 | Customers in Segment | 25,000 | 15,000 | 5,000 | 45,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,000 | 15,000 | 5,000 | |||||||||||||||||||||||||
24 | Type 1 | Type 2 | Type 3 | Total | 45,000 | €749 | €999 | €1,249 | €3,749 | €4,999 | €6,249 | €15,000 | €20,000 | €25,000 | BLENDED 75% | BLENDED 100% | BLENDED 125% | |||||||||||||
25 | 63 | 38 | 13 | 113 | 0.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 | 125 | 75 | 25 | 225 | 0.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 | 375 | 225 | 75 | 675 | 1.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 | 500 | 300 | 100 | 900 | 2.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 | 750 | 450 | 150 | 1,350 | 3.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,000 | 600 | 200 | 1,800 | 4.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,250 | 750 | 250 | 2,250 | 5.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,500 | 900 | 300 | 2,700 | 6.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,750 | 1,050 | 350 | 3,150 | 7.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,000 | 1,200 | 400 | 3,600 | 8.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,250 | 1,350 | 450 | 4,050 | 9.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,500 | 1,500 | 500 | 4,500 | 10.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,750 | 1,650 | 550 | 4,950 | 11.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,000 | 1,800 | 600 | 5,400 | 12.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,250 | 1,950 | 650 | 5,850 | 13.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,500 | 2,100 | 700 | 6,300 | 14.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,750 | 2,250 | 750 | 6,750 | 15.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,000 | 2,400 | 800 | 7,200 | 16.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,250 | 2,550 | 850 | 7,650 | 17.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,500 | 2,700 | 900 | 8,100 | 18.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,750 | 2,850 | 950 | 8,550 | 19.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,000 | 3,000 | 1,000 | 9,000 | 20.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,250 | 3,150 | 1,050 | 9,450 | 21.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,500 | 3,300 | 1,100 | 9,900 | 22.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,750 | 3,450 | 1,150 | 10,350 | 23.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,000 | 3,600 | 1,200 | 10,800 | 24.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,250 | 3,750 | 1,250 | 11,250 | 25.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 |