Current location - Loan Platform Complete Network - Bank loan - 10.4 million stores, 600,000 down payment, 800,000 loan, and pay off the extra money every month for 20 years. How much interest should I exchange? Which bank is more suitable?
10.4 million stores, 600,000 down payment, 800,000 loan, and pay off the extra money every month for 20 years. How much interest should I exchange? Which bank is more suitable?
Now the loan interest rate is 7.05%

You can use the financial function of excel to calculate:

=PMT(7.05%/ 12,20* 12,800000,0,0)=-6226.42

6226.42 yuan per month,

Total principal and interest: 6226.42 * 20 *12 =1494341.83.

Total interest: =1494341.83-800000 = 694341.83.

Any bank is similar.