Model Setup
Start by providing basic information for the company being valued. This will be used to label the final valuation report.
Financial Inputs
Enter historical and projected financial data. All values should be in USD ($). Projections are crucial for the Discounted Cash Flow (DCF) analysis.
Key Financial Metrics (in millions)
| Metric | Year -2 | Year -1 | LTM (Year 0) | Year +1 | Year +2 | Year +3 | Year +4 | Year +5 |
|---|---|---|---|---|---|---|---|---|
| Revenue | ||||||||
| EBITDA |
Comparable Company Analysis (CCA)
Input data for publicly traded companies similar to the one being valued. The model will calculate valuation multiples and apply them to your company.
Discounted Cash Flow (DCF) Inputs
Provide assumptions for calculating the DCF valuation. These include tax rates, capital expenditures, working capital changes, and the discount rate.
Valuation Adjustments
Apply discounts or premiums that are common in private company valuations.
Reflects the difficulty in selling shares of a private company.
Only apply if valuing a controlling stake. Leave as 0 for minority stake.
Total Debt minus Cash & Cash Equivalents.
Valuation Summary
Company Valuation Summary
Date of Valuation: