A solar panel system costs $28,000 upfront and saves $4,200 per year for 10 years. Sounds profitable - but at an 8% discount rate the NPV is only $188. The NPV Calculator reveals whether future cash flows justify today's investment.
NPV Calculator - Net Present Value of Any Investment
A solar panel system costs $28,000 upfront and saves $4,200 per year for 10 years. Sounds profitable - but at an 8% discount rate the NPV is only $188. The NPV Calculator reveals whether future cash flows justify today's investment.
Parameters
Enter data for calculations
💡 Fill in all required fields to unlock the calculate button
$100 today is not $100 next year - and NPV is the tool that proves it
A business partner proposes a deal: invest $100,000 now, receive $30,000 per year for 5 years. The sum of cash flows is $150,000, so it looks like a $50,000 profit. But if you could earn 10% elsewhere, those future payments are worth progressively less in today's dollars. Discounted at 10%, the five payments total only $113,724 in present value - making the NPV just $13,724, not $50,000. Change the discount rate to 15% and the NPV turns negative: -$394. That is the power of NPV - it converts future money into today's money so you can make honest comparisons.
How to calculate NPV - step by step
- Initial investment ($) - the lump sum you pay upfront at year 0. Equipment purchase, franchise fee, property down payment, project setup cost. This is always a cash outflow.
- Discount rate (% per year) - the return you could earn on the next best alternative. Corporate finance typically uses the weighted average cost of capital (WACC). Individual investors often use the expected return of a comparable-risk portfolio. Higher rate = harder for the project to show a positive NPV.
- Number of years - the project horizon. Select 1 to 10 years. Cash flow fields appear dynamically based on your selection.
- Yearly cash flows ($) - enter the net cash flow (revenue minus costs) for each year. These can be unequal - a renovation project might have negative cash flow in year 1 (more building costs) and positive from year 2 onward. Include any terminal or salvage value in the final year.
- Read the result - NPV in dollars (positive = invest, negative = reject), a decision label, a year-by-year discounted cash flow table showing exactly how each payment shrinks over time, and summary metrics.
How the discount rate changes the verdict
Same project ($100,000 upfront, $30,000/year for 5 years) at different discount rates:
| Discount rate | Present value of cash flows | NPV | Decision |
|---|---|---|---|
| 5% | $129,884 | +$29,884 | Invest |
| 8% | $119,781 | +$19,781 | Invest |
| 10% | $113,724 | +$13,724 | Invest |
| 15% | $100,565 | +$565 | Marginal |
| 20% | $89,676 | -$10,324 | Reject |
The breakeven discount rate (where NPV = 0) is the project's IRR - approximately 15.24% in this case.
5 real-world NPV scenarios
FAQ - Frequently asked questions
Related tools
ROI Calculator
Quick percentage return on any investment - cost in, revenue out, ROI and annualized ROI in one result - See calculator
IRR Calculator
Find the discount rate that makes NPV equal zero - the breakeven return for any series of cash flows - See calculator
Compound Interest Calculator
See how an investment grows over time with regular contributions and compound growth - See calculator
Sharpe Ratio Calculator
Measure portfolio efficiency by comparing return to volatility and risk-free rate - See calculator
ETF Return Calculator
Project long-term ETF portfolio value with compound growth and monthly contributions - See calculator
Ready-made calculations
The most searched variants of this calculator. Each link opens it with the value filled in and the result calculated.