|
Perma-Pipe International Holdings, Inc. (PPIH) DCF Valuation
US | Industrials | Construction | NASDAQ
|
- ✓ 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
Perma-Pipe International Holdings, Inc. (PPIH) Bundle
Discover the true value of Perma-Pipe International Holdings, Inc. (PPIH) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how different factors influence the valuation of Perma-Pipe International Holdings, Inc. (PPIH) – all within a user-friendly Excel template.
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 | 127.7 | 84.7 | 138.6 | 142.6 | 150.7 | 165.2 | 181.1 | 198.5 | 217.6 | 238.6 |
| Revenue Growth, % | 0 | -33.66 | 63.59 | 2.9 | 5.68 | 9.63 | 9.63 | 9.63 | 9.63 | 9.63 |
| EBITDA | 5.9 | -2.2 | 12.4 | 14.8 | 16.0 | 10.6 | 11.6 | 12.7 | 13.9 | 15.3 |
| EBITDA, % | 4.65 | -2.57 | 8.97 | 10.37 | 10.61 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
| Depreciation | 4.4 | 5.0 | 4.6 | 3.9 | 3.8 | 5.9 | 6.5 | 7.1 | 7.8 | 8.6 |
| Depreciation, % | 3.48 | 5.85 | 3.3 | 2.76 | 2.54 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
| EBIT | 1.5 | -7.1 | 7.9 | 10.9 | 12.2 | 4.7 | 5.1 | 5.6 | 6.1 | 6.7 |
| EBIT, % | 1.18 | -8.41 | 5.68 | 7.62 | 8.07 | 2.82 | 2.82 | 2.82 | 2.82 | 2.82 |
| Total Cash | 13.4 | 7.2 | 8.2 | 5.8 | 5.8 | 10.8 | 11.9 | 13.0 | 14.3 | 15.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 31.6 | 29.5 | 49.4 | 56.8 | 66.3 | 59.1 | 64.8 | 71.1 | 77.9 | 85.4 |
| Account Receivables, % | 24.73 | 34.81 | 35.66 | 39.82 | 44.03 | 35.81 | 35.81 | 35.81 | 35.81 | 35.81 |
| Inventories | 14.5 | 12.2 | 13.8 | 14.7 | 15.5 | 18.6 | 20.4 | 22.4 | 24.5 | 26.9 |
| Inventories, % | 11.36 | 14.35 | 9.93 | 10.34 | 10.31 | 11.26 | 11.26 | 11.26 | 11.26 | 11.26 |
| Accounts Payable | 9.6 | 10.4 | 13.6 | 14.8 | 25.3 | 18.7 | 20.5 | 22.5 | 24.7 | 27.1 |
| Accounts Payable, % | 7.5 | 12.24 | 9.83 | 10.35 | 16.81 | 11.34 | 11.34 | 11.34 | 11.34 | 11.34 |
| Capital Expenditure | -1.9 | -2.0 | -2.3 | -7.0 | -11.1 | -5.8 | -6.4 | -7.0 | -7.7 | -8.4 |
| Capital Expenditure, % | -1.49 | -2.32 | -1.63 | -4.89 | -7.37 | -3.54 | -3.54 | -3.54 | -3.54 | -3.54 |
| Tax Rate, % | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 |
| EBITAT | 1.1 | -7.0 | 5.7 | 6.8 | 12.9 | 3.8 | 4.1 | 4.5 | 5.0 | 5.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -32.9 | 1.2 | -10.3 | -3.5 | 5.8 | 1.4 | -1.5 | -1.6 | -1.8 | -1.9 |
| WACC, % | 5.66 | 6.07 | 5.68 | 5.52 | 6.09 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -4.2 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -2 | |||||||||
| Terminal Value | -37 | |||||||||
| Present Terminal Value | -28 | |||||||||
| Enterprise Value | -32 | |||||||||
| Net Debt | 27 | |||||||||
| Equity Value | -59 | |||||||||
| Diluted Shares Outstanding, MM | 8 | |||||||||
| Equity Value Per Share | -7.28 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Perma-Pipe International Holdings, Inc.'s (PPIH) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and other financial metrics.
- High-Precision Results: Leverages Perma-Pipe's (PPIH) actual financial data for accurate valuation insights.
- Effortless Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the need for complex model building from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template with Perma-Pipe International Holdings, Inc. (PPIH) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Perma-Pipe International Holdings, Inc. (PPIH)'s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Perma-Pipe International Holdings, Inc. (PPIH)?
- Accuracy: Utilizes real PPIH financial data to ensure precision.
- Flexibility: Allows users to easily adjust and experiment with inputs.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Perma-Pipe International Holdings, Inc. (PPIH)'s market position prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Gain insights into how established companies like Perma-Pipe are valued in the marketplace.
- Consultants: Create detailed valuation analyses and reports for client engagements.
- Students and Educators: Utilize current data to learn and teach effective valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Perma-Pipe International Holdings, Inc. (PPIH) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Perma-Pipe International Holdings, Inc. (PPIH).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.