annuity future value?

P

PeteK

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.
 
P

PeteK

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 said:
How about the Present Value (PV) function?
Click to expand...
 
M

Myrna Larson

What exact problems are you having that you can't resolve from the information
in 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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
annuity calculation for monthly payments but quarterly compoundin 5
Annuities 3
Annuity Payments From A Present Amount 2
Possible problem with PMT and FV functions 2
Repaymen of loan excel sheet with grace period etc... 7
Present Value of a Continuously Compounded Annuity Payment 5
How can I calculate a due interest of annuities for a certain peri 4

Top