Ans for the red box please

3. 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.75 points assuming the borrower prepays the loan at the end of year 6. Using IRR Function Yield to Lender Loan Amount Annual Interest Rate Discount Points Maturity (in years) Periods per year Prepayment Month 7 Monthly Amortization 8 Balance at EOY6 9 20 $950,000.00 6.00% 1.75% 15 12 72 $8,016,64 5667.733.39 Month 114 0 1 2 3 4 5 6 2 Payment 0 $8,016,64 58,016.64 $8,016,64 $8,016,64 58,016.64 $8,016,64 SRO1664 CAM Loan Amortization Schedule Interest Principal Balance 0 0 $950,000.00 $4,750.00 $3,266,64 $946,733.36 $4.733.67 $3,282.97 $943.450.39 $4,717.25 $3,299.39 $940,151.00 $4,700.75 $3,315.88 $936,835,11 $4,684.18 $3,332.46 $933.502.65 $4,667.51 $3,349.13 $930,153.52 4650.72 $3.1667 5926787.65 Cash Flows $933,375.00 $8,016.64 -$8,016,64 $8,016.64 -$8,016,64 -$8,016,64 -$8,016.64 CR 16.64 Concet