ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pillar VC Founder Guide Financial Model
2
Your Company Name
1234567891011
3
Date
11/15/2024-1
How to Update: Update all titles/values highlighted in green with your company's information. Numbers in black / red will update automatically.
4
5
AssumptionsJan-20Feb-20Mar-20Apr-20May-20Jun-20Jul-20Aug-20Sep-20Oct-20Nov-20Dec-20Year
6
7
Summary (See input values below)
8
Revenue
 700 500 500 1,200 1,000 1,700 1,500 1,500 2,200 2,000 2,000 2,700 17,500
9
COGS 4,650 4,700 4,950 5,850 8,150 9,300 9,850 10,600 13,000 13,800 15,800 17,450 118,100
10
Gross Margin
(3,950)(4,200)(4,450)(4,650)(7,150)(7,600)(8,350)(9,100)(10,800)(11,800)(13,800)(14,750)(100,600)
11
12
S&M 34,193 34,163 35,163 38,268 38,238 38,343 38,313 41,313 41,418 43,388 43,388 43,493 469,675
13
Operations
 20,450 20,450 20,450 20,450 20,450 20,450 20,450 30,675 30,675 30,675 30,675 30,675 296,525
14
R&D 32,617 32,617 32,617 41,842 41,842 41,842 41,842 41,842 41,842 41,842 41,842 41,842 474,425
15
G&A 52,000 52,000 54,000 64,250 64,250 66,250 64,250 64,250 66,250 64,250 64,250 66,250 742,250
16
Operating Costs 139,259 139,229 142,229 164,809 164,779 166,884 164,854 178,079 180,184 180,154 180,154 182,259 1,982,875
17
18
Operating Income (Expense)
(143,209)(143,429)(146,679)(169,459)(171,929)(174,484)(173,204)(187,179)(190,984)(191,954)(193,954)(197,009)(2,083,475)
19
20
Working Capital
(1,625)(1,850)(1,975)(1,725)(3,075)(2,950)(3,425)(3,800)(4,300)(4,900)(5,900)(6,025)(41,550)
21
22
Beginning Cash Balance
 1,500,000 1,500,000 1,358,416 1,215,212 1,068,658 898,948 728,369 553,760 1,381,031 1,194,227 1,003,743 812,388 619,434 1,500,000
23
less: Operating Expenses
(143,209)(143,429)(146,679)(169,459)(171,929)(174,484)(173,204)(187,179)(190,984)(191,954)(193,954)(197,009)(2,083,475)
24
less: Change in Working Capital
 1,625 225 125 (250) 1,350 (125) 475 375 500 600 1,000 125 6,025
25
plus: Equity Financing
Dec-19 0 0 0 0 0 0 1,000,000 0 0 0 0 0 1,000,000
26
Ending Cash Balance
 1,358,416 1,215,212 1,068,658 898,948 728,369 553,760 1,381,031 1,194,227 1,003,743 812,388 619,434 422,550 422,550
27
28
Monthly Burn Rate
(141,584)(143,204)(146,554)(169,709)(170,579)(174,609)(172,729)(186,804)(190,484)(191,354)(192,954)(196,884)(2,077,450)
29
Months Cash Available
 10 8 7 5 4 3 8 6 5 4 3 2
30
31
32
Units Sold
33
Product 1
 1 0 0 1 0 1 0 0 1 0 0 1 5
34
Product 2
 5 5 5 10 10 15 15 15 20 20 20 25 165
35
Product 3
 0 0 0 0 0 0 0 0 0 0 0 0 0
36
37
Cumulative Units
38
Product 1
 1 1 1 2 2 3 3 3 4 4 4 5 5
39
Product 2
 5 10 15 25 35 50 65 80 100 120 140 165 165
40
Product 3
 0 0 0 0 0 0 0 0 0 0 0 0 0
41
42
Revenue
Price
43
Product 1
 200 200 0 0 200 0 200 0 0 200 0 0 200 1,000
44
Product 2
 100 500 500 500 1,000 1,000 1,500 1,500 1,500 2,000 2,000 2,000 2,500 16,500
45
Product 3
 1,000 0 0 0 0 0 0 0 0 0 0 0 0 0
46
Total Revenue
 700 500 500 1,200 1,000 1,700 1,500 1,500 2,200 2,000 2,000 2,700 17,500
47
48
Cost of Goods Sold
Cost
49
Material 1
 200 200 0 0 200 0 200 0 0 200 0 0 200 1,000
50
Material 2
 20 100 100 100 200 200 300 300 300 400 400 400 500 3,300
51
Material 3
670 0 0 0 0 0 0 0 0 0 0 0 0 0
52
53
Maintenance Product 1
 100 100 100 100 200 200 300 300 300 400 400 400 500 3,300
54
Maintenance Product 2
 50 250 500 750 1,250 1,750 2,500 3,250 4,000 5,000 6,000 7,000 8,250 40,500
55
Maintenance Product 3
 85 0 0 0 0 0 0 0 0 0 0 0 0 0
56
57
Servers and Software
 4,000 4,000 4,000 4,000 6,000 6,000 6,000 6,000 7,000 7,000 8,000 8,000 70,000
58
Total Cost of Goods Sold
 4,650 4,700 4,950 5,850 8,150 9,300 9,850 10,600 13,000 13,800 15,800 17,450 118,100
59
60
Gross Margin
(3,950)(4,200)(4,450)(4,650)(7,150)(7,600)(8,350)(9,100)(10,800)(11,800)(13,800)(14,750)(100,600)
61
Gross Margin %
-564%-840%-890%-388%-715%-447%-557%-607%-491%-590%-690%-546%-575%
62
63
Operating Expenses by Department
64
Sales
65
Employee 1
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 90,000
66
Employee 2
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 90,000
67
68
Fringe & Benefits
23% 3,450 3,450 3,450 3,450 3,450 3,450 3,450 3,450 3,450 3,450 3,450 3,450 41,400
69
Commission
15% 105 75 75 180 150 255 225 225 330 300 300 405 2,625
70
Travel & Entertainment
 4,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 96,000
71
Total Sales
 26,555 26,525 26,525 26,630 26,600 26,705 26,675 26,675 26,780 26,750 26,750 26,855 320,025
72
73
Marketing
74
Employee 1
 55,000 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 55,000
75
76
Marketing Campaigns
 1,000 1,000 2,000 5,000 5,000 5,000 5,000 8,000 8,000 10,000 10,000 10,000 70,000
77
78
Fringe & Benefits
23% 1,054 1,054 1,054 1,054 1,054 1,054 1,054 1,054 1,054 1,054 1,054 1,054 12,650
79
Travel & Entertainment
 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
80
Total Marketing
 7,638 7,638 8,638 11,638 11,638 11,638 11,638 14,638 14,638 16,638 16,638 16,638 149,650
81
82
Operations
83
Employee 1
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 90,000
84
Employee 2
 90,000 7,500 7,500 7,500 7,500 7,500 37,500
85
Employee 3
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 90,000
86
87
Fringe & Benefits
23% 3,450 3,450 3,450 3,450 3,450 3,450 3,450 5,175 5,175 5,175 5,175 5,175 50,025
88
Travel & Entertainment
 1,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 3,000 3,000 3,000 3,000 3,000 29,000
89
Total Operations
 20,450 20,450 20,450 20,450 20,450 20,450 20,450 30,675 30,675 30,675 30,675 30,675 296,525
90
91
Research & Development
92
Employee 1
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 90,000
93
Employee 2
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 67,500
94
Employee 3
 90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 90,000
95
96
Fringe & Benefits
23% 3,450 3,450 3,450 5,175 5,175 5,175 5,175 5,175 5,175 5,175 5,175 5,175 56,925
97
98
R&D Materials
 140,000 11,667 11,667 11,667 11,667 11,667 11,667 11,667 11,667 11,667 11,667 11,667 11,667 140,000
99
Software Licenses
 30,000 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000
100
Total Research & Development
 32,617 32,617 32,617 41,842 41,842 41,842 41,842 41,842 41,842 41,842 41,842 41,842 474,425