The provident fund loan is 70 18, and the monthly payment is 4000. What are your interests?

You can use the excel function RATE to calculate:

Annual interest rate = interest rate (18 * 12,-4000,700000,0,0) *12.

=2.42%

So low? It seems unlikely.

Attached:

Repayment method: equal principal and interest method

Total loan: 700,000 yuan

Loan term: 18 years

Loan interest rate: 2.42%

Monthly repayment: 4,000.87 yuan

Total principal and interest: 86,465,438+088.30 yuan.

Total interest: 164 188.30 yuan.