I am trying to us the FV funtion to validate some annuity projections. I am not having much success.
Here are the numbers:
Four payments per year each $5569 (at the end of the period)
Age 41 (I need value at age 65) so I figured 96 payments
PV = $181770
Interest rate 6% annually (I entered 1.5% or .015 snice the payments are quarterly)
How do I set up the FV formula to get my investment value at age 65? Is the FV formlua the best formula?
Thanks!
Steve
Here are the numbers:
Four payments per year each $5569 (at the end of the period)
Age 41 (I need value at age 65) so I figured 96 payments
PV = $181770
Interest rate 6% annually (I entered 1.5% or .015 snice the payments are quarterly)
How do I set up the FV formula to get my investment value at age 65? Is the FV formlua the best formula?
Thanks!
Steve