Medifast, Inc. (MED) 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
Medifast, Inc. (MED) Bundle
Evaluate Medifast, Inc.'s (MED) financial outlook like an expert! This (MED) DCF Calculator comes with pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 713.7 | 934.8 | 1,526.1 | 1,598.6 | 1,072.1 | 1,241.8 | 1,438.5 | 1,666.2 | 1,930.1 | 2,235.7 |
Revenue Growth, % | 0 | 30.99 | 63.25 | 4.75 | -32.94 | 15.84 | 15.84 | 15.84 | 15.84 | 15.84 |
EBITDA | 95.7 | 134.2 | 223.1 | 201.8 | 139.5 | 168.9 | 195.7 | 226.6 | 262.5 | 304.1 |
EBITDA, % | 13.4 | 14.35 | 14.62 | 12.63 | 13.01 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 |
Depreciation | 4.6 | 7.3 | 11.9 | 17.1 | 13.1 | 11.2 | 12.9 | 15.0 | 17.4 | 20.1 |
Depreciation, % | 0.64792 | 0.77767 | 0.77853 | 1.07 | 1.22 | 0.89901 | 0.89901 | 0.89901 | 0.89901 | 0.89901 |
EBIT | 91.0 | 126.9 | 211.2 | 184.8 | 126.4 | 157.7 | 182.7 | 211.7 | 245.2 | 284.0 |
EBIT, % | 12.76 | 13.57 | 13.84 | 11.56 | 11.79 | 12.7 | 12.7 | 12.7 | 12.7 | 12.7 |
Total Cash | 92.7 | 174.5 | 109.5 | 87.7 | 150.0 | 144.8 | 167.8 | 194.3 | 225.1 | 260.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.4 | .6 | .0 | .0 | .0 | .7 | .8 | .9 | 1.0 | 1.2 |
Account Receivables, % | 0.20135 | 0.06247045 | 0 | 0 | 0 | 0.05276469 | 0.05276469 | 0.05276469 | 0.05276469 | 0.05276469 |
Inventories | 48.8 | 53.4 | 180.0 | 118.9 | 54.6 | 91.6 | 106.1 | 122.9 | 142.3 | 164.9 |
Inventories, % | 6.83 | 5.71 | 11.8 | 7.44 | 5.09 | 7.37 | 7.37 | 7.37 | 7.37 | 7.37 |
Accounts Payable | 22.6 | 36.1 | 70.9 | 53.1 | 39.2 | 46.3 | 53.7 | 62.2 | 72.0 | 83.4 |
Accounts Payable, % | 3.17 | 3.86 | 4.65 | 3.32 | 3.66 | 3.73 | 3.73 | 3.73 | 3.73 | 3.73 |
Capital Expenditure | -10.1 | -5.9 | -34.2 | -16.7 | -6.5 | -14.7 | -17.1 | -19.8 | -22.9 | -26.5 |
Capital Expenditure, % | -1.41 | -0.62973 | -2.24 | -1.04 | -0.60473 | -1.19 | -1.19 | -1.19 | -1.19 | -1.19 |
Tax Rate, % | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 |
EBITAT | 76.8 | 97.2 | 160.3 | 144.1 | 97.6 | 123.7 | 143.3 | 166.0 | 192.2 | 222.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 43.8 | 108.3 | 46.7 | 187.9 | 154.5 | 89.6 | 131.9 | 152.8 | 177.0 | 205.0 |
WACC, % | 9.28 | 9.25 | 9.24 | 9.25 | 9.25 | 9.26 | 9.26 | 9.26 | 9.26 | 9.26 |
PV UFCF | ||||||||||
SUM PV UFCF | 565.5 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 206 | |||||||||
Terminal Value | 2,353 | |||||||||
Present Terminal Value | 1,511 | |||||||||
Enterprise Value | 2,077 | |||||||||
Net Debt | -72 | |||||||||
Equity Value | 2,149 | |||||||||
Diluted Shares Outstanding, MM | 11 | |||||||||
Equity Value Per Share | 196.81 |
What You Will Get
- Pre-Filled Financial Model: Medifast’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide real-time results as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- 🔍 Real-Life MED Financials: Pre-filled historical and projected data for Medifast, Inc. (MED).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Medifast’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Medifast’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-prepared Excel file containing Medifast, Inc.'s (MED) financial information.
- Customize: Modify projections, including sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for Medifast, Inc. (MED)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for Medifast, Inc. (MED).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Medifast, Inc. (MED)'s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and forecasted data to ensure accurate analysis.
- Professional Quality: Perfect for financial analysts, investors, and consultants focused on Medifast, Inc. (MED).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Medifast, Inc. (MED) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models tailored for Medifast, Inc. (MED).
- Consultants: Deliver professional valuation insights on Medifast, Inc. (MED) to clients quickly and accurately.
- Business Owners: Understand how companies like Medifast, Inc. (MED) are valued to guide your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Medifast, Inc. (MED).
What the Template Contains
- Preloaded MED 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.