|
Valoración DCF de Westport Fuel Systems Inc. (WPRT)
CA | Consumer Cyclical | Auto - Parts | NASDAQ
|
- ✓ 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
Westport Fuel Systems Inc. (WPRT) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora WPRT DCF! Equipado con datos reales de Westport Fuel Systems Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar WPRT como un inversor experimentado.
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 | 305.3 | 252.5 | 312.4 | 305.7 | 331.8 | 342.4 | 353.4 | 364.7 | 376.4 | 388.5 |
| Revenue Growth, % | 0 | -17.31 | 23.73 | -2.15 | 8.54 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 |
| EBITDA | 2.6 | -8.4 | -9.2 | -15.5 | -33.9 | -14.2 | -14.6 | -15.1 | -15.6 | -16.1 |
| EBITDA, % | 0.84618 | -3.32 | -2.93 | -5.07 | -10.2 | -4.13 | -4.13 | -4.13 | -4.13 | -4.13 |
| Depreciation | 20.3 | 14.8 | 13.9 | 11.3 | 12.5 | 16.7 | 17.3 | 17.8 | 18.4 | 19.0 |
| Depreciation, % | 6.65 | 5.85 | 4.45 | 3.71 | 3.76 | 4.89 | 4.89 | 4.89 | 4.89 | 4.89 |
| EBIT | -17.7 | -23.1 | -23.1 | -26.8 | -46.3 | -30.9 | -31.9 | -32.9 | -34.0 | -35.0 |
| EBIT, % | -5.81 | -9.17 | -7.39 | -8.78 | -13.97 | -9.02 | -9.02 | -9.02 | -9.02 | -9.02 |
| Total Cash | 43.7 | 64.3 | 124.9 | 86.2 | 54.8 | 85.2 | 88.0 | 90.8 | 93.7 | 96.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 67.0 | 90.5 | 101.4 | 101.6 | 88.1 | 102.7 | 106.0 | 109.4 | 112.9 | 116.5 |
| Account Receivables, % | 21.93 | 35.83 | 32.45 | 33.23 | 26.55 | 30 | 30 | 30 | 30 | 30 |
| Inventories | 47.8 | 51.4 | 83.1 | 81.6 | 67.5 | 75.1 | 77.5 | 80.0 | 82.6 | 85.2 |
| Inventories, % | 15.66 | 20.36 | 26.61 | 26.7 | 20.35 | 21.94 | 21.94 | 21.94 | 21.94 | 21.94 |
| Accounts Payable | 60.2 | 57.3 | 73.4 | 72.9 | 70.6 | 76.0 | 78.5 | 81.0 | 83.6 | 86.3 |
| Accounts Payable, % | 19.71 | 22.7 | 23.49 | 23.86 | 21.27 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 |
| Capital Expenditure | -8.9 | -7.1 | -14.2 | -14.5 | -15.6 | -13.5 | -13.9 | -14.4 | -14.8 | -15.3 |
| Capital Expenditure, % | -2.9 | -2.82 | -4.53 | -4.75 | -4.69 | -3.94 | -3.94 | -3.94 | -3.94 | -3.94 |
| Tax Rate, % | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 |
| EBITAT | -1.6 | -28.7 | -57.0 | -28.0 | -47.3 | -25.3 | -26.1 | -26.9 | -27.8 | -28.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -44.7 | -51.1 | -83.8 | -30.4 | -25.1 | -38.8 | -26.0 | -26.8 | -27.7 | -28.6 |
| WACC, % | 8.61 | 10.9 | 10.9 | 10.9 | 10.9 | 10.44 | 10.44 | 10.44 | 10.44 | 10.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -112.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -29 | |||||||||
| Terminal Value | -345 | |||||||||
| Present Terminal Value | -210 | |||||||||
| Enterprise Value | -322 | |||||||||
| Net Debt | 28 | |||||||||
| Equity Value | -350 | |||||||||
| Diluted Shares Outstanding, MM | 17 | |||||||||
| Equity Value Per Share | -20.41 |
What You Will Get
- Real WPRT Financial Data: Pre-filled with Westport Fuel Systems’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Westport Fuel Systems’ 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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Westport Fuel Systems Inc. (WPRT).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with adjustable inputs to suit your analysis.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates specific to WPRT.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Westport Fuel Systems Inc. (WPRT).
- Visual Dashboard and Charts: Graphical outputs present key valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Westport Fuel Systems Inc. (WPRT) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth projections, WACC, and capital expenditures.
- 3. Instant Result Analysis: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Various Scenarios: Evaluate different forecasts to assess a range of valuation results.
- 5. Present with Assurance: Deliver professional valuation findings to enhance your decision-making process.
Why Choose This Calculator for Westport Fuel Systems Inc. (WPRT)?
- Accuracy: Utilizes real Westport financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Energy Sector Students: Understand fuel system technologies and apply them using real-world data.
- Researchers: Integrate advanced fuel system models into academic studies or projects.
- Investors: Evaluate your investment strategies and assess valuation metrics for Westport Fuel Systems Inc. (WPRT).
- Industry Analysts: Enhance your analysis with a customizable financial model specific to fuel systems.
- Entrepreneurs: Discover how large companies like Westport Fuel Systems Inc. (WPRT) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Westport Fuel Systems Inc. (WPRT) 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 Westport Fuel Systems Inc. (WPRT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.