Microsoft Excel LibreOffice Calc

Analysis of Debt

Difficulty: Advanced


Total Debt (Carrying Amount)

Bristol-Myers Squibb Co., 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 debt obligations 987  992  139  590  359 
Long-term debt, excluding current portion 6,975  5,716  6,550  7,242  7,981 
Total debt (carrying amount) 7,962  6,708  6,689  7,832  8,340 

Source: Based on data from Bristol-Myers Squibb Co., Annual Reports

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. Bristol-Myers Squibb Co.'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 987 
Long-term debt, including current portion 7,500 
Total debt (fair value) 8,487 
Ratio
Debt, fair value to carrying amount 1.07

Source: Based on data from Bristol-Myers Squibb Co., Annual Reports


Weighted-average Interest Rate on Debt

Weighted-average interest rate on debt: 3.04%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
1.75% 500 
1.60% 750  12 
2.00% 750  15 
7.15% 302  22 
3.25% 500  16 
1.00% 682 
6.80% 256  17 
3.25% 750  24 
1.75% 682  12 
5.88% 287  17 
6.13% 230  14 
3.25% 500  16 
4.50% 500  23 
6.88% 87 
5.75% 59 
1.17% 299 
Total 7,134  217  3.04%

Source: Based on data from Bristol-Myers Squibb Co., Annual Reports

1 USD $ in millions

2 Weighted-average interest rate = 100 × 217 ÷ 7,134 = 3.04%