You are referring to the NPV() function. Take a look at the PV() function
instead, and remember that your result will have a sign opposite of the one
you give the final payment. So...if you expect to receive a $100 payment in
5 years, you will get a negative result, indicating what you'd have to pay
OUT today to get that $100.
Duke
"Carmen" wrote:
Excel has a built in formula for calculating present value of an annuity
(series of payments), but I am looking forward to finding a way to calcuate
present value of a single sum (such as a note that accrues interest but is
only paid at the end of the period - therefore only paid once).
Thanks
|