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
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 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Current ratio 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 2.90 3.40 2.89 3.12
Quick ratio 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 2.74 3.24 2.77 2.96
Cash ratio 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 2.29 2.87 2.46 2.68

Based on: 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), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

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

Current Ratio

Microsoft Corp., current ratio calculation (quarterly data)

Microsoft Excel
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 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Selected Financial Data (US$ in millions)
Current assets 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 169,662 156,659 167,633 161,031
Current liabilities 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 58,488 46,133 58,099 51,615
Liquidity Ratio
Current ratio1 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 2.90 3.40 2.89 3.12
Benchmarks
Current Ratio, Competitors2
Accenture PLC 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 1.34 1.29 1.31 1.25
Adobe Inc. 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 1.13 1.66 2.08 2.12
International Business Machines Corp. 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.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 1.14 1.05 0.63 0.67
Oracle Corp. 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 3.96 4.33 5.07 3.63
Palo Alto Networks Inc. 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 1.93 1.14 1.19 1.17
Salesforce Inc. 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.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. 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 0.73 0.70 0.73 0.68

Based on: 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), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

1 Q2 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 147,393 ÷ 121,016 = 1.22

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 deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Quick Ratio

Microsoft Corp., quick ratio calculation (quarterly data)

Microsoft Excel
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 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Selected Financial Data (US$ in millions)
Cash and cash equivalents 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 11,946 9,221 12,859 6,884
Short-term investments 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 121,822 123,049 129,921 131,587
Accounts receivable, net of allowance for doubtful accounts 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 26,481 17,208 18,428 14,561
Total quick assets 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 160,249 149,478 161,208 153,032
 
Current liabilities 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 58,488 46,133 58,099 51,615
Liquidity Ratio
Quick ratio1 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 2.74 3.24 2.77 2.96
Benchmarks
Quick Ratio, Competitors2
Accenture PLC 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 1.24 1.19 1.19 1.13
Adobe Inc. 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 1.06 1.58 1.99 2.04
International Business Machines Corp. 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.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 0.86 0.83 0.41 0.42
Oracle Corp. 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 3.78 4.14 4.86 3.49
Palo Alto Networks Inc. 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 1.81 1.02 1.08 1.06
Salesforce Inc. 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.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. 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 0.61 0.60 0.61 0.57

Based on: 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), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

1 Q2 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 123,848 ÷ 121,016 = 1.02

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 deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Cash Ratio

Microsoft Corp., cash ratio calculation (quarterly data)

Microsoft Excel
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 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Selected Financial Data (US$ in millions)
Cash and cash equivalents 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 11,946 9,221 12,859 6,884
Short-term investments 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 121,822 123,049 129,921 131,587
Total cash assets 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 133,768 132,270 142,780 138,471
 
Current liabilities 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 58,488 46,133 58,099 51,615
Liquidity Ratio
Cash ratio1 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 2.29 2.87 2.46 2.68
Benchmarks
Cash Ratio, Competitors2
Accenture PLC 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 0.50 0.41 0.38 0.37
Adobe Inc. 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 0.75 1.30 1.70 1.74
International Business Machines Corp. 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.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 0.81 0.72 0.24 0.37
Oracle Corp. 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 3.50 3.92 4.62 3.31
Palo Alto Networks Inc. 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 1.59 0.83 0.88 0.86
Salesforce Inc. 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.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.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 0.34 0.36 0.30 0.31

Based on: 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), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

1 Q2 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 81,017 ÷ 121,016 = 0.67

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 Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.