Is this something in one of the add-in packages? I tried the formula and it
gives me a #NAME? error.
Thanks for your help!
"N Harkawat" wrote:
=future_payment/((1+r)^n)
where r is the rate of interest and n is the number of periods.
for instance present value of 120 three years from today = 120/1.03^3 =
109.81
"Carmen" wrote in message
...
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
|