Thank you sir for this video. Today visited many icici branch banks for this info. But finally got proper info.
@fincalc8 ай бұрын
Welcome 🤗
@sukanyachauhan965310 ай бұрын
I couldn't find the excel sheet for the loan prepayment. Where is it hidden?
@anuragmanitripathi318110 ай бұрын
Wonderful and very useful Video... Thanks
@manishsinhapatna Жыл бұрын
Bhai super Tarik batata hai ❤❤❤
@fincalc8 ай бұрын
Thanks bhai
@ankitshah71783 жыл бұрын
Very nice thank you for excel file
@fincalc3 жыл бұрын
You are welcome
@seshubabusc11 ай бұрын
very well explained sir...thank you
@fincalc8 ай бұрын
You are most welcome
@viviandas8991 Жыл бұрын
Thank you sir. This is very helpful.
@fincalc Жыл бұрын
Glad it was helpful!
@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.
@fincalc8 ай бұрын
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
@kaustav17128 ай бұрын
@@fincalc thanks for sharing your thoughts. I guess you are right, one shoe does not fit all.
@juyalashish42 ай бұрын
Moreover if you take for a longer period considering money value, EMI will put less burden after 10 years.
@kaustav17122 ай бұрын
@@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.
@nasamind6 ай бұрын
Beautiful explanation, after watching one video, I just hit like and subscribe
@dineshs11802 жыл бұрын
Apki jesi achhi video koi nhi banata
@fincalc2 жыл бұрын
Thank you 👍
@dbw80763 ай бұрын
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?
@Peacekeeper4333 ай бұрын
Sir sbi personal loan me pre payment karna se interest kam hoga. Please reply
@MohammedImran-pz2jc Жыл бұрын
What's same scenario for personal loan amount for 25 lakh , which is the best option to choose EMI or tenure
@amanchhabra3412 Жыл бұрын
I have home loan from sbi. Thinking to prepay some amount. Do they give option to reduce emi?
@fincalc8 ай бұрын
Yes
@johnmarbaniang3160 Жыл бұрын
Without going to bank can I repayment extra emi loan amount through online.
@laxmanpawar9098Ай бұрын
Nice video par mera sumif formula kam nahi kar raha hai please
@roshanjameerbasha98942 жыл бұрын
sir agar 40l ka loan 4 saal mai khatam kar saktha hu tho mai emi kum karna mai mera faidha hai na sir ..
@PkVp-ji1oq8 ай бұрын
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-eb3er3 ай бұрын
Sir hum apni emi increase kare or prepayment option choose kare
@Kafir854310 күн бұрын
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-ep6do3 ай бұрын
Thank you sir helpful video
@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Ай бұрын
Mera 1800000 lakh ka personal loan chal raha h mai maximum 1 year kitna pre payment kr sakte hai pls reply
@fincalcАй бұрын
jitna afford kar sakte ho utna kardo, interest save karne ke liye
@kishoredixit5661 Жыл бұрын
Thank u for your information
@fincalc8 ай бұрын
Welcome
@kishoredixit56618 ай бұрын
@@fincalcwhich is the best term and family floater health insurance ?
@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
@taddict32032 жыл бұрын
What abou if rate of interest is not fixed??
@VAMSHI_DHAR2 жыл бұрын
Followed by same formula
@fincalc2 жыл бұрын
made another video on floating rate home loan. check here: kzbin.info/www/bejne/aXa0p6aNmaelq7s
@pittalasrikanth788 Жыл бұрын
Is there any limit for part payment in terms of amount or Time limit ??
@M0nst3rGamingyt Жыл бұрын
Depends on bank and type of loan
@raviranjan2173 жыл бұрын
Thanks a lot sir.... You share very informative points.
@fincalc3 жыл бұрын
Glad it was helpful. Welcome 🙂
@Labakk2 жыл бұрын
Existing loans Ka tenure Kaisa Kam Karna padega,bank WaLa manega kya
@kajalbodode96512 жыл бұрын
After prepayment tenure will be reduced..so in this case interest rate will be same right as it was on original principle
@maheshmohan46369 ай бұрын
I have this same query did you try ?
@ankitshah71783 жыл бұрын
Please make VIDEO ON SWP
@fincalc3 жыл бұрын
yes sure. stay tuned :)
@fincalc3 жыл бұрын
Hello Ankit. Here's the video on SWP kzbin.info/www/bejne/Y6SmdGeLmMqKb80 Hope you like it 🙂
@user-gu9qz5ns7v3 жыл бұрын
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.hariks2 жыл бұрын
Excel download is not working. Didn't receive the mail
@fincalc2 жыл бұрын
Email ID?
@hari.hariks2 жыл бұрын
@@fincalc 😔
@fincalc2 жыл бұрын
@@hari.hariks what is your email ID?
@hari.hariks2 жыл бұрын
@@fincalc Not able to post email ids here
@akhilnair3652 жыл бұрын
Calculator nahi chal rha hai bhai... formulas missing hai. Please check kar lo ek baar
@kirtibhaijoshi98333 жыл бұрын
सर मेने 18लाख का होमलोन सात सालो का लीया हैं तो मे टेनयुर कम करे या ईमेआई कृपया बताये
@fincalc3 жыл бұрын
Tenure
@Rahulkumar-xf3jq2 ай бұрын
Ye kaise pta kre ki emi km hua h ya tenure
@fincalc2 ай бұрын
loan account me pata chalega online, ya phir bank employee se puch sakte ho kitna tenure bacha hai home loan me
@navverma1492 жыл бұрын
Sir HDFC is not deposit prepayment
@fincalc2 жыл бұрын
my friend recently did prepayment in HDFC ltd. Is your loan having fixed interest rate or variable interest rate?
@rajukundu53283 жыл бұрын
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
@gammembal2 жыл бұрын
Your Banker will guide you. Approx. It will come down by 5 years.
@Lofi-Life-Love3 жыл бұрын
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-qg6cq2 жыл бұрын
Prepayment ??Karna chahiye?? Or ??Nahi Karna chahiye??
@PankajKumar-dt9qj2 жыл бұрын
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
@fincalc2 жыл бұрын
ha prepayment kar sakte hai. Loan interest rate variable hona chahiye
@kirtibhaijoshi98333 жыл бұрын
सर मेने एच ड़ी ऐफ सी 18लाख का होमलोन सात सालो का लीया हैं मे हर महिने 36609/-पे करता हु छ महीने के बाद मे सेवानिवृत्ति होने वाला हु तो मुजे सरकार मेसे मिलने वाला फंड़ से मे होमलोन पुरी तरह से भर दु या मे प्रि-पेमेनट करु कृपया बताये
@fincalc3 жыл бұрын
Prepayment karke dhire dhire bhar sakte ho
@MdIrshad-nh8dx2 жыл бұрын
Preyment ke baad bacha hua tenure kaise calculate karen
@fincalc2 жыл бұрын
excel calculator me track karna padega. yaha se excel download karo: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/
@paigamenizami57043 жыл бұрын
Bike loan ka app me bataye
@fincalc3 жыл бұрын
Bike loan ka video hai link kzbin.info/www/bejne/qmbSd3ynpLN_bLs
@rajeshsahu-ej9pf2 жыл бұрын
plz send me the excel sheet
@fincalc2 жыл бұрын
please download excel from here: fincalc-blog.in/home-loan-with-variable-interest-rates-calculation-examples/