1. As shown in the figure below, the conditions give the total loan amount, annual loan interest rate and loan term. It is required to calculate the monthly repayment amount according to the conditions, and the result is displayed in cell B5.

2. Select cell B5 with the mouse, enter "=" in the cell, and then click the Insert Function button.

3. The Insert Function dialog box pops up, select PMT function in Select Function, and then click OK.

4. The function parameter dialog box pops up, and enter "B2/ 12" after the first parameter. Here, cell B2 gives the calculation formulas of annual interest rate and monthly interest rate.

5. Select the cell B3 after the second parameter, which indicates the loan term, and the term is in months.

6. Select the cell B 1 after the third parameter "PV", that is, the current total loan amount is "100000". After all the parameters are designed, click OK.

7. Going back to the worksheet, we can see that the monthly repayment amount is calculated.