The monthly repayment will be 1270.72 yuan if it is not floating, and 13 14. 19 yuan if it is floating by 5%, which will be 43.47 yuan more each month, which will be about 15600 yuan for more than 30 years.

In fact, the monthly repayment amount of the loan can be calculated by the PMT function in excel, and the corresponding usage of the PMT function formula in excel is as follows: =PMT (loan annual interest rate/12, service life * 12, payment amount, 1).

Note: Because the loan interest rate given by the bank is annualized, the so-called annualized interest rate is to convert the actual interest rate for a certain period of time into one year's interest rate, and the bank calculates the interest by double calculation on a monthly basis, so the loan interest rate in the above function needs to be divided by 12, and because the loan is usually repaid once a month, the number of years in the function * 12 means that you need to repay.