Net Present Value Calculator

Instructions: Use this Net Present Value Calculator to compute the net present value (\(NPV\)) of a stream of cash flows by indicating the yearly cash flows (\(F_t\)), starting at year \(t = 0\), and the discount rate (\(r\)) (Type in the cash flows for each year from \(t=0\) to \(t = n\). Type '0' if there is no cash flow for a year):

Interest Rate \((r)\) =
Type the yearly cash flows (comma or space separated)

Calculator of the Net Present Value (NPV)

More about the this NPV calculator so you can better understand how to use this solver: The net present value (\(PV\)) of a stream of cash flows \(F_t\) depends on the discount interest rate \(r\), and the cash flows themselves. The net present value (\(NPV\)) can be computed using the following formula:

\[ NPV = \displaystyle \sum_{i=0}^n \frac{F_i}{(1+i)^i} \]

How to compute the net present value excel

Excel has a built in function, the =NPV() function that allows you to compute the present value of cash flows.

There are other metrics used to evaluate a projects. You can also use our internal rate of return calculator, or our profitability index calculator.

In case you have any suggestion, or if you would like to report a broken solver/calculator, please do not hesitate to contact us.

log in

reset password

Back to
log in