1. Open the Excel table, select a column at will, and write down the annual interest rate, loan term, loan amount and related values respectively. For example, a bank loan of 200,000 yuan for five years with an annual interest rate of 6.25%. How much do you need to pay back from the bank every month?

2. Step 2 "Insert"-"Function" in any cell, find the PMT function (as shown) and confirm. (PMT: Calculate the equal installment repayment amount of the loan at a fixed interest rate. )