Discounted Cash Flow (DCF) Analysis Levered

Columbia Large Cap Index Fund Insti... (CLXRX)

$57.09

+0.46 (+0.81%)
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 91,42585,68979,59083,959100,662103,679.85106,788.18109,989.70113,287.19116,683.55
Revenue (%)
Operating Cash Flow 23,95121,34522,37417,80612,73423,447.6324,150.5924,874.6325,620.3726,388.47
Operating Cash Flow (%)
Capital Expenditure -10,589-10,755-10,910-13,067-15,300-14,225.72-14,652.20-15,091.48-15,543.92-16,009.93
Capital Expenditure (%)
Free Cash Flow 13,36210,59011,4644,739-2,5669,221.919,498.399,783.1510,076.4510,378.54

Weighted Average Cost Of Capital

Share price $ 57.09
Beta 1.000
Diluted Shares Outstanding 2,526.45
Cost of Debt
Tax Rate 41.89
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.879
Total Debt -
Total Equity 144,235.09
Total Capital -
Debt Weighting -
Equity Weighting -
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 91,42585,68979,59083,959100,662103,679.85106,788.18109,989.70113,287.19116,683.55
Operating Cash Flow 23,95121,34522,37417,80612,73423,447.6324,150.5924,874.6325,620.3726,388.47
Capital Expenditure -10,589-10,755-10,910-13,067-15,300-14,225.72-14,652.20-15,091.48-15,543.92-16,009.93
Free Cash Flow 13,36210,59011,4644,739-2,5669,221.919,498.399,783.1510,076.4510,378.54
WACC
PV LFCF -----
SUM PV LFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt -4,251
Equity Value -
Shares Outstanding 2,526.45
Equity Value Per Share -