Discounted Cash Flow (DCF) Analysis Unlevered

Well SA (MLKRI.PA)

3.34 €

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 3.34 | undervalue

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 9.0532.8150.24302.32569.141,857.716,063.7119,792.4664,604.22210,873.56
Revenue (%)
EBITDA -1.79-4.68-4.7635.2780.22-65.80-214.78-701.06-2,288.33-7,469.31
EBITDA (%)
EBIT -1.81-6.83-9.35-3.4425.01-208.55-680.72-2,221.92-7,252.53-23,672.85
EBIT (%)
Depreciation 0.022.164.5938.7155.20142.75465.941,520.854,964.1916,203.54
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 2.3315.6486.8961.9248.911,023.563,34110,905.3035,595.80116,187.64
Total Cash (%)
Account Receivables 1.042.248.9466.5479.48267.72873.852,852.329,310.2030,389.28
Account Receivables (%)
Inventories -0.081.270.791.3715.2049.60161.90528.441,724.87
Inventories (%)
Accounts Payable 1.703.027.4238.7150.73239.58782.012,552.568,331.7727,195.60
Accounts Payable (%)
Capital Expenditure -0.13-0.47-1.13-52.47-6.61-87.88-286.86-936.34-3,056.29-9,975.97
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 3.34
Beta 0.727
Diluted Shares Outstanding 220.69
Cost of Debt
Tax Rate 92.19
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.643
Total Debt -
Total Equity 737.11
Total Capital -
Debt Weighting -
Equity Weighting -
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 9.0532.8150.24302.32569.141,857.716,063.7119,792.4664,604.22210,873.56
EBITDA -1.79-4.68-4.7635.2780.22-65.80-214.78-701.06-2,288.33-7,469.31
EBIT -1.81-6.83-9.35-3.4425.01-208.55-680.72-2,221.92-7,252.53-23,672.85
Tax Rate 0.00%-0.77%51.07%-73.35%92.19%13.83%13.83%13.83%13.83%13.83%
EBIAT -1.81-6.89-4.58-5.961.95-179.71-586.60-1,914.71-6,249.76-20,399.73
Depreciation 0.022.164.5938.7155.20142.75465.941,520.854,964.1916,203.54
Accounts Receivable --1.20-6.69-57.60-12.94-188.23-606.13-1,978.47-6,457.89-21,079.08
Inventories ---1.190.48-0.58-13.83-34.40-112.30-366.54-1,196.43
Accounts Payable -1.324.4031.2912.02188.85542.431,770.555,779.2118,863.83
Capital Expenditure -0.13-0.47-1.14-52.48-6.62-87.88-286.86-936.34-3,056.29-9,975.97
UFCF -1.92-5.09-4.60-45.5649.04-138.06-505.63-1,650.41-5,387.07-17,583.85
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) -17,935.53
Terminal Value -
Present Value of Terminal Value -

Intrinsic Value

Enterprise Value -
Net Debt -48.91
Equity Value -
Shares Outstanding 220.69
Equity Value Per Share -