CHAPTER 6 - EXCEL EXERCISE (PART 1) You can use the function capability in excel to help solve time value of money problems Using these functions solve for the highlighted sections in the charts below. For the lump sum problems there is no Single Lum Sum Problems PV 31,347.83 PMT Rate 56 7W 10% Number of Periods 10 25 FV $25,000700 509,000.00 $450,000.00 $8,700.00 $225,000.00 $2,500.00 $15,000.00 OOOOOO 15% 5% 15 12 6 $35,000.00 fix Click on the function button in excel and select what you are trying to solve for (PV,FV, Nper, Rate or FV Function Arguments PV Rate a Nper De Pet The next step involves just selecting the proper cells that fit in each section in order for the formulas to work the PV must always be negative you can either change this in the table or add a negative sign in your formula, - 10 - 25000 Type -2534743134 Return the present value of an investment the total amount that a series of future payment is worth now Mate is the interest rate per period. For example, el for quarterly pentsat ON APR Formularesult - 515,347.13 He this function OK Cancel