Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Constellation Brands Inc., long-term (investment) activity ratios (quarterly data)
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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Constellation Brands Inc. net fixed asset turnover ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Constellation Brands Inc. total asset turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Constellation Brands Inc. equity turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Net Fixed Asset Turnover
Constellation Brands Inc., net fixed asset turnover calculation (quarterly data)
| 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) | |||||||||||||||||||||||||||||||||||
| Net sales | 2,436,500) | 2,655,100) | 2,363,200) | 2,102,500) | 2,320,600) | 2,371,100) | 2,026,500) | 1,953,000) | 2,438,100) | 2,260,400) | 1,963,400) | 1,902,900) | 1,999,400) | 2,344,000) | 2,097,200) | 1,797,200) | 1,972,600) | 2,299,100) | 2,047,100) | 1,765,900) | 1,799,100) | 2,084,500) | 1,935,500) | 1,628,000) | 1,810,500) | 2,021,200) | 1,871,800) | ||||||||
| Property, plant, and equipment | 6,523,800) | 6,234,000) | 6,163,300) | 6,059,600) | 5,519,300) | 5,505,400) | 5,392,200) | 5,821,600) | 5,580,700) | 5,184,900) | 5,098,200) | 5,333,000) | 5,187,200) | 5,141,600) | 5,118,000) | 5,267,300) | 4,986,300) | 4,947,700) | 4,815,800) | 4,789,700) | 4,551,000) | 4,464,200) | 4,186,900) | 3,932,800) | 3,708,000) | 3,632,100) | 3,507,200) | ||||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 1.46 | 1.51 | 1.49 | 1.46 | 1.57 | 1.60 | 1.61 | 1.48 | 1.53 | 1.57 | 1.61 | 1.56 | 1.59 | 1.60 | 1.60 | 1.54 | 1.62 | 1.60 | 1.60 | 1.58 | 1.64 | 1.67 | 1.77 | 1.86 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Altria Group Inc. | 15.11 | 15.31 | 15.65 | 15.61 | 15.90 | 16.36 | 16.72 | 16.75 | 17.17 | 13.66 | 13.03 | 13.00 | 12.87 | 12.78 | 12.94 | 12.56 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Coca-Cola Co. | 5.08 | 4.55 | 4.42 | 4.37 | 4.58 | 4.37 | 4.10 | 3.90 | 3.76 | 3.45 | 3.13 | 3.06 | 3.14 | 3.21 | 3.38 | 3.44 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| PepsiCo Inc. | 3.69 | 3.68 | 3.63 | 3.56 | 3.67 | 3.61 | 3.67 | 3.55 | 3.61 | 3.45 | 3.36 | 3.29 | 3.48 | 3.53 | 3.59 | 3.48 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Philip Morris International Inc. | 4.98 | 4.74 | 4.72 | 4.73 | 5.65 | 5.33 | 5.26 | 5.09 | 5.07 | 5.03 | 4.89 | 4.51 | 4.72 | 4.72 | 4.95 | 4.49 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Net fixed asset turnover
= (Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022)
÷ Property, plant, and equipment
= (2,436,500 + 2,655,100 + 2,363,200 + 2,102,500)
÷ 6,523,800 = 1.46
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Constellation Brands Inc. net fixed asset turnover ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Total Asset Turnover
Constellation Brands Inc., total asset turnover calculation (quarterly data)
| 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) | |||||||||||||||||||||||||||||||||||
| Net sales | 2,436,500) | 2,655,100) | 2,363,200) | 2,102,500) | 2,320,600) | 2,371,100) | 2,026,500) | 1,953,000) | 2,438,100) | 2,260,400) | 1,963,400) | 1,902,900) | 1,999,400) | 2,344,000) | 2,097,200) | 1,797,200) | 1,972,600) | 2,299,100) | 2,047,100) | 1,765,900) | 1,799,100) | 2,084,500) | 1,935,500) | 1,628,000) | 1,810,500) | 2,021,200) | 1,871,800) | ||||||||
| Total assets | 24,463,000) | 24,280,900) | 25,841,100) | 25,855,800) | 25,527,300) | 25,340,300) | 26,192,400) | 27,104,800) | 27,630,600) | 26,462,500) | 26,149,800) | 27,323,200) | 27,093,700) | 27,555,100) | 28,951,100) | 29,231,500) | 27,890,400) | 24,097,500) | 23,096,700) | 20,538,700) | 20,107,100) | 19,418,400) | 18,959,400) | 18,602,400) | 18,320,100) | 17,717,400) | 17,630,000) | ||||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Total asset turnover1 | 0.39 | 0.39 | 0.35 | 0.34 | 0.34 | 0.35 | 0.33 | 0.32 | 0.31 | 0.31 | 0.31 | 0.31 | 0.30 | 0.30 | 0.28 | 0.28 | 0.29 | 0.33 | 0.33 | 0.37 | 0.37 | 0.38 | 0.39 | 0.39 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Altria Group Inc. | 0.68 | 0.67 | 0.68 | 0.68 | 0.74 | 0.69 | 0.64 | 0.66 | 0.66 | 0.59 | 0.53 | 0.55 | 0.55 | 0.51 | 0.49 | 0.51 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Coca-Cola Co. | 0.46 | 0.45 | 0.45 | 0.46 | 0.46 | 0.44 | 0.43 | 0.41 | 0.42 | 0.40 | 0.37 | 0.38 | 0.34 | 0.36 | 0.40 | 0.43 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| PepsiCo Inc. | 0.92 | 0.94 | 0.95 | 0.94 | 0.89 | 0.88 | 0.87 | 0.86 | 0.82 | 0.81 | 0.78 | 0.76 | 0.74 | 0.76 | 0.80 | 0.86 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Philip Morris International Inc. | 0.54 | 0.54 | 0.52 | 0.51 | 0.78 | 0.78 | 0.76 | 0.76 | 0.74 | 0.74 | 0.73 | 0.64 | 0.74 | 0.74 | 0.81 | 0.70 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Total asset turnover
= (Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022)
÷ Total assets
= (2,436,500 + 2,655,100 + 2,363,200 + 2,102,500)
÷ 24,463,000 = 0.39
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Constellation Brands Inc. total asset turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Equity Turnover
Constellation Brands Inc., equity turnover calculation (quarterly data)
| 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) | |||||||||||||||||||||||||||||||||||
| Net sales | 2,436,500) | 2,655,100) | 2,363,200) | 2,102,500) | 2,320,600) | 2,371,100) | 2,026,500) | 1,953,000) | 2,438,100) | 2,260,400) | 1,963,400) | 1,902,900) | 1,999,400) | 2,344,000) | 2,097,200) | 1,797,200) | 1,972,600) | 2,299,100) | 2,047,100) | 1,765,900) | 1,799,100) | 2,084,500) | 1,935,500) | 1,628,000) | 1,810,500) | 2,021,200) | 1,871,800) | ||||||||
| Total CBI stockholders’ equity | 8,389,500) | 9,389,000) | 11,231,400) | 11,731,900) | 11,238,300) | 11,192,700) | 12,261,600) | 13,598,900) | 13,312,100) | 11,688,000) | 11,066,000) | 12,131,800) | 11,709,400) | 11,377,500) | 12,174,600) | 12,551,000) | 11,256,700) | 11,268,300) | 10,556,400) | 8,046,100) | 7,993,900) | 7,928,100) | 7,389,700) | 6,891,200) | 7,018,000) | 7,182,400) | 6,848,000) | ||||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Equity turnover1 | 1.14 | 1.01 | 0.82 | 0.75 | 0.77 | 0.79 | 0.71 | 0.63 | 0.64 | 0.70 | 0.74 | 0.69 | 0.70 | 0.72 | 0.67 | 0.65 | 0.72 | 0.70 | 0.73 | 0.94 | 0.93 | 0.94 | 1.00 | 1.06 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Altria Group Inc. | — | — | — | — | — | — | — | — | — | 8.11 | 8.87 | 9.21 | 8.24 | 4.50 | 3.95 | 4.04 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Coca-Cola Co. | 1.71 | 1.70 | 1.72 | 1.78 | 1.86 | 1.80 | 1.62 | 1.68 | 1.70 | 1.64 | 1.64 | 1.71 | 1.80 | 1.96 | 2.05 | 1.96 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| PepsiCo Inc. | 4.87 | 5.10 | 5.17 | 5.04 | 4.41 | 4.41 | 4.44 | 4.95 | 4.83 | 4.88 | 5.11 | 5.23 | 5.08 | 5.42 | 5.06 | 4.54 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Philip Morris International Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Equity turnover
= (Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022)
÷ Total CBI stockholders’ equity
= (2,436,500 + 2,655,100 + 2,363,200 + 2,102,500)
÷ 8,389,500 = 1.14
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Constellation Brands Inc. equity turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |