Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Analysis of Liquidity Ratios 

Microsoft Excel

Liquidity Ratios (Summary)

Microsoft Corp., liquidity ratios

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Current ratio 1.27 1.77 1.78 2.08 2.52 2.53
Quick ratio 1.06 1.54 1.57 1.90 2.33 2.35
Cash ratio 0.60 1.07 1.10 1.47 1.89 1.93

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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Microsoft Corp. current ratio deteriorated from 2022 to 2023 and from 2023 to 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 2022 to 2023 and from 2023 to 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Microsoft Corp. cash ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Current Ratio

Microsoft Corp., current ratio calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Current assets 159,734 184,257 169,684 184,406 181,915 175,552
Current liabilities 125,286 104,149 95,082 88,657 72,310 69,420
Liquidity Ratio
Current ratio1 1.27 1.77 1.78 2.08 2.52 2.53
Benchmarks
Current Ratio, Competitors2
Accenture PLC 1.10 1.30 1.23 1.25 1.40 1.40
Adobe Inc. 1.34 1.11 1.25 1.48 0.79
Autodesk Inc. 0.82 0.84 0.69 0.83 0.83 0.70
Cadence Design Systems Inc. 1.24 1.27 1.77 1.86 1.74
CrowdStrike Holdings Inc. 1.76 1.73 1.83 2.65 2.38
International Business Machines Corp. 0.96 0.92 0.88 0.98 1.02
Intuit Inc. 1.29 1.47 1.39 1.94 2.26 1.83
Oracle Corp. 0.72 0.91 1.62 2.30 3.03 2.49
Palantir Technologies Inc. 5.55 5.17 4.34 3.74
Palo Alto Networks Inc. 0.89 0.78 0.77 0.91 1.91 1.78
Salesforce Inc. 1.09 1.02 1.05 1.23 1.08 0.95
ServiceNow Inc. 1.06 1.11 1.05 1.21 1.03
Synopsys Inc. 2.44 1.15 1.09 1.16 1.19 0.99
Current Ratio, Sector
Software & Services 1.37 1.42 1.67 1.91 1.83
Current Ratio, Industry
Information Technology 1.47 1.44 1.64 1.85 1.77

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).

1 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 deteriorated from 2022 to 2023 and from 2023 to 2024.

Quick Ratio

Microsoft Corp., quick ratio calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 18,315 34,704 13,931 14,224 13,576 11,356
Short-term investments 57,228 76,558 90,826 116,110 122,951 122,463
Accounts receivable, net of allowance for doubtful accounts 56,924 48,688 44,261 38,043 32,011 29,524
Total quick assets 132,467 159,950 149,018 168,377 168,538 163,343
 
Current liabilities 125,286 104,149 95,082 88,657 72,310 69,420
Liquidity Ratio
Quick ratio1 1.06 1.54 1.57 1.90 2.33 2.35
Benchmarks
Quick Ratio, Competitors2
Accenture PLC 0.98 1.18 1.12 1.14 1.29 1.29
Adobe Inc. 1.22 1.00 1.11 1.34 0.70
Autodesk Inc. 0.72 0.76 0.62 0.77 0.78 0.62
Cadence Design Systems Inc. 1.02 1.02 1.47 1.60 1.51
CrowdStrike Holdings Inc. 1.60 1.58 1.68 2.50 2.18
International Business Machines Corp. 0.80 0.73 0.67 0.83 0.87
Intuit Inc. 0.71 1.25 1.17 1.65 2.04 1.44
Oracle Corp. 0.59 0.74 1.43 2.15 2.83 2.31
Palantir Technologies Inc. 5.41 4.92 4.11 3.59
Palo Alto Networks Inc. 0.82 0.72 0.75 0.88 1.85 1.72
Salesforce Inc. 0.96 0.90 0.93 1.11 0.95 0.82
ServiceNow Inc. 1.00 1.06 1.01 1.16 0.98
Synopsys Inc. 1.88 0.85 0.85 0.89 0.94 0.73
Quick Ratio, Sector
Software & Services 1.19 1.25 1.51 1.75 1.68
Quick Ratio, Industry
Information Technology 1.18 1.15 1.38 1.60 1.54

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).

1 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 deteriorated from 2022 to 2023 and from 2023 to 2024.

Cash Ratio

Microsoft Corp., cash ratio calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 18,315 34,704 13,931 14,224 13,576 11,356
Short-term investments 57,228 76,558 90,826 116,110 122,951 122,463
Total cash assets 75,543 111,262 104,757 130,334 136,527 133,819
 
Current liabilities 125,286 104,149 95,082 88,657 72,310 69,420
Liquidity Ratio
Cash ratio1 0.60 1.07 1.10 1.47 1.89 1.93
Benchmarks
Cash Ratio, Competitors2
Accenture PLC 0.26 0.50 0.45 0.52 0.67 0.55
Adobe Inc. 0.95 0.75 0.84 1.09 0.51
Autodesk Inc. 0.52 0.52 0.44 0.57 0.57 0.41
Cadence Design Systems Inc. 0.72 0.66 1.13 1.17 1.06
CrowdStrike Holdings Inc. 1.29 1.28 1.42 2.22 1.85
International Business Machines Corp. 0.39 0.28 0.22 0.36 0.24
Intuit Inc. 0.54 0.97 0.90 1.46 2.00 1.39
Oracle Corp. 0.34 0.44 1.12 1.93 2.50 2.03
Palantir Technologies Inc. 4.93 4.48 3.83 3.33
Palo Alto Networks Inc. 0.34 0.31 0.44 0.57 1.39 1.37
Salesforce Inc. 0.53 0.48 0.48 0.67 0.54 0.39
ServiceNow Inc. 0.66 0.71 0.67 0.83 0.61
Synopsys Inc. 1.53 0.53 0.56 0.65 0.58 0.42
Cash Ratio, Sector
Software & Services 0.76 0.81 1.10 1.32 1.22
Cash Ratio, Industry
Information Technology 0.76 0.72 0.96 1.19 1.10

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).

1 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 deteriorated from 2022 to 2023 and from 2023 to 2024.