Microsoft Excel LibreOffice Calc

Coca-Cola Co. (KO)


Analysis of Debt

Difficulty: Advanced


Total Debt (Carrying Amount)

Coca-Cola Co., Statement of Financial Position, Debt

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Loans and notes payable 13,194  13,205  12,498  13,129  19,130 
Current maturities of long-term debt 4,997  3,298  3,527  2,677  3,552 
Long-term debt, excluding current maturities 25,364  31,182  29,684  28,407  19,063 
Total debt (carrying amount) 43,555  47,685  45,709  44,213  41,745 

Based on: 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25).

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. Coca-Cola Co.’s total debt increased from 2016 to 2017 but then declined significantly from 2017 to 2018.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Dec 31, 2018
Selected Financial Data (USD $ in millions)
Loans and notes payable 13,194 
Long-term debt, including the current portion 30,438 
Total debt (fair value) 43,632 
Ratio
Debt, fair value to carrying amount 1.00

Based on: 10-K (filing date: 2019-02-21).


Weighted-average Interest Rate on Debt

Weighted-average effective interest rate on debt: 2.11%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
1.90% 30,361  577 
2.60% 13,063  340 
Total 43,424  916  2.11%

Based on: 10-K (filing date: 2019-02-21).

1 USD $ in millions

2 Weighted-average interest rate = 100 × 916 ÷ 43,424 = 2.11%