SaaS Financial Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPRSTUVWXYZAAABACADAEAFAGAHAI
1
RevenueJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17YTDYTDYTD
2
ForecastActualBudget
New Forecast
3
2017 Budget $20,000 $23,500 $27,000 $30,500 $34,000 $37,500 $41,000 $44,500 $48,000 $51,500 $55,000 $58,500 $471,000
4
Jan-17$15,000 $15,000 $15,000 $20,000
5
Feb-17$20,000 $35,000 $35,000 $43,500 $35,000
6
Mar-17$25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $285,000 $60,000 $70,500 $60,000
7
Apr-17 #VALUE!#VALUE! $101,000 $85,000
8
May-17 #VALUE!#VALUE! $135,000 $110,000
9
Jun-17 #VALUE!#VALUE! $172,500 $135,000
10
Jul-17 #VALUE!#VALUE! $213,500 $160,000
11
Aug-17 #VALUE!#VALUE! $258,000 $185,000
12
Sep-17 #VALUE!#VALUE! $306,000 $210,000
13
Oct-17 #VALUE!#VALUE! $357,500 $235,000
14
Nov-17 #VALUE!#VALUE! $412,500 $260,000
15
Dec-17 #VALUE!#VALUE! $471,000 $285,000
16
Actuals$15,000 $20,000 $25,000
17
New Forecast $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
18
19
Gross BurnJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17YTDYTDYTD
20
ForecastActualBudget
New Forecast
21
2017 Budget $25,000 $30,000 $35,000 $40,000 $45,000 $47,500 $50,000 $52,500 $55,000 $57,500 $60,000 $62,500 $560,000
22
Jan-17$23,593 $23,593 $23,593 $25,000
23
Feb-17$33,677 $57,270 $57,270 $55,000 $57,270
24
Mar-17$43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $492,870 $100,830 $90,000 $100,830
25
Apr-17 #VALUE!#VALUE! $130,000 $144,390
26
May-17 #VALUE!#VALUE! $175,000 $187,950
27
Jun-17 #VALUE!#VALUE! $222,500 $231,510
28
Jul-17 #VALUE!#VALUE! $272,500 $275,070
29
Aug-17 #VALUE!#VALUE! $325,000 $318,630
30
Sep-17 #VALUE!#VALUE! $380,000 $362,190
31
Oct-17 #VALUE!#VALUE! $437,500 $405,750
32
Nov-17 #VALUE!#VALUE! $497,500 $449,310
33
Dec-17 #VALUE!#VALUE! $560,000 $492,870
34
Actuals$23,593 $33,677 $43,560
35
New Forecast $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560 $43,560
36
37
Net IncomeJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17YTDYTDYTD
38
ForecastActualBudget
New Forecast
39
2017 Budget $(5,000) $(6,500) $(8,000) $(9,500) $(11,000) $(10,000) $(9,000) $(8,000) $(7,000) $(6,000) $(5,000) $(4,000) $(89,000)
40
Jan-17($8,593) $(8,593) $(8,593) $(5,000)
41
Feb-17($13,677) $(22,270) $(22,270) $(11,500) $(22,270)
42
Mar-17($18,560)($18,560)($18,560)($18,560)($18,560)($18,560)($18,560)($18,560)($18,560)($18,560) $(207,870) $(40,830) $(19,500) $(40,830)
43
Apr-17 #VALUE!#VALUE! $(29,000) $(59,390)
44
May-17 #VALUE!#VALUE! $(40,000) $(77,950)
45
Jun-17 #VALUE!#VALUE! $(50,000) $(96,510)
46
Jul-17 #VALUE!#VALUE! $(59,000) $(115,070)
47
Aug-17 #VALUE!#VALUE! $(67,000) $(133,630)
48
Sep-17 #VALUE!#VALUE! $(74,000) $(152,190)
49
Oct-17 #VALUE!#VALUE! $(80,000) $(170,750)
50
Nov-17 #VALUE!#VALUE! $(85,000) $(189,310)
51
Dec-17 #VALUE!#VALUE! $(89,000) $(207,870)
52
Actuals($8,593)($13,677)($18,560)
53
New Forecast $(18,560) $(18,560) $(18,560) $(18,560) $(18,560) $(18,560) $(18,560) $(18,560) $(18,560) $(18,560)
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
Loading...