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%