SaaSFinancialPlan2.0
Commentaires
 Partager
 
Commentaire uniquement
 
 
Chargement en cours...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Total 2016Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Total 2017
3
4
PRO-FORMA P&L ($)
5
6
Revenues178,550200,668223,654247,827273,202304,849337,323371,723412,659455,207503,495554,3394,063,496599,990652,974707,924765,730826,000894,866966,5451,046,6801,130,6531,218,6851,315,3321,417,05011,542,430
7
8
CoGS38,89250,98248,69670,81064,72777,55285,54793,706139,146139,923147,147156,5691,113,697189,029192,560225,069227,120246,930274,829300,676325,668349,786386,498405,736443,5443,567,444
9
% of revenues
22%25%22%29%24%25%25%25%34%31%29%28%27%32%29%32%30%30%31%31%31%31%32%31%31%31%
10
11
Gross Profit
139,658149,686174,959177,016208,475227,297251,776278,016273,513315,284356,348397,7712,949,799410,961460,414482,856538,611579,070620,037665,868721,013780,868832,186909,596973,5067,974,986
12
% of revenues
78%75%78%71%76%75%75%75%66%69%71%72%73%68%71%68%70%70%69%69%69%69%68%69%69%69%
13
14
Operating Costs
15
16
R&D54,90054,90077,60082,75090,10086,100134,550135,700156,200148,200159,550166,9001,347,450208,950196,950208,300217,450224,800244,100250,450246,450246,450246,450259,600255,6002,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&M120,250302,400291,650297,650330,900349,350355,350365,350375,350385,350395,350405,3503,974,300415,350440,200457,450463,450473,450539,450533,450595,200637,950649,600655,600665,6006,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&A252,228120,533120,883106,291106,760170,292148,566186,236144,983180,260168,425225,4671,930,925196,850249,424205,796237,312328,600257,693289,627294,734285,033287,534282,992221,9533,137,546
23
% of revenues
141%60%54%43%39%56%44%50%35%40%33%41%48%33%38%29%31%40%29%30%28%25%24%22%16%27%
24
25
Total Operating Costs
427,378477,833490,133486,691527,760605,742638,466687,286676,533713,810723,325797,7177,252,675821,150886,574871,546918,2121,026,8501,041,2431,073,5271,136,3841,169,4331,183,5841,198,1921,143,15312,469,846
26
% of revenues
239%238%219%196%193%199%189%185%164%157%144%144%178%137%136%123%120%124%116%111%109%103%97%91%81%108%
27
28
EBIT-287,719-328,147-315,174-309,675-319,285-378,445-386,690-409,270-403,020-398,526-366,977-399,946-4,302,876-410,188-426,160-388,690-379,601-447,780-421,206-407,659-415,372-388,565-351,398-288,595-169,647-4,494,861
29
30
OPERATING CASH FLOW ($)
31
Cash inflow329,550395,668402,654410,827420,202490,849502,323515,723590,659607,207493,495514,3395,673,496741,990893,474920,924951,230984,0001,145,8661,184,5451,286,6801,392,6531,442,6851,430,8321,490,05013,864,930
32
Cash outflow
408,169415,515653,828432,802463,687853,995582,514637,293965,779699,333713,0721,540,3868,366,372842,979909,5341,223,415968,4311,092,7801,430,8721,168,4041,235,6521,671,4181,321,5821,350,8272,821,39716,037,290
33
Total operating cashflow
-78,619-19,847-251,174-21,975-43,485-363,145-80,190-121,570-375,120-92,126-219,577-1,026,046-2,692,876-100,988-16,060-302,490-17,201-108,780-285,00616,14151,028-278,765121,10280,005-1,331,347-2,172,361
34
35
BANK BALANCE ($)
36
Starting bank balance
500,0005,421,3815,401,5335,150,3595,128,3845,084,8994,721,7544,641,5644,519,9944,144,8744,052,7483,833,1712,807,1242,706,1362,690,0762,387,5862,370,3852,261,6051,976,5991,992,7402,043,7681,765,0031,886,1061,966,110
37
Cash from financing
5,000,000000000000005,000,0000000000000000
38
Cash from operations
-78,619-19,847-251,174-21,975-43,485-363,145-80,190-121,570-375,120-92,126-219,577-1,026,046-2,692,876-100,988-16,060-302,490-17,201-108,780-285,00616,14151,028-278,765121,10280,005-1,331,347-2,172,361
39
Ending bank balance
5,421,3815,401,5335,150,3595,128,3845,084,8994,721,7544,641,5644,519,9944,144,8744,052,7483,833,1712,807,1242,706,1362,690,0762,387,5862,370,3852,261,6051,976,5991,992,7402,043,7681,765,0031,886,1061,966,110634,763
40
41
Template created by Christoph Janz of Point Nine Capital.
Transposed to Google spreadsheet by Antoine Perdaens of Knowledge Plaza
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
Chargement en cours...
 
 
 
Summary
Revenues
Costs
Sales Team Hiring Plan
All charts on one page