Free NPV Calculator — Calculate Net Present Value Instantly (No Excel Required)
Enter cash flows and a discount rate to evaluate whether a project creates value.
Your cost of capital or required return.
Year 0 is usually a negative number (initial investment). Add or remove rows below.
NPV & IRR Analysis
Cumulative discounted cash flow over time
Shows when the project breaks even and how value builds over time.
Enter cash flows to see results.
What is a Net Present Value (NPV) Calculator?
An NPV calculator, also called a Net Present Value calculator, discounts future cash flows back to today's dollars. It helps you decide whether a project, investment, or business case creates value after accounting for the required return or cost of capital.
This online NPV calculator lets you enter cash flows and a discount rate without building formulas in Excel. It also shows IRR, payback period, total undiscounted cash flow, and a cumulative discounted cash flow chart.
Example NPV Calculation
Suppose a project requires an initial investment of $100,000. It is expected to generate cash flows of $25k to $45k over 5 years, and the discount rate is 10%.
The calculator discounts each annual cash flow back to today's dollars and subtracts the upfront investment. With the default cash flows on this page, the project has a positive NPV, meaning the expected cash flows create value at a 10% required return.
What NPV and IRR tell you
- NPV > 0 means the project appears to create value at your discount rate. NPV < 0 means it may not meet the required return.
- IRR is the discount rate that would make NPV exactly zero. If IRR > your cost of capital, the project is attractive.
- Payback period tells you when undiscounted cash flows turn cumulatively positive. A simpler, cruder signal.
Formulas
NPV = Σ (CFₜ / (1 + r)ᵗ) for t = 0..n
IRR solves: Σ (CFₜ / (1 + IRR)ᵗ) = 0
Caveats
- IRR can have multiple solutions if cash flows change sign more than once. We pick the first one we find in a reasonable range.
- NPV assumes reinvestment at the discount rate. IRR assumes reinvestment at itself — often unrealistic.
- Use MIRR or scenario analysis for messier streams. This tool is for the clean case most homework and first-pass analyses actually have.
Pair with related tools
Complement your capital budgeting analysis with:
- Break-Even Calculator — determine minimum sales needed to cover costs.
- Monte Carlo Simulator for uncertain cash flows — run scenario analysis on investment outcomes.
- SWOT analysis tool for project strategy — organize strengths, weaknesses, opportunities, and threats before committing resources.