Recently, I was looking at a house with my family. I had a basic need, but I wanted to buy ones with more convenient transportation and larger areas. However, I was not very affordable, but I was not young anymore and I was also considering having a child. After locking in the large area, I looked at the new and second-hand properties around me and picked out several of the houses I liked in the community, each with its advantages and disadvantages, and it was also very entangled. Since the mortgage calculator on the market currently does not have a comparison function, an excle form was made for this, comparing the results of different prices, down payment ratios and repayment methods, making it easier to choose. I would like to share with you here, hoping it will be helpful to those in need.
Baidu network disk link: https://pan.baidu.com/s/1HjBiEGejaUsJxOGCcnB6rQ?pwd=1111
Extraction code: 1111
Description: There are two payment methods for mortgage loans - equal principal and interest and equal principal. equal principal and interest : [Loan principal × monthly interest rate × (1 + monthly interest rate) ＾ repayment months ５ ÷ [(1 + monthly interest rate) ＾ repayment months －1 ５. equal principal : monthly repayment amount = (loan principal / repayment months) + (principal — cumulative amount of principal returned) × monthly interest rate where the ＾ symbol indicates the multiplier. 2 months is the power of 2. Here I am using equal principal and interest. The formula converted to excle is:
monthly payment = (Q3/12*(1+Q3/12)^P3)/((1+Q3/12)^P3-1)*M3*10000
(Q3 represents the annual interest rate, P3 represents how many months of installment, M3 represents how much loan amount is 10,000)
The red background column of the table winning bid is all adjusted according to the actual situation. Finally, based on the monthly income of the family, minus monthly payment, temporary rent, basic living expenses and other expenses, see if the income can cover the expenditure.
