MiMedx Group, Inc. (MDXG) DCF Valuation
- ✓ 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
MiMedx Group, Inc. (MDXG) Bundle
Looking to evaluate MiMedx Group, Inc.'s intrinsic value? Our MDXG DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment strategies.
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 | 299.3 | 248.2 | 258.6 | 267.8 | 321.5 | 330.1 | 338.9 | 348.0 | 357.4 | 367.0 |
Revenue Growth, % | 0 | -17.05 | 4.18 | 3.57 | 20.03 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 |
EBITDA | -12.3 | -45.8 | -1.9 | -10.7 | 40.5 | -9.7 | -10.0 | -10.2 | -10.5 | -10.8 |
EBITDA, % | -4.13 | -18.44 | -0.7312 | -3.99 | 12.6 | -2.94 | -2.94 | -2.94 | -2.94 | -2.94 |
Depreciation | 8.5 | 7.8 | 6.2 | 4.0 | 3.4 | 7.2 | 7.4 | 7.6 | 7.8 | 8.1 |
Depreciation, % | 2.85 | 3.16 | 2.39 | 1.51 | 1.07 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 |
EBIT | -20.9 | -53.6 | -8.1 | -14.7 | 37.1 | -16.9 | -17.4 | -17.9 | -18.3 | -18.8 |
EBIT, % | -6.98 | -21.59 | -3.12 | -5.5 | 11.54 | -5.13 | -5.13 | -5.13 | -5.13 | -5.13 |
Total Cash | 69.1 | 95.8 | 87.1 | 66.0 | 82.0 | 96.0 | 98.6 | 101.3 | 104.0 | 106.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 32.3 | 45.5 | 41.1 | 43.1 | 53.9 | 51.4 | 52.8 | 54.2 | 55.6 | 57.1 |
Account Receivables, % | 10.81 | 18.32 | 15.89 | 16.09 | 16.76 | 15.57 | 15.57 | 15.57 | 15.57 | 15.57 |
Inventories | 9.1 | 10.4 | 11.4 | 13.2 | 21.0 | 15.2 | 15.6 | 16.1 | 16.5 | 16.9 |
Inventories, % | 3.04 | 4.17 | 4.4 | 4.92 | 6.54 | 4.62 | 4.62 | 4.62 | 4.62 | 4.62 |
Accounts Payable | 8.7 | 8.8 | 7.4 | 8.5 | 9.0 | 10.1 | 10.4 | 10.6 | 10.9 | 11.2 |
Accounts Payable, % | 2.91 | 3.53 | 2.86 | 3.16 | 2.81 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 |
Capital Expenditure | -2.2 | -4.6 | -3.5 | -2.7 | -2.0 | -3.7 | -3.8 | -3.9 | -4.0 | -4.1 |
Capital Expenditure, % | -0.74117 | -1.83 | -1.34 | -1 | -0.61808 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
Tax Rate, % | -120.15 | -120.15 | -120.15 | -120.15 | -120.15 | -120.15 | -120.15 | -120.15 | -120.15 | -120.15 |
EBITAT | -20.9 | -42.9 | -8.3 | -14.8 | 81.7 | -16.3 | -16.7 | -17.1 | -17.6 | -18.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -47.3 | -54.0 | -3.6 | -16.2 | 65.1 | -3.4 | -14.5 | -14.9 | -15.3 | -15.7 |
WACC, % | 13.6 | 13.51 | 13.6 | 13.6 | 13.6 | 13.58 | 13.58 | 13.58 | 13.58 | 13.58 |
PV UFCF | ||||||||||
SUM PV UFCF | -42.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -16 | |||||||||
Terminal Value | -139 | |||||||||
Present Terminal Value | -73 | |||||||||
Enterprise Value | -115 | |||||||||
Net Debt | -34 | |||||||||
Equity Value | -81 | |||||||||
Diluted Shares Outstanding, MM | 146 | |||||||||
Equity Value Per Share | -0.56 |
What You Will Receive
- Pre-Filled Financial Model: MiMedx Group’s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue growth, gross margin %, and R&D expenses.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional metrics in real-time.
- High-Precision Accuracy: Incorporates MiMedx's actual financial data for trustworthy valuation results.
- Streamlined Scenario Analysis: Easily evaluate various assumptions and analyze results side by side.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for MiMedx Group, Inc. (MDXG).
- Step 2: Review MiMedx's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for MiMedx Group, Inc. (MDXG)?
- Comprehensive Tool: Incorporates DCF, WACC, and financial ratio analyses tailored for MDXG.
- Customizable Inputs: Modify yellow-highlighted cells to explore various financial scenarios.
- Detailed Insights: Automatically calculates MiMedx’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on MDXG.
Who Should Use This Product?
- Investors: Accurately estimate MiMedx Group, Inc.'s (MDXG) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to MiMedx Group, Inc. (MDXG).
- Consultants: Quickly adapt the template for valuation reports tailored to clients interested in MiMedx Group, Inc. (MDXG).
- Entrepreneurs: Gain insights into financial modeling practices utilized by leading healthcare companies, including MiMedx Group, Inc. (MDXG).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to MiMedx Group, Inc. (MDXG).
What the Template Contains
- Preloaded MDXG 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.