Kindly slove the attached question

Kindly explain your answer using text/excel not screenshot/images

2. (50 points) John intends to get a loan in the Bank Alpha worth 200,000.00. The annual nominal rate is 6,0% with monthly compounding. The term of this loan is 25 years and is payable with monthly constant payments (principal and interest) at end of each month. a) Compute the value of each payment. b) Compute the first two lines of the following amortization table: Period Debt at beginning of the period Interest Payment Amortization Accumulative Amortization Debt at end of the period 2 c) At the end of the first year of the contract, the monthly effective rate changes to 0.55%. Compute the present value of the future/remaining payments (at the end of the first year)