DCF Tool

CHTR

Charter Communications Inc. – Cable and Other Subscription Programming
for company news and job opportunities, please follow us at: https://www.linkedin.com/company/spectrum/ spectrum is powered and innovated by charter communications.
Analysis Results
Intrinsic Value $6,667.15
Latest Price $404.87
Relative Value 94% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 23.8%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 3.9%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 23.8%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2023 15.7 15.1
2024 19.4 18.0
2025 24.0 21.4
2026 29.7 25.5
2027 36.8 30.3
Terminal Value

Assuming the company was sold after the projection period at an exit multiple of 30, the terminal value of the company would be 1100 billion. This corresponds to a present value of 876 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 110 billion. Adding in the terminal value gives a total present value of 986 billion.

There are presently 148.0 million outstanding shares, so the intrinsic value per share is 6667.15.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 4,017,000,000
Current Cash 645,000,000
Current Liabilities 12,065,000,000
Current Debt 1,510,000,000
Non-Cash Working Capital (NCWC) -7,183,000,000
Change in NCWC -687,000,000
EBIT 12,243,000,000
Tax Provision 1,613,000,000
Depreciation and Amortization 8,903,000,000
Capital Expenditure -9,376,000,000
Unlevered Free Cash Flow 8,436,530,018
Current Assets 3,566,000,000
Current Cash 601,000,000
Current Liabilities 12,458,000,000
Current Debt 2,997,000,000
Non-Cash Working Capital (NCWC) -6,496,000,000
Change in NCWC -537,000,000
EBIT 10,855,000,000
Tax Provision 1,068,000,000
Depreciation and Amortization 9,345,000,000
Capital Expenditure -7,635,000,000
Unlevered Free Cash Flow 10,213,169,067
Current Assets 3,906,000,000
Current Cash 998,000,000
Current Liabilities 9,875,000,000
Current Debt 1,008,000,000
Non-Cash Working Capital (NCWC) -5,959,000,000
Change in NCWC -62,000,000
EBIT 8,463,000,000
Tax Provision 626,000,000
Depreciation and Amortization 9,704,000,000
Capital Expenditure -7,415,000,000
Unlevered Free Cash Flow 9,458,517,433
Current Assets 6,471,000,000
Current Cash 3,483,000,000
Current Liabilities 12,385,000,000
Current Debt 3,500,000,000
Non-Cash Working Capital (NCWC) -5,897,000,000
Change in NCWC 729,000,000
EBIT 6,477,000,000
Tax Provision 439,000,000
Depreciation and Amortization 9,926,000,000
Capital Expenditure -7,195,000,000
Unlevered Free Cash Flow 8,767,356,643
Current Assets 2,730,000,000
Current Cash 551,000,000
Current Liabilities 12,095,000,000
Current Debt 3,290,000,000
Non-Cash Working Capital (NCWC) -6,626,000,000
Change in NCWC 485,000,000
EBIT 5,379,000,000
Tax Provision 180,000,000
Depreciation and Amortization 10,318,000,000
Capital Expenditure -9,125,000,000
Unlevered Free Cash Flow 6,482,729,537
Current Assets 2,555,000,000
Current Cash 621,000,000
Current Liabilities 11,090,000,000
Current Debt 2,045,000,000
Non-Cash Working Capital (NCWC) -7,111,000,000
Change in NCWC -1,332,000,000
EBIT 4,558,000,000
Tax Provision -9,087,000,000
Depreciation and Amortization 10,588,000,000
Capital Expenditure -8,681,000,000
Unlevered Free Cash Flow 5,133,000,000
Current Assets 3,300,000,000
Current Cash 1,535,000,000
Current Liabilities 9,572,000,000
Current Debt 2,028,000,000
Non-Cash Working Capital (NCWC) -5,779,000,000
Change in NCWC -4,147,000,000
EBIT 3,583,000,000
Tax Provision -2,925,000,000
Depreciation and Amortization 6,907,000,000
Capital Expenditure -5,325,000,000
Unlevered Free Cash Flow 1,018,000,000
Current Assets 345,000,000
Current Cash 5,000,000
Current Liabilities 1,972,000,000
Current Debt 0
Non-Cash Working Capital (NCWC) -1,632,000,000
Change in NCWC -365,000,000
EBIT 1,275,000,000
Tax Provision -60,000,000
Depreciation and Amortization 2,125,000,000
Capital Expenditure -1,840,000,000
Unlevered Free Cash Flow 1,195,000,000
Current Assets 371,000,000
Current Cash 3,000,000
Current Liabilities 1,635,000,000
Current Debt 0
Non-Cash Working Capital (NCWC) -1,267,000,000
Change in NCWC -101,000,000
EBIT 1,033,000,000
Tax Provision 236,000,000
Depreciation and Amortization 2,102,000,000
Capital Expenditure -2,221,000,000
Unlevered Free Cash Flow 577,000,000
Current Assets 322,000,000
Current Cash 21,000,000
Current Liabilities 1,467,000,000
Current Debt 0
Non-Cash Working Capital (NCWC) -1,166,000,000
Change in NCWC -268,000,000
EBIT 956,000,000
Tax Provision 120,000,000
Depreciation and Amortization 1,854,000,000
Capital Expenditure -1,825,000,000
Unlevered Free Cash Flow 717,000,000
Current Assets 333,000,000
Current Cash 7,000,000
Current Liabilities 1,224,000,000
Current Debt 0
Non-Cash Working Capital (NCWC) -898,000,000
Change in NCWC -113,000,000
EBIT 931,000,000
Tax Provision 257,000,000
Depreciation and Amortization 1,713,000,000
Capital Expenditure -1,745,000,000
Unlevered Free Cash Flow 786,000,000

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.