Discounted Cash Flow (DCF) Analysis Unlevered

Merus N.V. (MRUS)

$20.72

+0.06 (+0.29%)
All numbers are in Millions, Currency in USD
Stock DCF: -16.86 | 20.72 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 35.7531.1329.9449.1129.6030.1630.7331.3131.9032.51
Revenue (%)
EBITDA -26.62-53.82-83.27-65.221.29-39.45-40.19-40.95-41.72-42.51
EBITDA (%)
EBIT -27.35-54.96-84.71-66.71--40.52-41.29-42.07-42.86-43.67
EBIT (%)
Depreciation 0.731.141.441.491.291.081.101.121.141.16
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 215.74239.76207.76410.43290.23234.28238.70243.21247.80252.48
Total Cash (%)
Account Receivables 4.862.911.756.674.053.383.453.513.583.64
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 4.373.033.1313.249.835.585.695.805.916.02
Accounts Payable (%)
Capital Expenditure -4.21-2.60-1.29-0.87-7.59-3.13-3.18-3.24-3.31-3.37
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 20.72
Beta 0.755
Diluted Shares Outstanding 38.64
Cost of Debt
Tax Rate -0.70
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.376
Total Debt 1.68
Total Equity 800.59
Total Capital 802.27
Debt Weighting 0.21
Equity Weighting 99.79
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 35.7531.1329.9449.1129.6030.1630.7331.3131.9032.51
EBITDA -26.62-53.82-83.27-65.221.29-39.45-40.19-40.95-41.72-42.51
EBIT -27.35-54.96-84.71-66.71--40.52-41.29-42.07-42.86-43.67
Tax Rate -1.49%-0.35%-0.59%-0.36%-0.70%-0.70%-0.70%-0.70%-0.70%-0.70%
EBIAT -27.76-55.15-85.21-66.95--40.81-41.58-42.36-43.16-43.98
Depreciation 0.731.141.441.491.291.081.101.121.141.16
Accounts Receivable -1.951.16-4.922.620.67-0.06-0.07-0.07-0.07
Inventories ----------
Accounts Payable --1.340.1010.11-3.40-4.250.110.110.110.11
Capital Expenditure -4.21-2.60-1.29-0.87-7.59-3.13-3.18-3.24-3.31-3.37
UFCF -31.23-56-83.80-61.14-7.08-46.44-43.62-44.45-45.28-46.14
WACC
PV UFCF -43.25-37.84-35.91-34.07-32.33
SUM PV UFCF -183.40

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 7.37
Free cash flow (t + 1) -47.06
Terminal Value -876.39
Present Value of Terminal Value -614.16

Intrinsic Value

Enterprise Value -797.56
Net Debt -146.06
Equity Value -651.50
Shares Outstanding 38.64
Equity Value Per Share -16.86