MultiPlan Corporation (MPLN) 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
MultiPlan Corporation (MPLN) Bundle
Explore the financial future of MultiPlan Corporation (MPLN) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to determine the intrinsic value of MultiPlan Corporation (MPLN) and inform your investment decisions.
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 | 982.9 | 937.8 | 1,117.6 | 1,079.7 | 961.5 | 962.1 | 962.7 | 963.3 | 963.9 | 964.5 |
Revenue Growth, % | 0 | -4.59 | 19.18 | -3.39 | -10.95 | 0.06215092 | 0.06215092 | 0.06215092 | 0.06215092 | 0.06215092 |
EBITDA | 786.3 | 192.4 | 815.0 | 158.3 | 651.9 | 492.4 | 492.7 | 493.0 | 493.3 | 493.6 |
EBITDA, % | 80 | 20.52 | 72.92 | 14.66 | 67.8 | 51.18 | 51.18 | 51.18 | 51.18 | 51.18 |
Depreciation | 399.5 | 403.7 | 412.1 | 415.7 | 425.8 | 391.3 | 391.5 | 391.8 | 392.0 | 392.2 |
Depreciation, % | 40.64 | 43.05 | 36.87 | 38.5 | 44.28 | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 |
EBIT | 386.9 | -211.3 | 402.9 | -257.3 | 226.1 | 101.2 | 101.2 | 101.3 | 101.3 | 101.4 |
EBIT, % | 39.36 | -22.53 | 36.05 | -23.83 | 23.52 | 10.51 | 10.51 | 10.51 | 10.51 | 10.51 |
Total Cash | 21.8 | 126.8 | 185.3 | 334.0 | 71.5 | 136.0 | 136.1 | 136.2 | 136.3 | 136.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 77.1 | 63.2 | 99.9 | 78.9 | 76.6 | 74.6 | 74.7 | 74.7 | 74.8 | 74.8 |
Account Receivables, % | 7.84 | 6.74 | 8.94 | 7.31 | 7.96 | 7.76 | 7.76 | 7.76 | 7.76 | 7.76 |
Inventories | 2.1 | 17.7 | 33.0 | 30.1 | .0 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 |
Inventories, % | 0.21671 | 1.89 | 2.95 | 2.79 | 0 | 1.57 | 1.57 | 1.57 | 1.57 | 1.57 |
Accounts Payable | 9.6 | 15.3 | 13.0 | 13.3 | 19.6 | 13.5 | 13.5 | 13.5 | 13.6 | 13.6 |
Accounts Payable, % | 0.97314 | 1.63 | 1.16 | 1.23 | 2.04 | 1.41 | 1.41 | 1.41 | 1.41 | 1.41 |
Capital Expenditure | -66.4 | -70.8 | -84.6 | -89.7 | -108.9 | -79.9 | -79.9 | -80.0 | -80.0 | -80.1 |
Capital Expenditure, % | -6.76 | -7.55 | -7.57 | -8.31 | -11.32 | -8.3 | -8.3 | -8.3 | -8.3 | -8.3 |
Tax Rate, % | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 |
EBITAT | 357.4 | -201.3 | 303.7 | -262.9 | 193.7 | 90.8 | 90.8 | 90.9 | 90.9 | 91.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 620.8 | 135.6 | 576.8 | 87.2 | 549.4 | 382.9 | 402.4 | 402.6 | 402.9 | 403.1 |
WACC, % | 7.26 | 7.32 | 6.9 | 7.42 | 7.12 | 7.2 | 7.2 | 7.2 | 7.2 | 7.2 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,623.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 411 | |||||||||
Terminal Value | 7,900 | |||||||||
Present Terminal Value | 5,579 | |||||||||
Enterprise Value | 7,203 | |||||||||
Net Debt | 4,496 | |||||||||
Equity Value | 2,707 | |||||||||
Diluted Shares Outstanding, MM | 645 | |||||||||
Equity Value Per Share | 4.20 |
What You Will Get
- Pre-Filled Financial Model: MultiPlan Corporation’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive Financial Data: MultiPlan Corporation’s historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view MultiPlan’s intrinsic value as it updates live.
- Visual Analytics: Interactive dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-built Excel file featuring MultiPlan Corporation’s (MPLN) financial metrics.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Enjoy real-time updates for intrinsic value and NPV calculations as you make changes.
- Test Scenarios: Generate various forecasts and swiftly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for MultiPlan Corporation (MPLN)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for MultiPlan Corporation.
- Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes MultiPlan's intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on MultiPlan Corporation.
Who Should Use This Product?
- Finance Students: Discover valuation strategies and apply them to real-world data involving MultiPlan Corporation (MPLN).
- Academics: Integrate advanced financial models into your curriculum or research focused on MultiPlan Corporation (MPLN).
- Investors: Validate your investment hypotheses and evaluate valuation results for MultiPlan Corporation (MPLN).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for MultiPlan Corporation (MPLN).
- Small Business Owners: Learn how large public entities like MultiPlan Corporation (MPLN) are assessed in the market.
What the Template Contains
- Pre-Filled Data: Contains MultiPlan Corporation’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate MultiPlan’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visualizations and tables summarizing essential valuation outcomes.