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 | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | This is part of Ubiquity University at https://university.ubiquity.vc/dayone . | ||||||||||||||||||||||||||||
2 | In Google Sheets, go to "File, "Make a copy" to start editing your own version. This version is read-only. This template is provided as-is, so use at your own risk and double check every formula. | ||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||
4 | Ubiquity NewCo - Pro Forma Financials | ||||||||||||||||||||||||||||
5 | Blue = Inputs (only edit these) | ||||||||||||||||||||||||||||
6 | Contact: sunil@ubiquity.vc | ||||||||||||||||||||||||||||
7 | |||||||||||||||||||||||||||||
8 | New fundraise | $2,000,000 | |||||||||||||||||||||||||||
9 | Est. cash on hand at start | $0 | |||||||||||||||||||||||||||
10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |||||
11 | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | |||||
12 | Jan 1, 2024 | Feb 1, 2024 | Mar 1, 2024 | Apr 1, 2024 | May 1, 2024 | Jun 1, 2024 | Jul 1, 2024 | Aug 1, 2024 | Sep 1, 2024 | Oct 1, 2024 | Nov 1, 2024 | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 | Nov 1, 2025 | Dec 1, 2025 | |||||
13 | Customers | ||||||||||||||||||||||||||||
17 | Ending customers | 0 | 0 | 1 | 2 | 3 | 3 | 3 | 4 | 5 | 5 | 6 | 7 | 10 | 12 | 14 | 17 | 20 | 22 | 26 | 31 | 36 | 43 | 51 | 58 | ||||
18 | |||||||||||||||||||||||||||||
19 | Revenue | ||||||||||||||||||||||||||||
26 | Ending MRR (Monthly Recurring Revenue) | $0 | $0 | $5,000 | $10,250 | $16,763 | $17,601 | $18,481 | $25,405 | $32,675 | $34,309 | $44,024 | $54,225 | $80,937 | $100,983 | $122,033 | $158,134 | $196,041 | $225,843 | $277,135 | $340,992 | $408,041 | $498,444 | $603,366 | $703,534 | ||||
34 | Pilot revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
35 | Services revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
36 | Total Monthly Revenue | $0 | $0 | $5,000 | $10,250 | $16,763 | $17,601 | $18,481 | $25,405 | $32,675 | $34,309 | $44,024 | $54,225 | $80,937 | $100,983 | $122,033 | $158,134 | $196,041 | $225,843 | $277,135 | $340,992 | $408,041 | $498,444 | $603,366 | $703,534 | ||||
37 | |||||||||||||||||||||||||||||
38 | COGS | ||||||||||||||||||||||||||||
42 | Total COGS | $0 | $0 | $500 | $1,025 | $1,676 | $1,760 | $1,848 | $2,540 | $3,267 | $3,431 | $4,402 | $5,423 | $8,094 | $10,098 | $12,203 | $15,813 | $19,604 | $22,584 | $27,714 | $34,099 | $40,804 | $49,844 | $60,337 | $70,353 | ||||
43 | |||||||||||||||||||||||||||||
44 | Gross Profit | $0 | $0 | $4,500 | $9,225 | $15,086 | $15,841 | $16,633 | $22,864 | $29,407 | $30,878 | $39,622 | $48,803 | $72,843 | $90,885 | $109,829 | $142,321 | $176,437 | $203,259 | $249,422 | $306,893 | $367,237 | $448,599 | $543,029 | $633,181 | ||||
45 | Gross Margin | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | 90% | ||||||
46 | |||||||||||||||||||||||||||||
47 | Operating Expenses: | ||||||||||||||||||||||||||||
48 | Salaries (Fully-Loaded) | $27,083 | $40,625 | $62,292 | $88,833 | $88,833 | $96,092 | $125,342 | $138,883 | $165,967 | $182,217 | $182,217 | $189,258 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | $196,300 | ||||
49 | Administrative/Other | $9,000 | $9,000 | $9,000 | $23,000 | $23,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | ||||
50 | Monthly gross burn | -$36,083 | -$49,625 | -$71,792 | -$112,858 | -$113,510 | -$130,852 | -$160,190 | -$174,424 | -$202,234 | -$218,648 | -$219,619 | -$227,681 | -$237,394 | -$239,398 | -$241,503 | -$245,113 | -$248,904 | -$251,884 | -$257,014 | -$263,399 | -$270,104 | -$279,144 | -$289,637 | -$299,653 | ||||
51 | |||||||||||||||||||||||||||||
52 | Monthly net burn (offset by revenue) | -$36,083 | -$49,625 | -$66,792 | -$102,608 | -$96,747 | -$113,251 | -$141,709 | -$149,019 | -$169,559 | -$184,339 | -$175,595 | -$173,456 | -$156,457 | -$138,415 | -$119,471 | -$86,979 | -$52,863 | -$26,041 | $20,122 | $77,593 | $137,937 | $219,299 | $313,729 | $403,881 | ||||
53 | |||||||||||||||||||||||||||||
54 | Cash: | ||||||||||||||||||||||||||||
55 | Starting cash balance | $2,000,000 | $1,963,917 | $1,914,292 | $1,847,500 | $1,744,892 | $1,648,145 | $1,534,893 | $1,393,184 | $1,244,165 | $1,074,606 | $890,267 | $714,672 | $541,217 | $384,760 | $246,345 | $126,874 | $39,895 | -$12,968 | -$39,010 | -$18,888 | $58,704 | $196,642 | $415,941 | $729,670 | ||||
56 | Ending cash balance | $1,963,917 | $1,914,292 | $1,847,500 | $1,744,892 | $1,648,145 | $1,534,893 | $1,393,184 | $1,244,165 | $1,074,606 | $890,267 | $714,672 | $541,217 | $384,760 | $246,345 | $126,874 | $39,895 | -$12,968 | -$39,010 | -$18,888 | $58,704 | $196,642 | $415,941 | $729,670 | $1,133,551 | ||||
57 | Months of cash runway (estimated) | 54 | 39 | 28 | 17 | 17 | 14 | 10 | 8 | 6 | 5 | 4 | 3 | 2 | 2 | 1 | 0 | 0 | -1 | n/a | n/a | n/a | n/a | n/a | n/a | ||||
58 | |||||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||||
60 | |||||||||||||||||||||||||||||
61 | Salary Breakdown | ||||||||||||||||||||||||||||
62 | Salary Payroll multiplier (benefits, tax) | 1.3x | |||||||||||||||||||||||||||
63 | Cells D63:AA82 can be cleared/pasted for start date | Annual | Monthly rate | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | ||
64 | Marketing | ||||||||||||||||||||||||||||
65 | VP Marketing | $150,000 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | |||||||||||
66 | Marketing Manager | $125,000 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | |||||
67 | Marketing Associate | $75,000 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | $8,125 | |||||||||
68 | Sales | ||||||||||||||||||||||||||||
69 | Sales VP | $200,000 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | $21,667 | ||||
70 | Sales Director | $150,000 | $16,250 | ||||||||||||||||||||||||||
71 | Sales AE | $120,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | ||||||||
72 | SDR | $65,000 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | ||||||||||||||
73 | Sales Eng. | $150,000 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | ||||||||
74 | R&D | ||||||||||||||||||||||||||||
75 | CTO | $150,000 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | $16,250 | ||
76 | Senior Dev | $125,000 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | |||
77 | Dev | $125,000 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | ||||||||||
78 | Product Manager | $120,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | |||||
79 | Tester | $50,000 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | |||||||||
80 | UI Designer | $67,000 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | $7,258 | |||||||
81 | G&A | ||||||||||||||||||||||||||||
82 | CEO | $100,000 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | ||
83 | Office Manager | $65,000 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | $7,042 | |||||||||||||
84 | Chief of Staff | $125,000 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | $13,542 | ||||||||||
85 | Other? | $80,000 | $8,667 | ||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||||
87 | Total Headcount | 2 | 3 | 4 | 6 | 6 | 7 | 9 | 11 | 13 | 14 | 14 | 15 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | ||||
88 | |||||||||||||||||||||||||||||
89 | Administrative/Other Cost Breakdown | Monthly rate | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | Projected | |||
100 | |||||||||||||||||||||||||||||
101 | |||||||||||||||||||||||||||||
102 | |||||||||||||||||||||||||||||
103 | |||||||||||||||||||||||||||||
104 | |||||||||||||||||||||||||||||
105 | |||||||||||||||||||||||||||||
106 | |||||||||||||||||||||||||||||
107 | |||||||||||||||||||||||||||||
108 | |||||||||||||||||||||||||||||
109 | |||||||||||||||||||||||||||||
110 | |||||||||||||||||||||||||||||
111 | |||||||||||||||||||||||||||||
112 | |||||||||||||||||||||||||||||
113 | |||||||||||||||||||||||||||||
114 | |||||||||||||||||||||||||||||
115 | |||||||||||||||||||||||||||||
116 | |||||||||||||||||||||||||||||
117 | |||||||||||||||||||||||||||||
118 | |||||||||||||||||||||||||||||
119 | |||||||||||||||||||||||||||||
120 | |||||||||||||||||||||||||||||
121 | |||||||||||||||||||||||||||||
122 | |||||||||||||||||||||||||||||
123 | |||||||||||||||||||||||||||||
124 | |||||||||||||||||||||||||||||
125 | |||||||||||||||||||||||||||||
126 | |||||||||||||||||||||||||||||
127 | |||||||||||||||||||||||||||||
128 | |||||||||||||||||||||||||||||
129 |