S
sjsexcel
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.
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.