Home Loan Prepayment | Why You Should Reduce Loan Tenure? Excel Calculation Method

[@fincalc]

More videos: SIP Returns Excel: kzbin.info/www/bejne/b6nOhGqqqJl-rMU Home Loan EMI Excel: kzbin.info/www/bejne/fITFiqJ-drp_npI PPF Calculator Excel: kzbin.info/www/bejne/kH_JiWOohtCVhqs Income Tax Calculator Excel: kzbin.info/www/bejne/o6iQlqV8qr6Vpa8 Loan prepayment Excel: kzbin.info/www/bejne/opqqmJmdgtNorsk Download Income Tax Calculator App: play.google.com/store/apps/details?id=com.rrr.apps.financialcalculator Telegram: t.me/fincalc_tv

[@aakaashgupta-sb9bp]

Ek mathematics k hisab se soch k, i'd say jo amount additional h to pay, wo isliye because loan ka amount jo abhi tak pure nahi diye (out of 30lkh) humare pas kuch aur saal k liye h uska hum interest kamate h. But real life problem is that we are paying extra 1lakh

[@Rjamit007]

Sir kya hum tenure Kam kar sakte hai bank me bata ke Because muze 18 month ka tenure karna tha bank ne galti se 36 months kiya hai Waise bank ko karne ata hai kya ab tenure kam

[@fincalc]

Yes Bank ko bolo emi incr ase karna hai to tenure Kam ho jayega ya phir prepayment kar sakte ho

[@Rjamit007]

Prepayment achha rahega ya emi increase karna achha rahega

[@indian-vi5vb]

Truly a very useful video, thank you so much for such detailed video

[@ravig801]

PMAY subsidy milane ke bad EMI reduce karana chahiye , ya tenure Kam karana chahiye ...? Kisase fayada hoga..

[@rekhah.r.5976]

Pre payment add karne ke badd, appne formula kya change kiya.. Firr se batayo sir

[@vanishkota3772]

Thanks for excel,, all the best

[@pabitraprusty773]

If one person not want to pay Lumpsum amount to prepay loan in initial days and he wants to raise EMI amount 3 to 4 thousands every month. Please explain how much interest amount savings. Please explain in Excel sheet.

[@rihansahu3559]

Sir mujhe ye puchna tha ki agr home loan hm countinue pay kr rhe h fir hme khi se lumsaum amount mila jisee hm dairect home loan ko pay kiya ussse hmara principal to km ho jayega bt emi kyo kam nai hoti same amount hi kyo rhta h kya loan ke samay jo calculation krke emi nikala jata h whi pure smy ke liye rhta h ky

[@snehalgorule7947]

Hi sir agar 40 lakhs ka loan lena hai to 30 years ka lekar 20 me complete kre,ya lete time hi 20 years lena hoga

[@vipulthakor6196]

Sir mein prepayment bhar k installment karva sakta hu ya nahi ? Aisi konsi bank hai jo prepayment amt bharne ke bad install kam kar deti hai please aisi koi bank ka name pataaye Muje bhale hi tenure utna rahe par install kam karvani hai konsi bank aisa karti hai ?

[@Khushi-z1e1f]

Prepayment reduce principle amount or both principle and interest amount

[@mellowvibes7124]

Hello, how do I make sure that my prepayment on SBI home loan is to reduce the tenure of the loan? Thank you for your help!

[@fincalc]

While applying for prepayment you have to mention that you want to reduce tenure and they will do so. It is best practice to keep checking your outstanding principal amount on your loan so that you have the idea of remaining tenure

[@mohdamir5476]

Sir mujhe credit card ki emi me extra payment krna h to kya ye kam krega

[@KorialstraszD]

Hi, one thing you have not considered here is that by reducing EMI it helps you in the present day financials. Even though in total it seems that we are paying 1 lac more by reducing EMI, the value of that 1 lac after 10 years will have reduced because of inflation. Its always better to consider the inflation in that case..

[@fincalc]

You are right to some extent. We can either think this way and keep long tenure to be safe in terms of inflation as well. Other perspective is to close the loan as soon as possible as it is a burden in financial terms. Both perspectives are correct and it depends on individuals choice 👍 In the end we should be happy with our decisions 😀

[@rayeesali9742]

@FinCalc TV PMAY scheme ki amount homeloan account me credit hone k baad kya hume option milta hai k hum EMI ya fir Loan Tenure kam karwa sake aur agar PMAY scheme k amount credit hone k baad tenure kam hota hai toh kya hum humari EMI same rakh sakte ya fir vo badjaegi aap kuch advise kar sakte hai please

[@satishvarma8986]

Hi. Can you share your other excel files which you have discussed in your other videos like PPF Calculator Excel,SIP Returns Excel,20 Years SIP Calculator,etc

[@fincalc]

ok will consolidate all excel files and provide the link

[@satishvarma8986]

@@fincalc please share the Excel Sheet as requested earlier

[@SMRao]

When interest rate is reduced how much tenure will reduce if we keep emi same? Any calculator?

[@fincalc]

you need to use excel calculator to know the actual numbers: watch this video: kzbin.info/www/bejne/fYq2dZyngax9Ztk download calculator from here: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/

[@148riha]

Sir tenure kam karunga to emi amount bhi kam ho jayegi kya?

[@nandkumar53]

Sir prepayment ka formula boliye pl. Mera sub right aa raha hai, but intrest ek hi time kam dikh raha hai after prepayment, o kaise thik karu🙏

[@bluebirdblackbird8911]

I have a query, I have taken 65 lakh loan for under construction property. The builder has demanded time based payment till end 2025 by when pocession will happen. Builder is asking 3 lakhs after every two months. Now I have option to pay some amount directly to builder and then ask bank to diburse the rest amount. For example my builder has till today 25 lakh and I have paid 13 lakh out of my pocket to builder and asked bank to release on remaining 12 lakh. My plan is too pay directly to builder some amount till 2025. So out of 65 lakh loan which sanctioned, I am planning to pay around 25-30 lakh by pocket. Hereby will be taking disbursement of only 35-40 lakh by bank at end of 2025 when procession will happen. My question is what will be emi will it be based on 65 lakh or total actual amount disbursed by bank to builder towards cost of home.

[@infinitex2252]

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.

[@fincalc]

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 🙂

[@sreehariks1347]

Boss how to download the excel file I can’t able to do

[@dwarikadutt1367]

Sir home loan tenure kese km kru

[@sanjaykumar-cw9kx]

2012 me home loan liya tha jiska tenure 15 sal ka hai.ab mai us tenure ko badha sakta hu ya nhi??

[@gopalbehera330]

Which option is better? Paying 40k as emi or 25k emi+15k part payment every month? (That 15k directly towards outstanding every month)

[@gopalbehera330]

Pls help on this

[@gopalbehera330]

Hii pls help

[@fincalc]

40K is better to avoid missing 15K part payment

[@pkgola1996]

Should I increase emi amount or do prepayment, what is better to avoid extra payment to Bank.. Thanks

[@fincalc]

Doing prepayment is good. But if you can afford to increase EMI that will also be good as you'll be saving your interest amount

[@pkgola1996]

@@fincalc could your suggest your video or excel where I can see the difference of how much I can save with this. And I am really happy to see your reply on my comment. Thanks...

[@fincalc]

@@pkgola1996 check this detailed video kzbin.info/www/bejne/rIDVdYCbm7qlesU Hope this helps

[@PanchfulaPrakashan]

Best video

[@fincalc]

thanks

[@theobserver551]

If i take a loan of 18Lakhs and its monthly emi is 23k and tenure is 10 yrs ...after 1year a/c to my emi i will pay approx 2, 62,608 ....if i increase my emi to 28k then what is the change in loan ? Is it reduce my tenure ? I mean after 1yrs my principal ammount will 16lakhs after increase my emi ammount will the bank calculate the amount of my loan from this 16lakhs or the amount of loan will same ( at the starting amount of loan with interest ) ....do i have to pay the previous interest amount ?

[@RAJINDERSINGH-os7np]

Thanks

[@tejashreewadkar2408]

Apaki baat sahi hai but jab RBI repo rate badhata hai tab banks tenure badhate hai to fir kya benefit hoga? Last time hamne offer me 2300 bharkar 48 months ka tenure kam karake liya but bad me jab repo rate badha to hamara emi almost 12 months se badh gaya. Abhi hamne 325000 ka final disbursement liya to hamara tenure 190 months se 247 months hua. Please help how to reduce it? It means hamara emi bhi badha aur tenure bhi badha.

[@shilpaparihar4125]

Can i take personal loan after one year for part payment of loan of about 2 lakh. Personal loan is available at 9 percent for 2 years.

[@fincalc]

But personal loan interest rate will be higher than home loan interest rate right? In this case we should not take another loan for Prepayment

[@monikav9833]

Dear Customer, With the recent changes made by Reserve Bank of India, we have revised our Easy reference rate (ERR). Accordingly, on your Loan A/c No @@@@@@@@Tenure stands revised to 258 months. Sir iska matlab kya h

[@VinodKumar-jl5qr]

Sir, kya kisi bhi month me repayment kar sakte h

[@VinodKumar-jl5qr]

Ya saal me ek baar hi

[@anjaneyulukaka8620]

Shall we pay extra charges for prepayment?

[@fincalc]

yes in fixed interest rate home loan

[@jayeshkarale9118]

@@fincalc how much amt charged by bank...?

[@parthpatel8749]

How to download this excel

[@shyamal82mondalsm]

10 lakh ka home loan 15 sal ka tenure pe lene ke bad agar ek extra har sal de to mera tenure kitne sal mein khatam hoga ?

[@yog146]

Thank you

[@fincalc]

welcome

[@jituky4670]

Personal loan prepayment karne par emi kam hoga ya tenure

[@fincalc]

Koi bhi option choose kar sakte ho

[@ganeshbehera491]

Tenure keise Kom karenge

[@kiranbartwal1866]

Thank you sir

[@fincalc]

Welcome

[@rsjmt2]

Need this calculator please share link

[@fincalc]

yo can download calculator from here: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/

[@sonali.gokani]

Paint the walls grey or yellow for wealth related topics... and an upwards fast growing plant like bamboo or coconut.

[@vishalkanse5374]

But EMI reduce karke jitna amount reduce kiya hai wo saving karke part payment karte hai per year to principle kam hoga and agar principle kam hota hai to intrest bhi kam hoga i am right ??

[@fincalc]

Yes right.. lekin emi reduce karoge to tenure same rahega jiski vajah se interest zyada save nahi ho payega

[@venkatesanr2509]

I get in ten lakhs ten years 12.5 % interested I have reduced tenure or emi which better?

[@dwarikadutt1367]

Sir meri emi jyada ja rhi h fir bhi tenure km nhi ho rha h aisa kyu sir pls reply

[@Ayaan_bhai774]

Good information sir.....

[@fincalc]

thanks

[@Happy_smiles_]

Sir which option is better 1. Take home loan with 15yrs tenure and repay in 15 yrs. OR 2. Take home loan for 30 yrs. And repay within 15 yrs.

[@fincalc]

First option

[@RaghavSharma-ip1lf]

Banks staff ko home loan lene main kitna time lagta hai

[@fincalc]

same time

[@gauravjain1329]

How to download this excel sheet???

[@fincalc]

You can download from here fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/

[@jeetu24x7]

There is no excel sheet.

[@ravirajraut1748]

excel kaha he?

[@fincalc]

drive.google.com/file/d/1OvK_p-3PpMqrsvJp79WOtRRKUjsCDhzH/view?usp=sharing

[@ilove5538]

Bank ne kaha kye home loan tenure kam kara nehi jata.. Aa kya sahi hai

[@fincalc]

galat hai

[@parthmehta801]

Example is good but need to improve explanation part

[@atheistpatriotvschauvinist1479]

Taklif ho seh lenge lkn jab jan pe ban aaye( loan) uska solution jitna jldi kro,,,,,maine apni salary ka 70% loan me diya only 25%15000 me apna ghar chalaya 4 sal me complete,,,,,,loan jitna jldi ho,is musibat ko khtm karo,,,loan ghar)zamin ya shadi me hi le nhi to jlti aag me hanth na dale

[@gauravgupta8007]

Where is excel ??

[@rohitjain4057]

Jaldi se to kar diya but sir apne formula nahi btaya emi kam karne ke liye

[@gauravjakhar8385]

tenure km krne ka formula toh btate

[@fincalc]

Ye video dekho jaha mene saare formulas bataye hai kzbin.info/www/bejne/rIDVdYCbm7qlesU

[@drmdazharuddin9285]

Bhaisab ye solve kar k batana Principle 2000000 ROI 8.6 Year 30 EMI 15550 Ab agar mai every year EMI tReduced karunga not tenure that is 30 yrs only by depositing Pre payment by increasing 10k every year for example 1st year 50k 2nd 60k 3rd 70k 4th 80k 5th 90k 6th 1lakh and so on to mera loan kab or kitna interest dena hoga pls explain in calculator

[@kuhukaushik9497]

EMI na badhao prepayments krte jao yearly ya monthly

[@shiv.775]

SBI tenur कम नहीं करता

[@nabakishore9661]

Wrong information!! Tenure Kam hoga to interest to bachega leking agar job ya business doob gaya to emi kaise bharoge!! Risk factor badh jata hai tenure Kam hone se 😊

[@sudhirkarennavar5238]

Their is a insurance for Home loan upto 6 month they will pay for jobless

[@jeetu24x7]

No excel sheet on your website...won't be watching your videos again..

[@fincalc]

Please check here. Under download excel sheet section fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/

[@bhargavchandra5900]

How to contact you

[@DhananjayKumar-nm8xk]

Are you active in instagram?

[@fincalc]

yes I am active