Paying users zone. Data is covered by hidden.

  • Get to Microsoft Corp. for $19.99, or

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

Microsoft Excel LibreOffice Calc


Liquidity Analysis

Difficulty: Beginner


Ratios (Summary)

Microsoft Corp., liquidity ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Current ratio hidden hidden hidden hidden hidden hidden
Quick ratio hidden hidden hidden hidden hidden hidden
Cash ratio hidden hidden hidden hidden hidden hidden

Based on: 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), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

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

Current Ratio

Microsoft Corp., current ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (USD $ in millions)
Current assets hidden hidden hidden hidden hidden hidden
Current liabilities hidden hidden hidden hidden hidden hidden
Ratio
Current ratio1 hidden hidden hidden hidden hidden hidden
Benchmarks
Current Ratio, Competitors
Adobe Systems Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
Current Ratio, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Current Ratio, Industry
Technology hidden hidden hidden hidden hidden hidden

Based on: 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), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

2018 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= hidden ÷ hidden = hidden

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Microsoft Corp.’s current ratio improved from 2016 to 2017 and from 2017 to 2018.

Quick Ratio

Microsoft Corp., quick ratio calculation, comparison to benchmarks

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

Based on: 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), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

2018 Calculations

1 Quick ratio = Total quick assets ÷ Current liabilities
= hidden ÷ hidden = hidden

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 improved from 2016 to 2017 and from 2017 to 2018.

Cash Ratio

Microsoft Corp., cash ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents hidden hidden hidden hidden hidden hidden
Short-term investments hidden hidden hidden hidden hidden hidden
Total cash assets hidden hidden hidden hidden hidden hidden
Current liabilities hidden hidden hidden hidden hidden hidden
Ratio
Cash ratio1 hidden hidden hidden hidden hidden hidden
Benchmarks
Cash Ratio, Competitors
Adobe Systems Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
Cash Ratio, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Cash Ratio, Industry
Technology hidden hidden hidden hidden hidden hidden

Based on: 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), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

2018 Calculations

1 Cash ratio = Total cash assets ÷ Current liabilities
= hidden ÷ hidden = hidden

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 improved from 2016 to 2017 and from 2017 to 2018.