Create an excel sheet to answer the question below. See the daft excel sheet to get started.

2. Dr. Rubin has $10,000 to invest for three years. Two banks offer a 2 percent interest rate, but bank A compounds quarterly and bank B compounds semian nually. To what value would his money grow in each of the two banks! 1 Compound Interest 2. 3 3 Y=X*(1+r)^n 4 Principal Interest Rate 50 0.1 0.025 12 67 5 6 7 8 Bank A 9 quarterly rate 10 # of Quarters 71 Amount after 3 years 12 13 74 Bank B 15 Semiannual rate 16 # of Semis 17 Amount after 3 years 18 19 20 Difference 0.05 6 67 0