|
Palomar Holdings, Inc. (PLMR) Valoración de DCF
US | Financial Services | Insurance - Property & Casualty | 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
Palomar Holdings, Inc. (PLMR) Bundle
¡Simplifique la valoración de Palomar Holdings, Inc. (PLMR) con esta calculadora DCF personalizable! Con Real Palomar Holdings, Inc. (PLMR) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Palomar Holdings, Inc. (PLMR) en 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 | 113.3 | 168.5 | 247.8 | 327.1 | 375.9 | 510.1 | 692.0 | 938.9 | 1,273.9 | 1,728.5 |
| Revenue Growth, % | 0 | 48.69 | 47.09 | 32 | 14.93 | 35.68 | 35.68 | 35.68 | 35.68 | 35.68 |
| EBITDA | 19.4 | 7.6 | 60.7 | 72.5 | 111.9 | 100.0 | 135.7 | 184.1 | 249.7 | 338.8 |
| EBITDA, % | 17.09 | 4.49 | 24.49 | 22.18 | 29.77 | 19.6 | 19.6 | 19.6 | 19.6 | 19.6 |
| Depreciation | .2 | 1.3 | 3.5 | 4.1 | 4.5 | 5.0 | 6.7 | 9.1 | 12.4 | 16.8 |
| Depreciation, % | 0.19065 | 0.79305 | 1.43 | 1.26 | 1.2 | 0.97397 | 0.97397 | 0.97397 | 0.97397 | 0.97397 |
| EBIT | 19.1 | 6.2 | 57.1 | 68.4 | 107.4 | 95.0 | 128.9 | 174.9 | 237.3 | 322.0 |
| EBIT, % | 16.9 | 3.69 | 23.06 | 20.92 | 28.57 | 18.63 | 18.63 | 18.63 | 18.63 | 18.63 |
| Total Cash | 250.3 | 431.5 | 483.0 | 583.2 | 51.5 | 422.0 | 572.6 | 776.9 | 1,054.1 | 1,430.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -80.3 | -96.5 | -162.7 | .0 | .0 | -197.7 | -268.2 | -363.9 | -493.8 | -669.9 |
| Inventories, % | -70.85 | -57.3 | -65.64 | 0 | 0 | -38.76 | -38.76 | -38.76 | -38.76 | -38.76 |
| Accounts Payable | 24.9 | 43.0 | 58.7 | 171.9 | 224.1 | 187.1 | 253.8 | 344.4 | 467.3 | 634.0 |
| Accounts Payable, % | 22.01 | 25.5 | 23.71 | 52.55 | 59.62 | 36.68 | 36.68 | 36.68 | 36.68 | 36.68 |
| Capital Expenditure | -2.9 | -4.1 | -4.9 | -5.9 | -6.8 | -10.8 | -14.6 | -19.9 | -26.9 | -36.5 |
| Capital Expenditure, % | -2.58 | -2.42 | -1.96 | -1.81 | -1.8 | -2.11 | -2.11 | -2.11 | -2.11 | -2.11 |
| Tax Rate, % | 23.58 | 23.58 | 23.58 | 23.58 | 23.58 | 23.58 | 23.58 | 23.58 | 23.58 | 23.58 |
| EBITAT | 11.2 | 6.3 | 45.8 | 52.8 | 82.1 | 74.6 | 101.2 | 137.4 | 186.4 | 252.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 113.7 | 37.8 | 126.5 | 1.5 | 132.1 | 229.4 | 230.6 | 312.9 | 424.5 | 576.0 |
| WACC, % | 5.99 | 6.04 | 6.02 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,450.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 588 | |||||||||
| Terminal Value | 14,636 | |||||||||
| Present Terminal Value | 10,930 | |||||||||
| Enterprise Value | 12,380 | |||||||||
| Net Debt | 1 | |||||||||
| Equity Value | 12,379 | |||||||||
| Diluted Shares Outstanding, MM | 25 | |||||||||
| Equity Value Per Share | 488.77 |
What You Will Get
- Real Palomar Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Palomar Holdings, Inc. (PLMR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Palomar Holdings, Inc. (PLMR).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Palomar Holdings, Inc. (PLMR)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Palomar Holdings, Inc. (PLMR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Palomar Holdings, Inc. (PLMR).
Key Features
- Comprehensive Data: Palomar Holdings, Inc.'s historical financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: Observe Palomar's intrinsic value update instantly.
- Visual Performance Metrics: Dashboard charts illustrate valuation results and essential indicators.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Palomar Holdings data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Palomar Holdings' intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Palomar Holdings, Inc. (PLMR)?
- Comprehensive Coverage: Benefit from a wide range of insurance solutions tailored to your needs.
- Financial Strength: Backed by solid financials, ensuring reliability and stability.
- Innovative Solutions: Leverage cutting-edge technology for efficient claims processing and customer service.
- Expertise You Can Trust: Our team of professionals brings years of industry experience to the table.
- Client-Centric Approach: We prioritize your needs, providing personalized service and support.
Who Should Use This Product?
- Investors: Evaluate Palomar Holdings, Inc.'s (PLMR) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Palomar Holdings, Inc. (PLMR).
- Startup Founders: Gain insights into the valuation strategies of established companies like Palomar Holdings, Inc. (PLMR).
- Consultants: Create comprehensive valuation analyses and reports for clients involving Palomar Holdings, Inc. (PLMR).
- Students and Educators: Utilize real-time data to explore and teach valuation practices related to Palomar Holdings, Inc. (PLMR).
What the Template Contains
- Pre-Filled DCF Model: Palomar Holdings, Inc.’s (PLMR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Palomar Holdings, Inc.’s (PLMR) 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.