Visible.vc - Market Sizing, TAM & Sensitivity Analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Created by:https://visible.vc/Last Updated:1/13/2016
2
Instructions (inputs in green):
3
1. Click the arrow "Copy This Sheet!" below and copy to your own Google Sheet
4
2. Enter the number of total customers in each of your pricing segments
5
3. Enter the estimate yearly revenue from each customer type
6
4. Get to $100M/yr run rate, become unicorn and retire
7
5. Enoy this model? We'd love to have you share it
8
9
Customer Type 1Customer Type 2Customer Type 3Total
10
Customers in Segment40,00025,00015,00080,000
11
Yearly Customer Revenue$999$4,999$20,000
12
100% Market Penetration$39,960,000$124,975,000$300,000,000$464,935,000
13
14
Sensitivity Analysis
15
16
Num of Customers80,000$749$999$1,249$3,749$4,999$6,249$15,000$20,000$25,000
17
2000.25%$149,850$199,800$249,750$749,850$999,800$1,249,750$3,000,000$4,000,000$5,000,000
18
4000.50%$299,700$399,600$499,500$1,499,700$1,999,600$2,499,500$6,000,000$8,000,000$10,000,000
19
1,2001.50%$899,100$1,198,800$1,498,500$4,499,100$5,998,800$7,498,500$18,000,000$24,000,000$30,000,000
20
1,6002.00%$1,198,800$1,598,400$1,998,000$5,998,800$7,998,400$9,998,000$24,000,000$32,000,000$40,000,000
21
2,4003.00%$1,798,200$2,397,600$2,997,000$8,998,200$11,997,600$14,997,000$36,000,000$48,000,000$60,000,000
22
3,2004.00%$2,397,600$3,196,800$3,996,000$11,997,600$15,996,800$19,996,000$48,000,000$64,000,000$80,000,000
23
4,0005.00%$2,997,000$3,996,000$4,995,000$14,997,000$19,996,000$24,995,000$60,000,000$80,000,000$100,000,000
24
4,8006.00%$3,596,400$4,795,200$5,994,000$17,996,400$23,995,200$29,994,000$72,000,000$96,000,000$120,000,000
25
5,6007.00%$4,195,800$5,594,400$6,993,000$20,995,800$27,994,400$34,993,000$84,000,000$112,000,000$140,000,000
26
6,4008.00%$4,795,200$6,393,600$7,992,000$23,995,200$31,993,600$39,992,000$96,000,000$128,000,000$160,000,000
27
7,2009.00%$5,394,600$7,192,800$8,991,000$26,994,600$35,992,800$44,991,000$108,000,000$144,000,000$180,000,000
28
8,00010.00%$5,994,000$7,992,000$9,990,000$29,994,000$39,992,000$49,990,000$120,000,000$160,000,000$200,000,000
29
8,80011.00%$6,593,400$8,791,200$10,989,000$32,993,400$43,991,200$54,989,000$132,000,000$176,000,000$220,000,000
30
9,60012.00%$7,192,800$9,590,400$11,988,000$35,992,800$47,990,400$59,988,000$144,000,000$192,000,000$240,000,000
31
10,40013.00%$7,792,200$10,389,600$12,987,000$38,992,200$51,989,600$64,987,000$156,000,000$208,000,000$260,000,000
32
11,20014.00%$8,391,600$11,188,800$13,986,000$41,991,600$55,988,800$69,986,000$168,000,000$224,000,000$280,000,000
33
12,00015.00%$8,991,000$11,988,000$14,985,000$44,991,000$59,988,000$74,985,000$180,000,000$240,000,000$300,000,000
34
35
36
37
38
39
40
41
42
43
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