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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 1 | Customer Type 2 | Customer Type 3 | Total | % Serviceable Customer | ||||||||||||||||||||||
12 | Customers in Segment | 40,000 | 25,000 | 15,000 | 80,000 | 45 | |||||||||||||||||||||
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 | TAM | Customer Type 1 | Customer Type 2 | Customer Type 3 | |||||||||||||||||||||||
18 | Num of Customers | 80,000 | $749 | $999 | $1,249 | $3,749 | $4,999 | $6,249 | $15,000 | $20,000 | $25,000 | ||||||||||||||||
19 | 200 | 0.25% | $149,850 | $199,800 | $249,750 | $749,850 | $999,800 | $1,249,750 | $3,000,000 | $4,000,000 | $5,000,000 | ||||||||||||||||
20 | 400 | 0.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,200 | 1.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,600 | 2.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,400 | 3.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,200 | 4.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,000 | 5.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,800 | 6.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,600 | 7.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,400 | 8.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,200 | 9.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,000 | 10.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,800 | 11.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,600 | 12.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,400 | 13.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,200 | 14.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,000 | 15.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 | SAM | Customer Type 1 | Customer Type 2 | Customer Type 3 | |||||||||||||||||||||||
39 | Num of Customers | 36,000 | $749 | $999 | $1,249 | $3,749 | $4,999 | $6,249 | $15,000 | $20,000 | $25,000 | ||||||||||||||||
40 | 180 | 0.50% | $134,865 | $179,820 | $224,775 | $674,865 | $899,820 | $1,124,775 | $2,700,000 | $3,600,000 | $4,500,000 | ||||||||||||||||
41 | 360 | 1% | $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 | 720 | 2% | $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,080 | 3% | $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,440 | 4% | $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,800 | 5% | $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,160 | 6% | $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,520 | 7% | $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,880 | 8% | $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,240 | 9% | $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,600 | 10% | $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,960 | 11% | $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,320 | 12% | $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,680 | 13% | $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,040 | 14% | $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,400 | 15% | $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,760 | 16% | $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 |