Explore BrainMass
Share

# PV and FVIFA

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

I'm trying to find the formula in excel to help calculate the answers for part 1 of this problem. I do not understand how \$13,421 was calculated. I tried using FV and I do not have enough variables to calculate the answer.

You need \$28,974 at the end of 10 years, and your only investment outlet is an 8 percent long-term certificate of deposit (compounded annually). With the certificate of deposit, you make an initial investment at the beginning of the first year.

1. What single payment could be made at the beginning of the first year to achieve this objective?

Amount x (1+ 8%)^ 10= \$28,974
Therefore Amount= \$13,421

I do not understand how the answers 14.486562 was calculated only using the periods and interest rate.

2. What amount could you pay at the end of each year annually for 10 years to achieve this same objective?

FVIFA= Future Value Interest Factor for an Annuity

n= 10
r= 8.00%
FVIFA (10 periods, 8.% rate ) = 14.486562

Future value= \$28,974
Therefore, annuity= \$2,000 =28974/14.486562

© BrainMass Inc. brainmass.com March 21, 2019, 2:47 pm ad1c9bdddf