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, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
Short-term debt 9,072
Current portion of long-term debt 2,749 8,072 3,749 5,516 3,998 1,049
Current finance lease liabilities 1,060 791 540 317 176 113
Long-term debt, excluding current portion 47,032 50,074 59,578 66,662 72,242 76,073
Long-term finance lease liabilities 13,842 11,750 8,956 6,257 4,125 2,425
Total debt and finance lease liabilities (carrying amount) 64,683 70,687 72,823 78,752 80,541 88,732

Based on: 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), 10-K (reporting date: 2017-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 2020 to 2021 and from 2021 to 2022.

Total Debt (Fair Value)

Microsoft Excel
Jun 30, 2022
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt, including current portion 50,900
Finance lease liabilities 14,902
Total debt and finance lease liabilities (fair value) 65,802
Financial Ratio
Debt, fair value to carrying amount ratio 1.02

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


Weighted-average Interest Rate on Debt

Weighted average effective interest rate on debt: 3.73%

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% 1,204 43
4.92% 2,814 138
3.22% 2,404 77
4.78% 10,805 516
4.03% 9,430 380
4.53% 8,945 405
2.68% 10,000 268
3.04% 8,185 249
3.10% 14,902 462
Total 70,413 2,627
3.73%

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

1 US$ in millions

2 Weighted-average interest rate = 100 × 2,627 ÷ 70,413 = 3.73%