ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
StartupGeek Financial Worksheet Template
2
3
Make a copy and download this template and use it to forecast the financial details of your business by month. The mint green cells are input fields.

Step 1 - Download this template. Go to file --> download --> choose either csv or excel formats.
Step 2 - Make a list of everything you have to pay for - rent, salary, ads, ect.
Step 3 - Determine how much cash you have in the bank at the start of forecast period. (eg: If you start this forecast in March, determine how much cash you have as of March 1st. Input it at the "Opening Cash Balance" line 7.
Step 4 - Forecast revenue. You can use past data to help with your projections.
Step 5 - Plug in the rest of your data.
Step 6 - Keep updating your projections and plan for different scenarios. This is a living document.
4
More instructions on cash flow management here.
5
6
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
7
CASH BALANCE
8
Opening Cash Balance$1,000.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00
9
10
REVENUES
11
In-store sales$500.00
12
Online sales
13
Other revenues
14
Total Revenues$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
15
16
GROSS PROFITS
17
Cost of goods sold
18
Gross Profits$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
19
Gross Profit Margins100.0%-----------
20
21
EXPENSES
22
Fixed costs
23
Rent
24
Insurance
25
Fees (banking, licenses, etc.)
26
Total Fixed Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
27
Variable costs
28
Payroll
29
Shipping costs
30
Utilities
31
Equipment and supplies
32
Marketing spend
33
Other expenses
34
Total Variable Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
35
Total Expenses$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
36
37
NET PROFIT MARGINS
38
EBITDA
Earnings Before Interest, Taxes, Depreciation, and Amortization 		$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
39
Interest
40
Taxes
41
Net Profit / Losses$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
43
44
CLOSING CASH BALANCE
45
Net Profit / Losses$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
46
Closing Cash Balance$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00
47
48
49
50
51
52
53
54
55
56
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
101