|
Pangea Logistics Solutions, Ltd. (PANL) DCF Valoración
US | Industrials | Marine Shipping | 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
Pangaea Logistics Solutions, Ltd. (PANL) Bundle
¡Streamline Pangea Logistics Solutions, Ltd. (PANL) Valoración con nuestra calculadora DCF personalizable! Con REAL Pangea Logistics Solutions, Ltd. (Panl) Financials y entradas de pronóstico ajustable, puede experimentar con escenarios y revelar Pangea Logistics Solutions, Ltd. (PANL) Valor razonable en solo minutos.
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 | 412.2 | 382.9 | 718.1 | 699.7 | 499.3 | 560.7 | 629.7 | 707.2 | 794.3 | 892.0 |
| Revenue Growth, % | 0 | -7.11 | 87.55 | -2.56 | -28.65 | 12.31 | 12.31 | 12.31 | 12.31 | 12.31 |
| EBITDA | 44.9 | 39.3 | 101.8 | 138.3 | 76.1 | 78.9 | 88.6 | 99.5 | 111.7 | 125.5 |
| EBITDA, % | 10.88 | 10.26 | 14.18 | 19.77 | 15.24 | 14.07 | 14.07 | 14.07 | 14.07 | 14.07 |
| Depreciation | 18.5 | 17.1 | 23.0 | 29.5 | 30.1 | 25.1 | 28.2 | 31.7 | 35.6 | 39.9 |
| Depreciation, % | 4.5 | 4.45 | 3.2 | 4.21 | 6.02 | 4.48 | 4.48 | 4.48 | 4.48 | 4.48 |
| EBIT | 26.3 | 22.2 | 78.9 | 108.8 | 46.0 | 53.8 | 60.4 | 67.8 | 76.2 | 85.5 |
| EBIT, % | 6.39 | 5.81 | 10.98 | 15.55 | 9.22 | 9.59 | 9.59 | 9.59 | 9.59 | 9.59 |
| Total Cash | 50.6 | 46.9 | 56.2 | 128.4 | 99.0 | 79.1 | 88.8 | 99.8 | 112.0 | 125.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 28.3 | 29.2 | 54.3 | 36.8 | 53.7 | 42.7 | 47.9 | 53.8 | 60.4 | 67.9 |
| Account Receivables, % | 6.87 | 7.61 | 7.56 | 5.25 | 10.75 | 7.61 | 7.61 | 7.61 | 7.61 | 7.61 |
| Inventories | 21.0 | 16.0 | 27.1 | 29.1 | 19.1 | 23.6 | 26.5 | 29.7 | 33.4 | 37.5 |
| Inventories, % | 5.09 | 4.17 | 3.78 | 4.16 | 3.82 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 |
| Accounts Payable | 24.2 | 18.7 | 7.0 | 10.0 | 6.3 | 16.2 | 18.1 | 20.4 | 22.9 | 25.7 |
| Accounts Payable, % | 5.86 | 4.88 | 0.97895 | 1.43 | 1.26 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
| Capital Expenditure | -57.0 | -2.9 | -196.7 | -36.4 | -27.3 | -59.0 | -66.3 | -74.5 | -83.6 | -93.9 |
| Capital Expenditure, % | -13.83 | -0.76423 | -27.39 | -5.2 | -5.46 | -10.53 | -10.53 | -10.53 | -10.53 | -10.53 |
| Tax Rate, % | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 |
| EBITAT | 3.2 | 4.4 | 73.3 | 101.2 | 41.8 | 33.2 | 37.3 | 41.9 | 47.0 | 52.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -60.4 | 17.3 | -148.4 | 112.8 | 34.0 | 15.7 | -7.0 | -7.8 | -8.8 | -9.9 |
| WACC, % | 4.35 | 4.63 | 7.25 | 7.25 | 7.17 | 6.13 | 6.13 | 6.13 | 6.13 | 6.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -12.3 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -10 | |||||||||
| Terminal Value | -176 | |||||||||
| Present Terminal Value | -131 | |||||||||
| Enterprise Value | -143 | |||||||||
| Net Debt | 165 | |||||||||
| Equity Value | -309 | |||||||||
| Diluted Shares Outstanding, MM | 45 | |||||||||
| Equity Value Per Share | -6.79 |
What You Will Get
- Pre-Filled Financial Model: Pangaea Logistics Solutions’ actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Pre-Loaded Data: Pangaea Logistics Solutions' historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Pangaea's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and key metrics effectively.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Download: Access the pre-built Excel file featuring Pangaea Logistics Solutions, Ltd.'s (PANL) financial data.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: The calculations for intrinsic value and NPV refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Utilize the valuation outcomes to inform your investment approach.
Why Choose Pangaea Logistics Solutions, Ltd. (PANL)?
- Streamline Operations: Leverage our expertise to enhance your logistics efficiency.
- Boost Reliability: Our proven track record ensures dependable service and timely deliveries.
- Tailored Solutions: Customize logistics strategies to meet your specific business needs.
- User-Friendly Interface: Intuitive tools and resources simplify the logistics management process.
- Industry Expertise: Backed by professionals with extensive experience in the logistics sector.
Who Should Use Pangaea Logistics Solutions, Ltd. (PANL)?
- Investors: Gain insights into the logistics sector and make informed investment choices with our comprehensive analysis.
- Logistics Analysts: Utilize our data-driven tools to streamline your operational assessments and improve efficiency.
- Consultants: Easily customize our reports to meet client needs and enhance your strategic recommendations.
- Supply Chain Enthusiasts: Expand your knowledge of logistics solutions with real-life case studies and industry insights.
- Educators and Students: Leverage our resources as a hands-on learning aid in supply chain management and logistics courses.
What the Template Contains
- Preloaded PANL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.