choose the right formula for C15 C 1 CALCULATING PRESENT VALUES 2 Annual payment 3 r. interest rate 4 100 6% Payment Present at end of value of 5 Year year payment 6 1 100 94.34 7 2 100 89.00 8 3 100 83.96 9 4 100 79.21 10 5 100 74.73 11 12 Present value of all payments 13 Summing the present values 421.24 14 Using Excer's PV function 15 Using Excel's NPV function 421.24 421.24 NPV(83,86 B10) PV(83,5-100) SUM(B6 B10) -NPV(B3C6C10)