← All calculators

Net present value calculator

Initial investment is paid now; each signed cash flow occurs at the end of an equal period. Enter one flow per line, up to 500; use a discount rate for the same period.

NPV = −I + Σ CFₜ / (1 + r/100)ᵗ

+ : Cash received · − : Cash paid

Enter 0 for a period without cash flow; do not leave blank lines.

Use a dot for decimals; omit thousands separators.

0 ≤ I ≤ 10¹²; −100 < r ≤ 1000; |CFₜ| ≤ 10¹²; 1 ≤ t ≤ 500

Result

Present and future value calculator · Microsoft NPV / IRR