Discounted Cash Flow (DCF) Analysis Levered
Caisse régionale de Crédit Agricole... (CRLO.PA)
54.15 €
-0.34 (0.00%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 0.40 | 608.69 | 575.97 | 603.45 | 637.87 | 245,455.13 | 94,452,196.60 | 36,345,613,737.98 | 13,985,949,353,159.37 | 5,381,853,797,249,768 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 0.03 | 105.01 | 101.50 | 144.03 | 345.54 | 59,687.11 | 22,967,859.42 | 8,838,131,635.44 | 3,400,951,276,291.32 | 1,308,700,759,482,960.50 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -0.02 | -14.59 | -22.50 | -27.97 | -12.97 | -8,352.25 | -3,213,980.62 | -1,236,753,642.57 | -475,908,150,350.07 | -183,131,514,452,758.22 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 0.02 | 90.41 | 79 | 116.05 | 332.57 | 51,334.87 | 19,753,878.80 | 7,601,377,992.86 | 2,925,043,125,941.25 | 1,125,569,245,030,202.25 |
Weighted Average Cost Of Capital
Share price | $ 54.15 |
---|---|
Beta | 0.537 |
Diluted Shares Outstanding | 8.10 |
Cost of Debt | |
Tax Rate | 19.68 |
After-tax Cost of Debt | 3.50% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 6.891 |
Total Debt | 7,670.52 |
Total Equity | 438.76 |
Total Capital | 8,109.28 |
Debt Weighting | 94.59 |
Equity Weighting | 5.41 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 0.40 | 608.69 | 575.97 | 603.45 | 637.87 | 245,455.13 | 94,452,196.60 | 36,345,613,737.98 | 13,985,949,353,159.37 | 5,381,853,797,249,768 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 0.03 | 105.01 | 101.50 | 144.03 | 345.54 | 59,687.11 | 22,967,859.42 | 8,838,131,635.44 | 3,400,951,276,291.32 | 1,308,700,759,482,960.50 |
Capital Expenditure | -0.02 | -14.59 | -22.50 | -27.97 | -12.97 | -8,352.25 | -3,213,980.62 | -1,236,753,642.57 | -475,908,150,350.07 | -183,131,514,452,758.22 |
Free Cash Flow | 0.02 | 90.41 | 79 | 116.05 | 332.57 | 51,334.87 | 19,753,878.80 | 7,601,377,992.86 | 2,925,043,125,941.25 | 1,125,569,245,030,202.25 |
WACC | ||||||||||
PV LFCF | 49,512.80 | 18,376,483.45 | 6,820,361,019.46 | 2,531,350,710,696.79 | 939,501,061,931,955.25 | |||||
SUM PV LFCF | 942,039,251,429,667.75 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 3.68 |
Free cash flow (t + 1) | 1,148,080,629,930,806.25 |
Terminal Value | 68,338,132,733,976,568 |
Present Value of Terminal Value | 57,041,135,903,011,576 |
Intrinsic Value
Enterprise Value | 57,983,175,154,441,240 |
---|---|
Net Debt | 7,596.89 |
Equity Value | 57,983,175,154,433,640 |
Shares Outstanding | 8.10 |
Equity Value Per Share | 7,156,047,238,980,086.00 |