ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
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
123456789101112131415161718192021222324
11
ProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
12
Jan 1, 2024Feb 1, 2024Mar 1, 2024Apr 1, 2024May 1, 2024Jun 1, 2024Jul 1, 2024Aug 1, 2024Sep 1, 2024Oct 1, 2024Nov 1, 2024Dec 1, 2024Jan 1, 2025Feb 1, 2025Mar 1, 2025Apr 1, 2025May 1, 2025Jun 1, 2025Jul 1, 2025Aug 1, 2025Sep 1, 2025Oct 1, 2025Nov 1, 2025Dec 1, 2025
13
Customers
17
Ending customers001233345567101214172022263136435158
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 Margin90%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)543928171714108654322100-1n/an/an/an/an/an/a
58
59
60
61
Salary Breakdown
87
Total Headcount23466791113141415161616161616161616161616
88
89
Administrative/Other Cost BreakdownMonthly rateProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154