Microsoft Excel LibreOffice Calc

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Debt

Advanced level

Total Debt (Carrying Amount)

PepsiCo Inc., balance sheet: debt

US$ in millions

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

Based on: 10-K (filing date: 2020-02-13), 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).

Debt 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 decreased from 2017 to 2018 and from 2018 to 2019.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Dec 28, 2019
Selected Financial Data (US$ in millions)
Debt obligations 34,000 
Financial Ratio
Debt, fair value to carrying amount ratio 1.06

Based on: 10-K (filing date: 2020-02-13).

Weighted-average Interest Rate on Debt

Weighted-average effective interest rate on debt: 3.13%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
2.70% 2,840  77 
2.40% 3,276  79 
2.70% 3,831  103 
2.80% 1,272  36 
3.40% 1,839  63 
3.40% 18,910  643 
1.30% 28  — 
6.40% 72  5 
Total 32,068  1,005 
3.13%

Based on: 10-K (filing date: 2020-02-13).

1 US$ in millions

2 Weighted-average interest rate = 100 × 1,005 ÷ 32,068 = 3.13%