Discounted Cash Flow (DCF) Analysis Unlevered

Caisse régionale de Crédit Agricole... (CIV.PA)

58.5 €

-0.50 (-0.85%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 58.5 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 253.71206.51264519.22286.20329.87380.20438.21505.07582.13
Revenue (%)
EBITDA 94.5342.2691.279.6660.6076.0987.69101.07116.50134.27
EBITDA (%)
EBIT 82.3930.9181.25-49.2062.9572.5583.6296.38111.08
EBIT (%)
Depreciation 12.1411.3510.019.6611.4013.1415.1417.4620.1223.19
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 484.34610.241,456.02-162.17720.30830.20956.871,102.861,271.131,465.08
Total Cash (%)
Account Receivables 339.57391.24214.46700.13385.93444.81512.68590.90681.05784.97
Account Receivables (%)
Inventories -481.07-464.50-288.10-906.33-499.59-575.81-663.67-764.93-881.64-1,016.15
Inventories (%)
Accounts Payable 50.2753.0154.0147.7953.7761.9771.4382.3394.89109.36
Accounts Payable (%)
Capital Expenditure -13.30-8.09-9.48-8.07-10.24-11.80-13.60-15.67-18.06-20.82
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 58.5
Beta 0.908
Diluted Shares Outstanding -
Cost of Debt
Tax Rate 24.02
After-tax Cost of Debt 3.80%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.571
Total Debt -
Total Equity -
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 253.71206.51264519.22286.20329.87380.20438.21505.07582.13
EBITDA 94.5342.2691.279.6660.6076.0987.69101.07116.50134.27
EBIT 82.3930.9181.25-49.2062.9572.5583.6296.38111.08
Tax Rate 23.70%32.65%24.30%15.45%24.02%24.02%24.02%24.02%24.02%24.02%
EBIAT 62.8620.8261.51-37.3847.8255.1263.5373.2284.40
Depreciation 12.1411.3510.019.6611.4013.1415.1417.4620.1223.19
Accounts Receivable --51.67176.79-485.68314.21-58.88-67.87-78.22-90.16-103.91
Inventories --16.57-176.40618.23-406.7576.2387.86101.26116.71134.52
Accounts Payable -2.750.99-6.225.988.209.4610.9012.5614.48
Capital Expenditure -13.30-8.09-9.48-8.07-10.24-11.80-13.60-15.67-18.06-20.82
UFCF 61.70-41.4263.42127.92-48.0274.7186.1199.25114.39131.85
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

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