SaaS Financial Plan Template

	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-22	Feb-22	Mar-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Total 2022	Jan-23	Feb-23	Mar-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Total 2023

3
4	PRO-FORMA P&L ($)
5
6	Revenues	178,550	200,668	223,452	247,218	271,519	301,569	332,635	364,319	401,784	440,617	484,574	529,250	3,976,153	567,609	612,322	659,027	706,997	756,575	813,828	872,631	938,609	1,007,292	1,078,328	1,156,529	1,242,377	10,412,123
7
8	CoGS	36,972	48,582	46,278	67,278	61,104	73,313	80,709	79,087	91,852	134,892	133,269	132,616	985,953	157,827	164,175	181,872	186,607	207,789	215,120	233,764	259,992	263,230	295,148	306,307	323,932	2,795,763
9	% of revenues	21%	24%	21%	27%	23%	24%	24%	22%	23%	31%	28%	25%	25%	28%	27%	28%	26%	27%	26%	27%	28%	26%	27%	26%	26%	27%
10
11	Gross Profit	141,578	152,086	177,174	179,939	210,415	228,255	251,926	285,231	309,932	305,724	351,305	396,634	2,990,200	409,782	448,147	477,154	520,389	548,786	598,708	638,867	678,618	744,062	783,180	850,222	918,445	7,616,360
12	% of revenues	79%	76%	79%	73%	77%	76%	76%	78%	77%	69%	72%	75%	75%	72%	73%	72%	74%	73%	74%	73%	72%	74%	73%	74%	74%	73%
13
14	Operating Costs
15
16	R&D	89,360	89,360	120,440	108,440	132,500	145,220	148,090	202,000	198,030	216,280	208,280	230,670	1,888,670	233,030	229,030	229,030	229,030	229,030	229,030	229,030	229,030	229,030	229,030	229,030	229,030	2,752,360
17	% of revenues	50%	45%	54%	44%	49%	48%	45%	55%	49%	49%	43%	44%	47%	41%	37%	35%	32%	30%	28%	26%	24%	23%	21%	20%	18%	26%
18
19	S&M	59,250	95,500	131,250	133,250	143,250	191,250	215,300	217,300	227,300	237,300	259,900	265,900	2,176,750	275,900	285,900	295,900	305,900	315,900	373,650	371,650	381,650	391,650	401,650	411,650	437,900	4,249,300
20	% of revenues	33%	48%	59%	54%	53%	63%	65%	60%	57%	54%	54%	50%	55%	49%	47%	45%	43%	42%	46%	43%	41%	39%	37%	36%	35%	41%
21
22	G&A	117,228	150,533	105,873	106,261	166,676	153,728	180,232	157,566	198,139	168,781	195,679	199,888	1,900,583	192,905	215,066	201,026	217,050	248,154	225,666	241,957	216,355	250,890	237,541	251,026	210,944	2,708,581
23	% of revenues	66%	75%	47%	43%	61%	51%	54%	43%	49%	38%	40%	38%	48%	34%	35%	31%	31%	33%	28%	28%	23%	25%	22%	22%	17%	26%
24
25	Total Operating Costs	265,838	335,393	357,563	347,951	442,426	490,198	543,622	576,866	623,469	622,361	663,859	696,458	5,966,003	701,835	729,996	725,956	751,980	793,084	828,346	842,637	827,035	871,570	868,221	891,706	877,874	9,710,241
26	% of revenues	149%	167%	160%	141%	163%	163%	163%	158%	155%	141%	137%	132%	150%	124%	119%	110%	106%	105%	102%	97%	88%	87%	81%	77%	71%	93%
27
28	EBIT	-124,259	-183,307	-180,389	-168,012	-232,011	-261,943	-291,696	-291,634	-313,537	-316,637	-312,553	-299,824	-2,975,803	-292,053	-281,849	-248,802	-231,590	-244,298	-229,639	-203,769	-148,418	-127,508	-85,042	-41,485	40,571	-2,093,881
29
30	OPERATING CASH FLOW ($)
31	Cash inflow	329,550	395,668	402,452	410,218	418,519	487,569	497,635	508,319	579,784	592,617	474,574	489,250	5,586,153	709,609	852,822	872,027	892,497	914,575	1,064,828	1,090,631	1,178,609	1,269,292	1,302,328	1,272,029	1,370,377	12,789,623
32	Cash outflow	274,919	355,015	417,801	378,969	466,710	585,802	578,631	604,543	741,311	701,113	739,768	1,107,374	6,951,956	800,607	834,796	925,814	878,252	939,658	1,059,932	998,225	1,007,812	1,181,264	1,082,634	1,116,639	1,680,371	12,506,004
33	Total operating cashflow	54,631	40,653	-15,349	31,248	-48,191	-98,233	-80,996	-96,224	-161,527	-108,497	-265,193	-618,124	-1,365,803	-90,998	18,026	-53,787	14,245	-25,083	4,896	92,406	170,797	88,027	219,693	155,390	-309,994	283,619
34
35	BANK BALANCE ($)
36	Starting bank balance	500,000	5,554,631	5,595,283	5,579,935	5,611,183	5,562,992	5,464,758	5,383,763	5,287,538	5,126,011	5,017,514	4,752,321		4,134,197	4,043,199	4,061,225	4,007,438	4,021,683	3,996,600	4,001,496	4,093,902	4,264,699	4,352,727	4,572,420	4,727,810
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	54,631	40,653	-15,349	31,248	-48,191	-98,233	-80,996	-96,224	-161,527	-108,497	-265,193	-618,124	-1,365,803	-90,998	18,026	-53,787	14,245	-25,083	4,896	92,406	170,797	88,027	219,693	155,390	-309,994	283,619
39	Ending bank balance	5,554,631	5,595,283	5,579,935	5,611,183	5,562,992	5,464,758	5,383,763	5,287,538	5,126,011	5,017,514	4,752,321	4,134,197		4,043,199	4,061,225	4,007,438	4,021,683	3,996,600	4,001,496	4,093,902	4,264,699	4,352,727	4,572,420	4,727,810	4,417,817
40
41															Disclaimer: Please be aware that his model may be inaccurate, incorrect or misleading.
42																							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