National Beverage Corp. (FIZZ) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
National Beverage Corp. (FIZZ) Bundle
Looking to determine the intrinsic value of National Beverage Corp.? Our (FIZZ) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and make more informed investment choices.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 1,000.4 | 1,072.2 | 1,138.0 | 1,172.9 | 1,191.7 | 1,245.3 | 1,301.3 | 1,359.8 | 1,420.9 | 1,484.8 |
Revenue Growth, % | 0 | 7.18 | 6.14 | 3.07 | 1.6 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |
EBITDA | 196.3 | 259.0 | 207.9 | 220.0 | 238.7 | 251.1 | 262.4 | 274.2 | 286.5 | 299.4 |
EBITDA, % | 19.63 | 24.15 | 18.26 | 18.75 | 20.03 | 20.17 | 20.17 | 20.17 | 20.17 | 20.17 |
Depreciation | 30.6 | 31.2 | 31.8 | 33.3 | 20.2 | 33.1 | 34.6 | 36.1 | 37.8 | 39.5 |
Depreciation, % | 3.06 | 2.91 | 2.79 | 2.84 | 1.69 | 2.66 | 2.66 | 2.66 | 2.66 | 2.66 |
EBIT | 165.7 | 227.8 | 176.1 | 186.7 | 218.5 | 218.0 | 227.8 | 238.1 | 248.8 | 260.0 |
EBIT, % | 16.57 | 21.25 | 15.47 | 15.92 | 18.34 | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 |
Total Cash | 304.5 | 193.6 | 48.1 | 158.1 | 327.0 | 233.2 | 243.7 | 254.7 | 266.1 | 278.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 84.9 | 86.4 | 93.6 | 104.9 | 102.8 | 105.5 | 110.2 | 115.2 | 120.3 | 125.8 |
Account Receivables, % | 8.49 | 8.06 | 8.22 | 8.94 | 8.63 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
Inventories | 63.5 | 71.5 | 103.3 | 93.6 | 84.6 | 92.6 | 96.7 | 101.1 | 105.6 | 110.4 |
Inventories, % | 6.35 | 6.67 | 9.08 | 7.98 | 7.1 | 7.43 | 7.43 | 7.43 | 7.43 | 7.43 |
Accounts Payable | 74.4 | 88.8 | 95.3 | 85.1 | 78.3 | 94.4 | 98.7 | 103.1 | 107.7 | 112.6 |
Accounts Payable, % | 7.43 | 8.28 | 8.37 | 7.26 | 6.57 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
Capital Expenditure | -23.9 | -25.3 | -29.0 | -22.0 | -30.3 | -29.2 | -30.5 | -31.9 | -33.3 | -34.8 |
Capital Expenditure, % | -2.39 | -2.36 | -2.55 | -1.87 | -2.54 | -2.34 | -2.34 | -2.34 | -2.34 | -2.34 |
Tax Rate, % | 23.11 | 23.11 | 23.11 | 23.11 | 23.11 | 23.11 | 23.11 | 23.11 | 23.11 | 23.11 |
EBITAT | 127.1 | 173.9 | 134.4 | 142.3 | 168.0 | 166.8 | 174.3 | 182.1 | 190.3 | 198.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 59.8 | 184.6 | 104.8 | 141.9 | 162.1 | 176.2 | 173.7 | 181.5 | 189.7 | 198.2 |
WACC, % | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 |
PV UFCF | ||||||||||
SUM PV UFCF | 727.6 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 204 | |||||||||
Terminal Value | 3,963 | |||||||||
Present Terminal Value | 2,678 | |||||||||
Enterprise Value | 3,406 | |||||||||
Net Debt | -272 | |||||||||
Equity Value | 3,678 | |||||||||
Diluted Shares Outstanding, MM | 94 | |||||||||
Equity Value Per Share | 39.29 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real FIZZ financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe the effect of your inputs on National Beverage Corp.'s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Pre-Loaded Data: National Beverage Corp.'s (FIZZ) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View National Beverage Corp.'s (FIZZ) intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based National Beverage Corp. (FIZZ) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates National Beverage Corp.'s (FIZZ) intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: National Beverage Corp.’s (FIZZ) historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Clear Results: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Comprehensive step-by-step instructions ensure a smooth experience.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling National Beverage Corp. (FIZZ) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for National Beverage Corp. (FIZZ).
- Consultants: Deliver professional valuation insights on National Beverage Corp. (FIZZ) to clients quickly and accurately.
- Business Owners: Understand how companies like National Beverage Corp. (FIZZ) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to National Beverage Corp. (FIZZ).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled National Beverage Corp. (FIZZ) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for National Beverage Corp. (FIZZ).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.