The rate for Year 2 is very high. What is the correct formula? fx =RIGHT(PI()/ROW(DS),4) % A

The rate for Year 2 is very high. What is the correct formula? 

Transcribed Image Text:

fx =RIGHT(PI()/ROW(DS),4) % A B C D E F H I 1 2 Retirement Savings Calculator 3 Year 4 0 Age 34 Rate (%) Invested Amount $10,000.00 5 1 35 2.00 $2,500.00 6 2 36 2 27 79.59 200 $2,500.00 $15,250.00 $2.500.00 $79 0871 4803 64 Opening Balance Interest Debit Amount Closing Balance $10,000.00 $10,000.00 $12,500.00 $250.00 $12,137.48 $12,750.00 $27,387.48 $30 781 11 fx =RIGHT(PI()/ROW(DS),4) % A B C D E F H I 1 2 Retirement Savings Calculator 3 Year 4 0 Age 34 Rate (%) Invested Amount $10,000.00 5 1 35 2.00 $2,500.00 6 2 36 2 27 79.59 200 $2,500.00 $15,250.00 $2.500.00 $79 0871 4803 64 Opening Balance Interest Debit Amount Closing Balance $10,000.00 $10,000.00 $12,500.00 $250.00 $12,137.48 $12,750.00 $27,387.48 $30 781 11