Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Debt 

Microsoft Excel

Total Debt (Carrying Amount)

PepsiCo Inc., balance sheet: debt

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Short-term debt obligations 6,510 3,414 4,308 3,780 2,920
Long-term debt obligations, excluding current maturities 37,595 35,657 36,026 40,370 29,148
Total debt obligations (carrying amount) 44,105 39,071 40,334 44,150 32,068

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

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. total debt decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.

Total Debt (Fair Value)

Microsoft Excel
Dec 30, 2023
Selected Financial Data (US$ in millions)
Total debt obligations (fair value) 41,000
Financial Ratio
Debt, fair value to carrying amount ratio 0.93

Based on: 10-K (reporting date: 2023-12-30).


Weighted-average Interest Rate on Debt

Weighted-average effective interest rate on debt obligations: 3.14%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
5.50% 2,286 126
7.80% 300 23
3.00% 3,919 118
3.20% 3,994 128
3.70% 3,961 147
2.40% 2,544 61
2.10% 3,323 70
3.00% 23,725 712
3.60% 53 2
Total 44,105 1,386
3.14%

Based on: 10-K (reporting date: 2023-12-30).

1 US$ in millions

2 Weighted-average interest rate = 100 × 1,386 ÷ 44,105 = 3.14%