2 Lets assume we put S2000 into a bank account using simple interest at 5%. 3 How much intcrcat do wc car ater 1 ycarz? 5 6 Now, let's earn interest compounded for the four year period 7 Calculate the ending balance in our account at the end of years (atill 5% interest) 8 Date Calculation Running Balance 9 initial deposit 10 end of year 1 Il end of year 2 12 end of your 3 13 end of year + 14 15 Now. show the formula you can lise to get the answer insteac.: 16 Now, use the excel functivulu calculate your sumber: 1/1 18 Now. let's assume that we earn interest semi-annually. How 19 much interest da we earn? 20 Date Calculation Running Balance 21 initial deposit 22 June 30 year 1 23 Dec 31 year 1 24 June 30 year 2 25 Dec 31 year 2 26 June 30 year 3 27 Dec 31 year 3 28 June 30 year 4 29 Dec 31 year 4 30 31 Now, show the formula you can use to get the answer insteac: 32 Now, use the excel function to calculate your number