Home Loan Prepayment & Calculation Method | Reduce EMI or Tenure? With Excel Calculations

[@fincalc]

Home Loan calculation video aapko kaisa laga? COMMENT KARO Calculator link: fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/ MORE VIDEOS: SIP Excel Calculator: kzbin.info/www/bejne/b6nOhGqqqJl-rMU Income Tax Calculator: kzbin.info/www/bejne/o6iQlqV8qr6Vpa8 Loan EMI Calculator: kzbin.info/www/bejne/fITFiqJ-drp_npI 20 Years SIP Calculator: kzbin.info/www/bejne/ZmmbhGWQoJymj7c Loan EMI Prepayment Calculator: kzbin.info/www/bejne/opqqmJmdgtNorsk

[@imcjeewan0627]

Bhai whats the calculation for Mortgage Loan..? Same process or different?

[@_channel_name__]

why dont you share link copy of excel sheet itself. we will modify values as per requirements

[@Marie-ju2oq]

One of the best in depth explanation and covered all questions I have especially in regards to prepayment and applicable charges, simple interest was totally new for me and I am truly glad came across your channel... I am in the process of applying for home loan and feel more confident. Keep up the good work. Truly blessed to have come across ur channel. God less you tons 🙏

[@fincalc]

Thank you so much for your lovely comment. I am glad this information on my channel and website will help you in future. Stay tuned 🙂 👍

[@princeKumar-df2ov]

Ap bht acha or simple language m samjhate ho 😊🙏

[@fincalc]

thanks

[@NobitaHunMe]

Best video on KZbin on this calculator ❤

[@fincalc]

Glad it was helpful! share with your friends

[@gafarshaikh205]

बहोत ही मालूमात वाली वीडियो है

[@rohitarolkar1399]

Emi ke saath same bank se sip chalu karna चाहिए या दुसरी जगह से चालू करानी चाहिए

[@sonkamblesunil7158]

Nice concept bhai...I watch this video 2 times and likes and share my friends also...truly useful concept bhai...thank you

[@fincalc]

Thanks and welcome

[@naguhnd08]

Thanks lot for this video. Helped me to take decision prepayment vs personal loan to pre close HL

[@fincalc]

Glad it helped. can you share in how many years you closed loan, and what was the original tenure?

[@prafulbhojane2278]

This is the best video. you cleared my all doubts . Thank you

[@Superr77-m9v]

Thank you for such informative video. I have a question that can we transfer money from foreign account to Indian home loan account?

[@fincalc]

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

[@anoopkumar6337]

Thanks for presenting clear vision about home loan components with step by step calculations to save hard erning money. Great job 👍👍👍

[@fincalc]

Glad it was helpful!

[@vismitparmar4899]

Hello Mr. FinCalC, first of all, it is by far the best video i've seen explaining the terms. Kudos to that!. I have just one query and im sure i will get the right answer from you. I want to ask if every financial corporation or bank do the same settlement with the pre-payment as you did in the example ? Thank you.

[@jaikaran2733]

Bahut kaam ki baat batai h sir very very good sir thanks sir

[@fincalc]

Welcome 🙂

[@satyas7004]

Really very good bhayya You cleared so many doubts You are a talented financial adviser

[@fincalc]

Thanks 👍

[@himanshurawat4176]

Thanks a lot.. 1st detail video available on home loan

[@vinaysirji3691]

You tube ka loan ke liye best video

[@satyendrasinghmaurya4504]

Thanks sir, aapne bahut deeply bataya

[@matloobiftkhari8813]

Sir ji repayment me normal karna chahiye ki reduce principal

[@bmkrissh8714]

That Excel calc with examples = Excellent Video. keep up the good work

[@fincalc]

Glad it was helpful!

[@dilipghosalkar708]

Sir ji ....mene 350 month ka installment liya tha as per retirement age 58...lekin ab bank ne repo rate ke naaam pe installment 488 months ke kiye ...matlab till 72 years .......ye as per RBI VALID HAI KYA SIR?... PLEASE GUIDEE....

[@t.s.sharma6105]

Well explained sir,mene apni hl me 15 emi eksath jema ker di,per SBI bank ne tenure Kam kerne ke liye mena ker diya? Kya kerna chahiye mujhe?

[@rockymorwadiya9724]

Sir HBA jo state government employee ko milta hai uska emi calculation ka video banaiye ?

[@user-gu9qz5ns7v]

Friend kindly reply EMI same hai . ROI increase hone ne se principle aur interest badhta hai. ? Sath sath tenure bhi badhta hai kya? Kindly reply.

[@fincalc]

Yes interest increase pe tenure increase hota hai.. so interest bhi increase hota hai.. total outstanding principal same rahega and emi bhi same rahega

[@user-gu9qz5ns7v]

Friend , this month Mera home loan ka ROI Kum hua hai. Maine tenure Kum karaya hai. Remaining period Karib 21 months se kum hua hai.tenure Kum hua hai. Lekin total remaining balance Kum nahi hua hai aise kyu?? Kya aisa hota hai? What is your opinion... please guide

[@MohammedImran-pz2jc]

Can you help me with personal loan? For 7 years..shall i choose tenure or EMI option? For every personal loan pre payment/ part payment charges is 3% for 25 lakh month within 3 years? After 1 year there's no foreclosure charges so shall I pay full amount or reduce the tenure period?

[@user-em1ru1yx5f]

❤❤❤ Hi Abhilash, I have a Que. I have a SBI Home Loan 60lac. For now, pre emi is going on. That means only interest part is getting deducted as a EMI which is 10k. Along with that if i do pre payment of 40k per month, will that be as good as opting for the full emi ? Or will that be different? Pls answer.!! ❤❤❤❤❤❤

[@vinodtelawane9925]

Prepayment online karane ke time, bank ko information dena jaruri hai kya.

[@Nabhishek]

Thank you so much for this video. you have explained very well, one of the best videos, I subscribed, and I am going to watch more, please make a video on how we can prepay a LIC home loan.

[@NareshSinghalTheKing]

Fantastic ...explained very clear and very best example

[@fincalc]

Thanks 👍

[@nitinchavan3395]

Thank you for making such an informative video, this has cleared all my doubts.👍👍👍

[@fincalc]

Glad it was helpful

[@drvinit1137]

Best video in u tube

[@fincalc]

Thanks 👍🙂

[@asham7338]

Wow Amazing info Thank you sir.. i have recently applied for HL this is damn useful for me

[@fincalc]

Glad it is helpful. Subscribe and stay tuned for more such finance videos 🙂👍

[@banwarigupta6447]

Sir home loan ke section letter Name me typing mistake kar diya he or maine signature bhi kar diya blindly..koi problem hogi kya future me ya fir bank me jaakar correction karwana hoga..loan bale bole he is se koi fark ni padega even subsidy ke liya apply karne me bhi..plz reply

[@rakeshmathur5560]

You have explained well.But,in the table you need to change EMI at the time of reset and then show that without prepayment,the principal and interest become zero at the end of loan period.This will prove that the new emi calculation is correct. By the way,I have written a Macro to do the calculations.

[@praharshithasri3657]

Thank you FinCalcTV, this is a very good, very very good video. I was doing these steps, but felt what is the difference between tenure and EMI, and could not find for 26 years. this is very helpful and will follow your advice on tenure reduction.

[@fincalc]

Glad that my video helped you :)

[@girishs6668]

@@fincalc Hello you are missing the concept of inflation here. The emi amount will be reduced immediately but the benefit of tenure will be towards the end of closure. Moreover the amount you save today can be invested for extra returns.

[@sharaddhangar8701]

Sir, 1) Regarding top up👇 मैंने एचडीएफसी बैंक से जनवरी 2022 में टॉप अप लोन लिया है | मैं अक्टूबर 2022 में प्रीपेमेंट करना चाहता हूं | मुझे कुछ अलग से जुर्माना/चार्जेस लगेंगे? 2) Regarding Home loan insurance (HDFC) मैंने एचडीएफसी इंश्योरेंस लेकर रखा है, मुझे होम लोन क्लोज करना है,मुझे इंश्योरेंस की अमाउंट पूरी भरनी पड़ेगी क्या? क्या होम लोन क्लोज करने के बाद इंश्योरेंस कंपनी को इंश्योरेंस के संबंधी दावा करना पड़ेगा? कृपया बताइए 🙏

[@kevinsheikh9870]

Thank you for the video. My query is -- now i have accumulated a wealth of around 15 Lakhs thorugh mutual funds which i can redeem. For home construction i need 20 Lakhs which I have applied home loan for all. Should i redeem MF or use home loan amount which will be disbursed to me when needed? I have a steady income of 1 Lakh per month but have no emergency fund for now.

[@fincalc]

thanks, good question. It's better to keep some emergency fund as well. You can redeem half of the mutual fund units to pay for down payment of your new house and take remaining amount as loan. Remember that equity mutual funds should not be considered as emergency funds. so it's better you accumulate 4-6 months expenses as emergency fund and save it in FD or RD

[@VivekSingh-bv3fl]

Best vedio, cleared all doubt, keep it up Bhai

[@fincalc]

Thanks 👍

[@chaudharykuldip1328]

Bhai ye btao ki home loan ki emi me 1st month me interest jyada jayega ki principal jyada jayega

[@fincalc]

depend karta hai loan tenure aur principal amount pe

[@bimlabhajanbhola4557]

Nice description sir Sir mere homeloan per 31466 ki emi jati h... Last month mene 5 lakhs prepayment kiya to bank ne last month May2021 aur june 2021 ki emi usi 5 lakh me se kaat li jabki pehle saving m se debit hoti thi to ab prepayment bhi 437068 rs bata rahe h Dusri taraf outstanding amount m interest amount i. e. Rs13059 aur rs10476 add kiya hua h dono months ka. Mujhe kya karna chahiy sir.. Plz guide me.. Dono taraf se interst aur emi kaati jaa rhi h🙏🙏🙏🙏🙏

[@naseemfarooqui1071]

Mujhe school banane ke liye 100/2o fit 2nd floor hai kitne mileage aurkab tak chukana hoga bataye

[@koranga123]

Sumif ka formula bata de pls calculation karna hai total savings?

[@anoopbhakoo5353]

In floating rate loan can prepayment be made in small amounts any no of times?

[@tapanchatterjee8555]

Hamara HBL loan 15 years ka ab 7 years ho gia to ab due loan all pay karna chate hu 8 years pehele to kya subista milega humko.pls tell me sir

[@Rockbreaker07]

Hello sir ji. Mera home loan 8.1lack Ka home first finance India ltd company se h. Or Mera EMI SEP 2020 se chal Raha h rate of interest 13% h or emi me bad se ab tak Mera principle amount only 550 se 700 tak Kam hi raha h. Or principle Kam bhi ho jata h. Jabki principle amount badna Chahiye . 20 yr k liye h loan. Kya Karu sir koi upay digiye plz plzzz

[@technoshrey]

thanks for explaining in simple and easy way.

[@mayurchandramore8229]

if I do the prepayment on the same day of EMI, what will be my simple interest in prepayment?

[@ananthkrishnancn7590]

Pls tell the system where in the home loan is reduced by investing in Systematic investment plan in any bank who has given u the loan .

[@shankarsuryawanshi9882]

Badya jankari sir

[@fincalc]

Thank you 👍🙂

[@madhvikarkera1265]

Hi do you have a Overdraft Home Loan Calculator with floating interest rates?

[@fincalc]

you have to use excel calculator to check with floating interest rates. Here's the latest video I have made on floating rate: kzbin.info/www/bejne/aXa0p6aNmaelq7s let me know in case of queries

[@pavanmunagapati939]

Excellent great information

[@oceankrish]

If part disbursement done and after 2 yr balance amount of total loan amount paid by bank. Paid full EMI of loan amount of part disbursement then how is the calculation and tenure will reduce in that case.

[@ninadgokhale8025]

Nice & simple explanation👌👌

[@fincalc]

Thank you 🙂

[@Commando929]

Thank you very much

[@fincalc]

Welcome 👍

[@maneeta9207]

Great Video, but not able to its calculators???

[@prashanthle]

Hi, it was very informative video. Can you please tell us if I increase my emi payment by 50-60 percent higher than the emi given by bank then how it ll impact my overall tenure and savings. Example: If I I paying every month emi of 13k regularly and I want to increase to 20k so how it ll impact on my overall tenure and interest savings please explain on this)

[@fincalc]

Increasing EMI would help to reduce the tenure. And this also helps in reducing interest amount we pay, as total interest amount is related to tenure. So increasing emiy will be great to close your loan asap You can also increase the emi amount in excel and check by when the loan will get close Link: fincalc-blog.in/home-loan-prepayment-calculation-reduce-emi-or-tenure/

[@prashanthle]

@@fincalc Thank you 😊

[@mangeshpawar5609]

Thanks for sharing this valuable info. But Home Loan Prepayment Example to save Interest is not working in excel sheet which i have created... can u suggest on this. or can you share the excel sheet

[@fincalc]

You can download the excel from this link fincalc-blog.in/home-loan-prepayment-calculation-reduce-emi-or-tenure/

[@akshaykurimilla6547]

Regarding simple interest calculation on prepayment....if the EMI date is 10th....and I prepay on 25th of the month, simple interest will be calculated for how many days?

[@fincalc]

For 15 days. From 10th to 25th

[@PankajKumar-oo1zl]

I have one question, instead of prepayment if I invest those 2 lakh rs for 10 yrs and assuming 6% interest rate, the total amount after 10 yrs would be somewhere aprox 3.5 lakh, isn't that would be good instead of total saving of 1.8 lakh on prepayment or i am missing something ?

[@vivekborse58]

Sir prepayment ke option main bich main EMI increase kar saktey kya plz reply

[@fincalc]

Yes increase kar sakte hai

[@arjunrawat7234]

Sir ji, मैंने एक extara EMI दी है। EMI कम तो हुआ है पर हमे बैंक से कैसे पता चलेगा कि हमारी EMI के साथ year कम हुआ है की नही? plz... plz....

[@fincalc]

Emi Kam ki hai to years Kam nahi honge. EMI same rakhne par years Kam hote hai

[@piegambarmujawar5553]

Excellent information

[@jagatpalsihag9410]

Bro, everywhere there are links to links but the Excel is not found??? Once u said the link is in description it should be there na. You should make it simple as well.

[@irfanmohd6594]

Sir please bataye saving bank account me interest kaise count hota hai.?please

[@fincalc]

ye video dekho kzbin.info/www/bejne/bme3Yadvothjers

[@Gogol9108]

Very informative.. Thank you.. ❤️

[@prathiksaju1595]

Thanks for the video... This will help for many.. I have a query some home loans are paid to us stage by stage also there will be a lot of amount deduction like some charges & a penalty for late EMI payment. Can you help including that too so that many can get a complete idea when the loan will end & such informations. Thanks.

[@rajkumar-hh2cu]

Hlo sir car loan7year ka hai Ab maine 2 year ke baad 2lac repayment kiya hai mujhe ab mujhe emi kam hoga ya tenure

[@laxmibhaskar1698]

Bhai bahut acha vedio

[@fincalc]

Thank you

[@vipinverma638]

Most informational video sir🙏🙏 Banks never tell these things,they always keep customer in doubt Thanx a lot sir🙏🙏

[@fincalc]

Always welcome, keep watching

[@girishs6668]

@@fincalc Hello you are missing the concept of inflation here. The emi amount will be reduced immediately but the benefit of tenure will be towards the end of closure. Moreover the amount you save today can be invested for extra returns.

[@girishs6668]

Hello you are missing the concept of inflation here. The emi amount will be reduced immediately but the benefit of tenure will be towards the end of closure. Moreover the amount you save today can be invested for extra returns.

[@arkakundu225]

@@girishs6668 what has inflation to do here?

[@girishs6668]

@@arkakundu225 this guy is simply comparing interest but you should not compare the interest amount paid today vs 25 years later. If you reduce your emi you can invest in other assets to generate good returns instead. See less emi spent today can lead to higher return in your portfolio if you invest it

[@drvinit1137]

Which loan is better variable or fixed Plus how much variable it can get if variable is choosen

[@fincalc]

Variable seems to be better as we can do prepayments. It doesn't vary much as such..

[@carrymintos9544]

Fixed interest i.e 6.7 and prepayment after 2 year then the charges... For ₹18Lakh is ?

[@jyotisaini-hv6dt]

Ager ap loan emi ko ap change kr sakte h. To kase kre hidden charges ya harm kya h

[@fincalc]

bank me contact karke change karwa sakte hai

[@user-gu9qz5ns7v]

Friend kindly reply, question: Home loan pe ROI Kum hone pr tenure ke sath sath total remaining balance bhi kum hota hai kya????

[@user-gu9qz5ns7v]

Friend, please please reply this message..it's very urgent for me. Kindly reply above question

[@fincalc]

Total remaining balance Kam nahi hota is case me. Remaining balance decrease hoga only in case EMI pay karte hai ya loan prepayment karte hai tab. Hope this helps

[@fincalc]

Done 👍

[@gpatil84]

I like this video sir

[@fincalc]

Thanks 🙂👍

[@ankurkumar7835]

Nicely explained bro!

[@fincalc]

Glad you liked it

[@kankatlageetha9829]

Hello…I have a query regarding simple intrest… I have an principal outstanding of 42 lacs with 8.6 ROI….My emi amount is 34k and date is 5th of every month… For suppose If I do a prepayment of 22lakhs on 24th what will be my next month emi will it be 34k or the amount calculated for the remaining amount 20L….I have home loan from HDFc

[@Rashtrneeti]

Excellent video , can you share excel sheet link for downloading...

[@fincalc]

Yes. Download from here fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/

[@sheenamahahlingam4648]

Namaste bhaiya mene Icici bank se 10.75 perecent 13, 50,000 ka loan hai 4 saal ho gaya hai Emi Rs 14000 jata hai kya me dusre bank me trsf karke Kam Emi Matlab 10,000 emi le saktu hu kya pls reply??

[@fincalc]

Ha le sakte ho

[@8683zxc]

Sir you are good analyser. Plz make video on as many bank gives the offer for transfer as low interest rate for balance transfer . Is it feasible that, transfer of loan after 8-9 year to other bank which is gives 1 percent less interest

[@fincalc]

yes sure. Thanks :) Yes it is possible

[@ameyapatil123]

Thanks for clearing all the doubts

[@fincalc]

Welcome 🙂

[@stories1331]

Sir ji.Can v take gold loan nd can despite in Home loan.can v get tax rebate on gold loan int. in any bank

[@anoopbhakoo5353]

Any formula as to how much tenure or EMI is reduced against how much prepayment??

[@user-gu9qz5ns7v]

Dear friend, kindly reply.. My loan is in NBFC NBFC ne mera rate of interest 9.2 se 10.4 Kiya hai. EMI same hai . Last 4.5 years se. lekin Tenure badh Diya hai. Kya aisa hota hai? NBFC ne 2 yrs ka tenure badhya hai. Bina humse puche. Kya kare?? Kindly reply. Q2. 1% or 1.2% ROI badhne se Tenure 2 sal se badh sakta hai kya? Please answer. Mera loan 15 L for 15 yrs and rate of interest ,in starting 9.2 and after that they have increased 10.4 . right now it 10.4. They are giving offer 8.8 ROI reduction. Kitna tenure Kum hoga. Please reply.

[@madansingh6418]

Sir EMI kam kar k save kare or prepayment kre to accha option hoga kya?

[@fincalc]

saving ya prepayment karna chahiye iske liye ye video dekho kzbin.info/www/bejne/iWPOZ2SuppKHfbs

[@naveenkakkar4117]

you clear my doubts. Thanks.

[@fincalc]

welcome

[@sanjayerram3008]

Can we settle full principle amount in one transaction?

[@mohit.apr16]

Thank you brother

[@sudipchatterjee105]

Is simple interest applicable for variable loan pre-payment?

[@fincalc]

Yes

[@sudipchatterjee105]

@@fincalc how is it calculated if I make the prepayment on 25th of the month? My EMI Date is 15th of every month.

[@fincalc]

@@sudipchatterjee105 simple interest calculated for difference of 10 days in this case

[@irfanmohd6594]

Thank you sir 🙏.

[@fincalc]

Most welcome

[@KnowledgeisEverything-xk3of]

Same EMI date pe pre-payment kare toh kitna interest lagega Bhai

[@fincalc]

nahi lagna chahiye ya phir 1 din ka lagega max

[@KnowledgeisEverything-xk3of]

@@fincalc mera problem ye he ki mere subsidy feb-2022 me aayi he aur muje prepayment karna he, Mera interest variable he.toh Bank vale bol rahe hi ki aap subsidy Ane ke bad ek bad he prepayment kar sakte ho, ya phir aapko application Dena padega..approval k liye,aur ek consequence ae he ki aapki subsidy bhi waps khis sakti he ye kitna %sahi he. Wo muje Dara rahe sahad uske fayde k liye. Muje batao

[@fincalc]

@@KnowledgeisEverything-xk3of shayad Dara rahe hai. Mene to Aisa kabhi notice nahi Kiya aise restrictions

[@KnowledgeisEverything-xk3of]

@@fincalc usko fayda ho is liye...hdfc vale

[@sharebazaar73]

Thats mean we should go with variable rate of interest?

[@fincalc]

Yes

[@mayurlaniya5049]

Nice explaination

[@fincalc]

Thanks for liking

[@adityagarg673]

Btw which is beneficial fixed or variable.

[@fincalc]

Variable

[@rameshhariharan2623]

Very best can u share xll sheet link. Very good easy to understand. Im tamilian but easy to underdtand hind. Jaihind

[@fincalc]

Glad it was helpful. Excel link is in video description

[@jituky4670]

Personal loan prepayment karne par emi kam hoga ya tenure

[@fincalc]

Option hai ki emi reduce karna hai ya tenure.. jo karna hai vo bank ko bata sakte ho

[@sagarrakde9732]

G8 very nice explanations sirji❤

[@fincalc]

Thanks and welcome

[@KVS-87]

Will banks agree for extra EMI's during or in between loan period?

[@fincalc]

yes

[@KVS-87]

@@fincalc Generally regular EMI's are auto debited from our account.What abt these extra EMI's.How we have to pay to our loan account?

[@fincalc]

@@KVS-87 you have to visit bank and tell them you want to do Prepayment or part payment. They will provide you form to fill Fill that form, give the cheque of additional amount you plan to pay and bank statement as well they will ask. You should be done with these 3 docs

[@yogeshgore6099]

I do same sheet When I add pre payment Then my EMI getting low Not a time / yrs. What’s wrong in my sheet ??? Do explain

[@fincalc]

You need to calculate EMI only in first row and copy that emi as value in other rows. Don't calculate EMI in all rows. Hope this helps 👍

[@absarkhan6903]

Very nice video

[@fincalc]

Thanks

[@santoshvishwakarma698]

Thank you for explaining all the details step by step and deeply.

[@fincalc]

Glad it was helpful!

[@prasaddhuri8598]

Hello sir , Mera axis Bank ka loan hai aur uski EMI date 10th of every month hai..Toh agar mera payment ya cheque us month ke 1st day ko karta hu to simple interest lagega ya nahi? Please Guide.

[@fincalc]

yes simple interest lagega for 1 day. agar 5th ko karoge to 5 days ka simple interest lagega. It will be a small amount.

[@prasaddhuri8598]

@@fincalc ok..Lekin kal mai Axis loan centre gaya tha..Aur simple interest regarding query raise ki toh unhone bola aisa kuch nahi charge karta hai axis Bank. Unhone suggest kiya aapka EMI Auto debit 10th ko hoga to loan account me settle 11th ko hoga. Toh aap 12th or 13th ko Ertra payment karoge toh accha rahega.. Please guide

[@fincalc]

@@prasaddhuri8598 Haan to 12th ya 13th ko Kar sakte ho Jaise vo bol rahe hai.. agar simple interest Nahi Lagta to achi Baat hai

[@prasaddhuri8598]

@@fincalc ok.. Thank you 👍 but still I don't have faith on bank..kuch bhi kar sakte hai