annuity future value?
 

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.

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.

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.

What exact problems are you having that you can't resolve from the information
in Help?

On Fri, 26 Nov 2004 12:24:26 -0500, "PeteK" wrote:

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.