|
FRP Holdings, Inc. (FRPH) DCF Valoración
US | Real Estate | Real Estate - Services | 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
FRP Holdings, Inc. (FRPH) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (FRPH)! Utilizando datos reales de FRP Holdings, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar las participaciones de FRP 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 | 23.8 | 23.6 | 31.2 | 37.5 | 41.5 | 48.0 | 55.5 | 64.1 | 74.2 | 85.7 |
Revenue Growth, % | 0 | -0.72824 | 32.38 | 20.05 | 10.74 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 |
EBITDA | 10.0 | 5.3 | 9.3 | 20.1 | 22.5 | 19.4 | 22.4 | 25.9 | 29.9 | 34.6 |
EBITDA, % | 41.93 | 22.36 | 29.65 | 53.58 | 54.26 | 40.36 | 40.36 | 40.36 | 40.36 | 40.36 |
Depreciation | 18.0 | 18.4 | 28.9 | 29.5 | 10.8 | 33.7 | 39.0 | 45.1 | 52.1 | 60.3 |
Depreciation, % | 75.77 | 78.23 | 92.72 | 78.67 | 26.07 | 70.29 | 70.29 | 70.29 | 70.29 | 70.29 |
EBIT | -8.0 | -13.2 | -19.7 | -9.4 | 11.7 | -14.4 | -16.6 | -19.2 | -22.2 | -25.7 |
EBIT, % | -33.84 | -55.87 | -63.07 | -25.08 | 28.19 | -29.94 | -29.94 | -29.94 | -29.94 | -29.94 |
Total Cash | 164.5 | 149.5 | 165.8 | 177.5 | 157.6 | 48.0 | 55.5 | 64.1 | 74.2 | 85.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.1 | .0 | 2.5 | 2.0 | 3.0 | 2.4 | 2.8 | 3.3 | 3.8 | 4.3 |
Account Receivables, % | 4.63 | 0 | 8.06 | 5.39 | 7.28 | 5.07 | 5.07 | 5.07 | 5.07 | 5.07 |
Inventories | 28.1 | 80.4 | 165.5 | .0 | .0 | 28.8 | 33.3 | 38.5 | 44.5 | 51.4 |
Inventories, % | 118.2 | 340.82 | 530.24 | 0 | 0 | 60 | 60 | 60 | 60 | 60 |
Accounts Payable | 2.4 | 3.6 | 6.1 | 6.0 | 8.3 | 7.8 | 9.0 | 10.4 | 12.1 | 13.9 |
Accounts Payable, % | 10.23 | 15.41 | 19.66 | 15.93 | 20.08 | 16.26 | 16.26 | 16.26 | 16.26 | 16.26 |
Capital Expenditure | 1.1 | -17.5 | 30.0 | 49.2 | .0 | -7.1 | -8.3 | -9.5 | -11.0 | -12.8 |
Capital Expenditure, % | 4.63 | -74.39 | 95.98 | 131.25 | 0 | -14.88 | -14.88 | -14.88 | -14.88 | -14.88 |
Tax Rate, % | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 |
EBITAT | -6.0 | -11.2 | -15.7 | -7.7 | 9.7 | -11.6 | -13.4 | -15.5 | -18.0 | -20.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -13.7 | -60.3 | -41.9 | 236.9 | 21.9 | -13.8 | 13.7 | 15.8 | 18.3 | 21.1 |
WACC, % | 5.86 | 5.97 | 5.91 | 5.94 | 5.95 | 5.93 | 5.93 | 5.93 | 5.93 | 5.93 |
PV UFCF | ||||||||||
SUM PV UFCF | 42.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 22 | |||||||||
Terminal Value | 548 | |||||||||
Present Terminal Value | 411 | |||||||||
Enterprise Value | 454 | |||||||||
Net Debt | 21 | |||||||||
Equity Value | 433 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | 22.87 |
What You Will Get
- Real FRPH Financial Data: Pre-filled with FRP Holdings, Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See FRP Holdings, Inc.'s 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 FRP Holdings, Inc. (FRPH).
- WACC Calculation Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily modify growth projections, capital spending, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to FRP Holdings, Inc. (FRPH).
- Interactive Dashboard and Charts: Visual representations to summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring FRP Holdings, Inc. (FRPH) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including FRP Holdings, Inc. (FRPH)'s intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or generate comprehensive reports.
Why Choose This Calculator for FRP Holdings, Inc. (FRPH)?
- Accurate Data: Up-to-date FRP Holdings financials provide dependable valuation outcomes.
- Customizable: Tailor essential variables such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you the hassle of building from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focusing on FRP Holdings.
- User-Friendly: Simple design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate FRP Holdings, Inc. (FRPH) to inform buying or selling decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established firms like FRP Holdings, Inc. (FRPH).
- Consultants: Create detailed valuation reports for client presentations.
- Students and Educators: Utilize current data to learn and teach valuation practices.
What the Template Contains
- Historical Data: Includes FRP Holdings, Inc. (FRPH)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate FRP Holdings, Inc. (FRPH)’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of FRP Holdings, Inc. (FRPH)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.