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

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBN
1
2
FilterJan.-18Feb.-18März-18Apr.-18Mai-18Juni-18Juli-18Aug.-18Sept.-18Okt.-18Nov.-18Dez.-18Jan.-19Feb.-19März-19Apr.-19Mai-19Juni-19Juli-19Aug.-19Sept.-19Okt.-19Nov.-19Dez.-19Jan.-20Feb.-20März-20Apr.-20Mai-20Juni-20Juli-20Aug.-20Sept.-20Okt.-20Nov.-20Dez.-20Jan.-21Feb.-21März-21Apr.-21Mai-21Juni-21Juli-21Aug.-21Sept.-21Okt.-21Nov.-21Dez.-21Jan.-22Feb.-22März-22Apr.-22Mai-22Juni-22Juli-22Aug.-22Sept.-22Okt.-22Nov.-22Dez.-22
3
4
Revenue
5
6
Total
Revenue
 60.000 € 60.300 € 60.567 € 60.841 € 80.727 € 103.787 € 130.238 € 159.963 € 193.012 € 229.418 € 269.210 € 312.406 € 359.013 € 409.032 € 462.456 € 539.048 € 602.552 € 669.453 € 779.272 € 899.041 € 1.028.809 € 1.148.846 € 1.354.731 € 1.580.558 € 1.786.903 € 2.006.794 € 2.240.188 € 2.566.096 € 2.839.484 € 3.126.286 € 3.426.358 € 3.739.511 € 4.065.551 € 4.325.202 € 4.584.110 € 4.841.887 € 5.098.155 € 5.352.591 € 5.604.912 € 5.854.852 € 6.102.183 € 6.346.709 € 6.588.266 € 6.826.714 € 7.061.937 € 7.293.841 € 7.522.349 € 7.747.400 € 7.968.950 € 8.186.965 € 8.401.425 € 8.612.316 € 8.819.636 € 9.023.391 € 9.223.592 € 9.420.256 € 9.613.407 € 9.803.071 € 9.989.280 € 10.172.068 €
7
8
SaaS
SaaS: MRR
 60.000 € 60.300 € 60.414 € 60.367 € 63.446 € 69.720 € 79.241 € 92.046 € 108.160 € 127.596 € 150.356 € 176.436 € 205.822 € 238.497 € 274.437 € 316.876 € 362.568 € 411.464 € 470.039 € 538.342 € 616.391 € 700.914 € 804.887 € 928.426 € 1.065.055 € 1.214.673 € 1.377.161 € 1.565.442 € 1.766.512 € 1.980.159 € 2.206.165 € 2.444.316 € 2.694.396 € 2.943.135 € 3.190.121 € 3.435.002 € 3.677.479 € 3.917.303 € 4.154.262 € 4.388.182 € 4.618.919 € 4.846.358 € 5.070.407 € 5.290.995 € 5.508.068 € 5.721.589 € 5.931.534 € 6.137.892 € 6.340.660 € 6.539.847 € 6.735.467 € 6.927.541 € 7.116.096 € 7.301.164 € 7.482.780 € 7.660.984 € 7.835.817 € 8.007.324 € 8.175.551 € 8.340.545 €
9
SaaSBasic 15.000 € 13.200 € 11.616 € 10.222 € 10.147 € 11.234 € 13.342 € 16.349 € 20.147 € 24.641 € 29.748 € 35.394 € 41.515 € 48.053 € 54.959 € 63.340 € 71.867 € 80.523 € 91.596 € 104.797 € 119.869 € 135.437 € 156.048 € 181.099 € 207.751 € 235.813 € 265.115 € 300.117 € 335.527 € 371.296 € 407.380 € 443.743 € 480.350 € 512.564 € 540.912 € 565.859 € 587.812 € 607.130 € 624.131 € 639.091 € 652.256 € 663.841 € 674.036 € 683.008 € 690.903 € 697.851 € 703.965 € 709.345 € 714.079 € 718.246 € 721.912 € 725.139 € 727.978 € 730.477 € 732.676 € 734.611 € 736.313 € 737.812 € 739.130 € 740.291 €
10
SaaSPro 20.000 € 22.600 € 24.788 € 26.615 € 29.280 € 33.027 € 38.070 € 44.585 € 52.723 € 62.610 € 74.350 € 88.028 € 103.715 € 121.463 € 141.317 € 164.458 € 189.965 € 217.819 € 250.303 € 287.809 € 330.660 € 377.972 € 434.364 € 500.663 € 575.253 € 658.290 € 749.887 € 854.728 € 969.081 € 1.092.837 € 1.225.879 € 1.368.086 € 1.519.329 € 1.674.868 € 1.833.739 € 1.995.103 € 2.158.229 € 2.322.483 € 2.487.315 € 2.652.251 € 2.816.880 € 2.980.849 € 3.143.857 € 3.305.643 € 3.465.988 € 3.624.704 € 3.781.636 € 3.936.653 € 4.089.645 € 4.240.524 € 4.389.218 € 4.535.672 € 4.679.843 € 4.821.698 € 4.961.215 € 5.098.382 € 5.233.192 € 5.365.647 € 5.495.752 € 5.623.519 €
11
SaaS
Enterprise
 25.000 € 24.500 € 24.010 € 23.530 € 24.019 € 25.459 € 27.830 € 31.113 € 35.291 € 40.345 € 46.258 € 53.013 € 60.593 € 68.981 € 78.161 € 89.078 € 100.736 € 113.122 € 128.139 € 145.736 € 165.862 € 187.504 € 214.474 € 246.665 € 282.052 € 320.571 € 362.159 € 410.596 € 461.904 € 516.026 € 572.905 € 632.487 € 694.718 € 755.703 € 815.469 € 874.040 € 931.439 € 987.690 € 1.042.816 € 1.096.840 € 1.149.783 € 1.201.668 € 1.252.514 € 1.302.344 € 1.351.177 € 1.399.034 € 1.445.933 € 1.491.894 € 1.536.936 € 1.581.078 € 1.624.336 € 1.666.729 € 1.708.275 € 1.748.989 € 1.788.889 € 1.827.992 € 1.866.312 € 1.903.866 € 1.940.668 € 1.976.735 €
12
13
SaaS
SaaS: Setup revenues
 - € - € - € - € 16.512 € 33.024 € 49.536 € 66.048 € 82.560 € 99.072 € 115.584 € 132.096 € 148.608 € 165.120 € 181.632 € 214.656 € 231.168 € 247.680 € 297.216 € 346.752 € 396.288 € 429.312 € 528.384 € 627.456 € 693.504 € 759.552 € 825.600 € 957.696 € 1.023.744 € 1.089.792 € 1.155.840 € 1.221.888 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 € 1.287.936 €
14
SaaSBasic - € - € - € - € 6.912 € 13.824 € 20.736 € 27.648 € 34.560 € 41.472 € 48.384 € 55.296 € 62.208 € 69.120 € 76.032 € 89.856 € 96.768 € 103.680 € 124.416 € 145.152 € 165.888 € 179.712 € 221.184 € 262.656 € 290.304 € 317.952 € 345.600 € 400.896 € 428.544 € 456.192 € 483.840 € 511.488 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 € 539.136 €
15
SaaSPro - € - € - € - € 5.760 € 11.520 € 17.280 € 23.040 € 28.800 € 34.560 € 40.320 € 46.080 € 51.840 € 57.600 € 63.360 € 74.880 € 80.640 € 86.400 € 103.680 € 120.960 € 138.240 € 149.760 € 184.320 € 218.880 € 241.920 € 264.960 € 288.000 € 334.080 € 357.120 € 380.160 € 403.200 € 426.240 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 € 449.280 €
16
SaaS
Enterprise
 - € - € - € - € 3.840 € 7.680 € 11.520 € 15.360 € 19.200 € 23.040 € 26.880 € 30.720 € 34.560 € 38.400 € 42.240 € 49.920 € 53.760 € 57.600 € 69.120 € 80.640 € 92.160 € 99.840 € 122.880 € 145.920 € 161.280 € 176.640 € 192.000 € 222.720 € 238.080 € 253.440 € 268.800 € 284.160 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 € 299.520 €
17
18
Marketplace
Marketplace: Revenue
- € - € 153 € 474 € 769 € 1.043 € 1.461 € 1.868 € 2.292 € 2.751 € 3.270 € 3.874 € 4.582 € 5.414 € 6.387 € 7.516 € 8.815 € 10.309 € 12.017 € 13.947 € 16.131 € 18.621 € 21.460 € 24.676 € 28.344 € 32.569 € 37.426 € 42.959 € 49.228 € 56.335 € 64.353 € 73.307 € 83.219 € 94.131 € 106.054 € 118.949 € 132.740 € 147.352 € 162.714 € 178.734 € 195.327 € 212.415 € 229.922 € 247.783 € 265.933 € 284.316 € 302.879 € 321.573 € 340.354 € 359.182 € 378.022 € 396.839 € 415.605 € 434.292 € 452.876 € 471.336 € 489.654 € 507.811 € 525.793 € 543.587 €
19
20
21
22
23
24
Leads, Demos, Trials & Customers
25
26
SaaS
SaaS: Leads, Demos & Trials
27
SaaS
New Leads
0002040608010012014016018020022026028030036042048052064076084092010001160124013201400148015601560156015601560156015601560156015601560156015601560156015601560156015601560156015601560156015601560156015601560
28
SaaS
New Demos
00016324864809611212814416017620822424028833638441651260867273680092899210561120118412481248124812481248124812481248124812481248124812481248124812481248124812481248124812481248124812481248124812481248
29
SaaS
New Trials
00013263851647790102115128141166179192230269307333410486538589640742794845896947998998998998998998998998998998998998998998998998998998998998998998998998998998998998998
30
SaaS
31
SaaS
Sales Funnel Conversion Rate
19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%19%
32
33
SaaS
SaaS: New Customers
000048121519232731353842505458698192100123146161177192223238253269284300300300300300300300300300300300300300300300300300300300300300300300300300300300300
34
SaaSBasic000025791214161821232530323541485560748897106115134143152161170180180180180180180180180180180180180180180180180180180180180180180180180180180180180
35
SaaS
% New Costumers
60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%60%
36
SaaSPro000012356789101213151617212428303744485358677176818590909090909090909090909090909090909090909090909090909090
37
SaaS
% New Costumers
30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%30%
38
SaaS
Enterprise
000001122233344556789101215161819222425272830303030303030303030303030303030303030303030303030303030
39
SaaS
% New Costumers
10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%
40
41
SaaS
SaaS: Total Customers
6059585659667690107128152180211245282327374424485556637724832962110412581425161918252042227025092758300232423476370639324153436945814789499351935388558057685952613363096483665368196982714272997452760377507895
42
SaaSBasic3026232020222733404959718396110127144161183210240271312362416472530600671743815887961102510821132117612141248127813051328134813661382139614081419142814361444145014561461146514691473147614781481
43
SaaSPro2023252729333845536374881041211411641902182502883313784345015756587508559691093122613681519167518341995215823222487265228172981314433063466362537823937409042414389453646804822496150985233536654965624
44
SaaS
Enterprise
10101091010111214161921242831364045515866758699113128145164185206229253278302326350373395417439460481501521540560578597615632650667683700716731747762776791
45
46
Marketplace
Marketplace: New Customers
0001111111222334455678911121416182124273134384347515660646973778186909498102105109113117120124127131134137140
47
Marketplace
Via SaaS Basic
00000000000011111112222334455677891010111112121213131313141414141414141415151515151515
48
Marketplace
Conversion Rate
1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%
49
Marketplace
Via SaaS Pro
000000111111112223344567891012131517192225273033374043465053566063666972767982858891949699102105
50
Marketplace
Conversion Rate
2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%2%
51
Marketplace
Via SaaS Enterprise
00000000000000001111111122223334456678891010111213131414151616171718181919202021
52
Marketplace
Conversion Rate
3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%
53
54
Marketplace
Marketplace: Total Customers
0000112334567810111316182225293338445158677788101115131149169190213238264292321350381412445477510543577611645678712746780813846879912944
55
56
57
58
59
60
Churn, Contract Up-/Downselling, Retention
61
62
SaaS
SaaS: Churned Costumers
111111222334456778101113141719222528323641455055606570747983879296100104108112115119123126130133136140143146149152155158
63
SaaSBasic1100001111112223334455678911121315161819212223242425262627272728282828292929292929292929303030
64
SaaSPro000111111112223344567891012131517192225273033374043465053566063666972767982858891949699102105107110112
65
SaaS
Enterprise
0000000000000111111112222333445566777889910101011111212121313131414141515151616
66
67
SaaS
SaaS: Contract Downselling
000000000000000000000000000000000000000000000000000000000000
68
SaaS
Enterprise to Pro
000000000000000000000000000000000000000000000000000000000000
69
SaaS
Enterprise to Basic
000000000000000000000000000000000000000000000000000000000000
70
SaaS
Pro to Basic
000000000000000000000000000000000000000000000000000000000000
71
72
SaaS
SaaS: Contract Upselling
33222233456781011131416182124273136424753606774818996103108113118121125128130133135137138140141142143144144145146146147147147148148148
73
SaaS
Basic to Pro
33222233456781011131416182124273136424753606774818996103108113118121125128130133135137138140141142143144144145146146147147147148148148
74
SaaS
Basic to Enterprise
000000000000000000000000000000000000000000000000000000000000
75
SaaS
Pro to Enterprise
000000000000000000000000000000000000000000000000000000000000
76
77
Marketplace
Marketplace: Monthly Retention Rate
90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%90%
78
79
80
81
82
83
Headcount, Personnel Cost, COGS, Other Costs
84
85
Total
Headcount total
992323232425264244464952707378109115121129190198209222236306322342363385408433458483508532556579602625647669690711732752772791810829847866884901918935951967983998
86
Total
Top Management
333333333333333333333333333333333333333333333333333333333333
87
Total
Sales Team
0066666612121212121818183030303054545454547878787878787878787878787878787878787878787878787878787878787878787878
88
Total
Customer Success Managers
6666678911131518212528333743495765738497111128144164185207230255280305330354378401424447469491512533554574594613632651669688706723740757773789805820
89
Total
Development Team
0066666612121212121818183030303054545454547878787878787878787878787878787878787878787878787878787878787878787878
90
Total
Management Support & Admin
00111111222223335555999991313131313131313131313131313131313131313131313131313131313131313131313
91
92
SaaS
SaaS: Headcount
99171717181920303234374052556079849098135143154167181226242262282304327351376400424448471493515537558579599619639658677695713731748765782798814830845860875889
93
SaaS
Top Management
333333333333333333333333333333333333333333333333333333333333
94
SaaS
Sales Team
00333333666669991515151527272727273939393939393939393939393939393939393939393939393939393939393939393939
95
SaaS
Customer Success Managers
6666678911131518212528333742485664728396110126142162182204227251276300324348371393415437458479499519539558577595613631648665682698714730745760775789
96
SaaS
Development Team
00333333666669991515151527272727273939393939393939393939393939393939393939393939393939393939393939393939
97
SaaS
Management Support & Admin
00111111222223335555999991313131313131313131313131313131313131313131313131313131313131313131313
98
99
Marketplace
Marketplace: Headcount
0066666612121212121818183031313155555555558080808181818282838484858687888990919293949596979899101102103104105106107108109
100
Marketplace
Sales Team
00333333666669991515151527272727273939393939393939393939393939393939393939393939393939393939393939393939
Loading...