provide the answer in the green highlight cell with the excel function explanation, please

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) 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)