please post formulas thank you

. il IM HH D12 4 x fx G A B D E 789 790 291 5. What is the yield to a leader who funds a loan for $800,000 at 9% Interest with monthly payments over 15 years 792 that wraps around an existing loan for $500,000 at 5% interest with monthly payments for 10 years remaining? 293 Use the IRR function. 294 795 Existing Loan 796 Loan Amount 797 Annunl Interest Rate 798 Maturity (in years) 799 Periods per year 800 Monthly Payment 801 1802 Wraparound Loan 803 Loan Amount 804 Annual Interest Rate 805 Maturity (in years) 806 Periods per year 807 Monthly Payment 808 809 810 Month Cash Flow Yield to Wraparound Lender 811 0 B12 1 813 Would you be very surprised if the 2 814 prevailing rate for junior mortgage 3 815 loans in this market is greater than 4 12.5% (just a thinking question, not 5 817 graded) 6 818 7 319 8 820 9 10 822 11 23 12 13 kas 14 26 15 16 17 816 Concepts