How about the Present Value (PV) function?

On Wed, 24 Nov 2004 18:14:52 -0500, "PeteK" wrote:

What is the best approach of how to figure out the possible present value of
a future single payment annuity, based on the variability of several
possible interest rates?

Would like to do a small spreadsheet plugging in the term, future payment
and interest rate so we could do a test of 'what happens when this changes?'

Thnaks in advance for any help.