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, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Short-term debt 6,693
Current portion of long-term debt 2,249 5,247 2,749 8,072 3,749 5,516
Current finance lease liabilities 2,349 1,197 1,060 791 540 317
Long-term debt, excluding current portion 42,688 41,990 47,032 50,074 59,578 66,662
Long-term finance lease liabilities 24,796 15,870 13,842 11,750 8,956 6,257
Total debt and finance lease liabilities (carrying amount) 78,775 64,304 64,683 70,687 72,823 78,752

Based on: 10-K (reporting date: 2024-06-30), 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).

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 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

Total Debt (Fair Value)

Microsoft Excel
Jun 30, 2024
Selected Financial Data (US$ in millions)
Short-term debt 6,693
Long-term debt, including current portion 42,300
Finance lease liabilities 27,145
Total debt and finance lease liabilities (fair value) 76,138
Financial Ratio
Debt, fair value to carrying amount ratio 0.97

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


Weighted-average Interest Rate on Debt

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

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
5.40% 6,693 361
5.24% 520 27
4.57% 486 22
5.36% 718 38
3.57% 454 16
4.92% 314 15
3.22% 2,465 79
4.78% 9,805 469
4.03% 7,930 320
5.49% 6,833 375
5.43% 10,111 549
3.04% 8,185 249
5.49% 56 3
5.49% 3,344 184
3.90% 27,145 1,059
Total 85,059 3,767
4.43%

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

1 US$ in millions

2 Weighted-average interest rate = 100 × 3,767 ÷ 85,059 = 4.43%