$4773.$ Calculate the lender's yield on a constant amortization mortgage loan for $$950,000$ with monthly payments over $15$

years at $6\%$ interest with $1\mathrm{.}75$ points assuming the borrower prepays the loan at the end of year $6.$

CAM Loan Amortization Schedule

Edit showing the correct formulas used in excel and the results in a CLEAR manner please! thankyou. Find Yield to Lender