Discounted Cash Flow (DCF) Analysis Unlevered

CNIM Groupe SA (COM.PA)

7.46 €

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: -857.01 | 7.46 | overvalue

Operating Data

Year
A/P
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Revenue 539.86634.94689.77588.39632.89663.13694.82728.02762.81799.26
Revenue (%)
EBITDA 70.8116.0742.46-88.30-66.38-4.90-5.13-5.38-5.63-5.90
EBITDA (%)
EBIT 57.3627.4135.38-181.02-117.32-38.77-40.62-42.56-44.60-46.73
EBIT (%)
Depreciation 13.45-11.347.0992.7250.9433.8735.4937.1938.9640.83
Depreciation (%)

Balance Sheet Data

Year
A/P
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Total Cash 183.70146.6185.98100.55143.10144.94151.86159.12166.72174.69
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 24.4828.9219.2222.7824.2625.9727.2128.5129.8731.30
Inventories (%)
Accounts Payable 118.50137.68186.33156.81150.97160.68168.36176.40184.83193.66
Accounts Payable (%)
Capital Expenditure -21.26-25.08-22.41-22.99-22.54-24.68-25.86-27.09-28.39-29.74
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 7.46
Beta 0.966
Diluted Shares Outstanding 2.82
Cost of Debt
Tax Rate -2.92
After-tax Cost of Debt 3.32%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.123
Total Debt 250.89
Total Equity 21.07
Total Capital 271.96
Debt Weighting 92.25
Equity Weighting 7.75
Wacc

Build Up Free Cash

Year
A/P
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Revenue 539.86634.94689.77588.39632.89663.13694.82728.02762.81799.26
EBITDA 70.8116.0742.46-88.30-66.38-4.90-5.13-5.38-5.63-5.90
EBIT 57.3627.4135.38-181.02-117.32-38.77-40.62-42.56-44.60-46.73
Tax Rate -136.47%9.02%-14.29%-8.16%-2.92%-30.56%-30.56%-30.56%-30.56%-30.56%
EBIAT 135.6324.9440.43-195.79-120.75-50.62-53.04-55.57-58.23-61.01
Depreciation 13.45-11.347.0992.7250.9433.8735.4937.1938.9640.83
Accounts Receivable ----------
Inventories --4.449.70-3.56-1.48-1.70-1.24-1.30-1.36-1.43
Accounts Payable -19.1848.64-29.51-5.849.717.688.048.438.83
Capital Expenditure -21.27-25.08-22.41-22.99-22.54-24.68-25.86-27.09-28.39-29.74
UFCF 127.823.2683.45-159.13-99.68-33.42-36.97-38.73-40.58-42.52
WACC
PV UFCF -32.23-34.38-34.74-35.11-35.48
SUM PV UFCF -171.94

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 3.69
Free cash flow (t + 1) -43.37
Terminal Value -2,566.42
Present Value of Terminal Value -2,141.14

Intrinsic Value

Enterprise Value -2,313.07
Net Debt 107.79
Equity Value -2,420.86
Shares Outstanding 2.82
Equity Value Per Share -857.01