Stock Analysis on Net

Constellation Brands Inc. (NYSE:STZ)

This company has been moved to the archive! The financial data has not been updated since January 5, 2023.

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Constellation Brands Inc., liquidity ratios (quarterly data)

Microsoft Excel
Nov 30, 2022 Aug 31, 2022 May 31, 2022 Feb 28, 2022 Nov 30, 2021 Aug 31, 2021 May 31, 2021 Feb 28, 2021 Nov 30, 2020 Aug 31, 2020 May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016
Current ratio 1.29 1.41 1.40 1.23 1.50 1.35 1.61 2.40 1.69 1.85 1.94 1.51 1.41 1.61 1.22 1.16 1.08 1.66 1.81 1.79 1.40 1.61 1.54 1.20 1.31 1.44 1.19
Quick ratio 0.41 0.46 0.41 0.41 0.57 0.49 0.69 0.98 0.52 0.59 0.57 0.41 0.37 0.47 0.30 0.30 0.29 0.54 0.52 0.45 0.37 0.47 0.47 0.34 0.40 0.46 0.35
Cash ratio 0.07 0.07 0.04 0.07 0.16 0.05 0.24 0.36 0.07 0.11 0.17 0.04 0.04 0.04 0.03 0.03 0.04 0.10 0.11 0.05 0.06 0.06 0.09 0.07 0.07 0.08 0.06

Based on: 10-Q (reporting date: 2022-11-30), 10-Q (reporting date: 2022-08-31), 10-Q (reporting date: 2022-05-31), 10-K (reporting date: 2022-02-28), 10-Q (reporting date: 2021-11-30), 10-Q (reporting date: 2021-08-31), 10-Q (reporting date: 2021-05-31), 10-K (reporting date: 2021-02-28), 10-Q (reporting date: 2020-11-30), 10-Q (reporting date: 2020-08-31), 10-Q (reporting date: 2020-05-31), 10-K (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-Q (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-K (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-Q (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-K (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-Q (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-K (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-Q (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Constellation Brands Inc. current ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Constellation Brands Inc. quick ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Constellation Brands Inc. cash ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

Current Ratio

Constellation Brands Inc., current ratio calculation (quarterly data)

Microsoft Excel
Nov 30, 2022 Aug 31, 2022 May 31, 2022 Feb 28, 2022 Nov 30, 2021 Aug 31, 2021 May 31, 2021 Feb 28, 2021 Nov 30, 2020 Aug 31, 2020 May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016
Selected Financial Data (US$ in thousands)
Current assets 3,525,900 3,530,200 3,302,200 3,329,700 3,376,600 2,943,700 3,313,100 3,044,500 3,447,100 3,537,200 3,396,200 3,484,100 3,469,900 3,537,500 3,580,900 3,684,000 3,638,500 3,585,500 3,604,800 3,474,000 3,545,600 3,373,400 3,360,500 3,230,000 3,444,800 3,169,800 3,218,500
Current liabilities 2,725,000 2,511,900 2,365,800 2,698,800 2,248,600 2,187,100 2,062,800 1,269,100 2,041,400 1,909,900 1,752,400 2,311,800 2,460,200 2,195,900 2,939,300 3,163,800 3,363,400 2,162,500 1,990,500 1,944,700 2,535,900 2,090,000 2,182,400 2,697,600 2,636,600 2,199,600 2,698,700
Liquidity Ratio
Current ratio1 1.29 1.41 1.40 1.23 1.50 1.35 1.61 2.40 1.69 1.85 1.94 1.51 1.41 1.61 1.22 1.16 1.08 1.66 1.81 1.79 1.40 1.61 1.54 1.20 1.31 1.44 1.19
Benchmarks
Current Ratio, Competitors2
Altria Group Inc. 0.33 0.37 0.78 0.84 0.50 0.49 0.62 0.71 0.74 0.72 0.80 0.79 0.77 0.75 0.71 0.59 0.56 0.56 0.62
Coca-Cola Co. 1.14 1.14 1.15 1.15 1.13 1.13 1.18 1.13 1.52 1.47 1.33 1.32 1.13 1.09 0.87 0.76 0.92 0.83 1.02
Mondelēz International Inc. 0.61 0.65 0.68 0.60 0.69 0.68 0.68 0.74 0.73 0.61 0.61 0.66 0.74 0.55 0.53 0.50 0.50 0.44 0.48
PepsiCo Inc. 0.88 0.84 0.87 0.80 0.92 0.83 0.87 0.83 0.95 0.91 0.93 0.98 0.93 0.97 1.10 0.86 0.95 0.86 0.94
Philip Morris International Inc. 0.89 0.85 0.85 0.72 0.92 0.89 0.92 0.92 1.00 1.18 1.18 1.10 1.12 1.13 1.02 1.09 1.08 0.95 0.85

Based on: 10-Q (reporting date: 2022-11-30), 10-Q (reporting date: 2022-08-31), 10-Q (reporting date: 2022-05-31), 10-K (reporting date: 2022-02-28), 10-Q (reporting date: 2021-11-30), 10-Q (reporting date: 2021-08-31), 10-Q (reporting date: 2021-05-31), 10-K (reporting date: 2021-02-28), 10-Q (reporting date: 2020-11-30), 10-Q (reporting date: 2020-08-31), 10-Q (reporting date: 2020-05-31), 10-K (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-Q (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-K (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-Q (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-K (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-Q (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-K (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-Q (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31).

1 Q3 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= 3,525,900 ÷ 2,725,000 = 1.29

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. Constellation Brands Inc. current ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023.

Quick Ratio

Constellation Brands Inc., quick ratio calculation (quarterly data)

Microsoft Excel
Nov 30, 2022 Aug 31, 2022 May 31, 2022 Feb 28, 2022 Nov 30, 2021 Aug 31, 2021 May 31, 2021 Feb 28, 2021 Nov 30, 2020 Aug 31, 2020 May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016
Selected Financial Data (US$ in thousands)
Cash and cash equivalents 185,000 165,100 101,800 199,400 361,300 103,400 503,800 460,600 152,900 204,600 302,800 81,400 93,700 81,300 98,700 93,600 130,600 206,100 210,000 90,300 154,500 125,600 199,100 177,400 197,300 177,300 167,300
Accounts receivable 921,000 978,900 879,900 899,000 917,800 972,800 922,800 785,300 915,400 926,300 700,500 864,800 808,300 953,700 788,300 846,900 837,200 951,200 827,900 776,200 779,500 853,300 832,000 737,000 856,000 831,100 773,300
Total quick assets 1,106,000 1,144,000 981,700 1,098,400 1,279,100 1,076,200 1,426,600 1,245,900 1,068,300 1,130,900 1,003,300 946,200 902,000 1,035,000 887,000 940,500 967,800 1,157,300 1,037,900 866,500 934,000 978,900 1,031,100 914,400 1,053,300 1,008,400 940,600
 
Current liabilities 2,725,000 2,511,900 2,365,800 2,698,800 2,248,600 2,187,100 2,062,800 1,269,100 2,041,400 1,909,900 1,752,400 2,311,800 2,460,200 2,195,900 2,939,300 3,163,800 3,363,400 2,162,500 1,990,500 1,944,700 2,535,900 2,090,000 2,182,400 2,697,600 2,636,600 2,199,600 2,698,700
Liquidity Ratio
Quick ratio1 0.41 0.46 0.41 0.41 0.57 0.49 0.69 0.98 0.52 0.59 0.57 0.41 0.37 0.47 0.30 0.30 0.29 0.54 0.52 0.45 0.37 0.47 0.47 0.34 0.40 0.46 0.35
Benchmarks
Quick Ratio, Competitors2
Altria Group Inc. 0.15 0.23 0.63 0.67 0.31 0.31 0.49 0.54 0.37 0.35 0.59 0.56 0.52 0.53 0.52 0.28 0.23 0.25 0.35
Coca-Cola Co. 0.78 0.82 0.81 0.77 0.80 0.78 0.80 0.81 1.17 1.12 0.99 0.96 0.93 0.88 0.68 0.56 0.69 0.62 0.57
Mondelēz International Inc. 0.27 0.25 0.29 0.30 0.35 0.32 0.35 0.42 0.43 0.30 0.32 0.39 0.41 0.25 0.27 0.23 0.24 0.19 0.24
PepsiCo Inc. 0.68 0.60 0.61 0.58 0.68 0.59 0.63 0.56 0.65 0.66 0.68 0.77 0.73 0.75 0.89 0.66 0.73 0.61 0.69
Philip Morris International Inc. 0.36 0.37 0.31 0.29 0.48 0.47 0.44 0.44 0.49 0.59 0.53 0.56 0.55 0.52 0.43 0.56 0.57 0.45 0.36

Based on: 10-Q (reporting date: 2022-11-30), 10-Q (reporting date: 2022-08-31), 10-Q (reporting date: 2022-05-31), 10-K (reporting date: 2022-02-28), 10-Q (reporting date: 2021-11-30), 10-Q (reporting date: 2021-08-31), 10-Q (reporting date: 2021-05-31), 10-K (reporting date: 2021-02-28), 10-Q (reporting date: 2020-11-30), 10-Q (reporting date: 2020-08-31), 10-Q (reporting date: 2020-05-31), 10-K (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-Q (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-K (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-Q (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-K (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-Q (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-K (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-Q (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31).

1 Q3 2023 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 1,106,000 ÷ 2,725,000 = 0.41

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. Constellation Brands Inc. quick ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023.

Cash Ratio

Constellation Brands Inc., cash ratio calculation (quarterly data)

Microsoft Excel
Nov 30, 2022 Aug 31, 2022 May 31, 2022 Feb 28, 2022 Nov 30, 2021 Aug 31, 2021 May 31, 2021 Feb 28, 2021 Nov 30, 2020 Aug 31, 2020 May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016
Selected Financial Data (US$ in thousands)
Cash and cash equivalents 185,000 165,100 101,800 199,400 361,300 103,400 503,800 460,600 152,900 204,600 302,800 81,400 93,700 81,300 98,700 93,600 130,600 206,100 210,000 90,300 154,500 125,600 199,100 177,400 197,300 177,300 167,300
Total cash assets 185,000 165,100 101,800 199,400 361,300 103,400 503,800 460,600 152,900 204,600 302,800 81,400 93,700 81,300 98,700 93,600 130,600 206,100 210,000 90,300 154,500 125,600 199,100 177,400 197,300 177,300 167,300
 
Current liabilities 2,725,000 2,511,900 2,365,800 2,698,800 2,248,600 2,187,100 2,062,800 1,269,100 2,041,400 1,909,900 1,752,400 2,311,800 2,460,200 2,195,900 2,939,300 3,163,800 3,363,400 2,162,500 1,990,500 1,944,700 2,535,900 2,090,000 2,182,400 2,697,600 2,636,600 2,199,600 2,698,700
Liquidity Ratio
Cash ratio1 0.07 0.07 0.04 0.07 0.16 0.05 0.24 0.36 0.07 0.11 0.17 0.04 0.04 0.04 0.03 0.03 0.04 0.10 0.11 0.05 0.06 0.06 0.09 0.07 0.07 0.08 0.06
Benchmarks
Cash Ratio, Competitors2
Altria Group Inc. 0.15 0.07 0.43 0.47 0.31 0.31 0.49 0.53 0.36 0.32 0.58 0.55 0.50 0.51 0.50 0.26 0.21 0.23 0.33
Coca-Cola Co. 0.63 0.65 0.61 0.59 0.62 0.57 0.55 0.63 0.93 0.85 0.76 0.75 0.79 0.74 0.55 0.41 0.52 0.45 0.43
Mondelēz International Inc. 0.09 0.08 0.10 0.11 0.15 0.14 0.14 0.25 0.24 0.14 0.14 0.24 0.22 0.11 0.11 0.08 0.09 0.07 0.09
PepsiCo Inc. 0.31 0.22 0.20 0.20 0.26 0.21 0.27 0.23 0.27 0.24 0.29 0.41 0.37 0.38 0.51 0.28 0.29 0.19 0.29
Philip Morris International Inc. 0.14 0.15 0.11 0.12 0.26 0.25 0.23 0.23 0.25 0.31 0.26 0.37 0.31 0.27 0.23 0.36 0.36 0.22 0.17

Based on: 10-Q (reporting date: 2022-11-30), 10-Q (reporting date: 2022-08-31), 10-Q (reporting date: 2022-05-31), 10-K (reporting date: 2022-02-28), 10-Q (reporting date: 2021-11-30), 10-Q (reporting date: 2021-08-31), 10-Q (reporting date: 2021-05-31), 10-K (reporting date: 2021-02-28), 10-Q (reporting date: 2020-11-30), 10-Q (reporting date: 2020-08-31), 10-Q (reporting date: 2020-05-31), 10-K (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-Q (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-K (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-Q (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-K (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-Q (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-K (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-Q (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31).

1 Q3 2023 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 185,000 ÷ 2,725,000 = 0.07

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. Constellation Brands Inc. cash ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.