QUESTION 1 (40 Points) You plan to invest $5,000 per year in an account that pays you the highest interest rate. Bank A has a plan that guarantees $30,000 balance for you after 5 years, and Bank B guarantees a $37,800 balance after 6 years. Create a spreadsheet that would help you compute the interest rates offered by the two banks (to 2 places of decimal) and state which bank you'll select based on the highest interest rate only. Copy and paste the spreadsheet below and state the Excel function you used to help you calculate the interest rates. Provide an explanation.