Use Excel Please

Do it like this.

PV

FV

PMT

N

I/Y

7. Suppose you are a mortgage lender. A borrower has promised to pay you $11,746 each year for 20 years. Given you want to earn a 10 percent rate of return per year, what is the most you are willing to lend the borrower? 8. You are thinking about letting a friend borrow $10,000 today given that she will repay you $15,000 in 5 years. What is your internal rate of return on the investment