Part A. Calculate the total present value (the value at time 0) of the following cash flows. These cash flows occur once every year and at the end of each year. You may use the provided template or appropriate Excel functions. 1 2 3 Discount rate 5% 5 Present values 4 5 6 7 8 9 10 11 Year 1 2 3 4 5 Deposits at the end of each year 200 300 400 500 600 Total present value Part B. Calculate the total future value (the value at time 5) of the following cash flows. These cash flows occur once every year and at the end of each year. You may use the provided template or appropriate Excel functions. 12 13 14 Interest rate 5% 15 Balance at the end of the year Interest earned during the year 16 17 18 Year 1 2 3 4 5 Beginning Balance Deposits at the endg of the year of each year 0 300 300 300 300 300 19 20 21 22