Question: I need help on an excel worksheet. I was able to calculate FVIF (as shown in 1st screenshot), but need to now calculate FVIFA (future
I need help on an excel worksheet. I was able to calculate FVIF (as shown in 1st screenshot), but need to now calculate FVIFA (future value interest factor for annuity). It is based on the value of $1. Please include how to input into excel, I want to learn. Thank you!


A B D E F G H 1 2 3 5% 4 5 6 7 Future Value Interest Factor (FVIF) PV $1 0% 1 $1.0000 2 $1.0000 3 $1.0000 4 $1.0000 5 $1.0000 6 $1.0000 7 $1.0000 8 $1.0000 9 $1.0000 10 $1.0000 8 $1.0500 $1.1025 $1.1576 $1.2155 $1.2763 $1.3401 $1.4071 $1.4775 $1.5513 $1.6289 10% $1.1000 $1.2100 $1.3310 $1.4641 $1.6105 $1.7716 $1.9487 $2.1436 $2.3579 $2.5937 15% $1.1500 $1.3225 $1.5209 $1.7490 $2.0114 $2.3131 $2.6600 $3.0590 $3.5179 $4.0456 20% $1.2000 $1.4400 $1.7280 $2.0736 $2.4883 $2.9860 $3.5832 $4.2998 $5.1598 $6.1917 25% $1.2500 $1.5625 $1.9531 $2.4414 $3.0518 $3.8147 $4.7684 $5.9605 $7.4506 $9.3132 9 10 11 12 13 E F G H 10% 15% 20% 25% D. 27 Future Value Interest Factor for Annuity (FVIFA) 28 PV $1 29 0% 5% 30 1 31 2 32 3 33 4 34 5 35 6 NP 36 7 8 37 38 9 39 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
