urn UN CON A B 1 Rate of Retur H 2 3 4 Period/Year 5 1 6 2 7 3 8 4 9 5 10 11 Total 12 13 Net Present Value 14 15 16 Complete this sheet. Use a function to calculate the net present value for the following. Use the 17 "periods" concept as we did in class. You are going to get money over the next five years/periods. You will 18 19 get $2,500 in year 1, $1,500 in year 2, 62,000 in year 3 and $500 in year 4 and 5. The rate of return is four and a half percent. 20 21: Format this sheet appropriately. 22 23 10 points 24 25 26 27 28 29 30 31 32 33 34 Prob 1 Prob2 26