ABCDEFGHIJKL
1
ask us about other free templates ⬇️💡 YOUR RESULTS
2
https://hubs.la/Q01C4Rhb0Total actual company valueUSD10,377,044
3
Hardware part valueUSD4,261,508
4
Software part valueUSD6,115,536
5
6
Year 0 (Actual)Year 1Year 2Year 3Year 4Year 5
7
8
Hardware part of the business inputs
9
Total Hardware RevenueUSD3,151,3799,259,8167,874,96011,115,89513,339,07416,006,889✍️
10
Contribution marginUSD571,1711,489,964907,448723,244867,8931,041,471✍️
11
OPEX for hardware partUSD768,5211,162,591703,246838,580946,3651,065,122✍️
12
Discounted revenueUSD3,151,3798,287,5356,308,0407,969,1788,558,8979,192,256
13
Revenue growth rate%163%-24%26%7%7%
14
EBITDAUSD-197,350327,373204,202-115,336-78,472-23,650
15
EBITDA margin rate%-6.26%3.54%2.59%-1.04%-0.59%-0.15%
16
Rule of 40%166.52%-21.29%25.30%6.81%7.25%
17
18
Software part of the business inputs
19
Total Software RevenueUSD766,2131,609,4302,933,1465,062,8837,088,0369,923,251✍️
20
Contribution marginUSD590,4351,252,5512,187,9113,723,8395,213,3757,298,724✍️
21
OPEX for software partUSD599,608864,0591,891,6362,316,8452,682,3743,107,928✍️
22
Discounted revenueUSD766,2131,440,4402,349,5233,629,6694,547,9755,698,613
23
Revenue growth rate%110%82%73%40%40%
24
EBITDAUSD-9,173388,492296,2751,406,9942,531,0004,190,796
25
EBITDA margin%-1.20%24.14%10.10%27.79%35.71%42.23%
26
Rule of 40%134.19%92.35%100.40%75.71%82.23%
27
28
29
Market ratiosHardware RatiosSoftware Ratios
30
EV/Salesnum1.103.80 ✍️
31
EBITDA margin%10.40%24.02% ✍️
32
Expected revenue growth rate%19.63%22.15% ✍️
33
Rule of 40%30.03%46.17%
34
Discount rate (S&P 500)%10.50%10.50%
35
36
CalculationsHardwareSoftwareTotal
37
EV (based on EV/Sales)3,466,5172,911,6096,378,126
38
Rule of 40 ratio1.232.101.63
39
rule of 40 adjusted4,261,5086,115,53610,377,044
40