Carmen -

Not sure what you mean by it "doesn't work either."

It works fine on my PC. Are you suggesting you get an error, an erroneous
result, or something else entirely?

Are you posing your question here - and in Excel - accurately?



"Carmen" wrote:

This doesn't work either, already tried that.

"Duke Carey" wrote:

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