This company is transferred to the archive: financial data is no longer updated!

Microsoft Excel LibreOffice Calc

Analysis of Debt

Difficulty: Advanced


Total Debt (Carrying Amount)

Time Warner Inc., Statement of Financial Position, Debt

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Debt due within one year 5,450  1,947  198  1,118  66 
Long-term debt, excluding due within one year 18,294  22,392  23,594  21,376  20,099 
Total debt (carrying amount) 23,744  24,339  23,792  22,494  20,165 

Based on: 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-26), 10-K (filing date: 2014-02-26).

Item Description The company
Total debt (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Time Warner Inc.'s total debt increased from 2015 to 2016 but then declined significantly from 2016 to 2017.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Dec 31, 2017
Selected Financial Data (USD $ in millions)
Total debt (fair value) 25,327 
Ratio
Debt, fair value to carrying amount 1.07

Based on: 10-K (filing date: 2018-02-22).


Weighted-average Interest Rate on Debt

Weighted-average interest rate on total debt: 4.32%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
4.32% 23,744  1,026 
Total 23,744  1,026  4.32%

Based on: 10-K (filing date: 2018-02-22).

1 USD $ in millions

2 Weighted-average interest rate = 100 × 1,026 ÷ 23,744 = 4.32%