Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Analysis of Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Microsoft Corp., liquidity ratios (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018
Current ratio 1.27 1.24 1.22 1.66 1.77 1.91 1.93 1.84 1.78 1.99 2.25 2.16 2.08 2.29 2.58 2.53 2.52 2.90 2.80 2.85 2.53 2.97 3.12 2.92
Quick ratio 1.06 1.05 1.02 1.45 1.54 1.66 1.66 1.59 1.57 1.77 2.05 1.96 1.90 2.10 2.36 2.30 2.33 2.73 2.65 2.68 2.35 2.80 2.93 2.72
Cash ratio 0.60 0.68 0.67 1.15 1.07 1.22 1.22 1.23 1.10 1.35 1.62 1.62 1.47 1.74 1.96 1.97 1.89 2.34 2.25 2.35 1.93 2.44 2.54 2.41

Based on: 10-K (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Microsoft Corp. current ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Microsoft Corp. quick ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Microsoft Corp. cash ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Current Ratio

Microsoft Corp., current ratio calculation (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018
Selected Financial Data (US$ in millions)
Current assets 159,734 147,180 147,393 207,586 184,257 163,889 157,823 160,812 169,684 153,922 174,188 174,326 184,406 165,614 173,973 177,077 181,915 170,505 167,074 165,896 175,552 159,887 156,874 164,195
Current liabilities 125,286 118,525 121,016 124,792 104,149 85,691 81,718 87,389 95,082 77,439 77,510 80,528 88,657 72,193 67,486 70,056 72,310 58,707 59,640 58,118 69,420 53,861 50,318 56,277
Liquidity Ratio
Current ratio1 1.27 1.24 1.22 1.66 1.77 1.91 1.93 1.84 1.78 1.99 2.25 2.16 2.08 2.29 2.58 2.53 2.52 2.90 2.80 2.85 2.53 2.97 3.12 2.92
Benchmarks
Current Ratio, Competitors2
Accenture PLC 1.10 1.16 1.26 1.33 1.30 1.37 1.29 1.26 1.23 1.27 1.23 1.22 1.25 1.42 1.39 1.45 1.40 1.37 1.38 1.39 1.40 1.34 1.35 1.33
Adobe Inc. 1.11 1.16 1.05 1.34 1.25 1.16 1.12 1.11 1.14 1.07 1.04 1.25 1.39 1.31 1.27 1.48 1.44 1.29 1.23 0.79 0.74 0.70 0.97
Autodesk Inc. 0.82 0.75 0.73 0.72 0.84 0.73 0.64 0.62 0.69 0.81 0.50 0.48 0.83 0.83 0.84 0.79 0.83 0.60 0.56 0.64 0.70 0.80 0.83 0.92
Cadence Design Systems Inc. 1.43 1.32 1.24 1.44 1.37 1.44 1.27 1.33 1.59 1.81 1.77 1.70 1.57 1.70 1.86 1.55 1.42 1.38 1.74 1.70 1.60 1.45
CrowdStrike Holdings Inc. 1.76 1.74 1.82 1.78 1.73 1.76 1.80 1.83 1.83 1.90 1.98 2.07 2.65 1.91 2.18 2.25 2.38 2.53 2.94 1.03
International Business Machines Corp. 1.12 1.13 0.96 0.91 1.06 1.16 0.92 0.95 0.88 0.92 0.88 0.84 0.84 0.93 0.98 1.05 1.04 0.96 1.02 1.09 1.83 1.36
Intuit Inc. 1.29 1.50 1.17 1.25 1.47 1.51 1.23 1.37 1.39 1.63 1.18 2.10 1.94 1.96 1.53 3.09 2.26 1.79 1.67 1.80 1.83 1.85 1.32 1.41
Oracle Corp. 0.72 0.85 0.79 0.87 0.91 0.82 0.65 0.60 1.62 1.52 1.65 2.04 2.30 2.16 2.17 2.66 3.03 2.12 2.37 2.25 2.49 2.65 2.80 3.43
Palo Alto Networks Inc. 0.89 0.84 0.83 0.86 0.78 0.74 0.64 0.70 0.77 0.74 0.66 0.68 0.91 1.38 0.98 1.63 1.91 1.29 1.78 1.78 1.78 1.86 1.87 2.10
Salesforce Inc. 1.09 1.04 1.02 1.02 1.02 1.05 1.06 1.03 1.05 1.06 0.93 1.33 1.23 1.22 1.15 1.15 1.08 1.05 0.97 0.96 0.95 0.86 0.80 1.29
ServiceNow Inc. 1.13 1.12 1.05 1.06 1.08 1.14 1.17 1.11 1.24 1.12 1.12 1.05 1.13 1.08 1.23 1.21 1.40 1.17 1.03 1.03 1.05 1.10 1.13
Synopsys Inc. 2.02 1.86 1.29 1.15 1.20 1.15 1.11 1.09 1.14 1.25 1.19 1.16 1.18 1.19 1.10 1.19 1.06 0.95 0.95 0.99 0.99 0.95 0.89

Based on: 10-K (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30).

1 Q4 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 159,734 ÷ 125,286 = 1.27

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Microsoft Corp. current ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Quick Ratio

Microsoft Corp., quick ratio calculation (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018
Selected Financial Data (US$ in millions)
Cash and cash equivalents 18,315 19,634 17,305 80,452 34,704 26,562 15,646 22,884 13,931 12,498 20,604 19,165 14,224 13,702 14,432 17,205 13,576 11,710 8,864 13,117 11,356 11,212 6,638 15,137
Short-term investments 57,228 60,387 63,712 63,499 76,558 77,865 83,862 84,378 90,826 92,195 104,765 111,450 116,110 111,705 117,536 120,772 122,951 125,916 125,389 123,519 122,463 120,406 121,024 120,743
Accounts receivable, net of allowance for doubtful accounts 56,924 44,029 42,831 36,953 48,688 37,420 35,833 31,279 44,261 32,613 33,520 27,349 38,043 26,322 27,312 22,851 32,011 22,699 23,525 19,087 29,524 19,269 19,680 17,390
Total quick assets 132,467 124,050 123,848 180,904 159,950 141,847 135,341 138,541 149,018 137,306 158,889 157,964 168,377 151,729 159,280 160,828 168,538 160,325 157,778 155,723 163,343 150,887 147,342 153,270
 
Current liabilities 125,286 118,525 121,016 124,792 104,149 85,691 81,718 87,389 95,082 77,439 77,510 80,528 88,657 72,193 67,486 70,056 72,310 58,707 59,640 58,118 69,420 53,861 50,318 56,277
Liquidity Ratio
Quick ratio1 1.06 1.05 1.02 1.45 1.54 1.66 1.66 1.59 1.57 1.77 2.05 1.96 1.90 2.10 2.36 2.30 2.33 2.73 2.65 2.68 2.35 2.80 2.93 2.72
Benchmarks
Quick Ratio, Competitors2
Accenture PLC 0.98 1.03 1.13 1.18 1.18 1.24 1.15 1.12 1.12 1.14 1.10 1.10 1.14 1.31 1.27 1.34 1.29 1.25 1.25 1.28 1.29 1.22 1.23 1.22
Adobe Inc. 0.97 1.02 0.93 1.22 1.12 1.03 1.00 1.00 1.01 0.93 0.89 1.11 1.25 1.18 1.12 1.34 1.28 1.11 1.06 0.70 0.64 0.62 0.86
Autodesk Inc. 0.72 0.65 0.64 0.63 0.76 0.64 0.54 0.52 0.62 0.72 0.42 0.40 0.77 0.77 0.77 0.71 0.78 0.54 0.49 0.56 0.62 0.70 0.73 0.81
Cadence Design Systems Inc. 1.06 0.96 0.94 1.10 1.10 1.19 1.02 1.13 1.36 1.56 1.47 1.48 1.33 1.43 1.59 1.44 1.30 1.22 1.50 1.50 1.43 1.27
CrowdStrike Holdings Inc. 1.60 1.59 1.66 1.63 1.58 1.62 1.66 1.68 1.68 1.76 1.81 1.93 2.50 1.76 2.01 2.07 2.18 2.36 2.76 0.87
International Business Machines Corp. 0.93 0.96 0.80 0.73 0.87 0.97 0.73 0.74 0.66 0.72 0.67 0.64 0.66 0.75 0.83 0.88 0.88 0.80 0.87 0.91 1.68 1.19
Intuit Inc. 0.71 1.00 0.55 0.66 1.25 1.29 1.02 1.10 1.17 1.29 0.78 1.71 1.60 1.72 1.20 2.74 2.04 1.54 1.30 1.34 1.44 1.57 0.94 0.89
Oracle Corp. 0.59 0.69 0.63 0.73 0.74 0.65 0.50 0.49 1.43 1.34 1.45 1.90 2.15 2.00 2.02 2.50 2.83 1.91 2.16 2.09 2.31 2.45 2.63 3.26
Palo Alto Networks Inc. 0.82 0.78 0.78 0.81 0.72 0.66 0.58 0.65 0.73 0.70 0.62 0.64 0.86 1.23 0.88 1.48 1.78 1.16 1.64 1.64 1.65 1.73 1.74 1.98
Salesforce Inc. 0.96 0.86 0.86 0.86 0.90 0.89 0.91 0.88 0.93 0.89 0.79 1.19 1.11 1.05 0.98 1.00 0.95 0.87 0.82 0.81 0.82 0.68 0.64 1.13
ServiceNow Inc. 1.05 1.03 0.98 1.00 1.01 1.08 1.11 1.06 1.17 1.06 1.06 1.01 1.07 1.03 1.19 1.16 1.33 1.11 0.98 0.98 0.99 1.04 1.06
Synopsys Inc. 1.10 0.99 0.88 0.85 0.92 0.90 0.86 0.85 0.87 0.99 0.93 0.89 0.90 0.92 0.83 0.94 0.82 0.73 0.73 0.73 0.70 0.67 0.67

Based on: 10-K (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30).

1 Q4 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 132,467 ÷ 125,286 = 1.06

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Microsoft Corp. quick ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Cash Ratio

Microsoft Corp., cash ratio calculation (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018
Selected Financial Data (US$ in millions)
Cash and cash equivalents 18,315 19,634 17,305 80,452 34,704 26,562 15,646 22,884 13,931 12,498 20,604 19,165 14,224 13,702 14,432 17,205 13,576 11,710 8,864 13,117 11,356 11,212 6,638 15,137
Short-term investments 57,228 60,387 63,712 63,499 76,558 77,865 83,862 84,378 90,826 92,195 104,765 111,450 116,110 111,705 117,536 120,772 122,951 125,916 125,389 123,519 122,463 120,406 121,024 120,743
Total cash assets 75,543 80,021 81,017 143,951 111,262 104,427 99,508 107,262 104,757 104,693 125,369 130,615 130,334 125,407 131,968 137,977 136,527 137,626 134,253 136,636 133,819 131,618 127,662 135,880
 
Current liabilities 125,286 118,525 121,016 124,792 104,149 85,691 81,718 87,389 95,082 77,439 77,510 80,528 88,657 72,193 67,486 70,056 72,310 58,707 59,640 58,118 69,420 53,861 50,318 56,277
Liquidity Ratio
Cash ratio1 0.60 0.68 0.67 1.15 1.07 1.22 1.22 1.23 1.10 1.35 1.62 1.62 1.47 1.74 1.96 1.97 1.89 2.34 2.25 2.35 1.93 2.44 2.54 2.41
Benchmarks
Cash Ratio, Competitors2
Accenture PLC 0.26 0.30 0.32 0.41 0.50 0.50 0.38 0.36 0.45 0.41 0.35 0.37 0.52 0.67 0.65 0.68 0.67 0.54 0.49 0.52 0.55 0.45 0.44 0.43
Adobe Inc. 0.78 0.85 0.72 0.95 0.90 0.82 0.76 0.75 0.77 0.72 0.65 0.84 1.00 0.94 0.85 1.09 1.03 0.84 0.80 0.51 0.47 0.45 0.61
Autodesk Inc. 0.52 0.50 0.53 0.54 0.52 0.47 0.42 0.42 0.44 0.55 0.30 0.29 0.57 0.57 0.58 0.57 0.57 0.36 0.37 0.44 0.41 0.54 0.61 0.70
Cadence Design Systems Inc. 0.69 0.69 0.63 0.76 0.73 0.78 0.65 0.82 0.99 1.18 1.12 1.12 0.91 0.94 1.17 1.17 1.03 0.93 1.05 1.06 1.04 0.85
CrowdStrike Holdings Inc. 1.29 1.35 1.42 1.41 1.28 1.36 1.41 1.44 1.42 1.54 1.57 1.71 2.22 1.51 1.76 1.81 1.85 2.01 2.42 0.58
International Business Machines Corp. 0.54 0.60 0.39 0.36 0.50 0.57 0.28 0.32 0.24 0.32 0.22 0.23 0.22 0.31 0.36 0.41 0.37 0.30 0.24 0.31 1.10 0.47
Intuit Inc. 0.54 0.76 0.24 0.45 0.97 0.97 0.54 0.82 0.90 1.09 0.48 1.52 1.46 1.52 1.02 2.69 2.00 1.46 1.03 1.28 1.39 1.46 0.67 0.84
Oracle Corp. 0.34 0.40 0.36 0.48 0.44 0.38 0.27 0.32 1.12 1.12 1.21 1.70 1.93 1.77 1.81 2.26 2.50 1.64 1.88 1.89 2.03 2.23 2.43 3.07
Palo Alto Networks Inc. 0.34 0.41 0.43 0.52 0.31 0.46 0.39 0.46 0.44 0.50 0.45 0.48 0.57 0.98 0.72 1.22 1.39 0.87 1.40 1.39 1.37 1.52 1.51 1.76
Salesforce Inc. 0.53 0.61 0.60 0.65 0.48 0.65 0.67 0.68 0.48 0.62 0.55 0.98 0.67 0.78 0.72 0.76 0.54 0.62 0.59 0.61 0.39 0.43 0.40 0.91
ServiceNow Inc. 0.78 0.75 0.73 0.66 0.73 0.82 0.85 0.71 0.89 0.81 0.83 0.67 0.80 0.76 0.94 0.83 1.04 0.82 0.68 0.61 0.67 0.74 0.79
Synopsys Inc. 0.79 0.66 0.48 0.53 0.67 0.62 0.48 0.56 0.60 0.70 0.51 0.65 0.66 0.65 0.47 0.58 0.51 0.42 0.34 0.42 0.42 0.36 0.29

Based on: 10-K (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30).

1 Q4 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 75,543 ÷ 125,286 = 0.60

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Microsoft Corp. cash ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.