Stock Analysis on Net
Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

Analysis of Liquidity Ratios
Quarterly Data

Beginner level

Liquidity Ratios (Summary)

Medtronic PLC, liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017 Apr 28, 2017 Jan 27, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 Apr 24, 2015 Jan 23, 2015 Oct 24, 2014 Jul 25, 2014
Current ratio 2.16 1.87 2.13 2.75 2.77 2.67 2.59 2.36 2.56 2.46 2.28 2.43 2.40 1.64 1.75 1.77 2.35 2.98 3.29 3.39 3.53 3.81 3.36 6.80 3.11 3.82
Quick ratio 1.63 1.37 1.50 2.05 2.02 1.95 1.90 1.69 1.88 1.83 1.71 1.85 1.84 1.25 1.36 1.33 1.76 2.30 2.54 2.72 2.74 2.98 2.68 6.18 2.62 3.25
Cash ratio 1.18 0.99 1.06 1.33 1.27 1.25 1.16 1.03 1.20 1.21 1.11 1.32 1.29 0.86 0.96 0.90 1.17 1.62 1.76 2.12 2.12 2.35 2.12 5.55 2.08 2.57

Based on: 10-Q (filing date: 2020-12-03), 10-Q (filing date: 2020-09-03), 10-K (filing date: 2020-06-19), 10-Q (filing date: 2020-02-28), 10-Q (filing date: 2019-12-03), 10-Q (filing date: 2019-08-30), 10-K (filing date: 2019-06-21), 10-Q (filing date: 2019-03-01), 10-Q (filing date: 2018-11-29), 10-Q (filing date: 2018-08-31), 10-K (filing date: 2018-06-22), 10-Q (filing date: 2018-03-02), 10-Q (filing date: 2017-12-04), 10-Q (filing date: 2017-09-01), 10-K (filing date: 2017-06-27), 10-Q (filing date: 2017-03-03), 10-Q (filing date: 2016-12-05), 10-Q (filing date: 2016-09-07), 10-K (filing date: 2016-06-28), 10-Q (filing date: 2016-03-09), 10-Q (filing date: 2015-12-09), 10-Q (filing date: 2015-09-09), 10-K (filing date: 2015-06-23), 10-Q (filing date: 2015-02-27), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-29).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Medtronic PLC’s current ratio deteriorated from Q4 2020 to Q1 2021 but then improved from Q1 2021 to Q2 2021 exceeding Q4 2020 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Medtronic PLC’s quick ratio deteriorated from Q4 2020 to Q1 2021 but then improved from Q1 2021 to Q2 2021 exceeding Q4 2020 level.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Medtronic PLC’s cash ratio deteriorated from Q4 2020 to Q1 2021 but then improved from Q1 2021 to Q2 2021 exceeding Q4 2020 level.

Current Ratio

Medtronic PLC, current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017 Apr 28, 2017 Jan 27, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 Apr 24, 2015 Jan 23, 2015 Oct 24, 2014 Jul 25, 2014
Selected Financial Data (US$ in millions)
Current assets 26,036  24,509  22,031  24,043  22,653  22,705  21,967  20,877  21,653  22,460  22,980  26,607  25,162  24,779  24,873  22,423  22,526  23,498  23,600  27,569  28,723  29,147  30,844  38,161  21,597  20,770 
Current liabilities 12,071  13,086  10,366  8,735  8,170  8,518  8,472  8,853  8,463  9,112  10,084  10,933  10,496  15,148  14,220  12,672  9,601  7,896  7,165  8,141  8,126  7,660  9,173  5,613  6,952  5,433 
Liquidity Ratio
Current ratio1 2.16 1.87 2.13 2.75 2.77 2.67 2.59 2.36 2.56 2.46 2.28 2.43 2.40 1.64 1.75 1.77 2.35 2.98 3.29 3.39 3.53 3.81 3.36 6.80 3.11 3.82
Benchmarks
Current Ratio, Competitors2
Becton, Dickinson & Co. 1.54 1.45 0.98 0.96 1.18 1.09 0.96 0.97 1.03 1.23 1.70 1.54 5.58 5.56 1.22 1.14 1.45 1.55 1.51 1.25 1.38 1.40 1.56 5.82
Boston Scientific Corp. 1.87 1.87 1.21 0.97 1.14 1.31 1.39 0.76 0.78 0.83 0.82 0.68 0.72 0.75 0.87 0.90 1.05 1.05 1.21 1.43 1.55 1.95 1.29
Danaher Corp. 2.08 2.20 1.32 5.19 3.43 2.32 2.18 1.47 1.53 1.50 1.59 1.43 1.43 1.49 1.05 0.97 1.36 1.40 1.46 1.27 1.04 1.91 1.77
Edwards Lifesciences Corp. 3.52 3.08 3.36 3.31 3.53 3.38 3.66 2.61 2.31 2.28 2.07 1.80 3.49 4.06 3.45 4.21 4.08 4.15 3.97 4.30 4.03 5.16 5.56
Intuitive Surgical Inc. 7.04 6.38 4.96 4.53 4.64 5.04 5.44 5.28 6.05 5.98 5.82 3.99 4.76 4.41 3.88 5.45 5.51 5.78 5.31 4.46 5.01 4.56 4.29
Stryker Corp. 2.89 2.91 2.58 2.58 2.18 2.07 2.12 2.02 1.91 1.83 1.64 2.29 2.37 2.39 3.09 2.50 2.43 2.17 3.55 2.27 2.26 2.40 2.36
Thermo Fisher Scientific Inc. 2.93 2.62 2.32 1.92 1.80 1.49 1.69 1.73 1.84 1.58 1.36 1.34 1.26 1.47 1.37 1.44 1.56 1.15 1.03 1.38 1.05 1.02 0.90
UnitedHealth Group Inc. 0.82 0.84 0.75 0.69 0.70 0.67 0.73 0.73 0.69 0.75 0.71 0.73 0.70 0.72 0.71 0.69 0.70 0.70 0.73 0.74 0.75 0.77 0.77

Based on: 10-Q (filing date: 2020-12-03), 10-Q (filing date: 2020-09-03), 10-K (filing date: 2020-06-19), 10-Q (filing date: 2020-02-28), 10-Q (filing date: 2019-12-03), 10-Q (filing date: 2019-08-30), 10-K (filing date: 2019-06-21), 10-Q (filing date: 2019-03-01), 10-Q (filing date: 2018-11-29), 10-Q (filing date: 2018-08-31), 10-K (filing date: 2018-06-22), 10-Q (filing date: 2018-03-02), 10-Q (filing date: 2017-12-04), 10-Q (filing date: 2017-09-01), 10-K (filing date: 2017-06-27), 10-Q (filing date: 2017-03-03), 10-Q (filing date: 2016-12-05), 10-Q (filing date: 2016-09-07), 10-K (filing date: 2016-06-28), 10-Q (filing date: 2016-03-09), 10-Q (filing date: 2015-12-09), 10-Q (filing date: 2015-09-09), 10-K (filing date: 2015-06-23), 10-Q (filing date: 2015-02-27), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-29).

1 Q2 2021 Calculation
Current ratio = Current assets ÷ Current liabilities
= 26,036 ÷ 12,071 = 2.16

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. Medtronic PLC’s current ratio deteriorated from Q4 2020 to Q1 2021 but then improved from Q1 2021 to Q2 2021 exceeding Q4 2020 level.

Quick Ratio

Medtronic PLC, quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017 Apr 28, 2017 Jan 27, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 Apr 24, 2015 Jan 23, 2015 Oct 24, 2014 Jul 25, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 6,420  6,499  4,140  3,709  3,962  5,080  4,393  3,703  3,911  4,380  3,669  6,358  5,529  4,691  4,967  2,768  2,954  3,060  2,876  2,721  2,378  2,979  4,843  17,231  1,287  1,336 
Investments 7,857  6,513  6,808  7,919  6,436  5,603  5,455  5,439  6,222  6,624  7,558  8,078  7,997  8,397  8,741  8,690  8,303  9,750  9,758  14,565  14,851  15,003  14,637  13,917  13,177  12,626 
Accounts receivable, less allowances and credit losses 5,348  4,876  4,645  6,248  6,118  5,894  6,222  5,854  5,743  5,674  5,987  5,775  5,752  5,784  5,591  5,453  5,661  5,357  5,562  4,863  5,044  4,811  5,112  3,568  3,750  3,690 
Total quick assets 19,625  17,888  15,593  17,876  16,516  16,577  16,070  14,996  15,876  16,678  17,214  20,211  19,278  18,872  19,299  16,911  16,918  18,167  18,196  22,149  22,273  22,793  24,592  34,716  18,214  17,652 
 
Current liabilities 12,071  13,086  10,366  8,735  8,170  8,518  8,472  8,853  8,463  9,112  10,084  10,933  10,496  15,148  14,220  12,672  9,601  7,896  7,165  8,141  8,126  7,660  9,173  5,613  6,952  5,433 
Liquidity Ratio
Quick ratio1 1.63 1.37 1.50 2.05 2.02 1.95 1.90 1.69 1.88 1.83 1.71 1.85 1.84 1.25 1.36 1.33 1.76 2.30 2.54 2.72 2.74 2.98 2.68 6.18 2.62 3.25
Benchmarks
Quick Ratio, Competitors2
Becton, Dickinson & Co. 0.91 0.82 0.53 0.40 0.52 0.45 0.43 0.46 0.50 0.62 0.84 0.68 4.77 4.77 0.53 0.54 0.72 0.79 0.75 0.69 0.70 0.72 0.78 4.72
Boston Scientific Corp. 1.10 1.02 0.49 0.42 0.49 0.38 0.39 0.33 0.34 0.38 0.37 0.31 0.35 0.38 0.45 0.47 0.54 0.57 0.62 0.66 0.73 1.08 0.57
Danaher Corp. 1.52 1.59 0.92 4.68 2.99 1.78 1.58 0.88 0.92 0.91 0.97 0.87 0.89 0.94 0.64 0.60 0.85 1.01 0.85 0.77 0.67 1.37 1.20
Edwards Lifesciences Corp. 2.32 1.98 2.16 2.34 2.48 2.22 2.38 1.70 1.69 1.62 1.48 1.28 2.55 2.92 2.44 3.17 3.11 3.11 2.92 3.29 2.98 3.95 4.23
Intuitive Surgical Inc. 5.93 5.40 4.00 3.75 3.80 4.15 4.53 4.56 5.28 5.20 5.15 3.51 4.25 3.84 3.36 5.00 5.01 5.29 4.71 3.97 4.33 3.97 3.62
Stryker Corp. 2.04 2.00 1.61 1.66 1.14 1.08 1.09 1.25 1.03 0.99 0.95 1.43 1.43 1.59 2.02 1.70 1.59 1.50 2.85 1.64 1.37 1.55 1.57
Thermo Fisher Scientific Inc. 2.04 1.71 1.36 1.09 0.97 0.85 0.89 1.01 0.95 0.81 0.70 0.74 0.63 0.76 0.72 0.79 0.92 0.61 0.55 0.72 0.53 0.56 0.50
UnitedHealth Group Inc. 0.69 0.71 0.63 0.58 0.59 0.57 0.61 0.61 0.57 0.64 0.60 0.62 0.61 0.63 0.62 0.59 0.60 0.58 0.60 0.61 0.61 0.62 0.60

Based on: 10-Q (filing date: 2020-12-03), 10-Q (filing date: 2020-09-03), 10-K (filing date: 2020-06-19), 10-Q (filing date: 2020-02-28), 10-Q (filing date: 2019-12-03), 10-Q (filing date: 2019-08-30), 10-K (filing date: 2019-06-21), 10-Q (filing date: 2019-03-01), 10-Q (filing date: 2018-11-29), 10-Q (filing date: 2018-08-31), 10-K (filing date: 2018-06-22), 10-Q (filing date: 2018-03-02), 10-Q (filing date: 2017-12-04), 10-Q (filing date: 2017-09-01), 10-K (filing date: 2017-06-27), 10-Q (filing date: 2017-03-03), 10-Q (filing date: 2016-12-05), 10-Q (filing date: 2016-09-07), 10-K (filing date: 2016-06-28), 10-Q (filing date: 2016-03-09), 10-Q (filing date: 2015-12-09), 10-Q (filing date: 2015-09-09), 10-K (filing date: 2015-06-23), 10-Q (filing date: 2015-02-27), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-29).

1 Q2 2021 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 19,625 ÷ 12,071 = 1.63

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. Medtronic PLC’s quick ratio deteriorated from Q4 2020 to Q1 2021 but then improved from Q1 2021 to Q2 2021 exceeding Q4 2020 level.

Cash Ratio

Medtronic PLC, cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017 Apr 28, 2017 Jan 27, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 Apr 24, 2015 Jan 23, 2015 Oct 24, 2014 Jul 25, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 6,420  6,499  4,140  3,709  3,962  5,080  4,393  3,703  3,911  4,380  3,669  6,358  5,529  4,691  4,967  2,768  2,954  3,060  2,876  2,721  2,378  2,979  4,843  17,231  1,287  1,336 
Investments 7,857  6,513  6,808  7,919  6,436  5,603  5,455  5,439  6,222  6,624  7,558  8,078  7,997  8,397  8,741  8,690  8,303  9,750  9,758  14,565  14,851  15,003  14,637  13,917  13,177  12,626 
Total cash assets 14,277  13,012  10,948  11,628  10,398  10,683  9,848  9,142  10,133  11,004  11,227  14,436  13,526  13,088  13,708  11,458  11,257  12,810  12,634  17,286  17,229  17,982  19,480  31,148  14,464  13,962 
 
Current liabilities 12,071  13,086  10,366  8,735  8,170  8,518  8,472  8,853  8,463  9,112  10,084  10,933  10,496  15,148  14,220  12,672  9,601  7,896  7,165  8,141  8,126  7,660  9,173  5,613  6,952  5,433 
Liquidity Ratio
Cash ratio1 1.18 0.99 1.06 1.33 1.27 1.25 1.16 1.03 1.20 1.21 1.11 1.32 1.29 0.86 0.96 0.90 1.17 1.62 1.76 2.12 2.12 2.35 2.12 5.55 2.08 2.57
Benchmarks
Cash Ratio, Competitors2
Becton, Dickinson & Co. 0.50 0.49 0.28 0.09 0.11 0.10 0.11 0.15 0.17 0.25 0.32 0.27 4.25 4.24 0.14 0.21 0.36 0.40 0.39 0.35 0.33 0.35 0.43 4.22
Boston Scientific Corp. 0.61 0.55 0.09 0.04 0.07 0.03 0.03 0.03 0.03 0.04 0.06 0.03 0.04 0.05 0.04 0.05 0.08 0.14 0.13 0.13 0.16 0.47 0.10
Danaher Corp. 0.94 0.99 0.52 4.04 2.40 1.08 0.84 0.16 0.17 0.20 0.24 0.13 0.15 0.17 0.13 0.14 0.20 0.51 0.12 0.13 0.21 0.66 0.51
Edwards Lifesciences Corp. 1.53 1.33 1.38 1.68 1.75 1.34 1.49 1.09 1.27 1.18 1.14 0.95 1.91 2.01 1.57 2.39 2.25 2.22 2.08 2.57 2.35 3.16 3.38
Intuitive Surgical Inc. 5.27 4.85 3.44 3.13 3.11 3.37 3.79 3.73 4.46 4.40 4.33 2.78 3.49 3.04 2.62 4.28 4.19 4.46 3.99 3.17 3.63 3.29 2.98
Stryker Corp. 1.53 1.50 0.97 1.01 0.52 0.47 0.47 0.77 0.53 0.47 0.51 0.80 0.83 1.05 1.28 1.07 1.00 1.01 2.35 1.16 0.95 1.15 1.15
Thermo Fisher Scientific Inc. 1.21 0.97 0.54 0.39 0.22 0.30 0.19 0.34 0.21 0.16 0.13 0.19 0.11 0.12 0.13 0.16 0.37 0.12 0.13 0.11 0.09 0.13 0.13
UnitedHealth Group Inc. 0.31 0.37 0.31 0.23 0.25 0.28 0.27 0.27 0.25 0.35 0.33 0.31 0.34 0.31 0.34 0.27 0.31 0.23 0.28 0.30 0.25 0.27 0.30

Based on: 10-Q (filing date: 2020-12-03), 10-Q (filing date: 2020-09-03), 10-K (filing date: 2020-06-19), 10-Q (filing date: 2020-02-28), 10-Q (filing date: 2019-12-03), 10-Q (filing date: 2019-08-30), 10-K (filing date: 2019-06-21), 10-Q (filing date: 2019-03-01), 10-Q (filing date: 2018-11-29), 10-Q (filing date: 2018-08-31), 10-K (filing date: 2018-06-22), 10-Q (filing date: 2018-03-02), 10-Q (filing date: 2017-12-04), 10-Q (filing date: 2017-09-01), 10-K (filing date: 2017-06-27), 10-Q (filing date: 2017-03-03), 10-Q (filing date: 2016-12-05), 10-Q (filing date: 2016-09-07), 10-K (filing date: 2016-06-28), 10-Q (filing date: 2016-03-09), 10-Q (filing date: 2015-12-09), 10-Q (filing date: 2015-09-09), 10-K (filing date: 2015-06-23), 10-Q (filing date: 2015-02-27), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-29).

1 Q2 2021 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 14,277 ÷ 12,071 = 1.18

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. Medtronic PLC’s cash ratio deteriorated from Q4 2020 to Q1 2021 but then improved from Q1 2021 to Q2 2021 exceeding Q4 2020 level.