FRP Holdings, Inc. (FRPH) DCF Valuation

FRP Holdings, Inc. (FRPH) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

FRP Holdings, Inc. (FRPH) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Optimize your time and improve precision with our (FRPH) DCF Calculator! Utilizing real data from FRP Holdings, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and assess FRP Holdings like a seasoned investor.


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
Account Receivables, % 4.63 0 8.06 5.39 7.28
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.

No products were found matching.