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.

Common-Size Balance Sheet: Assets 
Quarterly Data

Constellation Brands Inc., common-size consolidated balance sheet: assets (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
Cash and cash equivalents 0.76 0.68 0.39 0.77 1.42 0.41 1.92 1.70 0.55 0.77 1.16 0.30 0.35 0.30 0.34 0.32 0.47 0.86 0.91 0.44 0.77 0.65 1.05 0.95 1.08 1.00 0.95
Accounts receivable 3.76 4.03 3.41 3.48 3.60 3.84 3.52 2.90 3.31 3.50 2.68 3.17 2.98 3.46 2.72 2.90 3.00 3.95 3.58 3.78 3.88 4.39 4.39 3.96 4.67 4.69 4.39
Inventories 7.37 6.80 6.41 6.08 5.95 5.28 5.26 4.76 4.98 5.02 5.10 5.03 5.02 4.76 5.16 7.29 7.88 8.06 8.96 10.15 10.78 9.94 10.22 10.51 11.59 10.47 10.88
Prepaid expenses and other 2.53 3.03 2.57 2.55 2.27 2.09 1.94 1.87 1.65 1.88 1.80 1.96 1.79 1.91 1.83 2.10 1.69 2.02 2.16 2.55 2.21 2.39 2.07 1.94 1.47 1.73 2.04
Assets held for sale, current 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.98 2.19 2.26 2.30 2.68 2.42 2.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current assets 14.41% 14.54% 12.78% 12.88% 13.23% 11.62% 12.65% 11.23% 12.48% 13.37% 12.99% 12.75% 12.81% 12.84% 12.37% 12.60% 13.05% 14.88% 15.61% 16.91% 17.63% 17.37% 17.72% 17.36% 18.80% 17.89% 18.26%
Property, plant, and equipment 26.67 25.67 23.85 23.44 21.62 21.73 20.59 21.48 20.20 19.59 19.50 19.52 19.15 18.66 17.68 18.02 17.88 20.53 20.85 23.32 22.63 22.99 22.08 21.14 20.24 20.50 19.89
Goodwill 32.28 32.53 30.63 30.41 30.74 30.78 29.81 28.75 28.19 29.16 29.39 28.39 28.68 27.93 26.79 27.67 28.91 33.54 34.86 39.36 40.21 41.79 42.05 42.58 41.04 41.52 41.69
Intangible assets 11.21 11.38 10.70 10.66 10.80 10.77 10.43 10.08 9.92 10.35 10.46 9.95 10.04 10.11 9.84 10.94 11.86 13.73 14.29 16.09 16.43 17.04 17.35 18.16 19.07 19.42 19.51
Equity method investments 3.15 3.43 9.81 10.40 10.80 11.12 10.14 10.29 10.71 11.08 11.04 11.32 11.29 10.90 11.85 11.86 12.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Securities measured at fair value 0.39 0.38 0.67 0.74 1.15 1.93 4.11 6.71 5.56 2.89 3.10 4.09 3.84 5.71 8.32 11.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deferred income taxes 9.16 9.44 9.04 9.09 9.46 9.66 9.89 9.20 9.28 9.73 9.94 9.72 9.83 7.79 7.61 7.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Assets held for sale 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.40 1.57 1.44 2.02 2.08 3.70 3.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other assets 2.73 2.62 2.53 2.39 2.21 2.40 2.38 2.27 2.28 2.26 2.16 2.24 2.29 2.36 2.35 0.38 15.46 17.32 14.39 4.32 3.09 0.81 0.79 0.76 0.85 0.66 0.64
Noncurrent assets 85.59% 85.46% 87.22% 87.12% 86.77% 88.38% 87.35% 88.77% 87.52% 86.63% 87.01% 87.25% 87.19% 87.16% 87.63% 87.40% 86.95% 85.12% 84.39% 83.09% 82.37% 82.63% 82.28% 82.64% 81.20% 82.11% 81.74%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

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).


Cash and cash equivalents
The proportion of cash and cash equivalents relative to total assets fluctuated over the analyzed periods, generally remaining below 1% with exceptions in early 2020 and early 2021 when notable spikes occurred, reaching peaks of 1.16% and 1.7-1.92%, respectively. Post these spikes, the ratio declined again but showed modest recovery towards the end of the timeline.
Accounts receivable
This metric showed a slight decline from around 4.39-4.69% in mid-2016 to lower levels in the 2.68-3.31% range in the late 2019 to early 2021 periods. There was a mild recovery after early 2021, with values approaching above 3.5% by late 2022, indicating some rebound in receivables as a proportion of total assets.
Inventories
A clear downward trend is observed from 10.88% in May 2016 to around 4.76-5.10% during 2019 and 2020. However, starting from around mid-2021, there was a gradual increase in inventory percentage, climbing steadily towards the 7.37% mark by late 2022, suggesting an accumulation or restocking of inventories relative to total assets.
Prepaid expenses and other
Prepaid expenses and other current assets maintained a relatively stable profile though with some fluctuations. Percentages mostly ranged between 1.73% and 2.57%, with a slight upward tendency from mid-2021 onward, peaking at 3.03% in August 2022, implying a higher proportion of prepaid or similar assets in recent periods.
Assets held for sale, current
This item appears starting in early 2019 and shows small but consistent values around 2.19-2.68%, with a decreasing trend appearance after early 2020. It disappears from reporting towards later periods, suggesting possible disposal or reclassification.
Current assets
The share of current assets relative to total assets declined notably from 18.26% in May 2016 to nearly half that level around 11-13% in the 2019-2022 range. There was a brief dip to 11.23% in early 2021, followed by modest increases afterward, hinting at a strategic shift towards a relatively lower current asset base.
Property, plant, and equipment (PP&E)
PP&E showed a general increasing trend over the period, starting near 19.89% in 2016 and progressively rising above 25% by late 2022. The steady growth indicates sustained investments or capitalization of physical assets within the company.
Goodwill
Goodwill, a major asset category, exhibited a significant downward trend from around 42% in 2016 to a low near 26.79% by mid-2019. Subsequently, it stabilized around the high 20% to low 30% range through 2022, reflecting possible impairments, asset disposals, or restructuring affecting intangible asset valuations.
Intangible assets
Intangible assets as a percentage of total assets decreased from about 19.51% in 2016 to approximately 9.84% by mid-2019, followed by a modest rebound to around 11.2% by late 2022. This suggests changes in the recognition or amortization of intangible assets, with partial recovery in recent years.
Equity method investments
Data for this category is available from late 2018 onwards, showing a declining trend from about 12.85% to as low as 3.15% by late 2022, indicating disposals or diminished valuations of investments accounted for using the equity method over time.
Securities measured at fair value
This item emerged around late 2018 at a relatively high level of 11.07%, but underwent a sharp decline to under 1% by late 2022. Fluctuations occurred in between, but the overall downward trajectory points to decreased holdings in marketable securities or similar assets.
Deferred income taxes
This asset category showed relatively stable proportions in the range of about 7.47% to just over 9.94% from late 2018 through 2022, reflecting consistent recognition of deferred tax assets as a portion of total assets.
Assets held for sale
Reported intermittently starting in early 2019 with values ranging from about 3.7% to 1.4%, then disappearing, this category suggests some level of asset disposals or restructuring activities impacting the asset base during this timeframe.
Other assets
This category shows an unusual spike in late 2017 through 2018, reaching unusually high proportions above 14%, which is a departure from generally stable low values (around 0.6-3%). Subsequently, the ratio normalized, returning to a range near 2-3%, indicating possible one-off reclassifications or reporting anomalies during the spike period.
Noncurrent assets
Noncurrent assets consistently represented the majority of total assets, generally hovering between 81% and 88%. Slight fluctuations occurred, but this stability highlights a predominately long-term asset structure throughout the period.
Total assets
As expected, sum totals anchored at 100% in all periods, providing a basis for proportional analysis of constituent assets.