Take the first day of construction to talk about the big money of 10 yuan: Calculate mortgage
It can be said that mortgage loan is the first step in our life towards common prosperity .
Because, this is one of the few opportunities for most ordinary people to add to leverage in life.
Many people don’t know what leverage means, but by buying a house, I took this vivid lesson, so most people will find that the more people around you buy a house, the more addicted it.
1.
. Behind the loan to buy a house, the wealth leverage effect is played:
If there is no loan leverage, the buyer will directly use cash to buy a house worth 1 million yuan, and the house price will rise by 200,000 yuan a year. His return on investment is 20%.
. Using the leverage effect of loans, it is still a house worth 1 million yuan. The buyer only paid a down payment of 100,000 yuan, while the house price still rose by 200,000 yuan.
The yield of after leverage is significantly higher:
.2 million yuan minus the 900,000 yuan you need to pay multiplied by 5% interest rate , which is equivalent to making 155,000 yuan. The profit of
is divided by the principal paid by 100,000 yuan, then his return on investment actually becomes 155%, far higher than the 20% yield obtained by not buying a house with a loan.
So, this is the taste of early home buyers becoming richer the more they buy.
2.
10 years ago when I bought a house, people basically didn’t look at the contract and didn’t know how to calculate the mortgage. Basically, they just listened to the numbers calculated by salesmen.
For example, how much is the down payment, how much is the monthly payment,
Then I can pay the monthly payment, and I can make up the down payment, but if I really can't borrow it, I will buy it.
However, the wealth effect of houses is no longer what they were like 10 years ago. Last month, I looked at the Baidu index and found that tens of thousands of people were calculated by searching for mortgage loans every day.
How is the mortgage calculated?
3,
If it is said that Li Si bought a house and the mortgage loan was 1 million, that's right, this little article today has to go with this number.
uses commercial loans, the mortgage interest rate is 4.9%
has a loan period of 30 years, and it uses equal principal and interest to repay.
Come and count it. It should not be correct. How much does it pay back every month?
Step 1
Open excel, enter the following information in the table:
Step 2
In cell B5 (yes, it's the red icon on the top) Enter the formula:
=PMT (B2, B3, B4)
Monthly mortgage repayment =PMT (interest rate, period, loan amount)
=5307
In other words, Li Si needs to repay 5307 yuan per month.
I studied it carefully and found that it is not difficult. You can buy a suite and practice this formula!
