Yes, thank you, that was the root of where I was starting. Was lookng for a
bit more in-depth response. I'm having trouble with plugging in the various
items as the variables.

"Myrna Larson" wrote in message
...
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.