investorscraft@gmail.com

Intrinsic value of Constellation Brands Inc (STZ)

Previous Close$234.50
Intrinsic Value
Upside potential
Previous Close
$234.50
Use floor (the cash flow based valuation has rendered a result, which is lower than an estimated minimum value derived from the company’s balance sheet analysis)

VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate (norm.), %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Adjusted assets / Revenue
Cash & ST Investments
Total debt
Market cap, m$
44,532

Based on fiscal year data as of 2022-02-28 and quarterly data as of 2022-02-28.

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2022(a)2023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047

INCOME STATEMENT

Revenue growth rate, %2.4NaN
Revenue, $8822NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m6490NaN
Operating income, $m2332NaN
EBITDA, $m2756NaN
Interest expense (income), $mNaN
Earnings before tax, $m269NaN
Tax expense, $m309NaN
Net income, $m-40NaN

BALANCE SHEET

Cash and short-term investments, $m199NaN
Total assets, $m25856NaN
Adjusted assets (=assets-cash), $m25657NaN
Average production assets, $m16992NaN
Working capital, $m631NaN
Total debt, $m10955NaN
Total liabilities, $m14124NaN
Total equity, $m11732NaN
Debt-to-equity ratio0.934NaN
Adjusted equity ratio0.489NaN

CASH FLOW

Net income, $m-40NaN
Depreciation, amort., depletion, $m424NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m2705NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-1023NaN
Free cash flow, $m3728NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m631
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenuAccount