Enter project cash flow assumptions
Example data table
| Input | Example Value |
|---|---|
| Initial investment | $150,000 |
| Discount rate | 10% |
| Tax rate | 25% |
| Working capital | $10,000 |
| Salvage value | $20,000 |
| Year 1 to 5 cash flows | $45,000, $52,000, $60,000, $58,000, $55,000 |
Formula used
NPV = Σ [ Cash Flowt / (1 + r)t ] − Initial Outlay
Initial Outlay = Initial Investment + Working Capital
After Tax Cash Flow = Operating Cash Flow × (1 − Tax Rate)
Profitability Index = Present Value of Inflows / Initial Outlay
Net present value discounts each future project inflow back to today using the selected discount rate. This lets managers compare projects with different timing, scale, and risk assumptions using one value-based metric.
The calculator also adjusts for tax, salvage value, and working capital recovery. Terminal additions are applied in the final year, then discounted with the same rate for a more complete project appraisal.
How to use this calculator
- Enter the upfront investment required to start the project.
- Set the discount rate that matches your hurdle rate or cost of capital.
- Choose the project life and enter expected yearly free cash flows.
- Add tax rate, working capital, and salvage value if relevant.
- Click the calculate button to view NPV, ROI, payback, and decision guidance.
- Download the outputs as CSV or PDF for reporting.
Frequently asked questions
1. What does a positive NPV mean?
A positive NPV means discounted project inflows exceed total upfront outflows. In most cases, this suggests the project adds value and meets the minimum required return.
2. Why is the discount rate important?
The discount rate converts future cash flows into present values. A higher rate reduces future value more aggressively, which can turn a profitable-looking project into a negative-NPV investment.
3. Should working capital be included?
Yes, if the project ties up inventory, receivables, or startup liquidity. Working capital increases initial outlay and is often recovered in the final year.
4. What is discounted payback?
Discounted payback shows how long it takes for discounted inflows to recover the initial outlay. It considers time value of money, unlike simple payback.
5. Can I use after-tax cash flows?
Yes. This calculator includes an option to apply a tax adjustment to annual operating cash flows and the salvage value, supporting more realistic project screening.
6. What if project NPV is exactly zero?
An NPV of zero means the project is expected to earn exactly the required return. It is financially neutral, so strategic factors may drive the final decision.
7. Is NPV better than ROI for projects?
NPV is usually stronger for capital budgeting because it measures absolute value creation and respects timing. ROI is useful, but it can hide differences in project scale and timing.
8. Can I compare several projects with this tool?
Yes. Run each project separately using consistent discount assumptions, then compare NPV, profitability index, discounted payback, and strategic fit before selecting an option.