Stock Analysis on Net

Time Warner Cable Inc. (NYSE:TWC)

This company has been moved to the archive! The financial data has not been updated since April 28, 2016.

Enterprise Value to FCFF (EV/FCFF) 

Microsoft Excel

Free Cash Flow to The Firm (FCFF)

Time Warner Cable Inc., FCFF calculation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Net income attributable to TWC shareholders 1,844 2,031 1,954 2,155 1,665
Net income attributable to noncontrolling interests 4 2
Net noncash charges 4,238 4,155 3,679 3,385 3,898
Changes in operating assets and liabilities, net of acquisitions and dispositions 457 164 120 (19) 123
Cash provided by operating activities 6,539 6,350 5,753 5,525 5,688
Cash paid for interest, net of tax1 915 977 1,119 1,147 1,080
Capital expenditures (4,446) (4,097) (3,198) (3,095) (2,937)
Acquisition of intangible assets (51) (39) (40) (37) (47)
Free cash flow to the firm (FCFF) 2,957 3,191 3,634 3,540 3,784

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

Item Description The company
FCFF Free cash flow to the firm is the cash flow available to the Time Warner Cable Inc. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made. Time Warner Cable Inc. FCFF decreased from 2013 to 2014 and from 2014 to 2015.

Interest Paid, Net of Tax

Time Warner Cable Inc., interest paid, net of tax calculation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Effective Income Tax Rate (EITR)
EITR1 38.29% 37.47% 35.70% 35.28% 32.29%
Interest Paid, Net of Tax
Cash paid for interest, before tax 1,482 1,562 1,740 1,773 1,595
Less: Cash paid for interest, tax2 567 585 621 626 515
Cash paid for interest, net of tax 915 977 1,119 1,147 1,080

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 See details »

2 2015 Calculation
Cash paid for interest, tax = Cash paid for interest × EITR
= 1,482 × 38.29% = 567


Enterprise Value to FCFF Ratio, Current

Time Warner Cable Inc., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in millions)
Enterprise value (EV) 81,348
Free cash flow to the firm (FCFF) 2,957
Valuation Ratio
EV/FCFF 27.51
Benchmarks
EV/FCFF, Competitors1
Alphabet Inc. 29.67
Comcast Corp. 16.30
Meta Platforms Inc. 31.34
Netflix Inc. 51.22
Walt Disney Co. 24.02

Based on: 10-K (reporting date: 2015-12-31).

1 Click competitor name to see calculations.

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

Time Warner Cable Inc., historical EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
Enterprise value (EV)1 73,738 65,077 64,756 48,931 45,664
Free cash flow to the firm (FCFF)2 2,957 3,191 3,634 3,540 3,784
Valuation Ratio
EV/FCFF3 24.94 20.40 17.82 13.82 12.07
Benchmarks
EV/FCFF, Competitors4
Alphabet Inc.
Comcast Corp.
Meta Platforms Inc.
Netflix Inc.
Walt Disney Co.

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 See details »

2 See details »

3 2015 Calculation
EV/FCFF = EV ÷ FCFF
= 73,738 ÷ 2,957 = 24.94

4 Click competitor name to see calculations.

Valuation ratio Description The company
EV/FCFF Enterprise value to free cash flow to the firm is whole company valuation indicator. Time Warner Cable Inc. EV/FCFF ratio increased from 2013 to 2014 and from 2014 to 2015.