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.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Total Assets

Constellation Brands Inc., adjusted total assets

US$ in thousands

Microsoft Excel
Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Total assets 25,855,800 27,104,800 27,323,200 29,231,500 20,538,700 18,602,400
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 450,424 452,267 395,311
Less: Deferred tax assets2 2,351,500 2,492,500 2,656,300 2,183,300 1,200
After Adjustment
Adjusted total assets 23,504,300 24,612,300 24,666,900 27,498,624 20,990,967 18,996,511

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Deferred tax assets. See details »


Adjustments to Current Liabilities

Constellation Brands Inc., adjusted current liabilities

US$ in thousands

Microsoft Excel
Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Current liabilities 2,698,800 1,269,100 2,311,800 3,163,800 1,944,700 2,697,600
Adjustments
Less: Current deferred revenue 32,000
After Adjustment
Adjusted current liabilities 2,666,800 1,269,100 2,311,800 3,163,800 1,944,700 2,697,600

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).


Adjustments to Total Liabilities

Constellation Brands Inc., adjusted total liabilities

US$ in thousands

Microsoft Excel
Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Total liabilities 13,808,000 13,175,700 14,848,900 16,394,300 12,476,000 11,717,600
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 450,424 452,267 395,311
Less: Deferred tax liabilities2 515,800 569,700 384,000 1,029,700 718,300 1,133,600
Less: Deferred revenue 136,100
After Adjustment
Adjusted total liabilities 13,156,100 12,606,000 14,464,900 15,815,024 12,209,967 10,979,311

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Constellation Brands Inc., adjusted total CBI stockholders’ equity

US$ in thousands

Microsoft Excel
Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Total CBI stockholders’ equity 11,731,900 13,598,900 12,131,800 12,551,000 8,046,100 6,891,200
Adjustments
Less: Deferred tax assets (liabilities), net1 1,835,700 1,922,800 2,272,400 1,153,600 (718,300) (1,132,400)
Add: Deferred revenue 136,100
Add: Noncontrolling interests 315,900 330,200 342,500 286,200 16,600 (6,400)
After Adjustment
Adjusted total stockholders’ equity 10,348,200 12,006,300 10,201,900 11,683,600 8,781,000 8,017,200

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).

1 Deferred tax assets (liabilities), net. See details »


Adjustments to Capitalization Table

Constellation Brands Inc., adjusted capitalization table

US$ in thousands

Microsoft Excel
Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Short-term borrowings 323,000 238,900 791,500 746,800 606,500
Current maturities of long-term debt 605,300 29,200 734,900 1,065,200 22,300 910,900
Long-term debt, less current maturities 9,488,200 10,413,100 11,210,800 11,759,800 9,417,600 7,720,700
Total reported debt 10,416,500 10,442,300 12,184,600 13,616,500 10,186,700 9,238,100
Total CBI stockholders’ equity 11,731,900 13,598,900 12,131,800 12,551,000 8,046,100 6,891,200
Total reported capital 22,148,400 24,041,200 24,316,400 26,167,500 18,232,800 16,129,300
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 450,424 452,267 395,311
Add: Current operating lease liability2 80,400 68,800 76,600
Add: Noncurrent operating lease liability3 457,300 471,100 483,600
Adjusted total debt 10,954,200 10,982,200 12,744,800 14,066,924 10,638,967 9,633,411
Adjustments to Equity
Less: Deferred tax assets (liabilities), net4 1,835,700 1,922,800 2,272,400 1,153,600 (718,300) (1,132,400)
Add: Deferred revenue 136,100
Add: Noncontrolling interests 315,900 330,200 342,500 286,200 16,600 (6,400)
Adjusted total stockholders’ equity 10,348,200 12,006,300 10,201,900 11,683,600 8,781,000 8,017,200
After Adjustment
Adjusted total capital 21,302,400 22,988,500 22,946,700 25,750,524 19,419,967 17,650,611

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current operating lease liability. See details »

3 Noncurrent operating lease liability. See details »

4 Deferred tax assets (liabilities), net. See details »


Adjustments to Revenues

Constellation Brands Inc., adjusted net sales

US$ in thousands

Microsoft Excel
12 months ended: Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Net sales 8,820,700 8,614,900 8,343,500 8,116,000 7,585,000 7,331,500
Adjustment
Add: Increase (decrease) in deferred revenue 118,300
After Adjustment
Adjusted net sales 8,939,000 8,614,900 8,343,500 8,116,000 7,585,000 7,331,500

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).


Adjustments to Reported Income

Constellation Brands Inc., adjusted net income (loss) attributable to CBI

US$ in thousands

Microsoft Excel
12 months ended: Feb 28, 2022 Feb 28, 2021 Feb 29, 2020 Feb 28, 2019 Feb 28, 2018 Feb 28, 2017
As Reported
Net income (loss) attributable to CBI (40,400) 1,998,000 (11,800) 3,435,900 2,318,900 1,535,100
Adjustments
Add: Deferred income tax expense (benefit)1 84,800 336,400 (1,153,700) 426,900 (428,100) 128,700
Add: Increase (decrease) in deferred revenue 118,300
Add: Other comprehensive income (loss), net of income tax effect (80,400) (80,300) 90,500 (152,800) 208,000 42,000
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 38,200 22,700 36,100 21,400 23,000 (6,600)
After Adjustment
Adjusted net income 120,500 2,276,800 (1,038,900) 3,731,400 2,121,800 1,699,200

Based on: 10-K (reporting date: 2022-02-28), 10-K (reporting date: 2021-02-28), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-02-28), 10-K (reporting date: 2018-02-28), 10-K (reporting date: 2017-02-28).

1 Deferred income tax expense (benefit). See details »