MATH 1031 Spreadsheet Assignment "Interest" Fall 2021 For this spreadsheet assignment, you'll be making an interest calculator! Suppose that you are making an investment which is going to be compounded quaterly for 2 years. So there will be 8 steps before the two years are up. Your spreadsheet should be able to take the following inputs. Initial investment Annual Interest Rate Quick tip: the input should be the annual interest rate, but you are compounding the investment quarterly (4 times a year). So make sure you adjust your calculator. Then the sheet should have columns for the following outputs. Quarter (so 8 rows numbered 1,2,3,4,5,6,7,8) Initial balance (how much $$$ you have at the beginning of the quarter) Ending balance (how much you have at the end) So for example we wanted to input the initial investment as $200 with an annual interest rate of 14%, then your sheet should look something like this... Quarter Initial Balance Ending Balance 1 $ 200.00 $206.66 2 $206.66 $213.54 3 $213.54 $220.65 Initial Investment $200 4 $220.65 $228.00 Annual Interest Rate 14% 5 $228.00 $235.59 6 $235.59 $243.44 7 $243.44 $251.54 8 $251.54 $259.92 You should be able to input anything in the Initial Investment and Annual Interest Rate and the outputs will change automatically