Microsoft Excel LibreOffice Calc

PepsiCo Inc. (PEP)

Analysis of Debt

Difficulty: Advanced

Total Debt (Carrying Amount)

PepsiCo Inc., Statement of Financial Position, Debt

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 29, 2018 Dec 30, 2017 Dec 31, 2016 Dec 26, 2015 Dec 27, 2014
Short-term debt obligations 4,026  5,485  6,892  4,071  5,076 
Long-term debt obligations 28,295  33,796  30,053  29,213  23,821 
Total debt obligations (carrying amount) 32,321  39,281  36,945  33,284  28,897 

Based on: 10-K (filing date: 2019-02-15), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-15), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-12).

Item Description The company
Total debt obligations (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. PepsiCo Inc.’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 29, 2018
Selected Financial Data (USD $ in millions)
Debt obligations 32,000 
Ratio
Debt, fair value to carrying amount 0.99

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

Weighted-average Interest Rate on Debt

Weighted-average effective interest rate on debt: 3.46%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
3.10% 3,948  122 
3.90% 3,784  148 
3.10% 3,257  101 
2.80% 3,802  106 
2.90% 1,270  37 
3.70% 16,161  598 
1.30% 26  — 
6.00% 73  4 
Total 32,321  1,117 
3.46%

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

1 USD $ in millions

2 Weighted-average interest rate = 100 × 1,117 ÷ 32,321 = 3.46%