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.

Analysis of Operating Leases

Microsoft Excel

Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)

Time Warner Cable Inc., future operating lease payments (before adoption of FASB Topic 842)

US$ in millions

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Total undiscounted future operating lease payments 854 930 912 874 901
Discount rate1 6.22% 5.95% 5.88% 5.89% 6.04%
 
Total present value of future operating lease payments 681 740 724 689 696

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 Weighted-average interest rate for Time Warner Cable Inc. debt

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 6.22%
2016 170 2016 170 160
2017 144 2017 144 128
2018 125 2018 125 104
2019 99 2019 99 78
2020 71 2020 71 53
2021 and thereafter 245 2021 71 49
2022 71 47
2023 71 44
2024 32 19
Total: 854 854 681

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 5.95%
2015 162 2015 162 153
2016 156 2016 156 139
2017 127 2017 127 107
2018 108 2018 108 86
2019 84 2019 84 63
2020 and thereafter 293 2020 84 59
2021 84 56
2022 84 53
2023 41 24
Total: 930 930 740

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 5.88%
2014 149 2014 149 141
2015 141 2015 141 126
2016 131 2016 131 110
2017 102 2017 102 81
2018 89 2018 89 67
2019 and thereafter 300 2019 89 63
2020 89 60
2021 89 56
2022 33 20
Total: 912 912 724

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 5.89%
2013 138 2013 138 130
2014 130 2014 130 116
2015 116 2015 116 98
2016 108 2016 108 86
2017 83 2017 83 62
2018 and thereafter 299 2018 83 59
2019 83 56
2020 83 53
2021 50 30
Total: 874 874 689

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 6.04%
2012 127 2012 127 120
2013 119 2013 119 106
2014 112 2014 112 94
2015 103 2015 103 81
2016 95 2016 95 71
2017 and thereafter 345 2017 95 67
2018 95 63
2019 95 59
2020 60 35
Total: 901 901 696

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


Adjustments to Financial Statements for Operating Leases

Time Warner Cable Inc., adjustments to financial statements

US$ in millions

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Adjustment to Total Assets
Total assets (as reported) 49,277 48,501 48,273 49,809 48,276
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 681 740 724 689 696
Total assets (adjusted) 49,958 49,241 48,997 50,498 48,972
Adjustment to Total Debt
Total debt (as reported) 22,502 23,718 25,052 26,689 26,442
Add: Operating lease liability (before adoption of FASB Topic 842)2 681 740 724 689 696
Total debt (adjusted) 23,183 24,458 25,776 27,378 27,138

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, 2 Equal to total present value of future operating lease payments.


Time Warner Cable Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios for Operating Leases (Summary)

Time Warner Cable Inc., adjusted financial ratios

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Total Asset Turnover1
Reported total asset turnover 0.48 0.47 0.46 0.43 0.41
Adjusted total asset turnover 0.47 0.46 0.45 0.42 0.40
Debt to Equity2
Reported debt to equity 2.50 2.96 3.61 3.67 3.51
Adjusted debt to equity 2.58 3.05 3.71 3.76 3.60
Return on Assets3 (ROA)
Reported ROA 3.74% 4.19% 4.05% 4.33% 3.45%
Adjusted ROA 3.69% 4.12% 3.99% 4.27% 3.40%

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).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Time Warner Cable Inc. adjusted total asset turnover ratio improved from 2013 to 2014 and from 2014 to 2015.
Adjusted debt to equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Time Warner Cable Inc. adjusted debt to equity ratio improved from 2013 to 2014 and from 2014 to 2015.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Time Warner Cable Inc. adjusted ROA improved from 2013 to 2014 but then deteriorated significantly from 2014 to 2015.

Time Warner Cable Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Revenue 23,697 22,812 22,120 21,386 19,675
Total assets 49,277 48,501 48,273 49,809 48,276
Activity Ratio
Total asset turnover1 0.48 0.47 0.46 0.43 0.41
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Revenue 23,697 22,812 22,120 21,386 19,675
Adjusted total assets 49,958 49,241 48,997 50,498 48,972
Activity Ratio
Adjusted total asset turnover2 0.47 0.46 0.45 0.42 0.40

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).

2015 Calculations

1 Total asset turnover = Revenue ÷ Total assets
= 23,697 ÷ 49,277 = 0.48

2 Adjusted total asset turnover = Revenue ÷ Adjusted total assets
= 23,697 ÷ 49,958 = 0.47

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Time Warner Cable Inc. adjusted total asset turnover ratio improved from 2013 to 2014 and from 2014 to 2015.

Adjusted Debt to Equity

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Total debt 22,502 23,718 25,052 26,689 26,442
Total TWC shareholders’ equity 8,995 8,013 6,943 7,279 7,530
Solvency Ratio
Debt to equity1 2.50 2.96 3.61 3.67 3.51
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 23,183 24,458 25,776 27,378 27,138
Total TWC shareholders’ equity 8,995 8,013 6,943 7,279 7,530
Solvency Ratio
Adjusted debt to equity2 2.58 3.05 3.71 3.76 3.60

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).

2015 Calculations

1 Debt to equity = Total debt ÷ Total TWC shareholders’ equity
= 22,502 ÷ 8,995 = 2.50

2 Adjusted debt to equity = Adjusted total debt ÷ Total TWC shareholders’ equity
= 23,183 ÷ 8,995 = 2.58

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Time Warner Cable Inc. adjusted debt-to-equity ratio improved from 2013 to 2014 and from 2014 to 2015.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to TWC shareholders 1,844 2,031 1,954 2,155 1,665
Total assets 49,277 48,501 48,273 49,809 48,276
Profitability Ratio
ROA1 3.74% 4.19% 4.05% 4.33% 3.45%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net income attributable to TWC shareholders 1,844 2,031 1,954 2,155 1,665
Adjusted total assets 49,958 49,241 48,997 50,498 48,972
Profitability Ratio
Adjusted ROA2 3.69% 4.12% 3.99% 4.27% 3.40%

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).

2015 Calculations

1 ROA = 100 × Net income attributable to TWC shareholders ÷ Total assets
= 100 × 1,844 ÷ 49,277 = 3.74%

2 Adjusted ROA = 100 × Net income attributable to TWC shareholders ÷ Adjusted total assets
= 100 × 1,844 ÷ 49,958 = 3.69%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Time Warner Cable Inc. adjusted ROA improved from 2013 to 2014 but then deteriorated significantly from 2014 to 2015.