PLEASE SHOW EXCEL WORK A borrower can get a mortgage for $400,000 over 30 years with the following terms: Initial interest rate = 5% Index = 1 year Treasuries Payments adjusted annually Margin = 2% Negative amortization = yes Based on forward rates the index is forecasted as follows: Beginning of year BOY2=7%, BOY3=8%, BOY4=7%, BOY5=5%

A.Compute the payments, loan balances, and the cost of borrowing over a 5-year period.

B. Consider the information from the problem above. Compute the payments, loan balances, and cost of borrowing over a 5-year period if there is a 1% annual interest rate cap on the loan.