First of all, we need to calculate three assumptions under two interest rates: there are 12 months, 360 periods per year. Use PMT function in Excel to get monthly repayment:

-When the interest rate is 4.8%, the monthly repayment amount is PMT (4.8%/12,360,600,000) ≈ 3,224.78 yuan;

-When the interest rate is 3.8%, the monthly repayment amount is PMT (3.8%/12,360,600,000) ≈ 2,785.32 yuan.

Then, calculate the total repayment amount under two interest rates:

-The interest rate is 3224.78 yuan/month x360 periods = 1. 160, 12 1.07 yuan;

-When the interest rate is 3.8%, the total repayment amount is x360 installments = 1, 003,965,438+07.98 yuan.

Interest on price difference:

-When the interest rates are 4.8% and 3.8%, the interest difference is 1. 160,121.917.98 yuan = 15.

Therefore, the interest rate of 600,000 mortgages within 30 years will be 4. Yes 156203.09 yuan.

Second, how much will this 600,000 mortgage be repaid every month after 30 years?

Buying a house can be said to be a major event in life. For young people, the pressure of buying a house is still great. When buying a house, because of the down payment and later renovation costs, these are very much in need of money. Many people will ask, how much is a monthly mortgage of 600,000 for 30 years? Let's take a look at Bian Xiao.

How much is the 600,000 mortgage for 30 years per month?

1. Equal principal and interest repayment method: the total loan amount is 600,000.00 yuan, the repayment period is 30 years, the monthly repayment amount is 3,369.18 yuan, the total interest paid is 665,438+02,906.55438+0 yuan, and the total principal and interest is 65,438+02.

2. Repayment method in average capital: the total loan amount is 600,000.00 yuan, the repayment period is 30 years, the repayment amount in the first month is 4,366.67 yuan, the monthly decrease amount is 7.50 yuan, the total interest paid is 487,350.00 yuan, and the total principal and interest is 65,438+0,087,350.00 yuan.

What is a mortgage loan?

A mortgage is a mortgage on a house. Mortgage is a legal document submitted by the buyer to the lending bank by filling in the Application for Housing Mortgage Loan, providing legal documents such as ID card, income certificate, housing sales contract, guarantee and other designated materials.

Classification of mortgage

1, housing loans and individual housing loans refer to ordinary housing loans issued by lending banks to borrowers. There are three kinds of personal housing loans: entrusted loans, self-operated loans and portfolio loans.

2, entrusted loans, refers to the loan bank entrusted by the housing provident fund management department, with the lender's housing provident fund deposits as the source of funds, in accordance with the provisions of the individual to buy ordinary housing loans.

3. Self-operated loans are loans provided by individuals with bank credit funds as the source.

4. Portfolio loans refer to ordinary housing loans issued to borrowers with the applicant's housing provident fund deposits and bank credit funds. This kind of loan is a combination of personal housing entrusted loan and self-operated loan.

At the end of the article, I wrote: How much will this 600,000 mortgage be repaid every month after 30 years? Matching principal and interest repayment method: the total loan amount is 600,000.00 yuan, the repayment period is 360 months, the monthly repayment amount is 3,369.18 yuan, the total interest paid is 665,438+02906.51yuan, and the total principal and interest amount is12/kloc-. Average capital repayment method: the total loan is 600,000.00 yuan, the repayment period is 360 months, the first month repayment is 4,366.67 yuan, with a monthly decrease of 7.50 yuan, the total interest paid is 487,350.00 yuan, and the total principal and interest is 65,438+0,087,350.00 yuan.

3. The monthly payment is 600,000 yuan, and the annual interest rate is 4.25%. How much is it for 30 years?

Annual interest of 600,000? 4.25% = 25,500 yuan, minute 12 months, monthly payment 2 125 yuan. If the monthly salary is 5000, then if you deduct 2 125 and 2875, you can still live. In 30 years, * * * paid the bank1530,000 yuan, deducting 600,000 yuan, and * * * paid the bank 930,000 yuan in interest, so the bank made a lot of money, and the high salary of bank staff was easy to understand.

4. The mortgage is 600,000 yuan. How much is the monthly payment for 30 years?

The interest rate is 6.55, and the monthly repayment is 38 12 yuan.