Spectrum Brands Holdings, Inc. (SPB) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Spectrum Brands Holdings, Inc. (SPB) Bundle
Evaluate Spectrum Brands Holdings, Inc. (SPB) financial outlook like an expert! This (SPB) DCF Calculator provides pre-filled financial data and allows you full control to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 3,964.2 | 2,998.1 | 3,132.5 | 2,918.8 | 2,963.9 | 2,777.4 | 2,602.7 | 2,439.0 | 2,285.5 | 2,141.7 |
| Revenue Growth, % | 0 | -24.37 | 4.48 | -6.82 | 1.55 | -6.29 | -6.29 | -6.29 | -6.29 | -6.29 |
| EBITDA | 244.1 | 253.4 | 166.9 | -72.0 | 323.9 | 157.8 | 147.8 | 138.5 | 129.8 | 121.6 |
| EBITDA, % | 6.16 | 8.45 | 5.33 | -2.47 | 10.93 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 |
| Depreciation | 114.6 | 117.0 | 99.3 | 91.2 | 101.8 | 91.8 | 86.0 | 80.6 | 75.5 | 70.8 |
| Depreciation, % | 2.89 | 3.9 | 3.17 | 3.12 | 3.43 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 |
| EBIT | 129.5 | 136.4 | 67.6 | -163.2 | 222.1 | 66.0 | 61.8 | 57.9 | 54.3 | 50.9 |
| EBIT, % | 3.27 | 4.55 | 2.16 | -5.59 | 7.49 | 2.38 | 2.38 | 2.38 | 2.38 | 2.38 |
| Total Cash | 531.6 | 187.9 | 243.7 | 1,857.2 | 368.9 | 575.1 | 538.9 | 505.0 | 473.3 | 443.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 299.8 | 312.1 | 343.1 | 561.6 | 706.1 | 399.9 | 374.7 | 351.2 | 329.1 | 308.4 |
| Account Receivables, % | 7.56 | 10.41 | 10.95 | 19.24 | 23.82 | 14.4 | 14.4 | 14.4 | 14.4 | 14.4 |
| Inventories | 557.7 | 562.8 | 780.6 | 462.8 | 462.1 | 495.5 | 464.4 | 435.1 | 407.8 | 382.1 |
| Inventories, % | 14.07 | 18.77 | 24.92 | 15.86 | 15.59 | 17.84 | 17.84 | 17.84 | 17.84 | 17.84 |
| Accounts Payable | 362.5 | 388.6 | 453.1 | 396.6 | 397.3 | 353.1 | 330.9 | 310.1 | 290.5 | 272.3 |
| Accounts Payable, % | 9.14 | 12.96 | 14.46 | 13.59 | 13.4 | 12.71 | 12.71 | 12.71 | 12.71 | 12.71 |
| Capital Expenditure | -61.0 | -43.6 | -64.0 | -59.0 | -44.0 | -47.4 | -44.5 | -41.7 | -39.0 | -36.6 |
| Capital Expenditure, % | -1.54 | -1.45 | -2.04 | -2.02 | -1.48 | -1.71 | -1.71 | -1.71 | -1.71 | -1.71 |
| Tax Rate, % | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 |
| EBITAT | 81.5 | -188.0 | 57.6 | 1,013.1 | 169.4 | 29.6 | 27.8 | 26.0 | 24.4 | 22.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -359.9 | -105.9 | -91.4 | 1,088.1 | 84.1 | 302.5 | 103.4 | 96.9 | 90.8 | 85.1 |
| WACC, % | 9.34 | 8.19 | 9.75 | 8.19 | 9.58 | 9.01 | 9.01 | 9.01 | 9.01 | 9.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 558.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 88 | |||||||||
| Terminal Value | 1,458 | |||||||||
| Present Terminal Value | 947 | |||||||||
| Enterprise Value | 1,506 | |||||||||
| Net Debt | 270 | |||||||||
| Equity Value | 1,237 | |||||||||
| Diluted Shares Outstanding, MM | 31 | |||||||||
| Equity Value Per Share | 40.55 |
What You Will Get
- Comprehensive SPB Financials: Access to historical and forecasted data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to project Spectrum Brands' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Spectrum Financials: Gain access to precise pre-loaded historical data and future forecasts for Spectrum Brands Holdings, Inc. (SPB).
- Adjustable Forecast Parameters: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins to tailor your analysis.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize easy-to-read charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout crafted for investors, CFOs, and consultants, whether seasoned or new to the field.
How It Works
- Download the Template: Gain immediate access to the Excel-based SPB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Spectrum Brands' intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for Spectrum Brands Holdings, Inc. (SPB)?
- Accurate Data: Real Spectrum Brands financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to fit your projections.
- Time-Saving: Pre-built calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the consumer goods sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Spectrum Brands Holdings, Inc. (SPB) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Spectrum Brands Holdings, Inc. (SPB).
- Consultants: Deliver professional valuation insights regarding Spectrum Brands Holdings, Inc. (SPB) to clients quickly and accurately.
- Business Owners: Understand how companies like Spectrum Brands Holdings, Inc. (SPB) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Spectrum Brands Holdings, Inc. (SPB).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Spectrum Brands Holdings, Inc. (SPB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Spectrum Brands Holdings, Inc. (SPB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.