Energy Recovery, Inc. (ERII) 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
Energy Recovery, Inc. (ERII) Bundle
Evaluate Energy Recovery, Inc. (ERII) financial prospects like an expert! This (ERII) DCF Calculator provides you with pre-filled financial data and full flexibility 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 | 86.9 | 119.0 | 103.9 | 125.6 | 128.3 | 143.5 | 160.5 | 179.4 | 200.6 | 224.3 |
| Revenue Growth, % | 0 | 36.86 | -12.68 | 20.87 | 2.2 | 11.81 | 11.81 | 11.81 | 11.81 | 11.81 |
| EBITDA | 16.7 | 38.9 | 19.8 | 31.1 | 24.8 | 33.0 | 36.9 | 41.3 | 46.1 | 51.6 |
| EBITDA, % | 19.15 | 32.71 | 19.03 | 24.79 | 19.32 | 23 | 23 | 23 | 23 | 23 |
| Depreciation | 4.4 | 5.3 | 5.9 | 6.3 | 5.7 | 7.1 | 7.9 | 8.9 | 9.9 | 11.1 |
| Depreciation, % | 5.06 | 4.45 | 5.72 | 5.02 | 4.48 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
| EBIT | 12.3 | 33.6 | 13.8 | 24.8 | 19.1 | 25.9 | 29.0 | 32.4 | 36.2 | 40.5 |
| EBIT, % | 14.1 | 28.26 | 13.31 | 19.77 | 14.84 | 18.06 | 18.06 | 18.06 | 18.06 | 18.06 |
| Total Cash | 85.1 | 114.7 | 105.7 | 92.9 | 108.5 | 130.0 | 145.3 | 162.5 | 181.7 | 203.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 13.5 | 13.1 | 21.1 | 35.8 | 48.1 | 32.4 | 36.2 | 40.5 | 45.3 | 50.6 |
| Account Receivables, % | 15.5 | 11.01 | 20.31 | 28.49 | 37.48 | 22.56 | 22.56 | 22.56 | 22.56 | 22.56 |
| Inventories | 10.3 | 11.7 | 20.4 | 28.4 | 26.1 | 24.2 | 27.1 | 30.3 | 33.8 | 37.8 |
| Inventories, % | 11.87 | 9.87 | 19.62 | 22.59 | 20.37 | 16.86 | 16.86 | 16.86 | 16.86 | 16.86 |
| Accounts Payable | 1.2 | 1.1 | .9 | .8 | 3.0 | 1.8 | 2.0 | 2.2 | 2.5 | 2.8 |
| Accounts Payable, % | 1.37 | 0.93961 | 0.87485 | 0.64814 | 2.34 | 1.23 | 1.23 | 1.23 | 1.23 | 1.23 |
| Capital Expenditure | -7.4 | -6.8 | -6.7 | -3.1 | -2.6 | -7.2 | -8.1 | -9.0 | -10.1 | -11.3 |
| Capital Expenditure, % | -8.49 | -5.7 | -6.43 | -2.49 | -2 | -5.02 | -5.02 | -5.02 | -5.02 | -5.02 |
| Tax Rate, % | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
| EBITAT | 10.9 | 27.6 | 14.1 | 22.9 | 18.0 | 23.7 | 26.5 | 29.7 | 33.2 | 37.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -14.7 | 25.0 | -3.5 | 3.3 | 13.3 | 40.1 | 19.9 | 22.3 | 24.9 | 27.9 |
| WACC, % | 10.14 | 10.14 | 10.15 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 103.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 29 | |||||||||
| Terminal Value | 472 | |||||||||
| Present Terminal Value | 291 | |||||||||
| Enterprise Value | 395 | |||||||||
| Net Debt | -55 | |||||||||
| Equity Value | 450 | |||||||||
| Diluted Shares Outstanding, MM | 58 | |||||||||
| Equity Value Per Share | 7.79 |
What You Will Receive
- Authentic ERII Financial Data: Pre-loaded with Energy Recovery’s historical and forecasted figures for thorough analysis.
- Completely Customizable Template: Easily adjust key metrics such as revenue growth, WACC, and EBITDA percentage.
- Instant Calculations: Watch as Energy Recovery’s intrinsic value updates in real-time with your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- Real-Life ERII Data: Pre-filled with Energy Recovery, Inc.'s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures specific to ERII.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes for ERII.
- User-Friendly Design: Simple, structured, and designed for both professionals and beginners in the energy sector.
How It Works
- Download the Template: Gain immediate access to the Excel-based ERII DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model automatically recalculates Energy Recovery, Inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Energy Recovery, Inc. (ERII)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for ERII.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for ERII.
- Detailed Insights: Automatically computes Energy Recovery's intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable benchmarks for ERII.
- Professional Quality: Designed for financial analysts, investors, and business consultants focusing on ERII.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing portfolios involving Energy Recovery, Inc. (ERII).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Energy Recovery, Inc. (ERII).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling techniques.
- Energy Sector Enthusiasts: Gain insights into how companies like Energy Recovery, Inc. (ERII) are valued within the energy market.
What the Template Contains
- Pre-Filled DCF Model: Energy Recovery, Inc.'s (ERII) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Energy Recovery, Inc.'s (ERII) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.