Tap to unmute

Home Loan Prepayment Reduce EMI or Tenure? Calculation Method EXPLAINED

  Рет қаралды 57,433

FinCalC TV

FinCalC TV

Күн бұрын

Пікірлер: 98
@pw604
@pw604 Жыл бұрын
Thank you sir for this video. Today visited many icici branch banks for this info. But finally got proper info.
@fincalc
@fincalc 8 ай бұрын
Welcome 🤗
@sukanyachauhan9653
@sukanyachauhan9653 10 ай бұрын
I couldn't find the excel sheet for the loan prepayment. Where is it hidden?
@anuragmanitripathi3181
@anuragmanitripathi3181 10 ай бұрын
Wonderful and very useful Video... Thanks
@manishsinhapatna
@manishsinhapatna Жыл бұрын
Bhai super Tarik batata hai ❤❤❤
@fincalc
@fincalc 8 ай бұрын
Thanks bhai
@ankitshah7178
@ankitshah7178 3 жыл бұрын
Very nice thank you for excel file
@fincalc
@fincalc 3 жыл бұрын
You are welcome
@seshubabusc
@seshubabusc 11 ай бұрын
very well explained sir...thank you
@fincalc
@fincalc 8 ай бұрын
You are most welcome
@viviandas8991
@viviandas8991 Жыл бұрын
Thank you sir. This is very helpful.
@fincalc
@fincalc Жыл бұрын
Glad it was helpful!
@kaustav1712
@kaustav1712 Жыл бұрын
I still think reducing EMI is better. Let me explain why. If you reduce your EMI say by 2000 per month then you can also invest that money in MF or other places where you will get a return also in 20 year loan term. You should add that amount with interest and then compare with the extra interest if not gone by tenure reduction. Also what about savings in income tax. You and your wife can claim up to almost 5 lacs per year in home loan savings tax benefit. If you close your loan early say by 5 years, then for those 5 years will pay much higher tax. Please think and calculate by your own what suits you better.
@fincalc
@fincalc 8 ай бұрын
Right to some extent. For some people getting out of loan burden is priority rather than investing in mutual funds that can be risky in short term. Also we have seen home loan rates increase in last couple of years that increases the loan tenure, which just increases the burden. Tax saving should not be the reason to take long term loans.. you are paying 100% interest to save 30-35% of tax which doesn't sound good, better to close the loan and invest that 100% of interest in mutual funds.. Anyway it depends on individuals interest and planning.. no option is 100% right for all
@kaustav1712
@kaustav1712 8 ай бұрын
@@fincalc thanks for sharing your thoughts. I guess you are right, one shoe does not fit all.
@juyalashish4
@juyalashish4 2 ай бұрын
Moreover if you take for a longer period considering money value, EMI will put less burden after 10 years.
@kaustav1712
@kaustav1712 2 ай бұрын
@@juyalashish4 exactly. My home loan was 63k back in 2017 when my income was significantly low. My emi now is 51k and my income increased and value of 51k now is much lesser than what it was or 63k back in 2017. Now I wish I didn't do any pre payment and continued only paying max loan term EMI.
@nasamind
@nasamind 6 ай бұрын
Beautiful explanation, after watching one video, I just hit like and subscribe
@dineshs1180
@dineshs1180 2 жыл бұрын
Apki jesi achhi video koi nhi banata
@fincalc
@fincalc 2 жыл бұрын
Thank you 👍
@dbw8076
@dbw8076 3 ай бұрын
I am planning to do part payment in my personal loan so how we can reduce interest which one is good reduce tenure or reduce emi?
@Peacekeeper433
@Peacekeeper433 3 ай бұрын
Sir sbi personal loan me pre payment karna se interest kam hoga. Please reply
@MohammedImran-pz2jc
@MohammedImran-pz2jc Жыл бұрын
What's same scenario for personal loan amount for 25 lakh , which is the best option to choose EMI or tenure
@amanchhabra3412
@amanchhabra3412 Жыл бұрын
I have home loan from sbi. Thinking to prepay some amount. Do they give option to reduce emi?
@fincalc
@fincalc 8 ай бұрын
Yes
@johnmarbaniang3160
@johnmarbaniang3160 Жыл бұрын
Without going to bank can I repayment extra emi loan amount through online.
@laxmanpawar9098
@laxmanpawar9098 Ай бұрын
Nice video par mera sumif formula kam nahi kar raha hai please
@roshanjameerbasha9894
@roshanjameerbasha9894 2 жыл бұрын
sir agar 40l ka loan 4 saal mai khatam kar saktha hu tho mai emi kum karna mai mera faidha hai na sir ..
@PkVp-ji1oq
@PkVp-ji1oq 8 ай бұрын
Sir its Very helpful n i like the idea but i don't see a option for selecting emi or tenure in yono app. Does this process require visiting the branch. Please reply.
@TanveerAhmad-eb3er
@TanveerAhmad-eb3er 3 ай бұрын
Sir hum apni emi increase kare or prepayment option choose kare
@Kafir8543
@Kafir8543 10 күн бұрын
Mera principle amount 1.24lakh kaa hai 39 month ka hai Or hmm espe part payment krne jaa rhe hai To please hme tenure reduce krna chahiye yaa Emi please Pr month kist 5713 ki hai
@KaminiMishra-ep6do
@KaminiMishra-ep6do 3 ай бұрын
Thank you sir helpful video
@shashankchalke4915
@shashankchalke4915 Жыл бұрын
Sir agar mere 8 lakh or muje apne home loan against pre payment kerna hai tho muje janana hai ki mai ek saat 8 lakh ka pre payment karu ya divde kerkai karu jaise 4 lakh abhi or 4 lakh after 3or 4 months... Please advise kijiye.. Thank you. 🙏
@PoojaDas-m7x
@PoojaDas-m7x Ай бұрын
Mera 1800000 lakh ka personal loan chal raha h mai maximum 1 year kitna pre payment kr sakte hai pls reply
@fincalc
@fincalc Ай бұрын
jitna afford kar sakte ho utna kardo, interest save karne ke liye
@kishoredixit5661
@kishoredixit5661 Жыл бұрын
Thank u for your information
@fincalc
@fincalc 8 ай бұрын
Welcome
@kishoredixit5661
@kishoredixit5661 8 ай бұрын
​@@fincalcwhich is the best term and family floater health insurance ?
@afreenfatma5413
@afreenfatma5413 Жыл бұрын
1) How do we take into account subsidy received from pradhan mantri aqas yojna, bank has not reduced the loan amount but adjusted the pmay amount with interest 2) For u der construction property, loan amount is taken as and when they builder demands , so total loan is not disbursed in one go, it is given in parts. How to incorporate this in excel calculator. Emi keeps increasas and when loan is disbursed 3) Rate of interest keeps changing with repo rate
@taddict3203
@taddict3203 2 жыл бұрын
What abou if rate of interest is not fixed??
@VAMSHI_DHAR
@VAMSHI_DHAR 2 жыл бұрын
Followed by same formula
@fincalc
@fincalc 2 жыл бұрын
made another video on floating rate home loan. check here: kzbin.info/www/bejne/aXa0p6aNmaelq7s
@pittalasrikanth788
@pittalasrikanth788 Жыл бұрын
Is there any limit for part payment in terms of amount or Time limit ??
@M0nst3rGamingyt
@M0nst3rGamingyt Жыл бұрын
Depends on bank and type of loan
@raviranjan217
@raviranjan217 3 жыл бұрын
Thanks a lot sir.... You share very informative points.
@fincalc
@fincalc 3 жыл бұрын
Glad it was helpful. Welcome 🙂
@Labakk
@Labakk 2 жыл бұрын
Existing loans Ka tenure Kaisa Kam Karna padega,bank WaLa manega kya
@kajalbodode9651
@kajalbodode9651 2 жыл бұрын
After prepayment tenure will be reduced..so in this case interest rate will be same right as it was on original principle
@maheshmohan4636
@maheshmohan4636 9 ай бұрын
I have this same query did you try ?
@ankitshah7178
@ankitshah7178 3 жыл бұрын
Please make VIDEO ON SWP
@fincalc
@fincalc 3 жыл бұрын
yes sure. stay tuned :)
@fincalc
@fincalc 3 жыл бұрын
Hello Ankit. Here's the video on SWP kzbin.info/www/bejne/Y6SmdGeLmMqKb80 Hope you like it 🙂
@user-gu9qz5ns7v
@user-gu9qz5ns7v 3 жыл бұрын
Sir , Q1.agar ROI 10.4 se 8.8 ho jaye to tenure kam karte hai to kitne mahine ka farak aayega. ?(15Lfor 15yrs ,emi 15581) Q2. Agar ROl 9.4 se 10.4 ho jay means 1%badh jay to tenure and intrest kitne mahine badh jayega? Kyoki ki Q2 ke hisab se NBFC ne mera EMI same rakha hai. lekin Tenure badh Diya hai 2 sal se. Ye kaise hua? Kindly reply..
@hari.hariks
@hari.hariks 2 жыл бұрын
Excel download is not working. Didn't receive the mail
@fincalc
@fincalc 2 жыл бұрын
Email ID?
@hari.hariks
@hari.hariks 2 жыл бұрын
@@fincalc 😔
@fincalc
@fincalc 2 жыл бұрын
@@hari.hariks what is your email ID?
@hari.hariks
@hari.hariks 2 жыл бұрын
@@fincalc Not able to post email ids here
@akhilnair365
@akhilnair365 2 жыл бұрын
Calculator nahi chal rha hai bhai... formulas missing hai. Please check kar lo ek baar
@kirtibhaijoshi9833
@kirtibhaijoshi9833 3 жыл бұрын
सर मेने 18लाख का होमलोन सात सालो का लीया हैं तो मे टेनयुर कम करे या ईमेआई कृपया बताये
@fincalc
@fincalc 3 жыл бұрын
Tenure
@Rahulkumar-xf3jq
@Rahulkumar-xf3jq 2 ай бұрын
Ye kaise pta kre ki emi km hua h ya tenure
@fincalc
@fincalc 2 ай бұрын
loan account me pata chalega online, ya phir bank employee se puch sakte ho kitna tenure bacha hai home loan me
@navverma149
@navverma149 2 жыл бұрын
Sir HDFC is not deposit prepayment
@fincalc
@fincalc 2 жыл бұрын
my friend recently did prepayment in HDFC ltd. Is your loan having fixed interest rate or variable interest rate?
@rajukundu5328
@rajukundu5328 3 жыл бұрын
Sir , maine 14 lakhs home loan 6.95% me 17 yrs ke liya hai, abhi EMI 11690/- Pay karna par raha hai , main abhi har month rs. 20,000/- EMI jama karna cha raha hu , kiya a sahi hoga? aur 20000 pay karne se mera tenure kitna hoga , please reply
@gammembal
@gammembal 2 жыл бұрын
Your Banker will guide you. Approx. It will come down by 5 years.
@Lofi-Life-Love
@Lofi-Life-Love 3 жыл бұрын
I need home loan of 12-15 lackh approx for construction of house but my salary is 19k in hand for now, so that much amount is not possible for me. My father is 58 years old and he is private driver so no salary slip, so how can we take home loan? Is there any option like loan will be sanction on my father's documents but I will clear all the EMI's from my salary?? Please help
@JAIHIND-qg6cq
@JAIHIND-qg6cq 2 жыл бұрын
Prepayment ??Karna chahiye?? Or ??Nahi Karna chahiye??
@PankajKumar-dt9qj
@PankajKumar-dt9qj 2 жыл бұрын
Sir hme home loan lena hai 15 lac Bandhan Bank de rha hai hamko 8.4 percent par Ham 1 lac per year prepament kar sakte hai to hme pradhanmantri awas ka labh milega total salary hamri 4.2lac ke aas pas hai
@fincalc
@fincalc 2 жыл бұрын
ha prepayment kar sakte hai. Loan interest rate variable hona chahiye
@kirtibhaijoshi9833
@kirtibhaijoshi9833 3 жыл бұрын
सर मेने एच ड़ी ऐफ सी 18लाख का होमलोन सात सालो का लीया हैं मे हर महिने 36609/-पे करता हु छ महीने के बाद मे सेवानिवृत्ति होने वाला हु तो मुजे सरकार मेसे मिलने वाला फंड़ से मे होमलोन पुरी तरह से भर दु या मे प्रि-पेमेनट करु कृपया बताये
@fincalc
@fincalc 3 жыл бұрын
Prepayment karke dhire dhire bhar sakte ho
@MdIrshad-nh8dx
@MdIrshad-nh8dx 2 жыл бұрын
Preyment ke baad bacha hua tenure kaise calculate karen
@fincalc
@fincalc 2 жыл бұрын
excel calculator me track karna padega. yaha se excel download karo: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/
@paigamenizami5704
@paigamenizami5704 3 жыл бұрын
Bike loan ka app me bataye
@fincalc
@fincalc 3 жыл бұрын
Bike loan ka video hai link kzbin.info/www/bejne/qmbSd3ynpLN_bLs
@rajeshsahu-ej9pf
@rajeshsahu-ej9pf 2 жыл бұрын
plz send me the excel sheet
@fincalc
@fincalc 2 жыл бұрын
please download excel from here: fincalc-blog.in/home-loan-with-variable-interest-rates-calculation-examples/
@Pushpajain2912
@Pushpajain2912 Ай бұрын
पर्सनल लोन मे भी ऐसे ही होता he
@user-gu9qz5ns7v
@user-gu9qz5ns7v 2 жыл бұрын
Tenure reduced hone pr total account balance bhi kum hota kya? Kindly reply ...
@fincalc
@fincalc 2 жыл бұрын
Yes. Principal balance Kam hota hai prepayment karne pe aur tenure reduce karne pe
@user-gu9qz5ns7v
@user-gu9qz5ns7v 2 жыл бұрын
Thank you
@patildilip2231
@patildilip2231 2 жыл бұрын
Koi loan sasta nahi hai SBI ka home loan 8.55 to 9.05 internet rate 1oct 22 se
@fincalc
@fincalc 2 жыл бұрын
Yes abhi home loan rates badh gaye
@RajuKumar-fr5op
@RajuKumar-fr5op 8 ай бұрын
Hloo
@akashkamble3291
@akashkamble3291 22 күн бұрын
kzbin.info/www/bejne/hpjFY61mgaxrjKcsi=X0PNGOQUE6cc3AnO
@gauravmetkar7853
@gauravmetkar7853 2 жыл бұрын
Hello sir, just now I gave you my email id through link. Plz send me excel sheet to same email id
@fincalc
@fincalc 2 жыл бұрын
while you submit the email ID, you'll get the link to download excel.. Please use that link to download excel sheet. Hope this helps
@akashkamble3291
@akashkamble3291 22 күн бұрын
kzbin.info/www/bejne/hpjFY61mgaxrjKcsi=X0PNGOQUE6cc3AnO
Save LAKHS while paying off LOANS! | Ankur Warikoo Hindi
13:47
Жездуха 41-серия
36:26
Million Show
Рет қаралды 5 МЛН
-5+3은 뭔가요? 📚 #shorts
0:19
5 분 Tricks
Рет қаралды 13 МЛН
Вопрос Ребром - Джиган
43:52
Gazgolder
Рет қаралды 3,8 МЛН
How to save LAKHS on your Home Loan: Complete Guide
24:12
Labour Law Advisor
Рет қаралды 1,8 МЛН
Investing vs Loan Repayment | 2022 | CA Rachana Ranade
17:15
CA Rachana Phadke Ranade
Рет қаралды 728 М.