Please show excel calculations

A basic ARM is made for $213,000 at an initial interest rate of 6 percent for 30 years with an annual reset date The borrower believes that the interest rate at the beginning of year (BOY)2 will increase to 7 percent. Required: a. Assuming that a fully amortizing loan is made, what will the monthly payments be duting year 17 b. Based on (a) what will the loan balance be at the end of year (EOY) 1? c. Given that the interest rate is expected to be 7 percent at the beginning of year 2 . what will the monthly payments be during year 2 ? d. What will be the loan balance at the EOY 2 ? e. What would be the monthly payments in year 1 if they are to be interest only? Complete this question by entering your answers in the tabs below. Assuming that a fully amortizing Ioan is made, what will the monthly payments be during year 17 (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Based on (a) what will the loan balance be at the end of year (EOY) 1? (Da not round intermediate calculations. Round your final answer to the nearest dollar amount.) Given that the interest rate is expected to be 7 percent at the beginning of year 2 , what will the monthly payments be during year 2? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) What will be the loan balance at the EOY 2 ? (Do not round intermediate calculations. Round your final answers to the nearent dollar amount.) What would be the monthly payments in year 1 if they are to be interest only? (Do not round intermediate calculations. Roun our final answer to 2 decimal places.)