Discounted Cash Flow (DCF) Analysis Unlevered

Cboe Global Markets, Inc. (CBOE)

$131.07

+1.79 (+1.38%)
All numbers are in Millions, Currency in USD
Stock DCF: 269.87 | 131.07 | 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 2,768.802,496.103,427.103,494.803,958.504,3814,848.595,366.095,938.836,572.69
Revenue (%)
EBITDA 815.20718.30854.20971.50656.101,117.301,236.561,368.541,514.601,676.26
EBITDA (%)
EBIT 611.20541.70695.70804.10489.30871.34964.341,067.271,181.181,307.25
EBIT (%)
Depreciation 204176.60158.50167.40166.80245.96272.21301.27333.42369.01
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 310.80300.30337.80379524.40501.23554.72613.93679.46751.98
Total Cash (%)
Account Receivables 357.70291.50390.40369.60418.10500.54553.97613.09678.53750.95
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 12.802128.5019.5026.6529.5032.6536.1339.9944.25
Accounts Payable (%)
Capital Expenditure -36.30-35.10-47.40-51-59.80-61.95-68.56-75.88-83.98-92.94
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 131.07
Beta 0.483
Diluted Shares Outstanding 106.70
Cost of Debt
Tax Rate 45.71
After-tax Cost of Debt 1.63%
Risk-Free Rate
Market Risk Premium
Cost of Equity 5.802
Total Debt 1,871.30
Total Equity 13,985.17
Total Capital 15,856.47
Debt Weighting 11.80
Equity Weighting 88.20
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 2,768.802,496.103,427.103,494.803,958.504,3814,848.595,366.095,938.836,572.69
EBITDA 815.20718.30854.20971.50656.101,117.301,236.561,368.541,514.601,676.26
EBIT 611.20541.70695.70804.10489.30871.34964.341,067.271,181.181,307.25
Tax Rate 25.33%25.23%29.10%30.04%45.71%31.08%31.08%31.08%31.08%31.08%
EBIAT 456.37405.03493.23562.58265.62600.50664.59735.53814.03900.91
Depreciation 204176.60158.50167.40166.80245.96272.21301.27333.42369.01
Accounts Receivable -66.20-98.9020.80-48.50-82.44-53.42-59.13-65.44-72.42
Inventories ----------
Accounts Payable -8.207.50-97.152.843.153.483.864.27
Capital Expenditure -36.30-35.10-47.40-51-59.80-61.95-68.56-75.88-83.98-92.94
UFCF 624.07620.93512.93690.78331.27704.91817.97905.271,001.891,108.83
WACC
PV UFCF 669.37737.56775.12814.60856.08
SUM PV UFCF 3,852.74

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 5.31
Free cash flow (t + 1) 1,131.01
Terminal Value 34,169.36
Present Value of Terminal Value 26,380.85

Intrinsic Value

Enterprise Value 30,233.59
Net Debt 1,438.60
Equity Value 28,794.99
Shares Outstanding 106.70
Equity Value Per Share 269.87