=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
|