ModivCare Inc. (MODV) 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
ModivCare Inc. (MODV) Bundle
As an investor or analyst, this (MODV) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from ModivCare Inc., you can adjust forecasts and immediately observe the effects.
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 | 1,509.9 | 1,368.7 | 1,996.9 | 2,504.4 | 2,751.2 | 3,245.1 | 3,827.7 | 4,514.9 | 5,325.4 | 6,281.5 |
Revenue Growth, % | 0 | -9.36 | 45.9 | 25.41 | 9.85 | 17.95 | 17.95 | 17.95 | 17.95 | 17.95 |
EBITDA | 12.1 | 148.2 | 146.8 | 157.5 | -26.8 | 157.7 | 186.0 | 219.4 | 258.8 | 305.3 |
EBITDA, % | 0.804 | 10.83 | 7.35 | 6.29 | -0.97231 | 4.86 | 4.86 | 4.86 | 4.86 | 4.86 |
Depreciation | 16.6 | 35.4 | 68.3 | 112.1 | 104.3 | 99.8 | 117.7 | 138.8 | 163.7 | 193.1 |
Depreciation, % | 1.1 | 2.59 | 3.42 | 4.47 | 3.79 | 3.07 | 3.07 | 3.07 | 3.07 | 3.07 |
EBIT | -4.4 | 112.8 | 78.4 | 45.4 | -131.0 | 57.9 | 68.3 | 80.6 | 95.1 | 112.2 |
EBIT, % | -0.29398 | 8.24 | 3.93 | 1.81 | -4.76 | 1.79 | 1.79 | 1.79 | 1.79 | 1.79 |
Total Cash | 61.4 | 183.3 | 133.1 | 14.5 | 2.2 | 160.8 | 189.7 | 223.8 | 263.9 | 311.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 183.8 | 197.9 | 237.9 | 296.8 | 375.1 | 415.6 | 490.2 | 578.2 | 682.0 | 804.5 |
Account Receivables, % | 12.17 | 14.46 | 11.91 | 11.85 | 13.63 | 12.81 | 12.81 | 12.81 | 12.81 | 12.81 |
Inventories | .2 | .8 | 1.5 | 2.0 | .0 | 1.4 | 1.7 | 2.0 | 2.3 | 2.8 |
Inventories, % | 0.01026528 | 0.05538203 | 0.07301346 | 0.08149679 | 0 | 0.04403151 | 0.04403151 | 0.04403151 | 0.04403151 | 0.04403151 |
Accounts Payable | 9.8 | 8.5 | 8.7 | 55.0 | 55.2 | 38.3 | 45.2 | 53.3 | 62.9 | 74.2 |
Accounts Payable, % | 0.64936 | 0.61841 | 0.43518 | 2.19 | 2.01 | 1.18 | 1.18 | 1.18 | 1.18 | 1.18 |
Capital Expenditure | -10.9 | -12.2 | -21.3 | -33.0 | -42.3 | -35.9 | -42.3 | -49.9 | -58.9 | -69.5 |
Capital Expenditure, % | -0.7191 | -0.88772 | -1.07 | -1.32 | -1.54 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
Tax Rate, % | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 |
EBITAT | -4.0 | 87.6 | 61.6 | 17.2 | -128.1 | 44.2 | 52.1 | 61.5 | 72.5 | 85.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -172.4 | 94.8 | 68.2 | 82.9 | -142.1 | 49.3 | 59.5 | 70.2 | 82.8 | 97.6 |
WACC, % | 5.6 | 4.96 | 5.01 | 2.84 | 6.03 | 4.89 | 4.89 | 4.89 | 4.89 | 4.89 |
PV UFCF | ||||||||||
SUM PV UFCF | 307.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 100 | |||||||||
Terminal Value | 3,450 | |||||||||
Present Terminal Value | 2,718 | |||||||||
Enterprise Value | 3,025 | |||||||||
Net Debt | 1,138 | |||||||||
Equity Value | 1,887 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | 133.15 |
What You Will Get
- Pre-Filled Financial Model: ModivCare Inc.'s actual data provides an accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates ensure you receive immediate results as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for ModivCare Inc. (MODV).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adaptable inputs specific to ModivCare Inc. (MODV).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit ModivCare Inc. (MODV) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to ModivCare Inc. (MODV).
- User-Friendly Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of ModivCare Inc. (MODV).
How It Works
- Step 1: Download the prebuilt Excel template with ModivCare Inc.'s (MODV) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including ModivCare Inc.'s (MODV) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose ModivCare Inc. (MODV) Calculator?
- Accuracy: Utilizes real ModivCare financials for precise data.
- Flexibility: Allows users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to construct a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive and accurate valuation models for analyzing ModivCare Inc. (MODV) investments.
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within healthcare services.
- Consultants and Financial Advisors: Deliver precise valuation insights to clients considering ModivCare Inc. (MODV) stock.
- Students and Educators: Utilize real-world data to enhance learning in financial modeling and healthcare economics.
- Healthcare Sector Enthusiasts: Gain insights into how companies like ModivCare Inc. (MODV) are valued in the healthcare market.
What the ModivCare Template Contains
- Preloaded MODV 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.