Use Excel Functions

Find the missing values in yellow: Annuity Payment, Present Value and Future Value. Find the values based on the assumptions of the other variables. Annuity Payment Present Value $ 15,000 21,400 145,300 325,000 Years 6 8 15 20 Interest Rate 11% 7% 8% 6% Present value Annuity Paymen Years $ 1,560 7 1,280 9 20,000 18 53,200 28 Interest rate 5% 10% 8% 14% Future Value Payment $ 2,100 6,500 1,100 5,000 Years 10 40 9 30 Interest Rate 8% 9% 6% 10%