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

A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800 origination fee and 2.5 discount points. A borrower wants a loan for $358.000. What is the yield to the lender, the effective borrowing cost to the borrower, and the APR assuming the borrower prepays the loan balance at the end of year 6? Use both the IRR function in the green highlighted cell as indicated Loan Amount Annual Interest Rate Origination Fee Discount Points Maturity (in years) Periods per year Prepayment Month Monthly Payment Balance at EOY 6 $358.000.00 4.50% $800.00 2.50% 6 12 72 Using IRR Function Yield to Lender Effective borrowing cost to borrower APR (this is tricky, be careful) Using RATE Function Yield to Lender Effective borrowing cost to borrower APR (this is tricky, be careful) A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800 origination fee and 2.5 discount points. A borrower wants a loan for $358.000. What is the yield to the lender, the effective borrowing cost to the borrower, and the APR assuming the borrower prepays the loan balance at the end of year 6? Use both the IRR function in the green highlighted cell as indicated Loan Amount Annual Interest Rate Origination Fee Discount Points Maturity (in years) Periods per year Prepayment Month Monthly Payment Balance at EOY 6 $358.000.00 4.50% $800.00 2.50% 6 12 72 Using IRR Function Yield to Lender Effective borrowing cost to borrower APR (this is tricky, be careful) Using RATE Function Yield to Lender Effective borrowing cost to borrower APR (this is tricky, be careful)