i need answer for 9 and 10 only

9:421 Table to calculate answer: 1 Loan mortgage 750000 2 Interest rate 5.50% 3 Monthly rate 0.004583333 4 Years 30 5 Months 360 6 Monthly payments $4,258.42 7 Months remaining 300 8 Loan balance after 5 years $693,454.53 9 New monthly mortgage rate 0.002916667 10 Monthly payments $3,471.60 11 Closing cost $34,672.73 12 Loan balance after 5 years $598,592.75 13 Loan payoff $658,781.80 14 Rate of return on finance 0.39% 15 Effective rate 4.80% Formulas applied: 1 Loan mortgage 750000 2 Interest rate 0.055 3 Monthly rate =B2/12 4 Years 30 5 Months =B4 12 6 Monthly payments =PMT(B3,B5,-81) 7 Months remaining =B5-512 8 Loan balance after 5 years =PV[B3,87,-86) 9 New monthly mortgage rate =3.5%/12 10 Monthly payments =PMT(89,87,-88) 11 Closing cost =5%B8 12 Loan balance after 5 years =PV(89,37-5'12.-310) 13 Loan payoff =B8-811 14 Rate of return on finance =RATE[5*12,810,-813,812) 15 Effective rate =(1+B14)^12-1 8) What is your return on investment if you have a chance to refinance your current mortgage of $750,000 with a rate of 5.5% and 30 year amortization after 5 years. You will do a non-cash out refinance and your clsoing costs to refinance is 5% the new amortization is 25 years and the intersest rate 3.5%. 9) What is the rate of return if you are only going to stay for an additional 5 years. 10) What is the effecitve cost of borrowing on the refiance above