NPV Calculator — Free Net Present Value Tool
Calculate the net present value of any investment by discounting future cash flows to today's dollars.
Cash Flows by Period
NPV Results
Outflows vs NPV
NPV Sensitivity to Discount Rate
| Discount Rate | NPV ($100K investment, $30K/yr for 5 years) | Profitability Index | Decision |
|---|---|---|---|
| 4% | $33,518 | 1.335 | Accept |
| 8% | $19,781 | 1.198 | Accept |
| 12% | $8,143 | 1.081 | Accept |
| 15.24% (IRR) | $0 | 1.000 | Break-even |
| 18% | -$6,095 | 0.939 | Reject |
| 22% | -$13,896 | 0.861 | Reject |
Related Calculators
IRR Calculator
Calculate internal rate of return for investments with multiple cash flows
Present Value Calculator
Find the present value of a future sum using time value of money
Future Value Calculator
Project investment growth with contributions and compound interest
Investment Calculator
Project investment growth with monthly contributions over time
Loan Calculator
Calculate loan payments and total cost of borrowing
Mortgage Calculator
Calculate mortgage payments and total cost of homeownership
About this calculator
Understanding the NPV Formula
Net present value is the cornerstone of discounted cash flow (DCF) analysis, the most rigorous method for valuing investments, companies, and financial instruments.
The NPV Formula
NPV = ∑ CFt / (1 + r)t
Expanded form:
NPV = CF0 + CF1/(1+r) + CF2/(1+r)2 + ... + CFn/(1+r)n
Where:
- CFt = Cash flow at time period t (negative for outflows, positive for inflows)
- r = Discount rate (required rate of return)
- n = Total number of periods
- t = Time period (0 for today, 1 for year 1, etc.)
Profitability Index Formula
PI = PV of Future Cash Inflows / PV of Cash Outflows
Step-by-Step Calculation Example
Calculate the NPV of a $120,000 investment that generates $40,000, $45,000, $50,000, and $35,000 over four years, using a 10% discount rate:
- Year 0: -$120,000 / (1.10)0 = -$120,000
- Year 1: $40,000 / (1.10)1 = $36,364
- Year 2: $45,000 / (1.10)2 = $37,190
- Year 3: $50,000 / (1.10)3 = $37,566
- Year 4: $35,000 / (1.10)4 = $23,905
- NPV: -$120,000 + $36,364 + $37,190 + $37,566 + $23,905 = $15,025
The positive NPV of $15,025 means this investment creates $15,025 in value above and beyond the 10% required return. The profitability index is ($36,364 + $37,190 + $37,566 + $23,905) / $120,000 = 1.125, meaning every dollar invested generates $1.125 in present value.
Why the Discount Rate Matters
The discount rate dramatically impacts NPV. Using the same cash flows above: at 5%, NPV = $38,845; at 10%, NPV = $15,025; at 15%, NPV = -$4,082. The rate at which NPV crosses zero (approximately 13.7% in this case) is the Internal Rate of Return (IRR). Understanding this sensitivity is crucial for making robust investment decisions.
Sources
- Investor.gov (SEC) — Introduction to Investing: investor.gov
- SEC — Investor Education: sec.gov
- Consumer Financial Protection Bureau — Financial Tools: consumerfinance.gov
- Federal Reserve Board — Economic Data and Interest Rates: federalreserve.gov
Disclaimer: This calculator is for informational purposes only and does not constitute financial advice. Consult a qualified financial advisor before making financial decisions.
Last updated: November 3, 2026