Can you please help me solve this problem? In excel would be great so i can see how you got answer

Luis took a fixed-rate mortgage loan 5 years ago for $120,000 at 7% interestrate for 15 years (monthly compounding loan). Now a new lender offers him aloan at 5% for 10 years, with a loan amount being $92,895, which is exactly the outstanding loan balance of the existing loan. If Luis refinances the existing loan,a prepayment penalty of3% will be applied. Also, the new loanhas a loanfee of $3,000. If Luis plans to hold the new loan for 10 yearsand he hastopay the refinancing fees out ofhis pocket, what is the effective interest rate for the new loan?