Suppose you were considering depositing money in a savings account at two different banks. Each bank will pay 5% interest. However, bank A compounds annually and bank B compounds semiannually. Provide a detailed explanation with your investment amount, period of time and your resulting investment. In addition, provide details on how you calculated using Excel (with formula) or financial calculator inputs. Which bank would you choose and why? Be sure to cite your source(s).