|
Pro-Dex, Inc. (PDEX) DCF Valuation
US | Healthcare | Medical - Instruments & Supplies | NASDAQ
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Pro-Dex, Inc. (PDEX) Bundle
Simplify Pro-Dex, Inc. (PDEX) valuation with this customizable DCF Calculator! Featuring real Pro-Dex, Inc. (PDEX) financials and adjustable forecast inputs, you can test scenarios and uncover Pro-Dex, Inc. (PDEX) fair value in minutes.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 34.8 | 38.0 | 42.0 | 46.1 | 53.8 | 60.1 | 67.0 | 74.7 | 83.4 | 93.0 |
Revenue Growth, % | 0 | 9.17 | 10.55 | 9.62 | 16.83 | 11.54 | 11.54 | 11.54 | 11.54 | 11.54 |
EBITDA | 8.8 | 8.1 | 6.0 | 6.6 | 8.3 | 10.9 | 12.1 | 13.5 | 15.1 | 16.8 |
EBITDA, % | 25.12 | 21.23 | 14.2 | 14.36 | 15.48 | 18.08 | 18.08 | 18.08 | 18.08 | 18.08 |
Depreciation | .6 | .7 | .7 | .9 | 1.2 | 1.1 | 1.3 | 1.4 | 1.6 | 1.8 |
Depreciation, % | 1.76 | 1.91 | 1.73 | 1.86 | 2.15 | 1.88 | 1.88 | 1.88 | 1.88 | 1.88 |
EBIT | 8.1 | 7.3 | 5.2 | 5.8 | 7.2 | 9.7 | 10.9 | 12.1 | 13.5 | 15.1 |
EBIT, % | 23.36 | 19.32 | 12.47 | 12.5 | 13.32 | 16.2 | 16.2 | 16.2 | 16.2 | 16.2 |
Total Cash | 9.0 | 5.0 | 1.6 | 4.1 | 6.8 | 7.7 | 8.6 | 9.6 | 10.7 | 12.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.2 | 10.9 | 15.4 | 10.0 | 13.9 | 15.3 | 17.1 | 19.1 | 21.3 | 23.7 |
Account Receivables, % | 14.8 | 28.75 | 36.59 | 21.59 | 25.79 | 25.51 | 25.51 | 25.51 | 25.51 | 25.51 |
Inventories | 8.2 | 8.4 | 12.7 | 16.2 | 15.3 | 16.7 | 18.7 | 20.8 | 23.2 | 25.9 |
Inventories, % | 23.65 | 22.19 | 30.16 | 35.08 | 28.36 | 27.89 | 27.89 | 27.89 | 27.89 | 27.89 |
Accounts Payable | 2.0 | 2.3 | 3.8 | 2.3 | 4.5 | 4.1 | 4.5 | 5.1 | 5.6 | 6.3 |
Accounts Payable, % | 5.64 | 6.02 | 8.95 | 4.91 | 8.38 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
Capital Expenditure | -.6 | -8.3 | -1.7 | -1.0 | -1.0 | -3.8 | -4.2 | -4.7 | -5.2 | -5.8 |
Capital Expenditure, % | -1.62 | -21.84 | -3.97 | -2.11 | -1.83 | -6.28 | -6.28 | -6.28 | -6.28 | -6.28 |
Tax Rate, % | 19.25 | 19.25 | 19.25 | 19.25 | 19.25 | 19.25 | 19.25 | 19.25 | 19.25 | 19.25 |
EBITAT | 6.3 | 5.8 | 5.1 | 4.3 | 5.8 | 8.0 | 8.9 | 9.9 | 11.1 | 12.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -5.1 | -7.4 | -3.1 | 4.6 | 5.2 | 2.0 | 2.7 | 3.0 | 3.4 | 3.8 |
WACC, % | 6.1 | 6.11 | 6.16 | 6.09 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 12.2 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 4 | |||||||||
Terminal Value | 185 | |||||||||
Present Terminal Value | 137 | |||||||||
Enterprise Value | 150 | |||||||||
Net Debt | 11 | |||||||||
Equity Value | 139 | |||||||||
Diluted Shares Outstanding, MM | 4 | |||||||||
Equity Value Per Share | 38.85 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Pro-Dex, Inc.’s (PDEX) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that can be tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Historical Data: Pro-Dex, Inc.'s (PDEX) financial statements and detailed forecasts are readily available.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Pro-Dex, Inc. (PDEX).
- Intuitive Visualizations: Engaging dashboard charts present valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Pro-Dex, Inc.'s (PDEX) 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 updated results, including Pro-Dex, Inc.'s (PDEX) intrinsic value.
- Step 5: Utilize the outputs to make informed investment choices or create detailed reports.
Why Choose Pro-Dex, Inc. (PDEX)?
- Innovative Solutions: Cutting-edge technology tailored for your specific needs.
- Enhanced Efficiency: Streamlined processes help you achieve better results faster.
- Customizable Products: Adapt our offerings to align with your unique requirements.
- User-Friendly Interface: Intuitive design ensures a smooth experience for all users.
- Industry Expertise: Backed by a team of professionals dedicated to excellence and support.
Who Should Use Pro-Dex, Inc. (PDEX)?
- Healthcare Professionals: Understand how Pro-Dex, Inc. (PDEX) innovates in medical device manufacturing.
- Investors: Evaluate investment opportunities and assess market trends related to Pro-Dex, Inc. (PDEX).
- Researchers: Utilize data on Pro-Dex, Inc. (PDEX) for studies in medical technology advancements.
- Business Analysts: Analyze Pro-Dex, Inc. (PDEX)'s performance metrics and industry positioning.
- Entrepreneurs: Learn from Pro-Dex, Inc. (PDEX)'s business strategies in the healthcare sector.
What the Template Contains
- Preloaded PDEX 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.