Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Microsoft Corp. (NASDAQ:MSFT)

Paying users zone. Data is hidden behind: .

  • Get 1-month access to Microsoft Corp. for $19.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Analysis of Liquidity Ratios

Beginner level


Liquidity Ratios (Summary)

Microsoft Corp., liquidity ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015
Current ratio
Quick ratio
Cash ratio

Based on: 10-K (filing date: 2020-07-31), 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Microsoft Corp.’s current ratio deteriorated from 2018 to 2019 and from 2019 to 2020.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Microsoft Corp.’s quick ratio deteriorated from 2018 to 2019 and from 2019 to 2020.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Microsoft Corp.’s cash ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Current Ratio

Microsoft Corp., current ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015
Selected Financial Data (US$ in millions)
Current assets
Current liabilities
Liquidity Ratio
Current ratio1
Benchmarks
Current Ratio, Competitors2
Adobe Inc.
Alphabet Inc.
Autodesk Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
salesforce.com inc.
ServiceNow Inc.
Current Ratio, Sector
Software & Computer Services
Current Ratio, Industry
Technology

Based on: 10-K (filing date: 2020-07-31), 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31).

1 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= ÷ =

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.’s current ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Quick Ratio

Microsoft Corp., quick ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents
Short-term investments
Accounts receivable, net of allowance for doubtful accounts
Total quick assets
 
Current liabilities
Liquidity Ratio
Quick ratio1
Benchmarks
Quick Ratio, Competitors2
Adobe Inc.
Alphabet Inc.
Autodesk Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
salesforce.com inc.
ServiceNow Inc.
Quick Ratio, Sector
Software & Computer Services
Quick Ratio, Industry
Technology

Based on: 10-K (filing date: 2020-07-31), 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31).

1 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

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.’s quick ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Cash Ratio

Microsoft Corp., cash ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents
Short-term investments
Total cash assets
 
Current liabilities
Liquidity Ratio
Cash ratio1
Benchmarks
Cash Ratio, Competitors2
Adobe Inc.
Alphabet Inc.
Autodesk Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
salesforce.com inc.
ServiceNow Inc.
Cash Ratio, Sector
Software & Computer Services
Cash Ratio, Industry
Technology

Based on: 10-K (filing date: 2020-07-31), 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31).

1 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

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.’s cash ratio deteriorated from 2018 to 2019 and from 2019 to 2020.