Can you pls show formulas to solve this in excell?

Thank you

The Textbook BF, Chapter 5, Problem 8, Page 149. A lender offers a 30-year, 51150900 adjustable rate mortgage. The initial rate is 3.5%, the margin =296, the interest rate cap = 1% annually and 3% lifetime. Negative amortization is allowed if interest rate caps reached. The discount point is 2%. The index rate is based on one-year treasuries. The index rates will be 3%, 8.5%, 9.5% and 11% for the next 4 years. Compute the payments, loan balances, and the yield for the ARM. Loan amount Amortization lnitital rate The margin Index Nominial Capped Interest Payment @ Balance Interest Rate Rate Period capped rate Ending Balance 3.50% 3.50% 933.50 5 - 9.00% 8.50% 348 5 - 3 3 10.50% 9.50% 336' #WALCIR! 3 3 11.50% 10.50% 324' #WALCIR! 3 13.00% 10.50% 312' #WALCIR! 3 Monthly rate [based on monthly cash flows]: ? Annualized mortgage rate: 7 The cash flowI pattern Month 3 1 593 3.50 2 593 3.50 3 593 3.50 4 593 3.50 5 593 3.50 6 593 3.50 3 593 3.50 B 593 3.50 9 593 3.50 10 593 3.50 11 593 3.50 12 593 3.50 13 $0.00 14 $0.00 15 $0.00 16 $0.00 13 $0.00 13 $0.00 19 $0.00