No doubt! This is the best video on UA-cam for Home loan pre payment savings calculation. The presentor provided a crystal clear knowledge, no much fuss or mess while providing details. Comprehensive Knowledge gained after watching this video.
This is some real quality content bro. However I want you to consider one thing.There are some fixed deposits that provide greater interest rate than housing loan interest rate (e.g.shriram city union finance). Moreover, housing loan is calculated by reducing balance method while fixed deposit interest is calculated by cumulative method. This means that 1 lakh invested for 3 years will earn around 7.95% with shriram that gives you almost 1.23 lakh at the end of 3 years which is a good option if you compare with loan prepayment
Thanks for your comment. Yes you are right, some fixed deposits can give higher returns compared to home loan interest rate and those fixed deposits can be considered too. But in case of variable home loan interest rate, the rates might increase in future and accordingly we have to decide whether to prepay first or invest the amount. It depends on case to case. Thanks for your lovely comment🙂👍
What if shriram. Goes bankrupt so does your fd as well i am not tellin it will go and all just giving perspective that it is better to do waht is in our control
Gupta ji your Video is very informative and your channel deserve for Subscribed, one little query is there if someone get a home loan amount 10 Lakh for 10 years from sbi bank on floating rate of interest, can individual pay 1 lakh extra as prepayment continuously for first five year, and is the tenure of loan can be reduced by doing this
Thank you sir. Yes prepayment can be done and tenure can be reduced by keeping EMI same Watch this video to know more information with examples ua-cam.com/video/vOrDMefUrDc/v-deo.html Hope this helps
No fixed rate costly hoga flexi achha rhta hai Rbl repo rate se link hona chahiye abhi market rate 6.9 hai aapka bhi hona chahiye nhi hai to balance transfer krwaye
Very informative Sir. Few basic questions :- 1. In the last months while doing prepayments, it was showing negative principal and interest. What does it mean ? 2. How does prepayment impact our tenure ? As an example, lets consider 2 cases in the above example :- Case#1 :- We are doing prepayment of 1 lakh Case#2 :- We are doing prepayment of 1.1 lakh, What's the difference in tenure in both the cases if EMI is same ? This is because bank generally talks about EMIs in terms of remaining months/tenure and if remaining months are same in both the cases whether we repay 1 lakh or 1.1 lakh, where exactly we are getting the benefit ?
Best video bro ...isse ache trike se koi bi home loan ke doubt clear nhi kr skta... But 1 doubt h ..agr prepayments na krke EMI ki jyada kr di jaae to usse ky fayda or ky nuksan hoga
Ha EMI increase kar sakte hai jisse tenure Kam hoga aur interest save hoga. 1 disadvantage ye ho sakta hai ki EMI afford hona chahiye. EMI afford kar sakte hai every month to increase karna acha hoga
Very nice explaination sir. My question is if I want to reduce the Emi value by doing any pre payment. What is the process for that. If I understand correctly that if I prepay in the earlier days and keep the emi same, then the tenure decreases. But if I want to reduce the emi value, then what is the process?
Same process. After prepayment you have tell bank to reduce EMI and they'll recalculate EMI for you. To know how reduced EMI is calculated watch this video ua-cam.com/video/vOrDMefUrDc/v-deo.html
I have a query on home loan. My loan AMT is fully disbursement now. In between I have opted for conversion twice to reduce interest rate from 9 to 6.9. my query is if it is wise to increase EMI. As per many suggestions, emi can be increased which will reduce tenure drastically. But the interest component will also increase accordingly, which is what the bank may want as they wan us to pay max money initially. Or is it wise to not increase the EMI but accumulate money and do part payment so it will reduce tenure to a huge extent. Or should I do both. Which is beneficial. Your suggestion pls.
You have commented on 4 of my videos and got my attention successfully 🙂 Anyway. Yes, increasing EMI will help you reduce the tenure drastically and also total interest will be reduced. It's not true that interest increases with increase in EMI, the total interest actually decreases with the increase in EMI. Secondly, doing Prepayments will again help you to reduce overall interest and tenure as well since it reduces your total outstanding balance on loan. So doing both is the best option here. But little bit of caution here. Don't use your entire funds in increasing EMI and doing prepayments, keep some funds for your basic needs as well. So plan accordingly to set the EMI, the amount you can afford every month to pay EMI and once you have some additional funds, do regular prepayments. Use my excel calculators to plan accordingly. I hope this will be useful. Let me know if anything else is required. All the best 👍 I'll paste this on all of your other comments so people find it useful 🙂
@@fincalc Thanks a lot. But just a confusion that on increasing EMI. assuming my emi is 20k per month. If I increase to 30k the additional 10k will also have principal plus interest right? So I'm paying additional interest in 10k rupees. If I just do prepayment will it have less benefits than prepayment plus EMI increase.
@@infinitex2252 yes you are right. Increase in EMI will increase principal and interest amounts "on monthly basis". You can do one thing to understand more: 1. For 20k EMI, check the interest amounts and add all interest amount of all months throughout the tenure. You'll get sum of interest for 20k emi 2. Next, for 30k EMI, add interest of all amounts throughout the tenure you'll be paying 3. Now compare total interest amounts of 20k EMI with 30k EMI 4. Notice, 30k EMI months (tenure) will be less compared to 20k EMI tenure You'll find total interest you'll pay with 30k EMI will be less, which is what we want - to pay less interest "overall" right? Your confusion is - you are comparing interest amount of single month for both EMI. Instead you should check the total interest you'll be paying throughout the tenure after comparing both amounts of EMI. In this way, higher the EMI you pay, less interest you have to pay. But as I said, plan accordingly. Doing only prepayments will also work in the great way as you must have seen in my videos. Hope this helps.
Thanks Vishal. Yes you can claim up to Rs. 2 lacs in a FY under section 24 and use home loan interest paid by you to reduce income tax. Watch this video to know more options to reduce income tax: ua-cam.com/video/2meRM9A4aT4/v-deo.html
Agar hum prepayment karte hai 6date ko toh jo hum principal amount bharte hai uska interest bank ne 6date se hi kam karna chaiye na but bank use reschedule ke naam par 2 din extra laga rahi hai har waqt toh iska complaint rbi main kaise kare ispar koi video banaiye pls.
hi jo bhi monthly emi hoga use jayada bhar rahe ho to kse interest calculate hoga? for exmple:17k hai uski jagah pe 19k bhar rahe ho to kse interest calculate hoga?
Gupta ji Maine home loan mai half amunt prepayment kar diya hai or mujhe ab apne EMI amount ko kam karna hai uske liye ek request letter format chaiye tha
Meri pnb ka lon chal raha he us me ripamnet jama karna hai lekin Bank wala 2 opsan de raha he ek to emi kam karne ka or dusra lon ke parincpal amaunt jama karwau to konsa best rahega mere liye
Home loan and Housing loan ,ye dono hi alag loan hae or mae home loan le rakhi hoon to kya mae ITR mae iska borrowing capital principle, Interest on EMI ka profit le sakti hoon ( ya ITR 2021 mae show kara sakti hoon ) . Please reply 🙏🙏
If we do prepayment,then our tenure will automatically gets reduced,right? Means depending on tenure and remaining principal amount , further intrest gets calculated?
Bhai pre payment ka mtlb EMI Ane se pehle he paisa dal dena hota hai kya aur agar pehle se paisa dal rahe hai to kya EMI se jada he dalne se faida hota hai ya fir jitne EMI arahe utna bhe dalne se faida hoga plz bro bataiye
But starting Mai interest amount high hoti hai aur principal kam hoti hai right ?? Mere interest amount high hai aur price bohot Kam hai like aprrox 18 k interest and 6-7 k for principal
Taking longer tenure like 15 years then prepaying it is more beneficial or short tenure like 10 years then prepaying will be more beneficial. As it is in my mind to prepay my loan earlier so i was thinking to take 10 years tenure but people are suggesting that I take longer tenure like 15 years then prepaying it will be more beneficial.. is this thing is right.? please suggest
Longer tenure will obviously make you pay more interest. So here 10 years will be more beneficial provided you can pay the emi as it will be slightly more compared to 15 years tenure And prepaying with 10 years tenure will help you close your loan faster compared to 15 years tenure
Very Nicely explained can u pls share the excel file with formula. I have prepared one excel file with formulae shown by you but when i entered Prepayment as Rs. 1,00,000 last four months values are showing in Negative. I wanted on updated interest and Total Savings
Ek doubt hai sir.... Agar initial statges pai extra principal repayment capacity hoti to log loan ka tennure hi kam lete, so by default intetest saving hota... Intital stag mai logo ka salary paisa down payment, stamp duty, furniture etc kharcha hota hai... Isliye initial stage pai jadha ka principal repayment possible nahi hota
Thanks. You can transfer from foreign account to Indian Bank account from which emi is getting deducted every month. From this account you can pay the loan amount
Hello, if we deduct prepay additional amount. EMI getting change and getting reduced. If I want to keep same emi it's not showing in Excel. Please explain
please download latest excel from here: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/ let me know in case of any queries. If EMI need to be same than you can set that number in EMI column
Sir plz tell me i can pay emi upto 25000 monthly of 2000000 interest rate 8.6 toh kya mujhe ye loan 15year ke liye lekr 19000 around pay krke repayment krna chahiye ya 10 years k liye 25000 par karna chahiye plz suggest
Sir mera home loan 3rd step pe hai.. last 4 months se.. total 23 months hogye hai loan lete.. Ab agar mai prepayment krna start karu to kya subsidy reject ho sakti hai? Mai subsidy ka wait kr rha hu.. otherwise mai thoda thoda prepay start kar sakta hu.. Mujhe pta hai ki eksath nai krna hai aor minimum 3 to 6 lacks to rahene hi dena hai loan amount. Thanks in advance..
Sir, thank you for well explained. I've two doubts, 1st interest amount kum hone par bhi EMI amount kyun same reh raha hai last month of loan repayment, agar aaisa hai to hum kaise savings kar sakte hai & 2. Loan tenure kum karne k kya options hai ? Please advise
our EMI consists of both principal and interest amount. Interest amount is high initially and decreases with time, whereas it is opposite with principal amount. Use excel calculator from here: fincalc-blog.in/home-loan-prepayment-calculation-reduce-emi-or-tenure/
sir, I am haryana government employee, I have taken home loan from pnb bank,I want to know that what was the homeloan interest that time and interest rate will remain same which was that time or it will be calculate according to current interest rate.
Hello sir, Wanted to know which loan to pay first? House loan on my parents name with 9 years remaining or education loan with 5 years remaining if I have Lump sum amount and interest on both are the same.
Paying 9 years loan first is better, since tenure is long.. longer the tenure, more interest amount you'll keep paying, so consider paying 9 years loan provided rates are same on both loans
@@fincalc wow sir, thanks.♥️♥️ U r one of my favourite UA-cam channel. Hamesha kamal k topics pah video laate ho aap joh ki practical life ar *businessman* /salaried person k lya superb useful h. Ar sabse badi baat h ki aap ak topic ko bana k bhul nahi jaate ho bal ki usi topic ko alag alag scenario mah batate ho ar update bhi krte ho ush topic ko in future.♥️♥️♥️♥️♥️
Can you help me with a sheet for a loam amount of 60lakhs for 20 years. Also, as you mentioned, to prepay in the initial stages. Can you specifically let me know, how early I should do it?
prepayment should be done consistently as soon as possible and affordable. For calculations, you can download excel sheet from here: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/
Sir home loan liya tab intrest rate 7% something tha but ab 8.45% hai iske karan emi में से intrest ज्यादा cut रहा hai ,sbi bich me bina sochna diye intrest badha सकती hai kya? Hum kya kar sakte hai
Sir please suggest- I have joined in ltd co since 1/4/2021 & no any salary income from march 2020(credit in April 2021) so how many months salary will be counted in itr for FY 2021-2022 either 11 month or 13 month
Calculator link: fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
MORE VIDEOS:
SIP Excel Calculator: ua-cam.com/video/9xkS7ts4Kvc/v-deo.html
Income Tax Calculator: ua-cam.com/video/mw-erFuYboM/v-deo.html
20 Years SIP Calculator: ua-cam.com/video/088S2Zk7sYU/v-deo.html
Loan EMI Calculator: ua-cam.com/video/FSbYoHAULh0/v-deo.html
PPF Excel Calculator: ua-cam.com/video/ZNfX0rQkbPI/v-deo.html
FREE Android App: play.google.com/store/apps/details?id=com.rrr.apps.financialcalculator
Telegram: t.me/fincalc_tv
LIKE || SHARE || SUBSCRIBE
hi plz help me.....are u frm mumbai coz i want tl take a loan and need help
416
Nice video sir
Download link is not working 🤩
@@tryvary1125 it's working check this from here you can download fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/
No doubt! This is the best video on UA-cam for Home loan pre payment savings calculation. The presentor provided a crystal clear knowledge, no much fuss or mess while providing details. Comprehensive Knowledge gained after watching this video.
Thanks a lot for such a detailed comment and appreciation. Such comments motivates me to make more such videos for you all :) Stay Tuned
Yes very easy to understand..
Appreciable efforts🔥🔥🔥👍👍👍
Awesome bhaiyya
@@fincalcBuddy just update the formula if interest is less
@@Anesh121 thanks
best samjhaya bhai ne atleast koi sip aur investments ka gyan nhi dia sabse best tarika 👍🏻
Clean and clear information. Thank you so much bro.
Welcome and thanks for your comment 👍🙂
This is the best video on UA-cam for Home loan pre payment savings calculation.
This is some real quality content bro. However I want you to consider one thing.There are some fixed deposits that provide greater interest rate than housing loan interest rate (e.g.shriram city union finance). Moreover, housing loan is calculated by reducing balance method while fixed deposit interest is calculated by cumulative method. This means that 1 lakh invested for 3 years will earn around 7.95% with shriram that gives you almost 1.23 lakh at the end of 3 years which is a good option if you compare with loan prepayment
Thanks for your comment. Yes you are right, some fixed deposits can give higher returns compared to home loan interest rate and those fixed deposits can be considered too. But in case of variable home loan interest rate, the rates might increase in future and accordingly we have to decide whether to prepay first or invest the amount.
It depends on case to case. Thanks for your lovely comment🙂👍
What if shriram. Goes bankrupt so does your fd as well i am not tellin it will go and all just giving perspective that it is better to do waht is in our control
That's not a bank.
Consider Tax on FD interest also .
Please contact number sir
Bahut hi shandar presentation sir,
Kahi home loan wale naaraj na ho jaye aapse😂😂😂
Thank you. Sahi Kaha Aapne 😂😂
Gupta ji your Video is very informative and your channel deserve for Subscribed, one little query is there if someone get a home loan amount 10 Lakh for 10 years from sbi bank on floating rate of interest, can individual pay 1 lakh extra as prepayment continuously for first five year, and is the tenure of loan can be reduced by doing this
Thank you sir. Yes prepayment can be done and tenure can be reduced by keeping EMI same
Watch this video to know more information with examples
ua-cam.com/video/vOrDMefUrDc/v-deo.html
Hope this helps
Bahut hi badiya video hai badi hi acchi Tarah explain Kiya Hai aapne aur bahut aasani se samajh me aa gaya.... Dhanyavad
Thank you
Excellent presentation, clear and precise 👌
thanks
aap bahut jaldi jaldi speech dete hai, jo samjh se bahar hai, step wise dhire dhire bataiye jiska labh aam janta Utah sake thanks
Sir ye floating rate aur fixed rate of interest me same hoga kya?
No fixed rate costly hoga flexi achha rhta hai Rbl repo rate se link hona chahiye abhi market rate 6.9 hai aapka bhi hona chahiye nhi hai to balance transfer krwaye
thoda different hota hai dono rates me. Ye video dekho isme mene saari queries solve ki hai. Link: ua-cam.com/video/vOrDMefUrDc/v-deo.html
@@Dhanjee_pandey999 processing fees bhi dubara pay karni hoti hai
Very informative Sir.
Few basic questions :-
1. In the last months while doing prepayments, it was showing negative principal and interest. What does it mean ?
2. How does prepayment impact our tenure ? As an example, lets consider 2 cases in the above example :-
Case#1 :- We are doing prepayment of 1 lakh
Case#2 :- We are doing prepayment of 1.1 lakh,
What's the difference in tenure in both the cases if EMI is same ? This is because bank generally talks about EMIs in terms of remaining months/tenure and if remaining months are same in both the cases whether we repay 1 lakh or 1.1 lakh, where exactly we are getting the benefit ?
Having the same query
Upon prepayment, what should we do?
Should we reduce loan term or should we reduce EMI?
Reduce loan term. Keep EMI same.
Because reduction in EMI will again take more interest amount from you which will cancel the benefit of prepayment
@@fincalc it may not completely cancel the benefit of prepayment, if I choose to reduce monthly EMI amount ?
This video deserve Likes. Great content. Far better than any reel Videos. This adds value 👍🏻
Thanks for your lovely comment 👍🙂
sirji are these calculations same for every institutes?
or does it differ?
(ex:- does sbi and hdfc both calculate in the same way? )
it is same in all banks and institutions
Best video bro ...isse ache trike se koi bi home loan ke doubt clear nhi kr skta...
But 1 doubt h ..agr prepayments na krke EMI ki jyada kr di jaae to usse ky fayda or ky nuksan hoga
Ha EMI increase kar sakte hai jisse tenure Kam hoga aur interest save hoga. 1 disadvantage ye ho sakta hai ki EMI afford hona chahiye. EMI afford kar sakte hai every month to increase karna acha hoga
Bank of India se 12 lakh home loan liya hu 20 years ke liye 12thousand mera emi hai mai is ko jaldi kaise clear kro please suggest me
prepayment karke hi jaldi clear kar sakte ho
Interest rate kya hai apka
Very well explained, u did not hide any calculation.
Thanks 👍
Can you please share the excel calculator for prepayment?
The link to download excel is in description of video
So nicely u have explained. Very important knowledge u have imported. Thanks a lot.
Thanks and welcome. Share with your friends as well :)
Very nice explaination sir. My question is if I want to reduce the Emi value by doing any pre payment. What is the process for that. If I understand correctly that if I prepay in the earlier days and keep the emi same, then the tenure decreases. But if I want to reduce the emi value, then what is the process?
Same process. After prepayment you have tell bank to reduce EMI and they'll recalculate EMI for you. To know how reduced EMI is calculated watch this video ua-cam.com/video/vOrDMefUrDc/v-deo.html
If you have sufficient amount to pay EMI, so Reduce EMI Amount is not good option
@@gandhimonali2247 right
already paid 8 years emi of 15 years tenure...is it good to pay extra emi now
U r late
@@SubashPanda-p7q ok thanks 🙏👍
Thanks
I have a query on home loan. My loan AMT is fully disbursement now. In between I have opted for conversion twice to reduce interest rate from 9 to 6.9. my query is if it is wise to increase EMI. As per many suggestions, emi can be increased which will reduce tenure drastically. But the interest component will also increase accordingly, which is what the bank may want as they wan us to pay max money initially.
Or is it wise to not increase the EMI but accumulate money and do part payment so it will reduce tenure to a huge extent.
Or should I do both. Which is beneficial. Your suggestion pls.
You have commented on 4 of my videos and got my attention successfully 🙂
Anyway.
Yes, increasing EMI will help you reduce the tenure drastically and also total interest will be reduced. It's not true that interest increases with increase in EMI, the total interest actually decreases with the increase in EMI.
Secondly, doing Prepayments will again help you to reduce overall interest and tenure as well since it reduces your total outstanding balance on loan.
So doing both is the best option here.
But little bit of caution here. Don't use your entire funds in increasing EMI and doing prepayments, keep some funds for your basic needs as well.
So plan accordingly to set the EMI, the amount you can afford every month to pay EMI and once you have some additional funds, do regular prepayments. Use my excel calculators to plan accordingly.
I hope this will be useful.
Let me know if anything else is required. All the best 👍
I'll paste this on all of your other comments so people find it useful 🙂
@@fincalc Thanks a lot. But just a confusion that on increasing EMI. assuming my emi is 20k per month. If I increase to 30k the additional 10k will also have principal plus interest right? So I'm paying additional interest in 10k rupees. If I just do prepayment will it have less benefits than prepayment plus EMI increase.
@@infinitex2252 yes you are right. Increase in EMI will increase principal and interest amounts "on monthly basis". You can do one thing to understand more:
1. For 20k EMI, check the interest amounts and add all interest amount of all months throughout the tenure. You'll get sum of interest for 20k emi
2. Next, for 30k EMI, add interest of all amounts throughout the tenure you'll be paying
3. Now compare total interest amounts of 20k EMI with 30k EMI
4. Notice, 30k EMI months (tenure) will be less compared to 20k EMI tenure
You'll find total interest you'll pay with 30k EMI will be less, which is what we want - to pay less interest "overall" right?
Your confusion is - you are comparing interest amount of single month for both EMI. Instead you should check the total interest you'll be paying throughout the tenure after comparing both amounts of EMI.
In this way, higher the EMI you pay, less interest you have to pay. But as I said, plan accordingly.
Doing only prepayments will also work in the great way as you must have seen in my videos.
Hope this helps.
@@fincalc superb. Thanks. alot. I will check the mentioned steps. God bless. 💐👍
very nice bro 100% accurate
Thanks and welcome
Nicely explained Abhilash ji.
I wanted to know, can I show the monthly interests paid for a home loan in income tax reduction?
Thanks Vishal. Yes you can claim up to Rs. 2 lacs in a FY under section 24 and use home loan interest paid by you to reduce income tax.
Watch this video to know more options to reduce income tax: ua-cam.com/video/2meRM9A4aT4/v-deo.html
@@fincalc Thank you Abhilash ji. Also, will do check this video.
Agar hum prepayment karte hai 6date ko toh jo hum principal amount bharte hai uska interest bank ne 6date se hi kam karna chaiye na but bank use reschedule ke naam par 2 din extra laga rahi hai har waqt toh iska complaint rbi main kaise kare ispar koi video banaiye pls.
2 days ka to extra interest lagta hai na?
Bahut khoob...👍👍
Thanks 👍
hi
jo bhi monthly emi hoga use jayada bhar rahe ho to kse interest calculate hoga? for exmple:17k hai uski jagah pe 19k bhar rahe ho to kse interest calculate hoga?
To EMI column me mention karoge phir interest apne aap update hoga Excel me
Thanks for valuable info... nice video
So we can repay additional amount in any month no need to wait for year end
Yes, correct
Bahut achchha formula hai bhaiya
Sir apke video bahut helpful hai
Lekin aap jo formula put krte ho use screen pr bhi with sign display Kiya Karo taki hme pata chl ske
Gupta ji Maine home loan mai half amunt prepayment kar diya hai or mujhe ab apne EMI amount ko kam karna hai uske liye ek request letter format chaiye tha
Thanks for this easy understand video for saving loan 🙏
Glad it was helpful!
Meri pnb ka lon chal raha he us me ripamnet jama karna hai lekin Bank wala 2 opsan de raha he ek to emi kam karne ka or dusra lon ke parincpal amaunt jama karwau to konsa best rahega mere liye
Axis personal loan, konse mahine se prepayment kr skte hai, 4 months bad ya 6 months bad
jab chaho tab kar sakte ho.. koi specific time limit nahi hai
Home loan and Housing loan ,ye dono hi alag loan hae or mae home loan le rakhi hoon to kya mae ITR mae iska borrowing capital principle, Interest on EMI ka profit le sakti hoon ( ya ITR 2021 mae show kara sakti hoon ) . Please reply 🙏🙏
It's urgent please reply 🙏
hello sir...
kya prepayment k liye v kuchh charges dene hote h bank ko ?
Fixed interest rate pe charges hote hai, variable rate pe nahi.. ye video Dekho for more information ua-cam.com/video/vOrDMefUrDc/v-deo.html
@@fincalc thanku sir
Best explanation i have ever seen
Loved it...
Thanks
Hii
Very good, informative video
Thanks 👍🙂
If we do prepayment,then our tenure will automatically gets reduced,right? Means depending on tenure and remaining principal amount , further intrest gets calculated?
Yes right.
Watch this video for more clarity
ua-cam.com/video/ISbQLq85CQI/v-deo.html
Amazing Bro. Very Nice. This is what I wanted. I wanted to calculate the monthly prepayment adjustments. Thank you.
Thank you. You may find below video helpful when interest rate on home loan changes. Check this as well
ua-cam.com/video/3EQvsWdBruY/v-deo.html
Very informative video… I derived value from this. Thankyou so much and god bless you with all success❤❤
Bhai pre payment ka mtlb EMI Ane se pehle he paisa dal dena hota hai kya aur agar pehle se paisa dal rahe hai to kya EMI se jada he dalne se faida hota hai ya fir jitne EMI arahe utna bhe dalne se faida hoga plz bro bataiye
prepayment matlab agar aapke paas thoda extra amount hai to aap loan me daalkar uska interest bacha sakte ho
But starting Mai interest amount high hoti hai aur principal kam hoti hai right ?? Mere interest amount high hai aur price bohot Kam hai like aprrox 18 k interest and 6-7 k for principal
Depend hota hai aapke tenure pe. Aapka loan tenure zyada hoga isliye interest amount zyada hai initially
@@fincalc 20 years...
Sir.. Pre payment kerkai bank ko EMI months kam kerne bolna hai ya monthly EMI ki amount kum kerne bolni hai.. Please guide kijiye muje... Thank you.
Sabhi loan or bank me Pre payment accpt hota h kya
Haa
Prepayment karege to prepayment charges nai lagega? Aur lagega to kitna lagega ? Please elaborate.
Prepayment charges fixed interest rate me Lagta hai. Ye video Dekho for more information ua-cam.com/video/vOrDMefUrDc/v-deo.html
Taking longer tenure like 15 years then prepaying it is more beneficial or short tenure like 10 years then prepaying will be more beneficial.
As it is in my mind to prepay my loan earlier so i was thinking to take 10 years tenure but people are suggesting that I take longer tenure like 15 years then prepaying it will be more beneficial.. is this thing is right.? please suggest
Longer tenure will obviously make you pay more interest.
So here 10 years will be more beneficial provided you can pay the emi as it will be slightly more compared to 15 years tenure
And prepaying with 10 years tenure will help you close your loan faster compared to 15 years tenure
Very Nicely explained
can u pls share the excel file with formula. I have prepared one excel file with formulae shown by you but when i entered Prepayment as Rs. 1,00,000 last four months values are showing in Negative. I wanted on updated interest and Total Savings
Sir UCO ma home loan ma anytime premayent kar sakte hai pura loan amount ?? Any charge deducted hoga kya?
Very nice informative video best
Thanks for liking
Sir, if we pay pre-payment then bank give us option that u want to reduce the emi amount or loan tenure.. Then option we have to go then?
Kya dastavege registration se owhle DD ban gaya he toh ,disbursement se pehle EMI CUT HO JAYEGA
JABKI HAMARE PAAS 1 RS BHI NAHI AAYA HE LOAN AMOUNT KA
Super video very good information sir Thank you
So nice of you
Ek doubt hai sir.... Agar initial statges pai extra principal repayment capacity hoti to log loan ka tennure hi kam lete, so by default intetest saving hota... Intital stag mai logo ka salary paisa down payment, stamp duty, furniture etc kharcha hota hai... Isliye initial stage pai jadha ka principal repayment possible nahi hota
Very good explanation tks
Welcome 👍
Plz help me.. should I give only interest for 2 year or hav to pay interest + principal??
You EMI has both principal + interest amounts included. When you make prepayment, you only pay principal amount
Thanks for detail information
Welcome
Very good
It is very knowledgeable
💐🌹🌷Thank You Sooo Much Bhai....Thank You Sooo Much....Thanks a lot⭐🌺🥀
Most welcome
Thank you for such informative video. I have a question that can we transfer money from foreign account to Indian home loan account?
Thanks. You can transfer from foreign account to Indian Bank account from which emi is getting deducted every month. From this account you can pay the loan amount
Very nice video..keep going on..👌👍
Thanks 👍🙂
Bhai bht bht dhanyawad 🙏❤️
welcome
Hello, if we deduct prepay additional amount. EMI getting change and getting reduced. If I want to keep same emi it's not showing in Excel. Please explain
please download latest excel from here:
fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/
let me know in case of any queries.
If EMI need to be same than you can set that number in EMI column
Sir bank aur nbfs ka same hota h payment plan?
Sir plz tell me i can pay emi upto 25000 monthly of 2000000 interest rate 8.6 toh kya mujhe ye loan 15year ke liye lekr 19000 around pay krke repayment krna chahiye ya 10 years k liye 25000 par karna chahiye plz suggest
Sir mera home loan 3rd step pe hai.. last 4 months se.. total 23 months hogye hai loan lete..
Ab agar mai prepayment krna start karu to kya subsidy reject ho sakti hai?
Mai subsidy ka wait kr rha hu.. otherwise mai thoda thoda prepay start kar sakta hu.. Mujhe pta hai ki eksath nai krna hai aor minimum 3 to 6 lacks to rahene hi dena hai loan amount. Thanks in advance..
Sir, thank you for well explained. I've two doubts, 1st interest amount kum hone par bhi EMI amount kyun same reh raha hai last month of loan repayment, agar aaisa hai to hum kaise savings kar sakte hai & 2. Loan tenure kum karne k kya options hai ?
Please advise
Sir aapka mobile no do problem puchna he
Excellent description
thanks
Sir mera withdraw power amount or ousting amount m different ara h isme withdraw power amount jyada h ab SBI bank kispr interst lega pls suggest
Sir prepayment dene se loan ki kist kam hoti he kya?
ha
U didn't said one thing if we pre payment the tenure also reduces right? I am asking
Yes you can either reduce EMI or tenure. Check this video where all queries are solved with examples ua-cam.com/video/vOrDMefUrDc/v-deo.html
Hi bro In home loan which one we pay principal or interest charge for monthly
our EMI consists of both principal and interest amount. Interest amount is high initially and decreases with time, whereas it is opposite with principal amount.
Use excel calculator from here: fincalc-blog.in/home-loan-prepayment-calculation-reduce-emi-or-tenure/
Sir mera loan amount 29l senction hua hai...but for registry 12L disbursh hua h..to ...mujhe starting EMI 12L se calculate hogi ..ya sanction amount se
jitna disburse hua uspe EMI calculate hona chahiye
Bahut bahut dhanyawad apka sir
Welcome 👍🙂
Excellent video for home loan
Sir agr hum repayment krte hai to humara loan time km hoga ..ROI badhhta hai..pls btaye sir
It's very useful for me thank u👍
Welcome
Very good information. Thanks
Sir maine sbi se 27 lacs ka home loan liya tha Jan 2021 mey. Mey Jan 2022 mey kitna prepayment kar sakti hu
Jitna chaho utna kar sakte ho.. minimum 2 EMI ka amount hona chahiye
Kya repayment se tenure bhi kam hoga???? Please batayen??
प्रधानमंत्री आवास योजना के अंतर्गत होम लोन लिया है सब्सिडी सर अभी नहीं आया है क्या प्री पेमेंट कर सकते हैं क्या उसका चार्ज भी लगता है
Good insights on this topic. Very useful.
Thank you. very nice presentation. now i will make my loan prepayment at least in the 3 rd year
Welcome. Glad to know the video helped you. 🙂👍
Sir agar EMI double jama karein toh kitna samay mein loan samapt ho jayega
Half time me
@@fincalc sir calculate Karke Sahi bataye pl
Hands down the best video on UA-cam for home loans prepayment. Good job buddy.
Glad you liked it!
sir, I am haryana government employee, I have taken home loan from pnb bank,I want to know that what was the homeloan interest that time and interest rate will remain same which was that time or it will be calculate according to current interest rate.
Interest is calculated based on changing interest rates. Watch this video to know more ua-cam.com/video/vOrDMefUrDc/v-deo.html
Thanks sir
Sir agr me home loan full pay kar deta hu toh use kya hoga kuch penalty chrgs lgega kya
Hello sir,
Wanted to know which loan to pay first?
House loan on my parents name with 9 years remaining or education loan with 5 years remaining if I have Lump sum amount and interest on both are the same.
Paying 9 years loan first is better, since tenure is long.. longer the tenure, more interest amount you'll keep paying, so consider paying 9 years loan provided rates are same on both loans
Sir, but agar interest rate change hota h toh ush case mah kaise hoga........??? Bohat baar bank interest rate kam ya jaada bhi hojata h
Interest rate change ka video banaya hai. Ye dekho ua-cam.com/video/Iddvu55S0vg/v-deo.html
Interest amount aur tenure increase hota hai
@@fincalc wow sir, thanks.♥️♥️
U r one of my favourite UA-cam channel. Hamesha kamal k topics pah video laate ho aap joh ki practical life ar *businessman* /salaried person k lya superb useful h.
Ar sabse badi baat h ki aap ak topic ko bana k bhul nahi jaate ho bal ki usi topic ko alag alag scenario mah batate ho ar update bhi krte ho ush topic ko in future.♥️♥️♥️♥️♥️
@@som8760-y7f Thank you so much for your lovely comment. Subscribe Karo aur Apne friends ke sath bhi share Karo 👍🙂
Thanks alot For wonderful information
hi...can u make an excel sheet for me with specific requirements...pl ans.
please send details on email. ID - team.rrrapps@gmail.com
Principal amount repayment online kar sakate hai kya please reply me sir
Yes online kar sakte hai loan company ki website use karke
Mera 20 yr tenure hai...2017 me 18 lakh ka loan liya hai ...8.55%
Me ab 6 lakh pre payment krna chahti hu...to benifit kitna hoga ..?
.
Excel calculator use karo
Link: fincalc-blog.in/home-loan-prepayment-calculation-reduce-emi-or-tenure/
Can you help me with a sheet for a loam amount of 60lakhs for 20 years. Also, as you mentioned, to prepay in the initial stages. Can you specifically let me know, how early I should do it?
prepayment should be done consistently as soon as possible and affordable. For calculations, you can download excel sheet from here:
fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/
Sir home loan liya tab intrest rate 7% something tha but ab 8.45% hai iske karan emi में से intrest ज्यादा cut रहा hai ,sbi bich me bina sochna diye intrest badha सकती hai kya? Hum kya kar sakte hai
Sir please suggest-
I have joined in ltd co since 1/4/2021 & no any salary income from march 2020(credit in April 2021) so how many months salary will be counted in itr for FY 2021-2022 either 11 month or 13 month
Can you consider floating rate interest?
Yes floating interest rate Calculation is done in this video. Watch this
ua-cam.com/video/Iddvu55S0vg/v-deo.html