please include formulas:)

789 790 791 5. What is the yield to a lender who funds a loan for $800,000 at 9% interest with monthly payments over 15 years 192 that wraps around an existing loan for $500,000 at 5% Interest with monthly payments for 10 years remaining? 793 Use the IRR function. 794 795 Existing Loan 796 Loan Amount 297 Annual Interest Rate 798 Maturity (in years) 199 Periods per year 800 Monthly Payment 801 802 Wraparound Loan 803 Loan Amount 804 Annual Interest Rate Sos Maturity (in years) 306 Periods per year 807 Monthly Payment 808 809 810 Month Cash Flow Yield to Wraparound Lender 811 0 812 1 Would you be very surprised if the 813 2 prevailing rate for junior mortgage 814 3 loans in this market is greater than 815 4 12.5%? (just a thinking question, not 816 5 graded) $17 6 $18 7 819 8 820 9 821 10 822 11 823 12 824 13 825 14 826 15 16 R27 G483 4 X fx 1 1 X c D 90 611 20 10 106 sen 104 10 110 111 112 113 114 13 SIL 116 LI! TI 110 00 10 TED 15 296 123 124 135 12 12 136 129 110 - 140 ICE 12 111 114 PLE LET 43 118 MI 113 40 161 14 10 14 145 14 14 P! 150 151 112 153 154 11 11 15 150 11 11 16 1 ITE TE 51 TI IN