Sypris Solutions, Inc. (SYPR) 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
Sypris Solutions, Inc. (SYPR) Bundle
Explore the financial outlook of Sypris Solutions, Inc. (SYPR) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Sypris Solutions, Inc. (SYPR) and shape your investment approach.
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 | 87.9 | 82.3 | 97.4 | 110.1 | 136.2 | 152.8 | 171.4 | 192.3 | 215.8 | 242.1 |
| Revenue Growth, % | 0 | -6.31 | 18.32 | 13.02 | 23.7 | 12.18 | 12.18 | 12.18 | 12.18 | 12.18 |
| EBITDA | -.4 | 3.0 | 8.5 | 3.5 | 3.1 | 5.3 | 6.0 | 6.7 | 7.5 | 8.4 |
| EBITDA, % | -0.43122 | 3.59 | 8.7 | 3.22 | 2.28 | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 |
| Depreciation | 2.7 | 3.4 | 3.6 | 4.0 | 3.3 | 5.2 | 5.8 | 6.5 | 7.3 | 8.2 |
| Depreciation, % | 3.04 | 4.15 | 3.7 | 3.61 | 2.39 | 3.38 | 3.38 | 3.38 | 3.38 | 3.38 |
| EBIT | -3.1 | -.5 | 4.9 | -.4 | -.2 | .1 | .2 | .2 | .2 | .2 |
| EBIT, % | -3.47 | -0.55133 | 4.99 | -0.39593 | -0.11452 | 0.09202228 | 0.09202228 | 0.09202228 | 0.09202228 | 0.09202228 |
| Total Cash | 5.1 | 11.6 | 11.6 | 21.6 | 7.9 | 17.5 | 19.6 | 22.0 | 24.7 | 27.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 8.4 | 8.5 | 10.4 | 10.5 | 13.6 | 15.3 | 17.1 | 19.2 | 21.5 | 24.2 |
| Account Receivables, % | 9.5 | 10.29 | 10.65 | 9.5 | 9.96 | 9.98 | 9.98 | 9.98 | 9.98 | 9.98 |
| Inventories | 20.8 | 16.2 | 30.1 | 42.1 | 77.3 | 51.7 | 58.0 | 65.1 | 73.0 | 81.9 |
| Inventories, % | 23.65 | 19.72 | 30.89 | 38.26 | 56.76 | 33.85 | 33.85 | 33.85 | 33.85 | 33.85 |
| Accounts Payable | 9.3 | 6.7 | 12.0 | 17.6 | 26.7 | 20.4 | 22.9 | 25.7 | 28.8 | 32.3 |
| Accounts Payable, % | 10.63 | 8.18 | 12.28 | 16.02 | 19.63 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 |
| Capital Expenditure | -.9 | -1.5 | -2.8 | -3.0 | -2.1 | -3.1 | -3.5 | -3.9 | -4.3 | -4.9 |
| Capital Expenditure, % | -0.97735 | -1.87 | -2.9 | -2.76 | -1.57 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 |
| Tax Rate, % | -71.06 | -71.06 | -71.06 | -71.06 | -71.06 | -71.06 | -71.06 | -71.06 | -71.06 | -71.06 |
| EBITAT | -3.0 | .6 | 3.6 | -.7 | -.3 | .1 | .1 | .1 | .1 | .2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -21.0 | 4.3 | -6.2 | -6.2 | -28.3 | 19.7 | -3.2 | -3.6 | -4.1 | -4.6 |
| WACC, % | 8.11 | 6.84 | 7.77 | 8.11 | 8.11 | 7.79 | 7.79 | 7.79 | 7.79 | 7.79 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 6.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -5 | |||||||||
| Terminal Value | -80 | |||||||||
| Present Terminal Value | -55 | |||||||||
| Enterprise Value | -49 | |||||||||
| Net Debt | 8 | |||||||||
| Equity Value | -57 | |||||||||
| Diluted Shares Outstanding, MM | 22 | |||||||||
| Equity Value Per Share | -2.59 |
What You Will Receive
- Flexible Forecast Inputs: Modify key assumptions (growth %, margins, WACC) to generate various scenarios.
- Industry-Specific Data: Sypris Solutions, Inc.'s (SYPR) financial data pre-loaded to enhance your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailorable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Designed for Analysts and Investors: Perfect for assessing projections, validating strategies, and optimizing efficiency.
Key Features
- Comprehensive SYPR Data: Pre-loaded with Sypris Solutions’ historical performance and future projections.
- Customizable Financial Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Interactive Valuation Model: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, suitable for both experienced professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template containing Sypris Solutions, Inc. (SYPR) 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 Sypris Solutions, Inc.'s (SYPR) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Sypris Solutions, Inc. (SYPR)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Sypris Solutions' valuation as you change inputs.
- Preloaded Data: Comes with Sypris Solutions' actual financial metrics for quick evaluations.
- Preferred by Experts: Valued by investors and analysts for making educated decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive valuation models for in-depth portfolio assessments of Sypris Solutions, Inc. (SYPR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients investing in Sypris Solutions, Inc. (SYPR).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into the market valuation of specialized technology and solutions providers like Sypris Solutions, Inc. (SYPR).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Sypris Solutions 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 Sypris Solutions, Inc. (SYPR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.