More videos: SIP Calculator: kzbin.info/www/bejne/b6nOhGqqqJl-rMU Home Loan Prepayment: kzbin.info/www/bejne/opqqmJmdgtNorsk 20 Years SIP Returns: kzbin.info/www/bejne/ZmmbhGWQoJymj7c Income Tax Calculation: kzbin.info/www/bejne/o6iQlqV8qr6Vpa8 PPF Calculator: kzbin.info/www/bejne/kH_JiWOohtCVhqs
@rishibasu055 ай бұрын
very easy to understand and i was able to do the calculations quite easily . Only one thing that you may want to add - most bank add a charge if you want to pre-pay loan in the first 24 months of loan tenure, around 5% of the outstanding principal at the time of pre-payment. That amount should be taken into consideration as then the total savings at the end is reduced. But still one still gets the benefit of decreased tenor and some savings definitely.
@alokranjansingh20 Жыл бұрын
A well explained video. Your way of explaining is excellent. Thank you so much 😊
@fincalc Жыл бұрын
thank you so much for your comment :)
@S.AJohnson8 күн бұрын
JESUS BLESS YOU AND CROWN 👑👑 YOU THIS YEAR WITH**""HIS BLESSINGS """** AMEN AMEN AMEN FOREVER
@satyendraambegaonkar86652 жыл бұрын
Best video on car loan repayment
@fincalc2 жыл бұрын
Glad you liked it
@NikhilSharma-mu8vt2 жыл бұрын
Best video I have ever seen on loan calculation thanks helped a lot🤩
@fincalc2 жыл бұрын
Glad it was helpful. Share with your friends 👍🙂
@NikhilSharma-mu8vt2 жыл бұрын
@@fincalc already did😊
@jaythakkar81178 ай бұрын
Amazing content 🙏🏻❤️
@fincalc8 ай бұрын
Thank you 🙌
@SanjeevKumar-yl2fw22 күн бұрын
Very much informative vedio. I appreciate
@fincalc20 күн бұрын
Glad it was helpful!
@hexabuddy4938 Жыл бұрын
there no availbe excel file for download
@DrDevinderBirSingh2 ай бұрын
👍very clearly explained in simple words
@VKlifeenjoy Жыл бұрын
Very informative video
@ankitjha9245 Жыл бұрын
Very informative video, thank you so much for sharing such a nice content in easy language.
@drrojarathodmbbsmsog19953 ай бұрын
Very well explained
@MasterinTechnologywithAjay7 күн бұрын
Grant vitara Lena hai. Down payment 5 lakhs ka hai. Email 50 k , is that fine. please suggest me some good idia to save money
@SonuRapstar9 ай бұрын
Maan lo hum 100000 prepayment ki jagha fd me bhi invest kr dete h to 3 saal me 7% se 21000/- rs earn kr sakte hai aur ye hi same amount hum prepayment krte h to uspe 5% charges bhi paid krna padega then uske baad jo saving interesy bachega lagbhag same ho jayega.... To kaan ek taraf se pakdo ya dusre side se baat same hi hai... 😂 Thank you for your informative video...
@ijustfoundit7864 ай бұрын
Zero fee pre payment
@VishalKumar-gb2if2 жыл бұрын
Sir kindly share the information about how to get back TCS which paid while buying new car, in income tax rebate
@sumitpetkar93003 ай бұрын
It's useful, thanks for sharing.
@biplabnaik7086 Жыл бұрын
Great bro......
@KhanMedicalHall-z5d9 ай бұрын
sir maine 6 lack ka ncar loan liya tha 8.75 % ki dar par 5 year ke liye uss 5 emi bhar di abh main 2lack pre payment karna chahta hu to mere ko kitna benifit ho ga 13000 pe month eme hai
@afa340 Жыл бұрын
I buy car in 2020 December,for 7 years tenure,and pricipal i paid was 80k,now currently in 2023 my intrest amount is 4424,so my question is if i deposit more money in my loand account like EMI+50000,will it benifit me if i do it once . please help
@JaspalKaur-d9u29 күн бұрын
Kitne din bad prepayment kar sakte hain kuch din hafte ya mahino bad
@fincalc23 күн бұрын
yes 1-2 mahine baad kar sakte
@shoaibdefy2 жыл бұрын
Sir.. Please give the excel sheet for simple interest.. For a bank employee taking loan from its own bank..
@karthikgln2 жыл бұрын
Good Information Bro, Thanks for sharing from AP.
@6387vickypatel Жыл бұрын
Pre-Payment me EMI kam karvane se koi benefit hoga ya Tenure kam karvane se benefit hoga?
@thejack003710 ай бұрын
Tenure
@umangsharma6902Ай бұрын
OD account or C.C loan working capital loan excel pr vedio banao
@monicatunar94492 жыл бұрын
Dos Muje ek Tata 407 Lena hn... down payment 5lakhs 4yrs ki emi Diya hua hn kse calculate kare
@sarvjeetsingh2407 Жыл бұрын
From the link not being able to download excel calculater.. After filling name n email id asking failed to submit contact administrator
@shariqqureshi739210 ай бұрын
In some time I am financing my car, so two things i am focused on force closure (there are some penalties+ GST) and secondly part payment possible after 1st year only that too maximum 25% on principal, and a bank employee said part payment will minimise your tenure but actual interest will be 2-3% higher on given ROI, so conclusion if u taking loan for 3 years so pay in 3 years or else your given interest rate will be higher as in beginning they'll take their profit(interest) and last emi are mainly your principal (which is like your real money you borrowed) bankers aren't fool to let you win this battle... If 9% ROI you had in beginning will end up 14-15% easily if you force close. All above knowledge I got in few days before applying loan, and I may be wrong... Please correct me, as safer side I am taking some 6-12 months longer duration for pay back... But I'm sure I'll get rid of loan way earlier.
@fincalc10 ай бұрын
why 9% rate will increase to14-15% rate? if it happens due to rise in interest rates than it's fine but if happening due to prepayment than increase in rate is incorrect
@kirankumarsp154 ай бұрын
Hi, Could you share me the car loan Excel Sheet.
@bhavinsoni98382 жыл бұрын
Hello sir mera 48 year ka lone hai but exel me 35 tak hi a raha hai 48 tak kase kr help kr dona
@sskk15033 жыл бұрын
please guide me. if prepayment of all amount ,we done after 6tn month. is it good ?
@fincalc3 жыл бұрын
yes that would be great to close your loan account
@aksharabodduna97192 жыл бұрын
One thing here confirm 5 month me prepayment 50000 add kiya na 5 month ka emi bi pay karna hi kya.. Ex: 15899.87 + 50000 I think only 50000 isme se emi cut hoga right . So here we adding 34100.13
@fincalc2 жыл бұрын
no, EMI is separate, 50,000 separately add karke loan amount kam kar sakte ho
@aksharabodduna97192 жыл бұрын
@@fincalc iam not finding calulater
@aksharabodduna97192 жыл бұрын
@@fincalc @FinCalC TV 50000 prepayment karvaneke badh 3 maine bach gaya.. 16000×3 EMI = 48000 .. What was we getting extra benefit here < in 32 month princple amount is 1247 and we r paying full EMI for this 1247 amount Thoda sa confuse kindly clear
@fincalc2 жыл бұрын
@@aksharabodduna9719 ye video dekho home loan ke related hai. Lekin car loan ke liye bhi applicable hai kzbin.info/www/bejne/rIDVdYCbm7qlesU
@kapilsharma60462 жыл бұрын
dhanyawad bhai
@fincalc2 жыл бұрын
Welcome
@Forbhaskarm075 ай бұрын
Link to download Excel file brings the control back to the same page. There is no Excel to download.
@fincalc5 ай бұрын
fill this form to download car loan excel calculator: fincalc-blog.in/car-loan-emi-calculation-method-india-excel-video/#htoc-download-car-loan-emi-calculator hope this helps
@onkarsingh46512 жыл бұрын
Thank you bro❤
@ithemickey3 жыл бұрын
Car loan EMI calculator does not include pre payment option. Could you please share the link to download the Excel of Car loan with prepayment .
@fincalc3 жыл бұрын
updated the file with prepayment option. please check fincalc-blog.blogspot.com/2021/09/car-loan-emi-calculation-method-India-excel-video.html
@ithemickey3 жыл бұрын
@@fincalc Thanks a lot
@fincalc3 жыл бұрын
@@ithemickey no problem 👍🙂
@ramessharma2 жыл бұрын
@@fincalc excel file download krne to do direct video ni chaiye... file ka link do direct
@mastivlogs8717 Жыл бұрын
Sir.. Please give the simple interest.. taking loan 2nd car loam . from its own bank.
@shobhaterdal2719 Жыл бұрын
Sir, car loan income tax exemtion hota hai ya nahi
@sellychandan2 жыл бұрын
I have given pre payment of my car load. But still I am seeing the duration and emi value not change in my bank account.how long it will take
@fincalc2 жыл бұрын
It should change once the prepayment amount is processed.. probably by next working day of prepayment. Please check with bank
@ajayojha6219 ай бұрын
Sir car loan 7 year ka h 5 year m close kr sakte h
@rajeshkumarsingha81296 ай бұрын
Thank you so very much sir ji... 🙏😇😴🧠🤴👸👋👌🤝☂️👏🇲🇰💯🇮🇳🎓🎂🎉🎁🌈❤👑
@fincalc5 ай бұрын
Most welcome
@amansrivastava3081 Жыл бұрын
prepayment charges agar ho to kaise karenge??
@NinadKhaire2 жыл бұрын
Really usefull content! 🙏
@fincalc2 жыл бұрын
Glad it was helpful!
@bharathk54412 жыл бұрын
Hi sir How to fix EMI values same for tenure can you help me out what is the excel formula how to fix
@fincalc2 жыл бұрын
You can copy the value of emi and paste in the remaining cells throughout tenure
@NishantSingh-oq5ci2 жыл бұрын
ish month car loan liya ...agle mahine mei kuch paisa hone pr prypayment krne mei kya fayda h.
@ktvyas3 ай бұрын
Download ka link hi nahi aarha website pe
@sandeepsharma91733 жыл бұрын
Car loan auto debit h to kya hum monthly kuch extra pay kr skte h agr ha to kaise kre kyunki loan to auto debit h
@fincalc3 жыл бұрын
Bank me jakar extra payments kar sakte hai
@ashokdhruw83262 жыл бұрын
Sir sbi se home loan liya hu one month emi due ho gya hai but salary nhi dal paa rha hai
@mehulsonara19642 жыл бұрын
Awesome
@antriksh85718 ай бұрын
Excel sheet link
@fincalc5 ай бұрын
fill this form to get excel fincalc-blog.in/car-loan-emi-calculation-method-india-excel-video/#htoc-download-car-loan-emi-calculator
@AnimalsCasa2 жыл бұрын
Bhai..15.03 minute me jo aapne bola 28th month me hi loan khatam ho jayega. Loan or interest nil ho jayega? Principal amount bhi Zero ho jayega kya? Nice video.
@amitsinha65725 ай бұрын
Prepayment me penalty lagta hai.. wo kon consider krega?
@zachariahanse102 жыл бұрын
I paid 2lakhs to showroom for down-payment Car loan amount rs. 538349 So how to calculate The interest takes 15% ? So please
@ashishjain23454 ай бұрын
information is good but your calculator is not downloaded
@singhsubash95622 жыл бұрын
Personal lone ka batadeje
@fincalc2 жыл бұрын
ye video dekho kzbin.info/www/bejne/mpK2qISdbrR1qas
@Mdwasim05903 жыл бұрын
Prepament ke charge bhi to lagta hai
@tanazkapadia6192 жыл бұрын
Ek bat samajh nahi aayi agar mene 50000 ka pre payment kiya to Mujhe last ke 3 installment nahi bharne pade Matlab Aprox. 48000 bahe To 12000 ka saving kaise hua
@travelpartner76198 ай бұрын
Hi Can you please send that excel sheet file Thanks in advance
@fincalc5 ай бұрын
fill this form to download excel: fincalc-blog.in/car-loan-emi-calculation-method-india-excel-video/#htoc-download-car-loan-emi-calculator
@deenuist2 жыл бұрын
sir Car EMI excel calculator is not open
@fincalc2 жыл бұрын
Check again
@teji0111 Жыл бұрын
unable to download car loan calculator from ur site.... pls resolve the issue and update
@fincalc Жыл бұрын
issue is solved now, please check. thanks for informing
@puneetsharma99629 ай бұрын
But You haven't explain the difference if we reduce the EMI instead ??
@gauravgautam48322 жыл бұрын
But sir, pre repayment penality ka kya ??
@pankajsaikia71902 жыл бұрын
Sir 910000 rupees loan me kitna emi hona sahiye 7.6 interest rate me..
@pankajsaikia71902 жыл бұрын
Traneur 5 years ka
@fincalc2 жыл бұрын
Car loan calculator check Karo EMI ke liye. Link: fincalc-blog.in/car-loan-emi-calculator/
@pankajsaikia71902 жыл бұрын
Sir mera emi 20930 bola he per month. Is it correct
@pankajsaikia71902 жыл бұрын
Lekin emi calculator me 18278 per month but dealer se bola 20930 per as per interest rate 7.6 per annum
@fincalc Жыл бұрын
@@pankajsaikia7190 dealer ko pucho emi kaise calculate Kiya hai? Kyuki 18278 correct emi hai
@deenuist2 жыл бұрын
from were download
@sahibsinghmarwah68722 жыл бұрын
Bht kahani bnatey ho sedhi bat ki vedio bnya kriye u hv good potential
@fincalc2 жыл бұрын
Theek hai dhyan rakhunga 👍
@josnaparmar6741 Жыл бұрын
Hum log 1 month ke bad 850000 ka sweft dizair lene wale finance bank se or down payment 200000 hai to kya hum every 6 mouth 50000 extra pay karenge to PESA bachega kya hamara
@letmeknowmore6697 Жыл бұрын
NOT FIND EXCEL FILE FOR CAR LOAN
@devilboyz52384 ай бұрын
Bhai 50000 deke 3 mahine ka EMI kum hogya but agar mai nahi deta 50000 to 45000 hi dena padta vo bhi 15000 per month to kya faida hau 50000 ka prepayment karne ka
@ZainZain-ei7ho3 ай бұрын
5th mahine ka emi 15899+ last 3 month emi Dhononko milake hisab karke dheko bhai
@ZainZain-ei7ho3 ай бұрын
Fahida hai
@shubhendrasingh99212 жыл бұрын
But you did't consider the PENALTY on PrePayment and +GST, Like SBI took 1% Penalty + GST on PrePayment, ,, Saving will not be 12342 at @13:30 ,,, According to me Saving will be 12342 - 9500=2842 ,, (I just took example of SBI ),, Correct me if I am wrong ? 50000*(1% Penalty + 18 % GST )=9500
@ashwinkumarmaurya44122 жыл бұрын
18% gst will be on penalty of 500 not 50k i think
@harshalshekharjha56692 жыл бұрын
Foreclosure kitne time me Kiya tha,Anyday foreclosure after 2yrs has NO penalty. Was the timeline before 2yrs?? Or after?? Agreement me kya mentioned tha???
@d-wamps6218 Жыл бұрын
You are right
@bhuphendrasinghchandrawat40347 ай бұрын
Agar fix ho to kya kre
@CrazeVideoz2 жыл бұрын
There is no excel file available for download
@fincalc2 жыл бұрын
you can download car loan excel from here fincalc-blog.in/car-loan-emi-calculation-method-india-excel-video/
@JaspalKaur-d9u16 күн бұрын
Bhai pre payment karne se to ulta zyada pesa dena pad rha h zara dhyan do ki 1 lakh pay karne k bad loan bhi to kam ho jaega na 4 lakh ka or phir use total payable amount se less karo to 552000-400000=152000 isse to pehle kam interest lag rha tha only 72000. Plz explain😮
@arpitsingh10229 ай бұрын
Meri bank ma to pre payment ka option hi nhi hai
@rohanpawar9395 Жыл бұрын
very complicated.
@pradeepkumar-ds8kq2 жыл бұрын
Value drag nhi hoti esme
@sonukumar16233 жыл бұрын
अशोक लीलैंड बड़ा दोस्त पर वीडियो बनाइए
@MehulShihora2 жыл бұрын
Nahi ho raha he bhai download
@fincalc2 жыл бұрын
yaha se try kiya? fincalc-blog.in/car-loan-emi-calculation-method-india-excel-video/#htoc-download-car-loan-emi-calculator
@noormasalewale1418 Жыл бұрын
Itna excel me magz mari krne se Acccha emi calculator download kr lo
@RajinderSingh-wu4wf2 ай бұрын
Itna pkka kyu rha h
@josnaparmar6741 Жыл бұрын
200000 download paymant hai or 15300 60 emi hai please gide me how to i pay pre paymant
@josnaparmar6741 Жыл бұрын
Ripley me please
@AmitSingh-hy2ekАй бұрын
Prepayment pr bhi interest bol rhi hai bank 2.5 lgga agr kroge to aise me kya krna chhiye
@riteshpoza2 жыл бұрын
Repayment schedule of bank and your excel does not match. Please help me. I can mail it you. Please give me your mail ID.
@simranmalka21512 жыл бұрын
Sir mane car loan par li thi 4 saal tak ki kishat thi abhi 4 month ho chuke ha mane time par kishat di thi or mane loan close karwana ha oske bare me jaruri baat karni thi apse apna number send krna sir