ExcelWhiz

EXCELWHIZ

All Calculators

NPV & IRR Calculator

Evaluate a project's net present value, internal rate of return, and payback period

Results are estimates for guidance only. This tool does not provide financial advice.

Cash Flow Projection

%

Your cost of capital or required return. Year 0 is not discounted.

Year 0
$
Year 1
$
Year 2
$
Year 3
$
Year 4
$
Year 5
$

Enter the initial investment as a negative number in Year 0 (e.g. -100000), then expected net cash flows for each year.

Results

Net Present Value (NPV)$29,078.68
Internal Rate of Return (IRR)19.71%
vs discount rateAccept (IRR > rate)
Payback Period4.3 years