Use formula not Excel

ans should be Annualized IRR from mortgage Q10 .A = 7.20% Q11 = B = 9.00% Q13 = 14.59%. Q14= 18.81%

Ann is looking for a fully amortizing 30-year Fixed Rate Mortgage with monthly payments for $1,500,000.

Mortgage A has a 7.05% interest rate and requires Ann to pay 1.5 points upfront.

Mortgage B has a 9% interest rate and requires Ann to pay zero fees upfront.

10.Assuming Ann makes payments for 30 years, what is Anns annualized IRR from mortgage A?

11.Assuming Ann makes payments for 30 years, what is Anns annualized IRR from mortgage B?

12.Assuming Ann makes payments for 30 years, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1 for A, type 2 for B

13.Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Anns annualized IRR from mortgage A?

14.Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Anns annualized IRR from mortgage B?

15. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1 for A, type 2 for B.