Microsoft Excel LibreOffice Calc

Procter & Gamble Co. (PG)

Analysis of Debt

Difficulty: Advanced

Total Debt (Carrying Amount)

Procter & Gamble Co., Statement of Financial Position, Debt

USD $ in millions

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Debt due within one year 9,697  10,423  13,554  11,653  12,021  15,606 
Long-term debt, excluding due within one year 20,395  20,863  18,038  18,945  18,329  19,811 
Total short-term and long-term debt (carrying amount) 30,092  31,286  31,592  30,598  30,350  35,417 

Based on: 10-K (filing date: 2019-08-06), 10-K (filing date: 2018-08-07), 10-K (filing date: 2017-08-07), 10-K (filing date: 2016-08-09), 10-K (filing date: 2015-08-07), 10-K (filing date: 2014-08-08).

Item Description The company
Total short-term and long-term debt (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Procter & Gamble Co.’s total debt declined from 2017 to 2018 and from 2018 to 2019.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Jun 30, 2019
Selected Financial Data (USD $ in millions)
Commercial paper 6,183 
Other 126 
Total short-term debt (fair value) 6,309 
Long-term debt, including current portion 25,378 
Total short-term and long-term debt (fair value) 31,687 
Ratio
Debt, fair value to carrying amount 1.05

Based on: 10-K (filing date: 2019-08-06).

Weighted-average Interest Rate on Debt

Weighted average interest rate on debt: 1.79%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
0.50% 9,697  48 
2.40% 20,395  489 
Total 30,092  538 
1.79%

Based on: 10-K (filing date: 2019-08-06).

1 USD $ in millions

2 Weighted-average interest rate = 100 × 538 ÷ 30,092 = 1.79%