Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Microsoft Corp., balance sheet: debt

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Current portion of long-term debt 5,247 2,749 8,072 3,749 5,516 3,998
Current finance lease liabilities 1,197 1,060 791 540 317 176
Long-term debt, excluding current portion 41,990 47,032 50,074 59,578 66,662 72,242
Long-term finance lease liabilities 15,870 13,842 11,750 8,956 6,257 4,125
Total debt and finance lease liabilities (carrying amount) 64,304 64,683 70,687 72,823 78,752 80,541

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

Debt item Description The company
Total debt and finance lease liabilities (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Microsoft Corp. total debt decreased from 2021 to 2022 and from 2022 to 2023.

Total Debt (Fair Value)

Microsoft Excel
Jun 30, 2023
Selected Financial Data (US$ in millions)
Long-term debt, including current portion 46,200
Finance lease liabilities 17,067
Total debt and finance lease liabilities (fair value) 63,267
Financial Ratio
Debt, fair value to carrying amount ratio 0.98

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


Weighted-average Interest Rate on Debt

Weighted average effective interest rate on debt and finance lease liabilities: 3.75%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
5.24% 520 27
4.57% 486 22
5.36% 718 38
3.57% 454 16
4.92% 1,814 89
3.22% 2,509 81
4.78% 9,805 469
4.03% 9,430 380
4.53% 8,945 405
2.68% 10,000 268
3.04% 8,185 249
3.40% 17,067 580
Total 69,933 2,625
3.75%

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

1 US$ in millions

2 Weighted-average interest rate = 100 × 2,625 ÷ 69,933 = 3.75%