1. Open the excel form and fill in the loan amount: A 1: B3.

2. Then fill in the position of F 1: J37 1-36.

3. Fill in the formula =PPMT($B$2, [@ number of periods], $B$3, $B$ 1) in G3 cell.

4. Display the principal amount of each repayment.

5. Fill in the formula =IPMT($B$2, [@ number of periods], $B$3, $B$ 1) in the H2 cell.

6. Show the repayment interest of each installment.

7. Fill in the formula = [@ principal]+[@ interest] in the I2 cell.

8. Fill in the formula =550000+[@ Principal] in the J2 cell. It's done.