Financial Worksheet Template - Adapted from Shopify

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Financial Worksheet Template Adapted from Shopify									Adapted from Shopify's Financial Worksheet Template to be more relevant to early-stage technology companies. See original here.
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, etc. 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	Resource: Intro to cash flow forecasting.
5
6		January	February	March	April	May	June	July	August	September	October	November	December
7	CASH BALANCE
8	Opening Cash Balance	$10,000.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00
9
10	REVENUES
11	Sales	$500.00
12	Other revenues
13	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
14
15	GROSS PROFITS
16	Cost of goods sold
17	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
18	Gross Profit Margins	100.0%	-	-	-	-	-	-	-	-	-	-	-
19
20	EXPENSES
21	Fixed costs
22	Rent
23	Insurance
24	Fees (banking, licenses, etc.)
25	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
26	Variable costs
27	Payroll
28	Software
29	Marketing spend
30	Other expenses
31	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
32	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
33
34	NET PROFIT MARGINS
35	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
36	Interest
37	Taxes
38	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
39	Net Profit Margins	100.0%	-	-	-	-	-	-	-	-	-	-	-
40
41	CLOSING CASH BALANCE
42	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	Closing Cash Balance	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00	$10,500.00
44
45
46
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