Smith & Wesson Brands, Inc. (SWBI) 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
Smith & Wesson Brands, Inc. (SWBI) Bundle
Discover the true potential of Smith & Wesson Brands, Inc. (SWBI) with our advanced DCF Calculator! Adjust crucial assumptions, explore various scenarios, and evaluate how different factors affect the valuation of Smith & Wesson Brands, Inc. (SWBI) – all within one comprehensive Excel template.
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 | 678.4 | 1,059.2 | 864.1 | 479.2 | 535.8 | 542.5 | 549.3 | 556.1 | 563.0 | 570.1 |
Revenue Growth, % | 0 | 56.13 | -18.42 | -44.54 | 11.81 | 1.25 | 1.25 | 1.25 | 1.25 | 1.25 |
EBITDA | 81.6 | 319.6 | 251.7 | 81.1 | 84.0 | 112.8 | 114.2 | 115.6 | 117.0 | 118.5 |
EBITDA, % | 12.03 | 30.18 | 29.12 | 16.92 | 15.68 | 20.79 | 20.79 | 20.79 | 20.79 | 20.79 |
Depreciation | 31.3 | 30.7 | 30.0 | 31.3 | 32.6 | 25.6 | 25.9 | 26.2 | 26.6 | 26.9 |
Depreciation, % | 4.61 | 2.9 | 3.47 | 6.54 | 6.08 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 |
EBIT | 50.3 | 288.9 | 221.7 | 49.8 | 51.5 | 87.2 | 88.2 | 89.3 | 90.5 | 91.6 |
EBIT, % | 7.42 | 27.28 | 25.65 | 10.38 | 9.6 | 16.07 | 16.07 | 16.07 | 16.07 | 16.07 |
Total Cash | 125.4 | 113.0 | 120.7 | 53.6 | 60.8 | 71.2 | 72.1 | 73.0 | 73.9 | 74.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 60.9 | 68.4 | 64.6 | 56.3 | 61.6 | 50.1 | 50.7 | 51.3 | 52.0 | 52.6 |
Account Receivables, % | 8.97 | 6.45 | 7.48 | 11.75 | 11.49 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 |
Inventories | 164.2 | 78.5 | 136.7 | 177.1 | 160.5 | 124.1 | 125.6 | 127.2 | 128.8 | 130.4 |
Inventories, % | 24.2 | 7.41 | 15.81 | 36.96 | 29.95 | 22.87 | 22.87 | 22.87 | 22.87 | 22.87 |
Accounts Payable | 31.5 | 57.3 | 30.0 | 36.8 | 41.8 | 31.5 | 31.9 | 32.3 | 32.7 | 33.1 |
Accounts Payable, % | 4.64 | 5.41 | 3.48 | 7.68 | 7.81 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
Capital Expenditure | -14.7 | -22.7 | -24.3 | -89.9 | -90.9 | -46.5 | -47.1 | -47.7 | -48.3 | -48.9 |
Capital Expenditure, % | -2.17 | -2.14 | -2.81 | -18.76 | -16.97 | -8.57 | -8.57 | -8.57 | -8.57 | -8.57 |
Tax Rate, % | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 |
EBITAT | 51.4 | 229.0 | 170.8 | 38.0 | 41.3 | 72.0 | 72.9 | 73.8 | 74.7 | 75.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -125.7 | 341.2 | 94.8 | -45.9 | -.7 | 88.7 | 50.0 | 50.6 | 51.2 | 51.8 |
WACC, % | 8.18 | 8.05 | 8.04 | 8.03 | 8.06 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
PV UFCF | ||||||||||
SUM PV UFCF | 237.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 53 | |||||||||
Terminal Value | 871 | |||||||||
Present Terminal Value | 591 | |||||||||
Enterprise Value | 828 | |||||||||
Net Debt | 18 | |||||||||
Equity Value | 811 | |||||||||
Diluted Shares Outstanding, MM | 46 | |||||||||
Equity Value Per Share | 17.53 |
What You Will Get
- Real SWBI Financial Data: Pre-filled with Smith & Wesson’s historical and projected data for accurate analysis.
- Fully Editable Template: Easily modify key inputs such as revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Watch Smith & Wesson’s intrinsic value update in real-time based on your adjustments.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- User-Friendly Design: Intuitive layout and straightforward instructions suitable for all experience levels.
Key Features
- Real-Life SWBI Data: Pre-filled with Smith & Wesson's historical financials and future projections.
- Fully Customizable Inputs: Adjust revenue growth, profit margins, weighted average cost of capital (WACC), tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create various forecast scenarios to explore different valuation outcomes.
- User-Friendly Design: Intuitive, structured, and suitable for both professionals and novices.
How It Works
- Step 1: Download the prebuilt Excel template featuring Smith & Wesson Brands, Inc. (SWBI) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Smith & Wesson's intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Smith & Wesson Brands, Inc. (SWBI)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for the firearms industry.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Smith & Wesson’s intrinsic value and Net Present Value.
- Ready-to-Use Data: Historical and projected data provide a reliable foundation for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and industry consultants focused on SWBI.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Smith & Wesson Brands, Inc. (SWBI) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Smith & Wesson Brands, Inc. (SWBI).
- Consultants: Deliver professional valuation insights regarding Smith & Wesson Brands, Inc. (SWBI) to clients quickly and accurately.
- Business Owners: Understand how firearm companies like Smith & Wesson Brands, Inc. (SWBI) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Smith & Wesson Brands, Inc. (SWBI).
What the Template Contains
- Pre-Filled DCF Model: Smith & Wesson’s financial data preloaded for immediate use.
- WACC Calculator: Comprehensive calculations for Weighted Average Cost of Capital.
- Financial Ratios: Assess Smith & Wesson’s profitability, leverage, and efficiency.
- Editable Inputs: Modify assumptions such as growth, margins, and CAPEX to suit your scenarios.
- Financial Statements: Annual and quarterly reports to facilitate detailed analysis.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and results.