A real estate investor feels that the cash flow from a property will enable her to pay a lender $15,000 per year, at the end of every year, for 10 years. How much should the lender be willing to loan her if he requires a 9% annual interest rate (annually compounded, assuming the first of the 10 equal payments arrives one year from the date the loan is disbursed)

specifically how do I do this in excel