CHAPTER 6 - EXCEL EXERCISE (PART 2) In this section we will do the same thing as the previous seclont only we will be solving for annuities Solve for the highlighted sections in the charts below. For an annuity you need either the PV or PMT Annuity Problems PV Rate Number of Periods 10 25 FV NA NA NA SR 700.00 79 10 TOTO $500.00 $1,500.00 1250.00 $2.000.00 $225,000.00 NA NA NA 15 12 15% $35,000.00 58 Click on the function button in excel and select what you are trying to solve for (PV, PV, Nper, Rate or FV) Function Arguments The next step involves just selecting the proper cells that fit in each section. In order for the formulas to work the PV OR the FV must always be negative you can either change this in the table or add a negative sign in your formula PV -0.05 - 10 - Iate CH per D Pet FS FV ES Type 25000 - 1534783134 Returns the present value of an investment the total amount that a series of future payment is worth now Rate is the interest rate per period. For exampit, use for quarterly payments at EN APR. Formulares - 515,347.33 OK Cancel Hele on this function