Hello,

Would you show me how to find future value using a calculator?

The calculation below was shown using Excel, and I was unsure how to find the values.

Thank you very much for your time!

Calculation of future value: FV (at age of 65) Age Monthly contribution 28 673.75 103,015.62 707.44 100,874.20 742.81 30 98,777.29 31 779.95 96,723.97 32 818.95 94,713.33 859.89 33 92,744.49 34 902.89 90,816.58 88,928.74 35 948.03 87,080.15 36 995.44 1,000.00 37 1,038,688.22 Total 1,892,362.60 Calculation is done using FV function of excel as follows: FV (rate, period, pmt, PV) where: Rate 0.07/12, period is 12 months for each of the monthly payments, pmt as calculated above, PV 0 C B 1 Age Monthly contribution FV (at age of 65) FV((0.07/12),12,-B2,0) ((1+ ( 0.07/12))* (12 36)) FV((0.07/12),12,-B3,0) (( 1+( 0.07/12 )) (12.35)) FV((0.07/12),12,-B4,0) ( ( 1- ( 0.07/12)) (12.34) 2 28 673.75 -A2+ 1 3 707.44 4A3+ 1 742.81 FV((0.07/ 12 ),12,-B5,0) ((1+(0.07/12))^ (12-33)) -FV((0.07/ 12 ) ,12,-B6,0) ((1+(0.07/12))^ (12 32)) FV((0.07/12),12,-B7,0) (( 1 + ( 0.07/12)) (12 31)) FV( (0.07/ 12),12,-B8,0) ( ( 1+ ( 0.07 /12)) ( 12-30)) FV((0.07/12),12,-B9,0) ((1+(0.07/12)) (12 29) FV( (0.07/ 12 ),12,-B10,0) ( ( 1+ ( 0.07/12))^ ( 12 28 )) FV((0.07/12),28 12,-B11,0) SUM(C2:C11) 5A4+1 779.95 6 -A5+ 1 818.95 7 -A6+ 1 859.89 8A7+1 902.89 9 A8+1 948.03 10A9+1 995.44 11-A10+1 1000 12 Total 12 29 5