annuity future value?

  • Thread starter Thread starter PeteK
  • Start date Start date
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.
 
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...
 
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...
 
You must log in or register to reply here.

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

annuity calculation for monthly payments but quarterly compoundin 5
Annuities 3
Annuity Payments From A Present Amount 2
Present Value of a Continuously Compounded Annuity Payment 5
Possible problem with PMT and FV functions 2
How can I calculate a due interest of annuities for a certain peri 4
Repaymen of loan excel sheet with grace period etc... 14
Calculate Single Pay Annuity 1

Back
Top