Loading...

Discounted Cash Flow (DCF) Analysis Unlevered


ONEOK Inc.

ONEOK Inc. (OKE)

Energy

Operating Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 11,871.8812,194.797,763.218,920.7012,173.1912,591.9413,125.8413,682.3814,262.5114,867.2415,497.61
Revenue (%)
EBITDA 1,087.461,128.021,152.841,425.531,727.382,412.621,806.121,882.701,962.522,045.732,132.47
EBITDA (%)
EBIT 702.82821.93798.061,033.911,320.791,984.491,337.521,394.231,453.351,514.971,579.21
EBIT (%)
Depreciation 384.65306.09354.78391.62406.58428.13468.59488.46509.17530.76553.26
Depreciation (%)

Balance Sheet Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash 146.02173.1797.82248.8937.7412.59154.88161.45168.30175.43182.87
Total Cash (%)
Account Receivables 1,110.02745.10593.89872.441,202.71818.481,077.631,123.321,170.951,220.601,272.35
Account Receivables (%)
Inventories 188.76190.24204.95200.72432.15141.03278.27290.07302.37315.19328.55
Inventories (%)
Accounts Payable 1,272.67891.44615.62875.121,140.631,116.911,181.331,231.411,283.631,338.051,394.79
Accounts Payable (%)
Capital Expenditure -2,256.84-1,779.22-1,188.55-624.45-512.49-2,141.89-1,686.67-1,758.19-1,832.73-1,910.44-1,991.44
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 67.22
Diluted Shares Outstanding 411.49
Cost of Debt
Tax Rate 23.96
After-tax Cost of Debt -1.15
Risk-Free Rate
Market Risk Premium
Cost of Equity 12.27
Total Debt 8,899.58
Total Equity 27,660.02
Total Capital 36,559.60
Debt Weighting 24.34
Equity Weighting 75.66
Wacc

Build Up Free Cash

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 11,871.8812,194.797,763.218,920.7012,173.1912,591.9413,125.8413,682.3814,262.5114,867.2415,497.61
EBITDA 1,087.461,128.021,152.841,425.531,727.382,412.621,806.121,882.701,962.522,045.732,132.47
EBIT 702.82821.93798.061,033.911,320.791,984.491,337.521,394.231,453.351,514.971,579.21
Tax Rate 38.39%32.49%35.80%37.63%53.56%23.96%36.97%36.97%36.97%36.97%36.97%
EBIAT 433.00554.90512.36644.84613.391,509.00843.02878.77916.03954.87995.35
Depreciation 384.65306.09354.78391.62406.58428.13468.59488.46509.17530.76553.26
Accounts Receivable -364.92151.22-278.56-330.27384.23-259.16-45.69-47.63-49.65-51.75
Inventories --1.48-14.714.23-231.43291.12-137.24-11.80-12.30-12.82-13.36
Accounts Payable --381.23-275.82259.50265.51-23.7264.4250.0952.2154.4356.73
Capital Expenditure --477.62-590.67-564.10-111.961,629.40-455.2271.5174.5577.7181.00
UFCF 817.65365.58137.16457.53611.834,218.16524.431,431.341,492.031,555.291,621.24
WACC
PV UFCF 475.841,178.421,114.591,054.21997.11
SUM PV UFCF 6,875.61

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 10.21
Free cash flow (t + 1) 1,686.09
Terminal Value 27,151.17
Present Value of Terminal Value 16,698.74

Intrinsic Value

Enterprise Value 23,574.35
Net Debt 8,886.99
Equity Value 14,687.36
Shares Outstanding 411.49
Equity Value Per Share 35.69