Please provide the excel function formula with the answer (answer is in the green highlight cell)

5. What is the yield to a lender who funds a loan for $500,000 at 9% interest with monthly payments over 15 years that wraps around an existing loan for $300,000 at 5% interest with monthly payments for 10 years remaining? Use the IRR function. Existing Loan Loan Amount Annual Interest Rate Maturity (in years) Periods per year Monthly Payment Wraparound Loan Loan Amount Annual Interest Rate Maturity (in years) Periods per year Monthly Payment Cash Flow Yield to Wraparound Lender Month 0 1 2 3 4 Would you be very surprised if the prevailing rate for junior mortgage loans in this market is greater than 12.5%? (just a thinking question, not graded)