# 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.