Advanced NPV & Return on Investment (ROI) Calculator
Net present value discounts every future cash flow back to today and subtracts the initial investment, so a result above $0 means the project adds value. Enter your investment, annual cash flow, term, and discount rate to get the exact NPV instantly.
Advanced ROI (NPV)
Business
Fill all inputs
Your result appears here automatically as you type.
How the Advanced ROI (NPV) Works
NPV answers one question: is this investment worth more than its cost once you account for time? The standard formula discounts each year with PV = CF / (1 + r)^n, where r is your discount rate (often WACC) and n is the year number. Sum every present value, then subtract the initial investment. A positive NPV means the project creates value; a negative NPV destroys it. Discounted ROI divides NPV by the investment to express the same result as a percentage. Unlike simple ROI, NPV treats 15,000 dollars earned in year five as worth less than the same amount today. This calculator assumes equal annual cash flows and a constant discount rate, which fits most equipment, marketing, and capital projects. For uneven cash flows, discount each year separately with the same formula. Use your cost of capital, not an arbitrary rate, or the result will mislead you. Sensitivity testing the discount rate is the fastest way to see how much the decision depends on your cost of capital.
Formula Used
NPV = -Initial Investment + sum of [Cash Flow / (1 + Discount Rate)^Year]
Invest $50,000, receive $15,000 per year for 5 years, discount rate 8%. Present value of cash flows = $59,891, NPV = $9,891, discounted ROI = 19.8%.
When to Use This Calculator
- Comparing two capital projects with different cash flow timing.
- Deciding whether to buy equipment that generates annual savings.
- Testing how sensitive a project is to your cost of capital.
Common Mistakes
- Using a 0% discount rate: A zero rate ignores the time value of money and always inflates NPV. Use your WACC or required return instead.
- Mixing annual and monthly inputs: Cash flow and discount rate must share the same period. This calculator assumes annual cash flows.
- Forgetting terminal value: Salvage value or working capital released at the end of a project belongs in the final year of the analysis.
Frequently Asked Questions
What is the difference between NPV and ROI?
Simple ROI divides total profit by cost and ignores timing. NPV discounts every cash flow to today before comparing it with the investment, so it reflects the time value of money. For projects spanning several years, NPV is the more reliable go/no-go test.
What discount rate should I use in an NPV calculation?
Use your weighted average cost of capital (WACC) or the minimum return you require. A common range is 8–12% for moderate-risk business projects. Higher-risk projects deserve a higher rate, which lowers NPV and raises your bar.
How do you interpret a positive vs negative NPV result?
Positive NPV means discounted returns exceed the investment, so the project adds value. Negative NPV means it earns less than your required return, so reject or revise it. Zero NPV means you exactly hit your hurdle rate, with no margin for error.
What is the formula for net present value (NPV)?
NPV equals each future cash flow discounted at your rate, minus the initial investment: NPV = -Investment + CF1/(1+r) + CF2/(1+r)^2, and so on through the final year. A result above zero means the project returns more than your required rate.
What is the difference between NPV and IRR?
NPV gives a dollar value showing how much wealth a project adds at your chosen discount rate. IRR solves for the rate that makes NPV equal zero. Use NPV to judge added value and IRR to compare similar-sized projects on rate of return.
How This Page Is Reviewed
Written by the Recapflow Editorial Team and last reviewed . Every formula and worked example is cross-checked against the live calculator engine and a hand-worked example. This page is educational and does not replace professional financial, tax, or legal advice.