கடனை வேகமாக முடிக்க உதவும் வழிமுறைகள் | Loan Repayment Calculation (MS Excel) | Tamil
Vložit
- čas přidán 12. 09. 2024
- Here, this video explains the workings of Amortization Table (EMI Schedule) and calculated approach to pay off your loan quickly. It will be helpful for you to analyze your loan payments and how to pay it off quickly. This calculation applies to all kind of loans such as home loan, bike loan, car loan, education loan, and personal loan.
#Loan #Payoff #Tips
Content:
00:10 Introduction
00:52 Loan calculation example
SECTION 1:
02:11 Amortization Table (EMI Schedule)
03:27 Workings of Amortization Table
SECTION 2:
06:19 How to pay off the loan quickly - Intro
06:33 Loan Duration
07:43 Never miss an EMI payment
08:44 Atleast pay interest amount
09:56 Part-payment
11:43 Pay one extra EMI every year
13:28 Increase EMI by 5% or 10% every year
SECTION 3:
14:38 Summary
15:53 End credits
Contact:
/ anandexplains
Download Excel Worksheet here:
---------------------------------------------------------------------------------------------------------------------
Loan Payment Calculator (version.1) (Click this link and save the file)
1drv.ms/x/s!Aq...
---------------------------------------------------------------------------------------------------------------------
Loan Payment Calculator (version.2) - Floating interest rate (Click this link and save the file)
1drv.ms/x/s!Aq...
---------------------------------------------------------------------------------------------------------------------
Google Sheets Link here:
Loan Payment Calculator v.1
docs.google.co...
---------------------------------------------------------------------------------------------------------------------
For EMI Calculation, Watch this:
• அறிவோம் தவணைக்கணக்கு |...
Attributions:
Music: www.bensound.com
Icons: iconscout.com/...
icon-library.n...
DISCLAIMER
This channel is for education purposes only and is not affiliated with any financial institution.
NEW LOAN CALCULATOR is updated with loan disbursements inputs. You can do loan calculation based on the disbursed loan amount as well. Link is given in the description. Please check it out!
Anand sir, V3 is not downloadable as it consumes high size. pls check and rectify and help us.
Hi sir, Unable to open V3 version from onedrive. Error is coming : Sorry, we can't open your workbook in Excel Online because it exceeds the 25 MB file size limit. Please upload it in some other portal and provide the link
Hi Mr.Anand, Pl give download link for loan calculator.
Will b handy . Tq
@@kiruthikathiru9384 V3 calculator has been fixed and is working now. Feel free to use it.
@@dineshkumarkmk The problem with V3 is fixed. Link is given in description. You can use and download the file.
sir, உண்மையில் தங்களுக்கு கோடி நன்றிகள் ஐயா.
Excellent sir, I barrow 40 lakh in hdfc, now I am struggling due to the pendamic situation. Now this is very useful for me. Really much appreciated sir. Thank you❤🌹🙏
உண்மையிலேயே மிக பயனுள்ள காணொளி சகோ... நன்றி! ❤️🔥
Honestly, this calculation was very helpful for me. Thanks brother.
அண்ணா,,,,என்ன சொல்ல ...வார்த்தையே வரல,,,,,உங்களுக்கு கோடானுகோடி நன்றிகள் ....
நன்றி
Very neatly explained.
Hats off
Wish your channel many more success.🙏🙏
Hello Mr.Anand.. This is very useful and amazing to hear such a great explanation.. a big eye opener for all of us who are really struggling to plan for loan prepayment.. I never came across this sort of clarification and just after I done with your video I became your subscriber. Thank you so much for your support.. Wish you all success 😊
Anybody interested in the worksheet used in the video. You can download it using the link in the description. To support us, please SUBSCRIBE to the channel.
Hi sir
Please help me
@@1kshorts605 If you have any questions, let me know.
Ya
Really great applause for your work. Even though I don't have emi or idea to take. It helps many who are trapped in loan.
இந்தத் தகவல் கொடுத்ததற்கு ரொம்ப நன்றி ஐயா எனக்கு மிகவும் பயனுள்ளதாக இருக்கும்
Hello Mr anand. Excellent eye opener of emi calculation.
உண்மையில் மிக மிக பயனுள்ள தகவல் கோடான கோடி நன்றிகள்
தமிழ் வார்த்தைகளும் அதன் உச்சரிப்பும் அருமை....
Super bro... U said pay 13 installments instead of 12 in a year, one more small suggestion is that, that 1 extra installment v r planning to pay at the end year could be distributed in all the 12 installments in a year which also vl give a huge change... Try that too frnds...
மிக்க நன்றி திரு ஆனந்த்...மிகவும் தெளிவான விளக்கம் கொடுத்துள்ளீர்கள்.
பயனுள்ள தகவல் அருமையான விளக்கத்துடன்.
நன்றிகள் பல.
New updated LOAN PAYMENT CALCULATOR is available here. It includes floating interest rate option. Link is given in the description box. Please check it out!
Thanks Anand, even in the bank/other sites, we are not getting this detailed report. Thanks a lot for wonderful service. Your way of explanation is good.
நன்றி
Hi Anand sir, Is it possible to make excel sheet according to dispersal amount? Bank use to disperse partial payment not one time payment.
@@senthilkumar-hk4cl Yes, it is possible to include that in excel sheet. I will include this loan disbursement option in next upgrade. Thanks for the suggestion!
neenga edit panra mathiri ung excel sheet ah edit panna mudiyalai...
protected sheet ah irukku
சூப்பர் sir பல லட்சம் மதிப்புள்ள காணொளி இது நன்றி
Very Good explanation Mr.Anand 🙂Thanks much for the spread-sheet which is very useful for every borrower. Looking for more such videos. Thanks again for your great support. All the very best. 👍
Good Explained and even bank employees also never tell this kind tips,it will helpful for all middle class people,thank you so very much.
❤ மிகவும் பயனுள்ள தகவல் மிக்க நன்றி அண்ணா
Fabulously explained Anand. Seriously. Sooo helpful. Please keep doing such helpful works.
Superb video sir. Thanks a lot for ur dedicated guidance to common people. Clear and good explanation with examples made understanding easier amd interesting. Thank u sir. 🎉🎉
Your PowerPoint and Excel Skills are awesome Anand Sir👍🏻👌🏻🤓
Thank you very much, but i have missed it earlier, anyhow its an eye opening for me, thank you once again Sir. God bless you.
Very useful calculation sheet and very useful video. Learnt a lot on how everything is calculated. Thanks bro.
Super Sir very useful message just now we have started our home loan this may help us a lot thank you.
Extremely impressive content delivery. Thanks a lot. Its was very useful...
Sir, you improved our confidence... Thank you so much
Nidhanam and Thelivana explaination, easily understand by everyone 👍
Super sir very useful sir thank you
Super super simple way of easy tips I will follow this ideas.
Hai sir,your explanation is very good .i am easily understood what you are trying to explain.thank you so much
Vera level anna video iruntha doubts laam clear rompa thank u anna
Awesome bro super explain ...sathyama ennku eathula evvlo process earukunu thareyala.....
Yenna Oru Declaration
Very very Use full content sir really good sir
Sir na ivlonaal theditu irunthathu intha explanation tha. But personal loan. Thank you so much for this sharing... I asked anyone who works in a bank or related private sectors also having no idea about it. Nice video thanks a lot
Sir can you send this worksheet please
@@anithaanitha8932 You can find the excel worksheet in the description of the video. You can download it.
Great Explanation ...never saw such a detailed video like this..Thanks Sago
Hi Anand , Please Clarify this For NRI - HDFC bank, SBI bank, Indian Overseas bank
1. How many times we can pay the Part payment in the tenure? Any conditions when we have to start to pay the part payment?
2. How much amount we can pay for part payment? Is there any limit or no limit?
Awesome brother. What a clear explanation. Keep it up. 💯
Rembha mukkiyama na video poturikinga.. it will help many people.
Super super super !!!
Very clear presentation!! I’m New to ur channel .. but very impressed!!!
Hats off ..
Very nice video. Useful to all. Thanks Anand sir
Very very useful. Very neatly explained
Sir excellent uh explain seitheenga sir.... Kodanu Kodi nandrikal
விவரித்த விதம் அருமை.மிகவும் உதவியாக உள்ளது.வாழ்த்துகள்.,.!!
Dedicated work clear explanation 👌
Thanks sir very very useful information sir I will try sir nan ipa than loan vankiruken sariyana time la than unga vedio parthiruken sir
Thank you for This good video is this applicable for all bank
It depends on the banks and their terms&conditions.
Very nicely explained bro. Will use the tips you have given.
Excellent video brother.. got clyster clear idea about loan.. please keep uploading such videos. Keep rocking..
நல்ல விளக்கம் நன்றி
Sir thangs God arumai.plnnitinga.yarukkum idhu theyriyathu.very. Very thx 🙏🙏🙏🙏🙏👍👍👍
Vera level explanation sir.... superb. Good work and keep it up
Bro amortization table ku formula konjam solunga plz so that enoda loan ku calculate panika use aagum nd your explanation is 👌👌👌👌👌👌very useful.
Amortization table calculation indha video'la full'a explain panneerukkean. Please watch this: czcams.com/video/KFe-CdGS_7s/video.html
Excellent, clearly explained the details. Thanks
Superb brooo.... Clarity ahh solirukinga..... 👏👏👏
This is very useful and amazing to hear such a great explanation
Nice simple& very very useful to loan buyers
Sir great sir. U have given eye opening to people who want to get loanhow to safeguard . Var mun kappathu. Great sir.
Thanks!
Very professional ❤️
It is very useful to the society. Congratulation.
அருமையான பதிவு சார்.ரொம்ப நன்றி சார் மற்றும் ஆங்கில புத்தாண்டு வாழ்த்துக்கள் சார் 🙏🙏🙏
நன்றி நண்பரே🙏🏼 புத்தாண்டு வாழ்த்துக்கள்!!
THANK YOU BRO VERY WELL AND CLEAR EXPLAINED.
BRO AS MY SUGGESTION..
- LOAN REPAYMENT EXCEL SHEET YEPPADI READY PANNURADHU NU EXPLAIN PANNA ROMBA HELPFULL LA IRUKKUM
Sir, I have got more useful information from you, thank you so much sir.
very clean and clear explaination... thank you for such a video
உங்களின் சேவை மிகவும் சிறப்பாக உள்ளது. இந்த calculation sheet copy செய்து வேறு எக்செல் ஷீட்ல amount, intrest rate change panni செய்ய முடியுமா?. அப்படி இருந்தால் please reply and option சொல்லுங்களேன்
Calculation sheet'யை பதிவிறக்கம் செய்து பயன்படுத்திக்கொள்ளுங்கள். பதிவிறக்கம் செய்ய File >> Save as >> Download a copy.
Great explanation 👌👌👌👌video of the year
Very good explain I need your advice. How to close car loan early
Super explanation..power of compounding
Really a very good content i watched on youtube after long time thank you
Hello Mr. Anand, First of all thanks for an excellent explanation. you have shown floating interest rate option in attached file. in that you have made EMI as constant. what I done was, I made a prepayment and adjusted EMI and not reduce the turner. Is this benefit for me. 2)how to calculate in graph about breakeven for interest and principle amount for any method of payment. this will help us to know where we are standing
Yes, I kept the EMI column locked in the floating rate calculator. You can tweak the number in the extra payment column to your requirement. Yes, you can keep the tenure constant, so your monthly EMI will be reduced.
Regarding graph, I will soon update the calculator accordingly.
Thanks for your support. Glad it helps you out.
Thanks bro. Romba theliva soneenga
Vera level bro! Very much appreciated!! 👍
Very clear explanation....
Excellent job, keep it up. Keep doing it so useful for people like us.
Your expline excellent 👏👌👍
Thank you so much brother
Mr.Anand...Thank you so much for your valuable information...
excellent you are eye opener thanks lot
Excellent Sir... Really Superb..! Useful advise..!! Thank u So..!😊
நண்பரே அருமையா தெழிவ படுத்தினீங்க
Very well explained.Thanks a lot...Much appreciated
Bro very good 😁
I have clean explaination for u r channel only
Sir it is very usefull msg for me i received this msg in the right time thank you
Thanks for your explanation. Super. Keep posting
அருமையான விளக்கம் நன்றி 🙏
Very nice explanation, superb thank you sir🎉
Sir very thank for you
Please house loan quick
Solved a idea given. God
Blessings you. Valka valamudan.
VALARKA nalamuduan.
Thank you for valuable suggestion. Really very useful.....
Sir, EMI schedule prepared by bankers and ecs or e-mandate obtained from borrowers bank account then how we increase the principal or interest amount ? Please explain 🙏
Spr anna clear aa explain panninga , intha excel epdi potinganu sollunga
Mr.anand thanks very useful video and helpful.
Points are very clear. Requesting you to post the videos related to share market.
Sure, I will do share market related videos.
Very very use full bro, thank you so much😉😉😉.
Excellent and indepth explanation.....
Really very useful sir.tnq SIR
sir excellent explanation thanks a lot......very useful
Excellent sir your a great Teacher sir
very useful information sir. Please explain how to calculate the duration, the number of payments, and the money saved table in excel
Sure I will
@@AnandExplains thank you sir.waiting for your explanation
Thanks for your useful information....
Nalla purigiramathiri solranga sir thank u sir