ProPhase Labs, Inc. (PRPH) DCF Valuation

ProPhase Labs, Inc. (PRPH) DCF Valuation
  • ✓ 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

ProPhase Labs, Inc. (PRPH) 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:

Gain mastery over your ProPhase Labs, Inc. (PRPH) valuation analysis using our state-of-the-art DCF Calculator! This Excel template comes preloaded with real PRPH data, enabling you to adjust forecasts and assumptions to accurately calculate the intrinsic value of ProPhase Labs, Inc. (PRPH).


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 9.9 14.5 79.0 122.6 44.4 59.7 80.4 108.2 145.6 195.9
Revenue Growth, % 0 46.96 444.59 55.17 -63.81 34.58 34.58 34.58 34.58 34.58
EBITDA -2.7 -1.5 11.4 28.7 -14.8 -4.0 -5.3 -7.2 -9.7 -13.0
EBITDA, % -27.42 -10.25 14.41 23.43 -33.41 -6.65 -6.65 -6.65 -6.65 -6.65
Depreciation .4 .5 4.9 5.1 6.7 4.0 5.3 7.2 9.7 13.0
Depreciation, % 4.03 3.66 6.24 4.13 15.09 6.63 6.63 6.63 6.63 6.63
EBIT -3.1 -2.0 6.5 23.7 -21.5 -7.9 -10.7 -14.4 -19.3 -26.0
EBIT, % -31.45 -13.91 8.16 19.3 -48.5 -13.28 -13.28 -13.28 -13.28 -13.28
Total Cash 1.4 8.5 17.3 17.4 4.7 14.2 19.1 25.7 34.6 46.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 6.8 3.2 37.7 37.1 36.3
Account Receivables, % 69.08 21.74 47.71 30.21 81.82
Inventories 1.5 3.0 4.6 4.0 3.8 6.4 8.6 11.6 15.6 20.9
Inventories, % 14.77 20.94 5.82 3.24 8.65 10.69 10.69 10.69 10.69 10.69
Accounts Payable .4 3.8 7.0 5.9 9.4 7.8 10.5 14.1 19.0 25.6
Accounts Payable, % 4.37 25.98 8.89 4.81 21.14 13.04 13.04 13.04 13.04 13.04
Capital Expenditure -.2 -1.7 -4.2 -3.9 -3.2 -3.5 -4.8 -6.4 -8.6 -11.6
Capital Expenditure, % -2.31 -11.64 -5.35 -3.2 -7.11 -5.92 -5.92 -5.92 -5.92 -5.92
Tax Rate, % 26.39 26.39 26.39 26.39 26.39 26.39 26.39 26.39 26.39 26.39
EBITAT -3.0 -2.1 7.6 19.1 -15.8 -7.2 -9.6 -13.0 -17.4 -23.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -10.7 2.2 -24.5 20.4 -7.9 -4.5 -18.9 -25.5 -34.3 -46.1
WACC, % 5.65 5.77 5.77 5.01 4.73 5.39 5.39 5.39 5.39 5.39
PV UFCF
SUM PV UFCF -106.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -47
Terminal Value -1,390
Present Terminal Value -1,069
Enterprise Value -1,175
Net Debt 20
Equity Value -1,195
Diluted Shares Outstanding, MM 17
Equity Value Per Share -69.46

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real PRPH financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Quickly observe the effect of your inputs on ProPhase Labs' valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Current PRPH Data: Pre-filled with ProPhase Labs’ historical performance metrics and future growth estimates.
  • Fully Customizable Inputs: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital expenditures.
  • Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value reflecting your adjustments.
  • Scenario Testing: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • User-Friendly Design: Intuitive, organized, and suitable for both seasoned professionals and newcomers.

How It Works

  • 1. Access the Template: Download and open the Excel file containing ProPhase Labs, Inc. (PRPH) data.
  • 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
  • 3. See Results Immediately: The DCF model automatically computes intrinsic value and NPV.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
  • 5. Present with Assurance: Deliver expert valuation insights to back your strategic decisions.

Why Choose ProPhase Labs, Inc. (PRPH) Calculator?

  • Accuracy: Utilizes real ProPhase Labs financial data for reliable results.
  • Flexibility: Allows users to easily adjust and experiment with various inputs.
  • Time-Saving: Eliminate the need to create a financial model from the ground up.
  • Professional-Grade: Crafted with precision and usability tailored for finance professionals.
  • User-Friendly: Intuitive design makes it accessible for users of all skill levels.

Who Should Use ProPhase Labs, Inc. (PRPH)?

  • Healthcare Professionals: Understand the latest trends in health supplements and their market potential.
  • Researchers: Utilize ProPhase Labs' data for studies related to health and wellness products.
  • Investors: Evaluate investment opportunities and analyze the financial performance of ProPhase Labs, Inc. (PRPH).
  • Market Analysts: Enhance your reports with insights from ProPhase Labs' innovative product lines.
  • Entrepreneurs: Learn from ProPhase Labs' business strategies to inform your own health-focused ventures.

What the Template Contains

  • Pre-Filled Data: Includes ProPhase Labs, Inc.'s (PRPH) historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze ProPhase Labs, Inc.'s (PRPH) profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.