Discounted Cash Flow (DCF) Analysis Unlevered

Compagnie des Eaux de Royan (MLEDR.PA)

86.5 €

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

Operating Data

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 36.1535.5236.1637.7641.7843.364546.7048.4750.30
Revenue (%)
EBITDA 2.782.582.453.133.403.313.433.563.703.84
EBITDA (%)
EBIT 2.782.582.453.133.403.313.433.563.703.84
EBIT (%)
Depreciation ----------
Depreciation (%)

Balance Sheet Data

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash 0.080.070.220.030.190.140.140.150.150.16
Total Cash (%)
Account Receivables 30.3730.0430.5035.2637.8537.8939.3240.8142.3543.95
Account Receivables (%)
Inventories 0.290.220.280.300.440.350.360.380.390.41
Inventories (%)
Accounts Payable 2.923.122.944.455.124.254.414.584.754.93
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 86.5
Beta 0.161
Diluted Shares Outstanding 0.18
Cost of Debt
Tax Rate 31.56
After-tax Cost of Debt 3.42%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.564
Total Debt -
Total Equity 15.57
Total Capital 15.57
Debt Weighting 0.00
Equity Weighting 100.00
Wacc

Build Up Free Cash

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 36.1535.5236.1637.7641.7843.364546.7048.4750.30
EBITDA 2.782.582.453.133.403.313.433.563.703.84
EBIT 2.782.582.453.133.403.313.433.563.703.84
Tax Rate 33.45%33.33%33.88%28.85%31.56%32.21%32.21%32.21%32.21%32.21%
EBIAT 1.851.721.622.232.332.242.332.422.512.60
Depreciation ----------
Accounts Receivable -0.33-0.46-4.76-2.59-0.04-1.43-1.49-1.54-1.60
Inventories -0.07-0.06-0.02-0.140.09-0.01-0.01-0.01-0.01
Accounts Payable -0.20-0.181.510.67-0.870.160.170.170.18
Capital Expenditure ----------
UFCF 1.852.320.92-1.040.271.431.041.081.121.17
WACC
PV UFCF 1.360.950.950.940.93
SUM PV UFCF 5.13

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt -0.19
Equity Value -
Shares Outstanding 0.18
Equity Value Per Share -