Stock Analysis on Net

Merck & Co. Inc. (NYSE:MRK)

Analysis of Liquidity Ratios

Microsoft Excel

Liquidity Ratios (Summary)

Merck & Co. Inc., liquidity ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Current ratio 1.25 1.47 1.27 1.02 1.24
Quick ratio 0.68 0.93 0.73 0.58 0.78
Cash ratio 0.28 0.54 0.34 0.30 0.47

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Merck & Co. Inc. current ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Merck & Co. Inc. quick ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Merck & Co. Inc. cash ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Current Ratio

Merck & Co. Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Current assets 32,168 35,722 30,266 27,764 27,483
Current liabilities 25,694 24,239 23,872 27,327 22,220
Liquidity Ratio
Current ratio1 1.25 1.47 1.27 1.02 1.24
Benchmarks
Current Ratio, Competitors2
AbbVie Inc. 0.87 0.96 0.79 0.84 3.18
Amgen Inc. 1.65 1.41 1.59 1.81 1.44
Bristol-Myers Squibb Co. 1.43 1.25 1.52 1.58 1.60
Danaher Corp. 1.68 1.89 1.43 1.86 5.19
Eli Lilly & Co. 0.94 1.05 1.23 1.40 1.16
Gilead Sciences Inc. 1.43 1.29 1.27 1.40 3.10
Johnson & Johnson 1.16 0.99 1.35 1.21 1.26
Moderna Inc. 3.42 2.73 1.76 1.43 7.89
Pfizer Inc. 0.91 1.22 1.40 1.35 0.88
Regeneron Pharmaceuticals Inc. 5.69 5.06 3.56 3.63 3.67
Thermo Fisher Scientific Inc. 1.75 1.48 1.50 2.13 1.92
Current Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 1.26 1.29 1.35 1.35 1.66
Current Ratio, Industry
Health Care 1.14 1.16 1.21 1.21 1.34

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= 32,168 ÷ 25,694 = 1.25

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. Merck & Co. Inc. current ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Quick Ratio

Merck & Co. Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 6,841 12,694 8,096 8,062 9,676
Short-term investments 252 498 774
Accounts receivable, net of allowance for doubtful accounts 10,349 9,450 9,230 7,851 6,778
Total quick assets 17,442 22,642 17,326 15,913 17,228
 
Current liabilities 25,694 24,239 23,872 27,327 22,220
Liquidity Ratio
Quick ratio1 0.68 0.93 0.73 0.58 0.78
Benchmarks
Quick Ratio, Competitors2
AbbVie Inc. 0.63 0.69 0.56 0.60 2.91
Amgen Inc. 0.99 0.95 1.06 1.30 1.01
Bristol-Myers Squibb Co. 1.04 0.87 1.20 1.28 1.26
Danaher Corp. 1.18 1.30 0.89 1.36 4.68
Eli Lilly & Co. 0.52 0.63 0.80 0.85 0.68
Gilead Sciences Inc. 1.06 0.99 0.95 1.08 2.86
Johnson & Johnson 0.82 0.71 1.04 0.91 0.94
Moderna Inc. 3.15 2.29 1.52 1.37 7.74
Pfizer Inc. 0.50 0.80 1.00 0.78 0.50
Regeneron Pharmaceuticals Inc. 4.82 4.16 2.98 2.86 2.81
Thermo Fisher Scientific Inc. 1.27 1.06 1.00 1.63 1.19
Quick Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 0.84 0.90 0.97 0.96 1.27
Quick Ratio, Industry
Health Care 0.83 0.86 0.90 0.90 1.00

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 17,442 ÷ 25,694 = 0.68

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. Merck & Co. Inc. quick ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Cash Ratio

Merck & Co. Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 6,841 12,694 8,096 8,062 9,676
Short-term investments 252 498 774
Total cash assets 7,093 13,192 8,096 8,062 10,450
 
Current liabilities 25,694 24,239 23,872 27,327 22,220
Liquidity Ratio
Cash ratio1 0.28 0.54 0.34 0.30 0.47
Benchmarks
Cash Ratio, Competitors2
AbbVie Inc. 0.34 0.31 0.28 0.30 2.56
Amgen Inc. 0.60 0.59 0.66 0.91 0.69
Bristol-Myers Squibb Co. 0.55 0.42 0.78 0.83 0.84
Danaher Corp. 0.71 0.71 0.32 0.82 4.04
Eli Lilly & Co. 0.11 0.13 0.26 0.29 0.21
Gilead Sciences Inc. 0.64 0.57 0.56 0.65 2.50
Johnson & Johnson 0.50 0.42 0.70 0.59 0.54
Moderna Inc. 2.85 2.01 1.18 1.05 7.71
Pfizer Inc. 0.27 0.54 0.73 0.47 0.26
Regeneron Pharmaceuticals Inc. 3.17 2.46 1.45 1.33 1.53
Thermo Fisher Scientific Inc. 0.58 0.50 0.33 1.00 0.39
Cash Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 0.46 0.51 0.58 0.57 0.89
Cash Ratio, Industry
Health Care 0.44 0.48 0.52 0.53 0.64

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 7,093 ÷ 25,694 = 0.28

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. Merck & Co. Inc. cash ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.