ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Created by: https://visible.vc/
2
Modified by Andreas Mitschke linkedin for The Ultimate Notion Data Room Template for Startups
3
Instructions (inputs in green):
4
1. Click the arrow "Copy This Sheet!" below and copy to your own Google Sheet
5
2. Enter the number of total customers in each of your pricing segments
6
3. Enter the estimate yearly revenue from each customer type
7
4. Get to $100M/yr run rate, become unicorn and retire
8
9
10
11
Customer Type 1Customer Type 2Customer Type 3Total% Serviceable Customer
12
Customers in Segment40,00025,00015,00080,00045
13
Yearly Customer Revenue$999$4,999$20,000
14
100% Market Penetration$39,960,000$124,975,000$300,000,000$464,935,000
15
16
17
TAMCustomer Type 1Customer Type 2Customer Type 3
18
Num of Customers80,000$749$999$1,249$3,749$4,999$6,249$15,000$20,000$25,000
19
2000.25%$149,850$199,800$249,750$749,850$999,800$1,249,750$3,000,000$4,000,000$5,000,000
20
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
21
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
22
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
23
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
24
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
25
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
26
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
27
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
28
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
29
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
30
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
31
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
32
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
33
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
34
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
35
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
36
37
38
SAMCustomer Type 1Customer Type 2Customer Type 3
39
Num of Customers36,000$749$999$1,249$3,749$4,999$6,249$15,000$20,000$25,000
40
1800.50%$134,865$179,820$224,775$674,865$899,820$1,124,775$2,700,000$3,600,000$4,500,000
41
3601%$269,730$359,640$449,550$1,349,730$1,799,640$2,249,550$5,400,000$7,200,000$9,000,000
42
7202%$539,460$719,280$899,100$2,699,460$3,599,280$4,499,100$10,800,000$14,400,000$18,000,000
43
1,0803%$809,190$1,078,920$1,348,650$4,049,190$5,398,920$6,748,650$16,200,000$21,600,000$27,000,000
44
1,4404%$1,078,920$1,438,560$1,798,200$5,398,920$7,198,560$8,998,200$21,600,000$28,800,000$36,000,000
45
1,8005%$1,348,650$1,798,200$2,247,750$6,748,650$8,998,200$11,247,750$27,000,000$36,000,000$45,000,000
46
2,1606%$1,618,380$2,157,840$2,697,300$8,098,380$10,797,840$13,497,300$32,400,000$43,200,000$54,000,000
47
2,5207%$1,888,110$2,517,480$3,146,850$9,448,110$12,597,480$15,746,850$37,800,000$50,400,000$63,000,000
48
2,8808%$2,157,840$2,877,120$3,596,400$10,797,840$14,397,120$17,996,400$43,200,000$57,600,000$72,000,000
49
3,2409%$2,427,570$3,236,760$4,045,950$12,147,570$16,196,760$20,245,950$48,600,000$64,800,000$81,000,000
50
3,60010%$2,697,300$3,596,400$4,495,500$13,497,300$17,996,400$22,495,500$54,000,000$72,000,000$90,000,000
51
3,96011%$2,967,030$3,956,040$4,945,050$14,847,030$19,796,040$24,745,050$59,400,000$79,200,000$99,000,000
52
4,32012%$3,236,760$4,315,680$5,394,600$16,196,760$21,595,680$26,994,600$64,800,000$86,400,000$108,000,000
53
4,68013%$3,506,490$4,675,320$5,844,150$17,546,490$23,395,320$29,244,150$70,200,000$93,600,000$117,000,000
54
5,04014%$3,776,220$5,034,960$6,293,700$18,896,220$25,194,960$31,493,700$75,600,000$100,800,000$126,000,000
55
5,40015%$4,045,950$5,394,600$6,743,250$20,245,950$26,994,600$33,743,250$81,000,000$108,000,000$135,000,000
56
5,76016%$4,315,680$5,754,240$7,192,800$21,595,680$28,794,240$35,992,800$86,400,000$115,200,000$144,000,000
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