18 Now, let's assume that we earn interest semi-annually. How 19 much interest do 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 26 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 instead: 32 Now, use the excel function to calculate your number: 00 18 Now, let's assume that we earn interest semi-annually. How 19 much interest do 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 26 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 instead: 32 Now, use the excel function to calculate your number: 00