Sturm, Ruger & Company, Inc. (RGR) 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
Sturm, Ruger & Company, Inc. (RGR) Bundle
Evaluate the financial outlook of Sturm, Ruger & Company, Inc. (RGR) with expertise! This (RGR) DCF Calculator provides pre-filled financial data and full customization to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 410.5 | 568.9 | 730.7 | 595.8 | 543.8 | 597.9 | 657.5 | 722.9 | 794.9 | 874.1 |
| Revenue Growth, % | 0 | 38.58 | 28.45 | -18.46 | -8.74 | 9.96 | 9.96 | 9.96 | 9.96 | 9.96 |
| EBITDA | 72.4 | 148.7 | 232.9 | 134.3 | 81.4 | 135.3 | 148.8 | 163.6 | 179.9 | 197.8 |
| EBITDA, % | 17.63 | 26.15 | 31.87 | 22.54 | 14.97 | 22.63 | 22.63 | 22.63 | 22.63 | 22.63 |
| Depreciation | 29.3 | 27.6 | 26.2 | 25.8 | 22.4 | 28.7 | 31.6 | 34.7 | 38.2 | 42.0 |
| Depreciation, % | 7.15 | 4.85 | 3.58 | 4.33 | 4.12 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 |
| EBIT | 43.0 | 121.2 | 206.8 | 108.5 | 59.0 | 106.6 | 117.2 | 128.9 | 141.7 | 155.8 |
| EBIT, % | 10.48 | 21.3 | 28.29 | 18.22 | 10.86 | 17.83 | 17.83 | 17.83 | 17.83 | 17.83 |
| Total Cash | 164.9 | 141.2 | 221.0 | 224.3 | 117.7 | 184.8 | 203.2 | 223.4 | 245.6 | 270.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 52.6 | 57.9 | 57.0 | 65.4 | 59.9 | 63.1 | 69.4 | 76.3 | 83.9 | 92.3 |
| Account Receivables, % | 12.82 | 10.17 | 7.81 | 10.98 | 11.01 | 10.56 | 10.56 | 10.56 | 10.56 | 10.56 |
| Inventories | 28.3 | 29.1 | 43.9 | 65.0 | 79.8 | 52.1 | 57.3 | 63.0 | 69.3 | 76.2 |
| Inventories, % | 6.89 | 5.11 | 6 | 10.91 | 14.68 | 8.72 | 8.72 | 8.72 | 8.72 | 8.72 |
| Accounts Payable | 8.3 | 12.8 | 12.2 | 13.3 | 11.1 | 12.2 | 13.4 | 14.8 | 16.3 | 17.9 |
| Accounts Payable, % | 2.03 | 2.25 | 1.67 | 2.23 | 2.04 | 2.04 | 2.04 | 2.04 | 2.04 | 2.04 |
| Capital Expenditure | -20.3 | -24.2 | -28.8 | -27.7 | -15.8 | -24.8 | -27.2 | -29.9 | -32.9 | -36.2 |
| Capital Expenditure, % | -4.94 | -4.26 | -3.94 | -4.65 | -2.9 | -4.14 | -4.14 | -4.14 | -4.14 | -4.14 |
| Tax Rate, % | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 |
| EBITAT | 32.3 | 90.5 | 156.0 | 88.5 | 48.4 | 82.9 | 91.1 | 100.2 | 110.2 | 121.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -31.3 | 92.3 | 138.9 | 58.1 | 43.6 | 112.4 | 85.2 | 93.7 | 103.1 | 113.3 |
| WACC, % | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 421.0 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 114 | |||||||||
| Terminal Value | 2,076 | |||||||||
| Present Terminal Value | 1,514 | |||||||||
| Enterprise Value | 1,935 | |||||||||
| Net Debt | -13 | |||||||||
| Equity Value | 1,948 | |||||||||
| Diluted Shares Outstanding, MM | 18 | |||||||||
| Equity Value Per Share | 109.38 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real RGR financials.
- Real-World Data: Historical data and forward-looking estimates (as showcased in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Sturm, Ruger & Company’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 guidance.
Key Features
- Real-Life RGR Data: Pre-filled with Sturm, Ruger & Company’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.
How It Works
- Download the Template: Gain immediate access to the Excel-based RGR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically calculates Sturm, Ruger & Company’s 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 decisions.
Why Choose This Calculator for Sturm, Ruger & Company, Inc. (RGR)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Comprehensive Data: Sturm, Ruger's historical and projected financials are preloaded to ensure precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Intuitive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Detailed step-by-step instructions to navigate the calculator seamlessly.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing Sturm, Ruger & Company, Inc. (RGR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Sturm, Ruger & Company, Inc. (RGR).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Firearms Industry Enthusiasts: Gain insights into how companies like Sturm, Ruger & Company, Inc. (RGR) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes Sturm, Ruger & Company, Inc.'s (RGR) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Sturm, Ruger & Company, Inc.'s (RGR) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.