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% per year. The bank requires that your firm pay 20% of the purchase price as a down payment, so you can borrow only $80,000. What is the amount of present value (PV) in above quesiton? Question 21 options: $20,000 $80,000 $100,0000 None of the above Question 22 (1 point) Anya finally decides that she will give her cousin, Zen, the loan he requested. He is expected to pay Anya $12,500 each year for the next 5 years, starting at the end of this year. The loan interest rate at the bank is 5% but because he is family, she will only charge him half of this interest rate. What is the current value of this loan today? Calculating the present value of annuity using the Excel functions = PV (RATE,NPER,PMT,FV,0) What is NPER? Question 22 options: 1 year 5 years None of the above Question 23 (1 point) NPER is an excel function that calculates the number of payments periods for a loan or investment. Question 23 options: True False Question 24 (1 point) Anya finally decides that she will give her cousin, Zen, the loan he requested. He is expected to pay Anya $12,500 each year for the next 5 years, starting at the end of this year. The loan interest rate at the bank is 5% but because he is family, she will only charge him half of this interest rate. Calculating the present value of annuity using the Exc