Discounted Cash Flow (DCF) Analysis Levered

Similarweb Ltd. (SMWB)

$5.16

+0.08 (+1.57%)
All numbers are in Millions, Currency in USD
Stock DCF: -117.69 | 5.16 | overvalue

Free Cash Flow

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 70.5993.49137.67192.53269.24376.53526.57736.40
Revenue (%)
Operating Cash Flow -9.69-3.76-27.63-24.27-33.94-47.47-66.38-92.83
Operating Cash Flow (%)
Capital Expenditure -1.81-1.14-3.11-3.87-5.42-7.57-10.59-14.81
Capital Expenditure (%)
Free Cash Flow -11.50-4.90-30.74-28.14-39.36-55.04-76.97-107.64

Weighted Average Cost Of Capital

Share price $ 5.16
Beta 0.000
Diluted Shares Outstanding 53.20
Cost of Debt
Tax Rate -1.44
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 3.506
Total Debt -
Total Equity 274.52
Total Capital 274.52
Debt Weighting 0.00
Equity Weighting 100.00
Wacc

Build Up Free Cash Flow

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 70.5993.49137.67192.53269.24376.53526.57736.40
Operating Cash Flow -9.69-3.76-27.63-24.27-33.94-47.47-66.38-92.83
Capital Expenditure -1.81-1.14-3.11-3.87-5.42-7.57-10.59-14.81
Free Cash Flow -11.50-4.90-30.74-28.14-39.36-55.04-76.97-107.64
WACC
PV LFCF -29.13-39.36-53.17-71.84-97.06
SUM PV LFCF -271.19

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 3.51
Free cash flow (t + 1) -109.79
Terminal Value -7,271.18
Present Value of Terminal Value -6,119.18

Intrinsic Value

Enterprise Value -6,390.37
Net Debt -128.88
Equity Value -6,261.49
Shares Outstanding 53.20
Equity Value Per Share -117.69