Microsoft Excel LibreOffice Calc

Analysis of Debt

Difficulty: Advanced


Total Debt (Carrying Amount)

AbbVie 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
Short-term borrowings 400  377  406  425  413 
Current portion of long-term debt and lease obligations 6,015  25  2,025  4,021  18 
Long-term debt and lease obligations, excluding current portion 30,953  36,440  29,240  10,565  14,292 
Total debt and lease obligations (carrying amount) 37,368  36,842  31,671  15,011  14,723 

Source: Based on data from AbbVie Inc., Annual Reports

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

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Dec 31, 2017
Selected Financial Data (USD $ in millions)
Short-term borrowings 400 
Current portion of long-term debt and lease obligations, excluding fair value hedges 6,034 
Long-term debt and lease obligations, excluding fair value hedges 32,846 
Total debt and lease obligations (fair value) 39,280 
Ratio
Debt, fair value to carrying amount 1.05

Source: Based on data from AbbVie Inc., Annual Reports


Weighted-average Interest Rate on Debt

Weighted-average effective interest rate on debt: 3.10%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
2.15% 1,000  22 
2.97% 3,100  92 
4.46% 2,600  116 
1.92% 3,000  58 
2.65% 3,750  99 
3.28% 1,000  33 
3.66% 3,750  137 
4.58% 2,500  115 
4.73% 2,700  128 
2.40% 1,800  43 
2.91% 1,000  29 
3.28% 2,000  66 
4.37% 1,000  44 
4.50% 2,000  90 
0.55% 1,673 
1.46% 1,733  25 
2.18% 896  20 
2.26% 2,000  45 
1.30% 400 
Total 37,902  1,175  3.10%

Source: Based on data from AbbVie Inc., Annual Reports

1 USD $ in millions

2 Weighted-average interest rate = 100 × 1,175 ÷ 37,902 = 3.10%