65438+ million 10 years of second-hand housing loans, what is the interest rate and the monthly repayment?

According to the following formula, the result can be obtained:

150000, 10 years (120 months), 6.6555%, monthly payment =-PMT (6.6555%/ 12, 120,/kloc-)

150000, 10 years (120 months), 5.22%, monthly payment =-PMT (5.22%/ 12, 120,10).

3. EXCEL calculation formula of equal principal and interest repayment:

Enter =-PMT(rate/ 12, n, pv) in the cell of EXCEL.

Pmt () is a function to calculate equal principal and interest. Because its value is negative, a negative sign is usually added.

Rate is the annual interest rate, divided by 12 to get the monthly interest rate;

N duration, 20 years * 12=240 periods;

Pv is the loan principal.