15 (1 point) Excel formula for calculating the cashflow is: Question 15 options: =PMT(RATE,PV,NPER,FV,0) =PMT(NPER,PV,RATE,FV,0) =PMT(RATE,NPER,PV,FV,0) None of the above Question 16 (1 point) Matthew wants to take out a loan to buy a car. He calculates that he can make repayments of $4000 per year. If he can get a five-year loan with an interest rate of 7.5%. Calculating the present value of annuity using the Excel functions = PV (RATE,NPER,PMT,FV,0) What is the FV value in the above formula? Question 16 options: 0 $4,000 $20,000 $16,183.54 Question 17 (1 point) Ellen is 35 years old, and she has decided it is time to plan seriously for her retirement. At the end of each year until she is 65, she will save $10,000 in a retirement account. If the account earns 10% per year, how much will Ellen have saved at age 65? Question 17 options: $1.000 million $1.645 million $1.654 million None of the above Question 18 (1 point) Present Value of an Annuity : Just as with the perpetuity, we assume the first payment takes place one period from today. Question 18 options: True False Question 19 (1 point) PV function in excel stand for Present Value Question 19 options: True False Question 20 (1 point) Annuity and Perpetuity are one and the same. Question 20 options: True False Question 21 (1 point) Your firm plans to buy a warehouse for $100,000. The bank offers you a 30-year loan with equal annual payments and an interest rate of 8