MathishaGammanpila

DCF / NPV-IRR Calculator

Paste your cash flows — one per line, starting with the year-0 investment as a negative — and get NPV, IRR, payback and the profitability index, plus how sensitive the answer is to your discount rate.

Cash flows (one per line: year 0, year 1, year 2… commas and brackets fine)

Discount rate

%/yr

Need at least two cash flows, and the first is usually negative.

NPV

—

IRR

—

rate where NPV = 0

Payback

—

Profitability index

—

PV of inflows ÷ outlay

NPV profile — where the curve crosses zero is your IRR

Discount-rate sensitivity

Discount rate	NPV	PI

Present value by year

Year	Cash flow	Discount factor	Present value	Cumulative PV

Notes

Cash flows are assumed to land at the end of each period; the first line is period 0 (undiscounted).
IRR is solved numerically. If your cash flows change sign more than once, multiple IRRs can exist — trust the NPV profile over the single number.
Payback shown is simple (undiscounted) with the discounted payback alongside where it exists.