please post formulas

B D E F G I 476 477 3. Calculate the lender's yield on constant amortization mortgage loan for $950,000 with monthly payments over 478 15 years at 6% Interest with 1.75 points assuming the borrower prepays the loan at the end of year 6. 479 480 481 Lom Amount Using IRR Function 482 Annual Interest Rate Yield to Lender 483 Discount Points 484 Maturity (in years) 485 Periods per year 486 Prepayment Month 457 Monthly Amortization 488 Balance at EOY 6 489 490 CAM Lo Amortization Schedule 491 Month Payment Interest Principal Balance 492 0 491 1 494 2 495 3 Cash Flows 496 - 497 493 499 500 301 502 503 504 SOS 506 507 sos 509 310 511 SI $13 514 515 18 19 20 21 22 23 Concepts +