Excel Functions
 

How do I calculate the present worth of $1 utilizing an Excel function?
With the correct formula, the present worth of $1, at a 10% discount rate
for 5 periods (or years) would equal: yr1 .9091, yr2 .8264, yr3 .7513, yr4
..6831, yr5 .6209.

This unknown functions is different from the PV and FV functions. If I just
wanted the sum of those figures, I could use the NPV function but I want to
calculate the present worth of $1 each period.

Thanks.

Not sure what's "different from the PV" function...

=PV(10%,1,0,-1) ==== 0.9091
=PV(10%,2,0,-1) ==== 0.8264
=PV(10%,3,0,-1) ==== 0.7513
...




In article ,
"sjsexcel" wrote:

How do I calculate the present worth of $1 utilizing an Excel function?
With the correct formula, the present worth of $1, at a 10% discount rate
for 5 periods (or years) would equal: yr1 .9091, yr2 .8264, yr3 .7513, yr4
.6831, yr5 .6209.

This unknown functions is different from the PV and FV functions. If I just
wanted the sum of those figures, I could use the NPV function but I want to
calculate the present worth of $1 each period.

Thanks.