Calculator Inputs
Example Data Table
| Scenario | Initial Investment | Year One Revenue | Growth | Discount Rate | Likely Signal |
|---|---|---|---|---|---|
| Conservative expansion | $500,000 | $240,000 | 4% | 13% | Review risk |
| Base operating case | $500,000 | $275,000 | 8% | 12% | Balanced decision |
| Upside demand case | $500,000 | $325,000 | 12% | 11% | Potential value |
Formula Used
- Revenue: Year one revenue × (1 + growth rate)year - 1
- EBITDA: Revenue − operating costs
- EBIT: EBITDA − depreciation
- Tax: Positive EBIT × tax rate
- Free Cash Flow: NOPAT + depreciation − capital spend − working capital change
- Risk Adjusted FCF: Free cash flow × (1 − risk haircut)
- Present Value: Cash flow ÷ (1 + discount rate)year
- NPV: Present value of inflows − initial investment
- Gordon Terminal Value: Final cash flow × (1 + terminal growth) ÷ (discount rate − terminal growth)
- Profitability Index: Present value of inflows ÷ initial investment
How to Use This Calculator
Enter the initial project cost first. Add the number of projection years. Then enter year one revenue and expected growth. Set the operating cost percentage, yearly capital spend, depreciation period, and tax rate.
Next, enter the discount rate. This should reflect project risk and capital cost. Choose a terminal value method. Add a risk haircut if the cash flow forecast is uncertain. Press the calculate button. Review NPV, IRR, MIRR, payback, and the chart. Export the results if you need a report.
Project Valuation Guide
Project valuation turns an idea into a measurable investment view. It links future cash flows with today’s required return. A good valuation does not only ask whether revenue can grow. It also checks cost pressure, tax impact, capital spending, and working capital needs.
Why project value matters
Every project uses capital. That capital has an opportunity cost. A project should create value above that cost. Net present value shows this excess value in currency terms. A positive result suggests the project may add wealth. A negative result warns that the same capital may work better elsewhere.
Reading the core metrics
NPV is usually the main decision metric. IRR shows the break even discount rate. Profitability index compares present value against the initial spend. Payback shows how quickly cash comes back. Discounted payback is stricter because it includes time value. MIRR can be useful when reinvestment assumptions must be realistic.
Using scenario thinking
Inputs are never certain. Revenue growth may slow. Costs may rise. Tax rules may change. A higher discount rate can lower value fast. For that reason, compare a base case, a conservative case, and an upside case. This calculator supports scenario work by letting you adjust risk, terminal value, and cash flow drivers.
Practical interpretation
Do not rely on one number only. A strong project often has positive NPV, acceptable payback, and stable yearly cash flow. Review the terminal value carefully. It can dominate the answer in long lived projects. Also check whether working capital demands are realistic. High growth can consume cash before profits arrive.
Good valuation is a decision aid. It is not a guarantee. Use it with market research, execution planning, and funding checks. When assumptions are clear, teams can debate risks better. They can also explain investment choices with simple evidence.
Common mistakes
Many valuations fail because assumptions are hidden. Some ignore maintenance spending. Others treat sales growth as free cash. Some use a terminal growth rate that is too high. Keep assumptions modest and visible. Update the model when real results arrive. Small changes can reveal whether the project is resilient or fragile. That habit improves capital discipline and review quality over time.
FAQs
What is project valuation?
Project valuation estimates what a project is worth today. It discounts expected future cash flows and compares them with the required investment.
Which metric matters most?
NPV is usually the strongest decision metric. It shows value added after covering the required return and initial investment.
What is a good IRR?
A good IRR is usually higher than the project discount rate. The margin should also be enough to cover forecast risk.
Why does terminal value matter?
Terminal value captures cash flow after the forecast period. It can be large, so use careful growth and exit multiple assumptions.
What is discounted payback?
Discounted payback shows when the project recovers its initial investment after applying the time value of money.
How does the risk haircut work?
The risk haircut reduces projected free cash flow. It helps model uncertainty, execution risk, demand risk, or weak forecast confidence.
Should taxes be included?
Yes. Taxes affect available cash flow. A valuation is more useful when it includes expected tax impact and depreciation effects.
Can this calculator support scenario analysis?
Yes. Change growth, cost, risk, discount rate, and terminal assumptions. Compare results across conservative, base, and upside cases.