Founder Guide Financial Model (Hardware & Software)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Your Company Name
1234567891011
2
Date
5/16/2018-1
How to Update: Update all titles/values highlighted in green with your company's information. Numbers in black / red will update automatically.
3
4
AssumptionsJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Year
5
6
Summary (See input values below)
7
Revenue
700 500 500 1,200 1,000 1,700 1,500 1,500 2,200 2,000 2,000 2,700 17,500
8
COGS 4,775 5,000 5,425 6,625 9,275 10,900 11,975 13,250 16,300 17,800 20,500 22,975 144,800
9
Gross Margin
(4,075)(4,500)(4,925)(5,425)(8,275)(9,200)(10,475)(11,750)(14,100)(15,800)(18,500)(20,275)(127,300)
10
11
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
12
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
13
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
14
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
15
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
16
17
Operating Income (Expense)
(143,334)(143,729)(147,154)(170,234)(173,054)(176,084)(175,329)(189,829)(194,284)(195,954)(198,654)(202,534)(2,110,175)
18
19
Working Capital
(1,688)(2,000)(2,213)(2,113)(3,638)(3,750)(4,488)(5,125)(5,950)(6,900)(8,250)(8,788)(54,900)
20
21
Beginning Cash Balance
1,500,000 1,358,353 1,214,937 1,067,995 897,661 726,132 550,160 1,375,568 1,186,377 992,918 797,913 600,609 1,500,000
22
less: Operating Expenses
(143,334)(143,729)(147,154)(170,234)(173,054)(176,084)(175,329)(189,829)(194,284)(195,954)(198,654)(202,534)(2,110,175)
23
less: Change in Working Capital
1,688 313 213 (100) 1,525 113 738 638 825 950 1,350 538 8,788
24
plus: Equity Financing
Dec-17 0 0 0 0 0 0 1,000,000 0 0 0 0 0 1,000,000
25
Ending Cash Balance
1,500,000 1,358,353 1,214,937 1,067,995 897,661 726,132 550,160 1,375,568 1,186,377 992,918 797,913 600,609 398,613 398,613
26
27
Monthly Burn Rate
(141,647)(143,417)(146,942)(170,334)(171,529)(175,972)(174,592)(189,192)(193,459)(195,004)(197,304)(201,997)(2,101,388)
28
Months Cash Available
10 8 7 5 4 3 8 6 5 4 3 2
29
30
31
Units Sold
32
Product 1
1 0 0 1 0 1 0 0 1 0 0 1 5
33
Product 2
5 5 5 10 10 15 15 15 20 20 20 25 165
34
Product 3
0 0 0 0 0 0 0 0 0 0 0 0 0
35
36
Cumulative Units
37
Product 1
1 1 1 2 2 3 3 3 4 4 4 5 5
38
Product 2
5 10 15 25 35 50 65 80 100 120 140 165 165
39
Product 3
0 0 0 0 0 0 0 0 0 0 0 0 0
40
41
Revenue
Price
42
Product 1
200 200 0 0 200 0 200 0 0 200 0 0 200 1,000
43
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
44
Product 3
1,000 0 0 0 0 0 0 0 0 0 0 0 0 0
45
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
46
47
Cost of Goods Sold
Cost
48
Material 1
200 200 0 0 200 0 200 0 0 200 0 0 200 1,000
49
Material 2
20 100 100 100 200 200 300 300 300 400 400 400 500 3,300
50
Material 3
670 0 0 0 0 0 0 0 0 0 0 0 0 0
51
52
Maintenance Product 1
100 0 0 0 0 0 0 0 0 0 0 0 0 0
53
Maintenance Product 2
50 50 50 50 100 100 150 150 150 200 200 200 250 1,650
54
Maintenance Product 3
85 425 850 1,275 2,125 2,975 4,250 5,525 6,800 8,500 10,200 11,900 14,025 68,850
55
56
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
57
Total Cost of Goods Sold
4,775 5,000 5,425 6,625 9,275 10,900 11,975 13,250 16,300 17,800 20,500 22,975 144,800
58
59
Gross Margin
(4,075)(4,500)(4,925)(5,425)(8,275)(9,200)(10,475)(11,750)(14,100)(15,800)(18,500)(20,275)(127,300)
60
Gross Margin %
-582%-900%-985%-452%-828%-541%-698%-783%-641%-790%-925%-751%-727%
61
62
Operating Expenses by Department
63
Sales
64
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
65
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
66
67
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
68
Commission
15% 105 75 75 180 150 255 225 225 330 300 300 405 2,625
69
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
70
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
71
72
Marketing
73
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
74
75
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
76
77
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
78
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
79
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
80
81
Operations
82
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
83
Employee 2
90,000 7,500 7,500 7,500 7,500 7,500 37,500
84
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
85
86
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
87
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
88
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
89
90
Research & Development
91
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
92
Employee 2
90,000 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 67,500
93
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
94
95
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
96
97
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
98
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
99
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
100
Loading...
Main menu