What is the yield to a lender who funds a loan for $$800,000$ at $9\%$ interest with monthly payments over ${15}_{?}$ years

that wraps around an existing loan for $$500,000$ at $5\%$ interest with monthly payments for $10$ years remaining? Use

the IRR function.

Existing Loan

Loan Amount

Annual Interest Rate

Maturity $($in years$)$

Periods per year

Monthly Payment

Wraparound Loan

Loan Amount

Annual Interest Rate

Maturity $($in years$)$

Periods per year

Monthly Payment

solve all and use formulas and show results!