A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ask us about other free templates ⬇️ | 💡 YOUR RESULTS | ||||||||||
2 | https://hubs.la/Q01C4Rhb0 | Total actual company value | USD | 10,377,044 | ||||||||
3 | Hardware part value | USD | 4,261,508 | |||||||||
4 | Software part value | USD | 6,115,536 | |||||||||
5 | ||||||||||||
6 | Year 0 (Actual) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
7 | ||||||||||||
8 | Hardware part of the business inputs | |||||||||||
9 | Total Hardware Revenue | USD | 3,151,379 | 9,259,816 | 7,874,960 | 11,115,895 | 13,339,074 | 16,006,889 | ✍️ | |||
10 | Contribution margin | USD | 571,171 | 1,489,964 | 907,448 | 723,244 | 867,893 | 1,041,471 | ✍️ | |||
11 | OPEX for hardware part | USD | 768,521 | 1,162,591 | 703,246 | 838,580 | 946,365 | 1,065,122 | ✍️ | |||
12 | Discounted revenue | USD | 3,151,379 | 8,287,535 | 6,308,040 | 7,969,178 | 8,558,897 | 9,192,256 | ||||
13 | Revenue growth rate | % | 163% | -24% | 26% | 7% | 7% | |||||
14 | EBITDA | USD | -197,350 | 327,373 | 204,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 Revenue | USD | 766,213 | 1,609,430 | 2,933,146 | 5,062,883 | 7,088,036 | 9,923,251 | ✍️ | |||
20 | Contribution margin | USD | 590,435 | 1,252,551 | 2,187,911 | 3,723,839 | 5,213,375 | 7,298,724 | ✍️ | |||
21 | OPEX for software part | USD | 599,608 | 864,059 | 1,891,636 | 2,316,845 | 2,682,374 | 3,107,928 | ✍️ | |||
22 | Discounted revenue | USD | 766,213 | 1,440,440 | 2,349,523 | 3,629,669 | 4,547,975 | 5,698,613 | ||||
23 | Revenue growth rate | % | 110% | 82% | 73% | 40% | 40% | |||||
24 | EBITDA | USD | -9,173 | 388,492 | 296,275 | 1,406,994 | 2,531,000 | 4,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 ratios | Hardware Ratios | Software Ratios | |||||||||
30 | EV/Sales | num | 1.10 | 3.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 | Calculations | Hardware | Software | Total | ||||||||
37 | EV (based on EV/Sales) | 3,466,517 | 2,911,609 | 6,378,126 | ||||||||
38 | Rule of 40 ratio | 1.23 | 2.10 | 1.63 | ||||||||
39 | rule of 40 adjusted | 4,261,508 | 6,115,536 | 10,377,044 | ||||||||
40 |