Free Tool
NPV Calculator
Use our free NPV calculator to find out whether an investment or project is truly worth making. Enter your initial investment, discount rate, and expected cash flows to get an instant net present value result — no sign-up required.
How to Use This NPV Calculator
- Initial Investment: Enter the upfront cost of the investment (e.g. 10000 for £10,000).
- Discount Rate: Enter your required rate of return as a percentage (e.g. 8 for 8%). This reflects the investment’s risk and opportunity cost.
- Cash Flows: Enter the expected cash flow for each year, separated by commas (e.g. 3000, 4000, 5000). Use negative numbers for years with outflows.
- Click Calculate NPV to see your result and full year-by-year breakdown.
Net Present Value Calculator
Year-by-Year Breakdown
| Year | Cash Flow | Present Value |
|---|
Cash Flow vs. Present Value — Chart
How to Interpret Your NPV Result
Positive NPV (> 0)
Go ahead. The investment is expected to add value and generate a return above your discount rate. The higher the NPV, the more attractive the investment.
Negative NPV (< 0)
Reconsider. The investment is expected to destroy value — you would earn less than your required rate of return. Look for ways to reduce costs or increase cash flows.
Zero NPV (= 0)
Break-even. The investment exactly matches your required rate of return. Whether to proceed depends on other factors such as strategic value or risk.
What is Net Present Value (NPV)?
Net Present Value (NPV) is one of the most widely used tools in investment appraisal and financial decision-making. It is based on the principle of the time value of money — the idea that money available today is worth more than the same amount in the future, because it can be invested to earn a return in the meantime.
Our free NPV calculator takes your expected future cash flows, discounts them back to their value in today’s money using your chosen discount rate, and subtracts the initial investment. The result tells you — in a single number — whether the investment creates or destroys value.
Real-World Example
A small business owner is considering buying a new piece of equipment for £5,000. They expect it to increase net cash flow by £2,000 per year for the next 3 years. Using a discount rate of 8% (their required rate of return), the NPV comes out at approximately +£158. Because the NPV is positive — even if only just — the purchase is financially justified. If the NPV had been negative, they would need to renegotiate the price or reconsider.
The NPV Formula
- C(t) = Cash flow in year t
- r = Discount rate (as a decimal)
- t = Year number
- C(0) = Initial investment
Choosing a Discount Rate
The discount rate reflects both the risk of the investment and the return you could earn by investing elsewhere (opportunity cost).
- For businesses: Use your Weighted Average Cost of Capital (WACC), typically 8–15%.
- For individuals: Use the expected return from an alternative investment such as index funds (historically 7–10% per year).
- Higher risk projects should use a higher discount rate to account for uncertainty.
Advantages of NPV
- ✅Accounts for the time value of money
- ✅Gives a clear absolute value in pounds or dollars
- ✅Directly measures value creation for the business
- ✅Works with any pattern of cash flows, including negatives
Limitations of NPV
- ❌Only as accurate as your cash flow estimates
- ❌Harder to compare projects of very different sizes
- ❌Choosing the right discount rate requires judgement
- ❌Does not account for non-financial factors
Frequently Asked Questions
What is an NPV calculator?
An NPV calculator helps you determine whether an investment or project is financially worthwhile. It discounts future cash flows back to today’s value using your chosen discount rate, then subtracts the initial investment. A positive result means the investment adds value; a negative result means it doesn’t.
What is the difference between NPV and IRR?
NPV gives you a result in today’s currency (e.g. +£1,000), representing the total value added by the investment. IRR (Internal Rate of Return) gives you a percentage, representing the project’s expected rate of return. For comparing mutually exclusive projects, NPV is generally preferred because it focuses on the absolute value created rather than a relative rate.
What if my cash flows are negative in some years?
That’s perfectly normal for projects that require follow-up investments or have significant maintenance costs. Simply enter the negative number (e.g. -1500) for that year in the cash flows field. Our NPV calculator handles both positive and negative values correctly.
What discount rate should I use?
For businesses, the discount rate is often the Weighted Average Cost of Capital (WACC). For individuals, a common approach is to use the expected return from an alternative investment such as the stock market (typically 7–10%). The discount rate should reflect both the risk of the project and the opportunity cost of your capital.
Can I use this NPV calculator for personal finance decisions?
Absolutely. You can use it to evaluate decisions like buying a rental property, installing solar panels, or assessing whether a postgraduate degree is financially worthwhile by projecting future salary increases against the cost of tuition and lost earnings.
Related Free Calculators
Use these alongside your NPV analysis for a complete investment picture.
Need a full financial model?
Go deeper with a premium template
Our Cash Flow Forecast template gives you a complete multi-year financial model for Excel and Google Sheets.