OneWater Marine Inc. (ONEW) 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
OneWater Marine Inc. (ONEW) Bundle
Explore the financial prospects of OneWater Marine Inc. (ONEW) using our user-friendly DCF Calculator! Enter your forecasts for growth, margins, and expenses to calculate the intrinsic value of OneWater Marine Inc. (ONEW) and refine your investment approach.
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,023.0 | 1,228.2 | 1,744.8 | 1,936.3 | 1,772.6 | 2,059.1 | 2,391.9 | 2,778.5 | 3,227.5 | 3,749.2 |
| Revenue Growth, % | 0 | 20.06 | 42.06 | 10.97 | -8.45 | 16.16 | 16.16 | 16.16 | 16.16 | 16.16 |
| EBITDA | 91.9 | 158.4 | 230.0 | 43.9 | 87.0 | 174.0 | 202.1 | 234.7 | 272.7 | 316.7 |
| EBITDA, % | 8.99 | 12.9 | 13.18 | 2.27 | 4.91 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
| Depreciation | 3.2 | 5.4 | 16.3 | 26.8 | 22.2 | 17.8 | 20.7 | 24.0 | 27.9 | 32.4 |
| Depreciation, % | 0.3176 | 0.44056 | 0.93396 | 1.38 | 1.25 | 0.86546 | 0.86546 | 0.86546 | 0.86546 | 0.86546 |
| EBIT | 88.7 | 153.0 | 213.7 | 17.1 | 64.8 | 156.1 | 181.4 | 210.7 | 244.7 | 284.3 |
| EBIT, % | 8.67 | 12.46 | 12.25 | 0.88385 | 3.66 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
| Total Cash | 66.1 | 62.6 | 42.1 | 84.6 | 16.8 | 79.4 | 92.3 | 107.2 | 124.5 | 144.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 18.5 | 30.8 | 61.7 | 117.6 | 75.8 | 75.0 | 87.1 | 101.1 | 117.5 | 136.5 |
| Account Receivables, % | 1.81 | 2.51 | 3.53 | 6.07 | 4.28 | 3.64 | 3.64 | 3.64 | 3.64 | 3.64 |
| Inventories | 150.1 | 143.9 | 373.0 | 609.6 | 590.8 | 463.6 | 538.6 | 625.6 | 726.7 | 844.2 |
| Inventories, % | 14.68 | 11.71 | 21.38 | 31.48 | 33.33 | 22.52 | 22.52 | 22.52 | 22.52 | 22.52 |
| Accounts Payable | 12.8 | 18.1 | 27.3 | 27.1 | 32.1 | 30.9 | 35.9 | 41.7 | 48.4 | 56.2 |
| Accounts Payable, % | 1.25 | 1.47 | 1.56 | 1.4 | 1.81 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
| Capital Expenditure | -6.3 | -9.9 | -15.6 | -24.1 | -25.9 | -20.7 | -24.0 | -27.9 | -32.4 | -37.7 |
| Capital Expenditure, % | -0.61673 | -0.80573 | -0.89688 | -1.24 | -1.46 | -1 | -1 | -1 | -1 | -1 |
| Tax Rate, % | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 |
| EBITAT | 78.5 | 125.2 | 142.9 | 15.5 | 58.4 | 130.5 | 151.6 | 176.1 | 204.6 | 237.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -80.4 | 120.0 | -107.2 | -274.5 | 120.1 | 254.5 | 66.2 | 77.0 | 89.4 | 103.8 |
| WACC, % | 8.37 | 7.99 | 7.15 | 8.49 | 8.46 | 8.09 | 8.09 | 8.09 | 8.09 | 8.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 489.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 104 | |||||||||
| Terminal Value | 1,374 | |||||||||
| Present Terminal Value | 931 | |||||||||
| Enterprise Value | 1,420 | |||||||||
| Net Debt | 991 | |||||||||
| Equity Value | 429 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | 29.43 |
What You Will Get
- Real ONEW Financial Data: Pre-filled with OneWater Marine Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See OneWater Marine Inc.'s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Real-Life ONEW Data: Pre-filled with OneWater Marine Inc.'s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures according to your needs.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Create multiple forecast scenarios to evaluate different valuation outcomes.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review OneWater Marine Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the findings for investment decisions.
Why Choose This Calculator for OneWater Marine Inc. (ONEW)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient platform.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes OneWater Marine's intrinsic value and Net Present Value.
- Preloaded Data: Features historical and projected data for precise analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on OneWater Marine Inc. (ONEW).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling OneWater Marine Inc. (ONEW) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for OneWater Marine Inc. (ONEW).
- Consultants: Provide clients with precise valuation insights regarding OneWater Marine Inc. (ONEW) efficiently.
- Business Owners: Gain insights into how companies like OneWater Marine Inc. (ONEW) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-world data and case studies related to OneWater Marine Inc. (ONEW).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for OneWater Marine Inc. (ONEW).
- Real-World Data: OneWater Marine’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into OneWater Marine Inc. (ONEW).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to OneWater Marine Inc. (ONEW).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to OneWater Marine Inc. (ONEW).