Discounted Cash Flow (DCF) Analysis Unlevered

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

$56.53

+0.02 (+0.04%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 56.53 | undervalue

Operating Data

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 (%)
EBITDA 26,16721,85322,84021,17713,83625,254.1526,011.2726,791.0927,594.2828,421.56
EBITDA (%)
EBIT 18,16213,73514,36411,8694,93215,132.7115,586.3916,053.6716,534.9617,030.68
EBIT (%)
Depreciation 8,0058,1188,4769,3088,90410,121.4310,424.8710,737.4111,059.3211,390.88
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 16,12211,02813,91311,95211,55615,282.4715,740.6416,212.5416,698.6017,199.22
Total Cash (%)
Account Receivables 11,22910,79110,86811,70710,50413,044.8013,435.8813,838.6914,253.5714,680.90
Account Receivables (%)
Inventories 2,8402,5102,8722,9413,6963,487.513,592.073,699.763,810.683,924.92
Inventories (%)
Accounts Payable 6,6545,8516,0786,1206,5137,361.767,582.467,809.798,043.928,285.08
Accounts Payable (%)
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 (%)

Weighted Average Cost Of Capital

Share price $ 56.53
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 9.005
Total Debt -
Total Equity 142,820.28
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash

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
EBITDA 26,16721,85322,84021,17713,83625,254.1526,011.2726,791.0927,594.2828,421.56
EBIT 18,16213,73514,36411,8694,93215,132.7115,586.3916,053.6716,534.9617,030.68
Tax Rate 27.31%45.47%26.10%25.77%41.89%33.31%33.31%33.31%33.31%33.31%
EBIAT 13,201.827,489.0410,615.708,810.182,866.1410,092.3410,394.9110,706.5511,027.5311,358.14
Depreciation 8,0058,1188,4769,3088,90410,121.4310,424.8710,737.4111,059.3211,390.88
Accounts Receivable -438-77-8391,203-2,540.80-391.08-402.81-414.88-427.32
Inventories -330-362-69-755208.49-104.56-107.69-110.92-114.24
Accounts Payable --80322742393848.76220.71227.32234.14241.16
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
UFCF 10,617.824,817.047,969.704,185.18-2,688.864,504.515,892.656,069.316,251.276,438.68
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) 6,567.45
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 -