SaaS Financial Model Template.xlsx

	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1
2		Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16	Dec-16	Total 2016	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Total 2017
3
4	PRO-FORMA P&L ($)
5
6	Revenues	178,550	200,668	223,654	247,827	273,202	304,849	337,323	371,723	412,659	455,207	503,495	554,339	4,063,496	599,459	652,441	707,656	765,461	825,729	894,594	966,271	1,046,405	1,130,377	1,218,407	1,315,053	1,421,770	11,543,623
7
8	CoGS	38,892	50,982	48,696	70,810	64,727	77,552	85,547	93,706	139,146	139,923	147,147	156,569	1,113,697	188,984	192,515	225,046	227,097	246,907	265,255	304,653	325,644	349,762	386,475	405,712	444,770	3,562,820
9	% of revenues	22%	25%	22%	29%	24%	25%	25%	25%	34%	31%	29%	28%	27%	32%	30%	32%	30%	30%	30%	32%	31%	31%	32%	31%	31%	31%
10
11	Gross Profit	139,658	149,686	174,959	177,016	208,475	227,297	251,776	278,016	273,513	315,284	356,348	397,771	2,949,799	410,475	459,926	482,610	538,364	578,822	629,338	661,618	720,761	780,615	831,932	909,341	976,999	7,980,803
12	% of revenues	78%	75%	78%	71%	76%	75%	75%	75%	66%	69%	71%	72%	73%	68%	70%	68%	70%	70%	70%	68%	69%	69%	68%	69%	69%	69%
13
14	Operating Costs
15
16	R&D	54,900	54,900	77,600	82,750	90,100	86,100	134,550	135,700	156,200	148,200	159,550	166,900	1,347,450	208,950	196,950	208,300	217,450	224,800	244,100	250,450	246,450	246,450	246,450	259,600	255,600	2,805,550
17	% of revenues	31%	27%	35%	33%	33%	28%	40%	37%	38%	33%	32%	30%	33%	35%	30%	29%	28%	27%	27%	26%	24%	22%	20%	20%	18%	24%
18
19	S&M	120,250	302,400	291,650	297,650	330,900	349,350	355,350	365,350	375,350	385,350	395,350	405,350	3,974,300	415,350	440,200	457,450	463,450	473,450	539,450	533,450	595,200	637,950	649,600	655,600	665,600	6,526,750
20	% of revenues	67%	151%	130%	120%	121%	115%	105%	98%	91%	85%	79%	73%	98%	69%	67%	65%	61%	57%	60%	55%	57%	56%	53%	50%	47%	57%
21
22	G&A	244,678	110,783	111,933	98,141	99,410	160,992	140,316	179,036	136,083	172,660	168,925	227,467	1,850,425	189,723	237,372	195,133	228,023	305,686	260,130	278,714	282,720	271,919	276,320	277,203	218,538	3,021,481
23	% of revenues	137%	55%	50%	40%	36%	53%	42%	48%	33%	38%	34%	41%	46%	32%	36%	28%	30%	37%	29%	29%	27%	24%	23%	21%	15%	26%
24
25	Total Operating Costs	419,828	468,083	481,183	478,541	520,410	596,442	630,216	680,086	667,633	706,210	723,825	799,717	7,172,175	814,023	874,522	860,883	908,923	1,003,936	1,043,680	1,062,614	1,124,370	1,156,319	1,172,370	1,192,403	1,139,738	12,353,781
26	% of revenues	235%	233%	215%	193%	190%	196%	187%	183%	162%	155%	144%	144%	177%	136%	134%	122%	119%	122%	117%	110%	107%	102%	96%	91%	80%	107%
27
28	EBIT	-280,169	-318,397	-306,224	-301,525	-311,935	-369,145	-378,440	-402,070	-394,120	-390,926	-367,477	-401,946	-4,222,376	-403,548	-414,596	-378,272	-370,559	-425,115	-414,341	-400,995	-403,609	-375,704	-340,438	-283,062	-162,739	-4,372,978
29
30	OPERATING CASH FLOW ($)
31	Cash inflow	329,550	395,668	402,654	410,827	420,202	490,849	502,323	515,723	590,659	607,207	493,495	514,339	5,673,496	741,459	892,941	920,656	950,961	983,729	1,145,594	1,184,271	1,286,405	1,392,377	1,442,407	1,430,553	1,549,770	13,921,123
32	Cash outflow	400,619	405,765	644,878	424,652	456,337	844,695	574,264	630,093	956,879	691,733	713,572	1,542,386	8,285,872	835,807	897,437	1,212,729	959,120	1,069,843	1,424,535	1,161,467	1,223,615	1,658,281	1,310,345	1,345,015	2,818,409	15,916,602
33	Total operating cashflow	-71,069	-10,097	-242,224	-13,825	-36,135	-353,845	-71,940	-114,370	-366,220	-84,526	-220,077	-1,028,046	-2,612,376	-94,348	-4,496	-292,072	-8,159	-86,115	-278,941	22,805	62,791	-265,904	132,062	85,538	-1,268,639	-1,995,478
34
35	BANK BALANCE ($)
36	Starting bank balance	500,000	5,428,931	5,418,833	5,176,609	5,162,784	5,126,649	4,772,804	4,700,864	4,586,494	4,220,274	4,135,748	3,915,671		2,887,624	2,793,277	2,788,780	2,496,708	2,488,549	2,402,435	2,123,493	2,146,298	2,209,089	1,943,185	2,075,247	2,160,785
37	Cash from financing	5,000,000	0	0	0	0	0	0	0	0	0	0	0	5,000,000	0	0	0	0	0	0	0	0	0	0	0	0	0
38	Cash from operations	-71,069	-10,097	-242,224	-13,825	-36,135	-353,845	-71,940	-114,370	-366,220	-84,526	-220,077	-1,028,046	-2,612,376	-94,348	-4,496	-292,072	-8,159	-86,115	-278,941	22,805	62,791	-265,904	132,062	85,538	-1,268,639	-1,995,478
39	Ending bank balance	5,428,931	5,418,833	5,176,609	5,162,784	5,126,649	4,772,804	4,700,864	4,586,494	4,220,274	4,135,748	3,915,671	2,887,624		2,793,277	2,788,780	2,496,708	2,488,549	2,402,435	2,123,493	2,146,298	2,209,089	1,943,185	2,075,247	2,160,785	892,146
40
41	Template created by Christoph Janz of Point Nine Capital.														Disclaimer: Please be aware that his model may be inaccurate, incorrect or misleading.
42	Please take a look at these notes on how to use this model.																						Use it at your own risk, yada yada yada.
43
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