You use the NPV function. Start by specifying the rate and follow it with a list of future values that you want to help determine your result. So you could have something like this:
=NPV(5%,10,20)
View page
the net present value as determined by normal discount rate is
10%
View page
Net Present Value
View page
Net present value method has value adding-up property