Home Loan Eligibility Based On Salary with Calculator - YouTube

Channel: Asset Yogi

[0]
Subscribe to the Asset Yogi channel and press the bell icon
[4]
To watch the latest finance video above all
[7]
Music
[11]
Hello, my name is Mukul and you are welcome to the Asset Yogi
[15]
Where we unlock the knowledge of real estate and finance
[19]
Assume you want to buy a house for yourself
[24]
Then the question that arises here is
[25]
How will you do its financing?
[27]
One way that you have is that
[29]
If you have the full amount in your savings
[32]
Then you can withdraw the money from the investment or savings
[36]
And can invest in the house
[37]
The second way is that you can withdraw some amount from the savings
[42]
And the rest will be paid by the loan
[45]
And the home loan is a very good way to finance
[48]
Because the home loan is cheaper and its interest rates are minimal
[53]
So the maximum amount of loan
[56]
Is dependent on your salary
[60]
But there are many different factors
[62]
On which your home loan eligibility is dependant
[65]
So what is the formula for a home loan eligibility?
[67]
What are the factors on which your loan eligibility is dependent?
[72]
In this video, we will talk about these things in detail
[75]
And along with this, I'll show you a home loan eligibility calculator
[78]
I will give you its demo
[79]
I've put options in the calculator
[82]
You'll know all the things like how much you can take the loan
[86]
How much is the maximum amount you can spend to buy a house?
[88]
How much you'll pay as principal and interest
[91]
Over 20 years, 30 years?
[93]
How much soever you take a loan
[94]
You'll know these things from that
[96]
And in the same series, I will make another video
[99]
And I will talk about how you can increase your home loan eligibility
[104]
We will talk about that also
[106]
In another video
[107]
In this video, we will talk about how eligibility is calculated?
[112]
Let's go straight to my computer screen
[114]
First, we will understand how the home loan eligibility is calculated?
[119]
What is the exact formula for that
[121]
But before that, we will understand a logic
[124]
That what logic does the bank have
[126]
Whenever it calculates home loan eligibility
[128]
So assume that your income is "I", let's say it is 50,000 Rs per month
[137]
Then your home loan eligibility is dependent on this
[140]
So the bank says that
[142]
You will cover 50 % of your expenses with your income
[148]
And with the rest 50%, you can do savings
[152]
Because you will need 50% for your household expenses
[158]
And the 50% that you are saving, you can deposit in your EMI
[162]
So you can pay EMI with a maximum of 50% of your monthly income
[167]
According to that only, your home loan eligibility is calculated
[171]
Now we will its formula
[173]
The formula for a home loan eligibility is
[176]
Your monthly fixed income脳50%
[179]
As I have explained to you that this 50% portion
[183]
You first calculated its 50%
[186]
Out of that if you are paying another EMI
[189]
Assume you have your personal loan, car loan
[192]
Education loan, you are paying EMI for that
[195]
You will subtract that from this
[197]
And then the amount will be divided by per lac EMI
[201]
How is this per lac EMI is calculated?
[205]
Generally, if there is a banker
[207]
Whoever is giving you a home loan
[209]
He has an EMI chart, it looks somewhat like this
[213]
He has that for every year
[216]
For as many years as you want
[217]
He has a chart for per lac EMI
[220]
So that you'll know how much EMI will you get for a loan of Rs 1 lac
[225]
Assuming the interest rate as 10.5%
[229]
So your per lac EMI will be this
[233]
5 years, 10 years, 15 years, 20 years, 25, and 30 years
[235]
I have given you the chart
[238]
This EMI is given in the chart
[241]
But I have made an EMI calculator for this
[245]
It is quite detailed
[247]
I have also made a video about that, you can search it on youtube
[251]
So download the EMI calculator
[254]
You'll know the exact EMI
[256]
For how many years, whatever the loan amount, whatever interest rates
[260]
You can put all these inputs, you can change them also
[264]
You'll know the exact EMI
[265]
you don't need to approach any banker
[268]
So now we will see, we will understand by the example
[271]
That what will be the loan eligibility amount if we take the example of 50000
[276]
So assume your monthly fixed income is 50000 in hand
[281]
And then you will multiply it by 5 %
[285]
After that, assuming you have another EMI of 10000
[291]
Including all the loans
[293]
We will subtract that amount
[294]
And we will divide it by per lac EMI
[297]
The per lac EMI will depend on your loan tenure
[300]
So we will assume that a standard home loan is of 20 years
[304]
Its per lac EMI is 1000 Rs
[306]
At the interest rate of 10.5%
[309]
If we divide it by that, if divide it by 1000
[314]
So the amount that you have is
[316]
You divided 50,000 by 2
[318]
25,000-10,000 (subtraction)
[323]
Divided by 1000
[325]
By our per lac EMI
[328]
So the amount is 15000 divided by 1000
[331]
The amount we get is 15 lac Rs.
[334]
You are eligible for a maximum of 15 lacs
[339]
And you can get a loan for that
[341]
So in this way, you can calculate
[345]
EMI for as many loan tenure as you want
[345]
I am giving you an EMI calculator
[347]
You can calculate your EMI with a calculator I am giving
[350]
for 1 lac Rs
[353]
And you already know your fixed income and you know
[357]
How much EMI is going on,
[360]
So you can easily calculate your loan eligibility by yourself
[363]
And if you don't want to do it by yourself
[366]
Then I'll give you a calculator for that and I'll show you the demo
[369]
You'll get other details in that
[372]
How much you can afford, what is the total amount of house that you can afford?
[378]
How much will you pay for principal and interest?
[381]
We'll get all these things, I will give a demo for that also
[383]
But before that let's understand that what are factors on which loan eligibility is dependent?
[389]
We understood that this is the formula for loan eligibility
[393]
We have to understand the other factors too
[396]
First, we will understand the quantitative factors
[399]
Quantitative factors are those factors that are dependent on financial numbers
[404]
So like your monthly income, as we have seen that loan eligibility is dependent on monthly income
[410]
After that, it is dependent on the loan tenure
[413]
So the per lac EMI is dependent on your loan tenure, you are seeing it or not
[419]
If you take a loan for fewer years, then your EMI will be more
[424]
But if your loan period extends if it is 20 years then your EMI decreases
[429]
Per lac EMI
[431]
If the per EMI decreases, then your loan eligibility amount increases
[434]
Because your denominator will decrease and your loan eligibility amount will increase
[440]
Then the third factor is that it depends on the interest rates
[443]
Like we have taken here 10.5 %
[446]
Assume if your interest rate decreases to 8.5%
[449]
As the current rate of home, loans is 8.5%
[453]
So in that case your per lac EMI assuming for 20 years
[457]
So it will decrease to approx 850 Rs
[461]
So in that case your per lac EMI decreases
[465]
And your loan eligibility amount will increase
[467]
The fourth, as we have seen that if your other EMI is going on
[471]
It also depends on that
[473]
So if your other EMI is going on
[475]
Then your loan eligibility amount will decrease naturally
[479]
And the fifth factor is the loan to value ratio
[482]
Which is not reflected in this formula
[484]
I will explain this to you
[486]
What's happening, in this case, is that
[488]
Your loan amount is also dependent on your property value
[493]
You get the loan at a maximum of 80% on property value
[498]
So assume your property value is 50 lac Rs
[502]
Then 80% of the property value
[504]
Then you'll get a loan for only 40 lac Rs
[507]
The maximum loan can be 40 lacs only
[509]
And you have to do a down payment of the rest 10 lac Rs
[515]
You have to give a down payment amount from your pocket
[519]
We can call this out-of-pocket expense
[522]
We can call it, out-of-pocket investment
[525]
So you have to spend these 10 lac Rs from your pocket
[529]
And you will get a loan for the rest of 40 lac
[532]
So on this too, your loan eligibility depends
[534]
So these were all quantitative factors, which are dependent on numbers
[539]
Now some are qualitative factors
[541]
What is your age, what is your credit history?
[545]
So this risk profile is studied
[548]
So we will see all these qualitative factors too
[551]
So these are all the qualitative factors like the first is a type of property
[556]
So if the property is registrable, then you will get the loan on that very easily
[564]
Like if you have a ready to move property
[567]
That can be registered easily
[568]
Or there is some under-construction property
[571]
You'll get the loan on that easily
[573]
Now under construction property, you can also construct your house by yourself
[578]
You may have booked a flat of some builder
[581]
In that case, you'll get a loan
[583]
But in an under-construction property, the payment is done stage wise
[587]
Whatever the bank, assume your 20% construction is done
[591]
Then it will release only a 20 % amount
[593]
And if its done 50% then they will release 50%
[596]
But they will release 100% in the case of ready to move property
[599]
There is no need of stage by stage payment
[601]
Because you are buying immediately
[603]
Then the bank will release a 10% payment as soon as you register your sale lead
[608]
And the second is the properties
[610]
That cannot be registered
[613]
Assume the property is being sold on general power of attorney
[617]
Then you'll not get the loan on that easily
[620]
And second, assume if you are buying a plot then you don't get the loan on that also
[625]
And the other factors are there, like what is your age
[628]
Assume you are young and you are 25 years old
[632]
So your working age is quite long, so you can get a maximum loan of 30 years
[638]
As you are seeing here, you can take a loan for 30 years
[641]
Then your loan eligibility increases
[644]
Assume if you are 50 years old, then your left working age is 10 years
[650]
60 years is considered to be the retirement age
[653]
So, in that case, you'll get a loan for a maximum of 10 years
[657]
And assume if you get pension after retirement, then the bank can consider it
[663]
So in this case, according to your pension, it can increase your loan eligibility
[668]
Then there is a factor called a credit history
[670]
You may have heard about the cibil score
[674]
Cibil score tells us that how was your transaction and payment history
[679]
Whenever you took EMI or loan
[682]
So you did the payment on time or not
[685]
So this score is out of 800
[688]
If your score is 700 plus then you get a loan very easily
[693]
But if your score goes below 700
[697]
Assume you did default then your cibil score will be ruined
[701]
It may be somewhat less
[702]
So in that case, how can you increase or improve your cibil score?
[706]
What is a cibil score?
[708]
I'll make a detailed video about this too
[711]
Then make sure to watch those videos too
[713]
The loan eligibility is often dependent on your credit history
[716]
If your credit history is too bad, then it is possible that
[720]
The loan will not be sanctioned in the first place. This is also possible
[722]
And another factor is qualifications, assume you have done some professional degrees
[727]
Assume you are B.Tech, MBA, CA, Doctor
[733]
Then it also depends on that
[735]
You may get offered better interest rates
[737]
And your loan can be sanctioned quite easily
[741]
How's your work experience? What are your growth prospects?
[744]
Loan eligibility depends on that
[747]
Then how is your professional stability
[750]
As I said assume you are professional, you are CA or doctor
[756]
Or you are an architect or you are working in a software industry
[759]
Then your stability is considered good
[761]
But some sectors are considered to be unstable
[765]
Where the jobs are lost easily, the attrition rate is high
[770]
For example, the BPO industry, according to banks, is considered unstable
[777]
The loan doesn't get approved easily
[779]
Then how is your employer category?
[782]
How big is your company is?
[784]
How stable is that?
[786]
They are kept in A, B, and C categories
[789]
So the employers of A categories, the big companies
[793]
They get offered the better interest rates
[796]
And they get loans very easily
[799]
So better interest rates mean the employees will get lower interest rates
[804]
Your family background is also checked
[807]
Assume you are working in the BPO industry
[811]
But your family background is quite good
[813]
Your family have professionals
[817]
Your family owns various assets
[820]
These things will be checked
[821]
And the other factor is how is your expense pattern?
[825]
Assume as I have said in the example
[828]
That your salary is 50,000 Rs
[829]
And you have only two dependents
[832]
Assume one is your wife and the other one is your child
[836]
So fewer people are dependent on you
[838]
And your salary is good
[839]
So your loan will be approved easily
[842]
And your loan will be sanctioned on full eligibility amount
[847]
But assume if your salary is only 20000
[851]
And 4 people are dependent on you
[853]
So, in that case, you need a little more money to meet your expenses
[859]
It may be possible if we talk about the 50% then
[863]
10000 may not work for you
[865]
So in that case, the bank can decrease your eligibility
[869]
So the bank will consider the EMI of 8000 instead of 10000
[873]
And maybe for 20 years, the loan of only 8 lacs get approved
[877]
So I have told you about how the home loan eligibility is calculated
[882]
On what factors it is dependent?
[884]
We have seen quantitative factors and qualitative factors
[887]
Now I'll show you a calculator
[890]
Which I have made myself
[891]
It will tell you the exact amount
[893]
For how much loan are you eligible for?
[896]
And with that, it will also tell you the amount you can buy the house with
[901]
And how much will you pay for principal and interest on your loan?
[904]
So let's see the demo of that loan eligibility calculator
[907]
So this is the home loan eligibility calculator
[910]
About which I've talked about
[912]
So here I'll show you the demo
[914]
What are all input and output values
[917]
The one's which are marked with the yellow color is input values
[921]
You can change them
[922]
And the rest are output values, that you cannot change
[925]
They are locked
[926]
These are the input values, I have put the same values as an example
[931]
That we've talked about
[932]
Assume your income is 50000 and your loan tenure is 20 years
[938]
The interest rate is 10.5 % per annum
[940]
And the rest of the EMI is 10000
[944]
So you can see that it is giving you all the outputs
[947]
The maximum eligibility of loan amount is 15 lacs
[951]
You can see it in green color
[953]
You can pay EMI of a maximum of 15000 for a home loan
[958]
And along with that, it is also showing you in blue color
[960]
The maximum amount with which you can buy the house
[963]
So for example, in this case, you can buy a house of approx 18,50,000 Rs
[968]
Our of which you have to arrange 3.5 lacs by yourself
[971]
And you'll get a loan for 15 lac Rs
[974]
With that, it also tells you the principle and interest amount
[978]
You have to pay a total interest of 21 lac Rs in 20 years
[983]
And you have to pay 15 lacs as the principle
[986]
So you can also see that you are paying approx 58% interest
[991]
So your interest amount is quite high in this case
[994]
If you want to decrease your interest amount then you can play around here
[1000]
If you do it for 10 years, if you can pay early
[1004]
So you'll see that interest amount decreases suddenly
[1007]
In 10 years, the interest amount is 7 lacs
[1010]
From 21 lacs to 7 lacs, it means that you are saving straight 14 lacs
[1016]
But your EMI is 15000, so this is happening
[1020]
Your loan amount eligibility decreased,
[1023]
Then you can take a maximum loan of 11 lacs Rs only according to your salary
[1028]
So you can see that how much amount of loan you want to take
[1032]
Assume you want to take a small property and it will come for 14 lacs only
[1037]
Then you will save very much in interest
[1039]
You can see in this way
[1041]
and assume you want to purchase big property
[1044]
So in that case, if you can decrease the rest of the EMI
[1048]
Then try and see by putting 0 amount here
[1051]
How much are you eligible for?
[1053]
In this case, you can see that your loan amount has increased
[1056]
Your loan eligibility is 18.5 lacs
[1059]
Because you can pay 25000 Rs as EMI of home loan
[1064]
And your budget for the house has also increased
[1067]
You can buy a house of 23 lacs in this case
[1070]
So you can change all these values
[1071]
According to your salary,
[1073]
You can calculate
[1074]
Maximum how much loan can you take?
[1076]
How much can you afford for a house?
[1079]
You'll get to know every thing with this
[1081]
So in this video, we saw how to calculate home loan eligibility
[1085]
On what factor it is dependent?
[1087]
And with this calculator, in what ways you can put your inputs and calculate your maximum eligibility
[1094]
How much will be your EMI?
[1096]
How much maximum can you spend on a house?
[1099]
With this, I'll also make one more video
[1101]
After this video
[1102]
In which we will talk about
[1104]
How can you increase your home loan eligibility?
[1107]
In that, I'll give you some tips
[1109]
That how can you change your pattern
[1113]
You can change your income
[1115]
You can change your loan tenure
[1117]
What are ways in which you can increase your home loan eligibility?
[1121]
We will talk about these things in detail
[1123]
So please make sure to watch my next video
[1125]
So that's all in this video
[1128]
If you want to suggest the topic related to finance and investment
[1131]
Then comment it below
[1133]
And if you like the video
[1135]
Then don't forget to like and share this video
[1137]
Subscribe to the channel and press the bell icon
[1140]
So that you'll get the notification of my latest video
[1143]
We'll meet in the next video
[1145]
Till then keep learning, keep earning
[1147]
And be happy as always