NPV and IRR Calculator Template
Discount a project’s cash flows to a net present value and internal rate of return, so you can decide whether it clears your hurdle rate.
Prefer the spreadsheet? Capital Appraisal: NPV, IRR, MIRR, Payback · Lease vs Buy · Loan & Amortisation Schedule Template · Loan Overpayment & Offset Comparison · NPV & IRR Appraisal Template · Development Appraisal Template — free with an account, 3 free downloads.
See inside before you download: Capital Appraisal: NPV, IRR, MIRR, Payback · Lease vs Buy · Loan & Amortisation Schedule Template · Loan Overpayment & Offset Comparison · NPV & IRR Appraisal Template · Development Appraisal Template
What's inside this template
How it works
It loads with realistic sample data so you see a finished result immediately — nothing to set up.
Type over the sample values, or upload your own file and map the columns in a couple of clicks.
The NPV calculator recalculates instantly. Export to Excel or send a live link.
Related templates
Common questions
What's the difference between NPV and IRR?
NPV tells you how much value a project adds in today's money at a discount rate you choose. IRR tells you the discount rate at which that value would be zero. NPV answers 'how much', IRR answers 'what return'.
Which discount rate should I use?
Your cost of capital — the blended cost of the debt and equity funding the project — or the return you'd get from the next best use of the money. Using a rate that's too low makes almost everything look worthwhile.
Can NPV and IRR disagree?
Yes, typically when projects differ in size or in when the cash arrives. When they conflict, NPV is the one to follow: it measures actual value created rather than a percentage.
Start from the NPV / IRR appraisal template
Open it with sample data, swap in your own, and export in seconds — no formulas, no blank page.
Use this template free →