You plan to invest $5,000 per year in an account that pays you the highest interest...

Transcribed Image Text:

You plan to invest $5,000 per year in an account that pays you the highest interest rate. Bank 1 has a plan that guarantees a $10,000 balance for you after 5 years, and Bank 2 guarantees a $11,000 balance after 6 years. There are no uniform payments in both cases. B Bank 1 Bank 2 Investment Term (years) $5,000 5 $5,000 Uniform Payment $0 $0 Balance $10,000 $11,000 12345 Develop an Excel spreadsheet that calculates the interest rate offered by each bank (to 2 places of decimal) and state which bank you'll select based on the highest interest rate. (Note: The investment period is not critical, just the highest rate of return). Copy and paste the spreadsheet below and state the approach and the Excel function you used to help you calculate the interest. You plan to invest $5,000 per year in an account that pays you the highest interest rate. Bank 1 has a plan that guarantees a $10,000 balance for you after 5 years, and Bank 2 guarantees a $11,000 balance after 6 years. There are no uniform payments in both cases. B Bank 1 Bank 2 Investment Term (years) $5,000 5 $5,000 Uniform Payment $0 $0 Balance $10,000 $11,000 12345 Develop an Excel spreadsheet that calculates the interest rate offered by each bank (to 2 places of decimal) and state which bank you'll select based on the highest interest rate. (Note: The investment period is not critical, just the highest rate of return). Copy and paste the spreadsheet below and state the approach and the Excel function you used to help you calculate the interest.