C24 X fx A B D E F F G H H I J K L M 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% Present values 4 4 5 6 7 8 9 10 11 Year 1 2 3 3 4 5 Deposits at the end of each year 200 300 400 500 600 Total present value Balance at the end of the 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 Beginning Balance Deposits at the endg 16 Year of the year of each year Interest earned during the year 17 1 0 300 2 300 19 3 300 20 4 300 21 5 300 22 23 year 18 24 C24 x fox X A B D E F F G H L M 5% 14 Interest rate 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 23 24 25 the year Part C. What if your reward Is $200 for the next year, $300 for the 2nd year, $400 for the 3rd year, and $500 for the 4th year, how much 26 will your account balance be at the end of the 4th year? All payments will still be made at the beginning of every year. 27 28 Interest rate 2% Sum 29 Beginning Balance of Balance at the end of the 30 Year Payment Interest earned during the year year 31 1 0 200 32 2 300 33 3 400 34 4 500 35 36 37 38 39 40 41 42 43