கடனை வேகமாக முடிக்க உதவும் வழிமுறைகள் | Loan Repayment Calculation (MS Excel) | Tamil
Вставка
- Опубліковано 22 сер 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. Excellent eye opener of emi calculation.
மிக்க நன்றி திரு ஆனந்த்...மிகவும் தெளிவான விளக்கம் கொடுத்துள்ளீர்கள்.
Very nice video. Useful to all. Thanks Anand sir
சூப்பர் sir பல லட்சம் மதிப்புள்ள காணொளி இது நன்றி
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 😊
Thanks for your support!!
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...
Super super simple way of easy tips I will follow this ideas.
Dedicated work clear explanation 👌
Super Sir very useful message just now we have started our home loan this may help us a lot thank you.
Vera level anna video iruntha doubts laam clear rompa thank u anna
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. 🎉🎉
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 very useful. Very neatly explained
அருமையான பதிவு
Fabulously explained Anand. Seriously. Sooo helpful. Please keep doing such helpful works.
Sir excellent uh explain seitheenga sir.... Kodanu Kodi nandrikal
Thank you for This good video is this applicable for all bank
It depends on the banks and their terms&conditions.
Yenna Oru Declaration
Very very Use full content sir really good sir
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.
Sir, you improved our confidence... Thank you so much
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.
Your PowerPoint and Excel Skills are awesome Anand Sir👍🏻👌🏻🤓
Hai sir,your explanation is very good .i am easily understood what you are trying to explain.thank you so much
சூப்பர் பிரதர்
Very clear explanation....
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.
Very nice sir best approach super explain
Thanks bro. Romba theliva soneenga
Nice simple& very very useful to loan buyers
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 bro super explain ...sathyama ennku eathula evvlo process earukunu thareyala.....
Nidhanam and Thelivana explaination, easily understand by everyone 👍
Super sir very useful sir thank you
Rembha mukkiyama na video poturikinga.. it will help many people.
Sir, I have got more useful information from you, thank you so much sir.
Very useful calculation sheet and very useful video. Learnt a lot on how everything is calculated. Thanks bro.
Extremely impressive content delivery. Thanks a lot. Its was very useful...
Very good explain I need your advice. How to close car loan early
விவரித்த விதம் அருமை.மிகவும் உதவியாக உள்ளது.வாழ்த்துகள்.,.!!
Thanks sir very very useful information sir I will try sir nan ipa than loan vankiruken sariyana time la than unga vedio parthiruken sir
Super super super !!!
Very clear presentation!! I’m New to ur channel .. but very impressed!!!
Hats off ..
வணக்கம் சார் ரொம்ப நன்றி.
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 thank for you
Please house loan quick
Solved a idea given. God
Blessings you. Valka valamudan.
VALARKA nalamuduan.
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
நண்பரே அருமையா தெழிவ படுத்தினீங்க
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.
This is very useful and amazing to hear such a great explanation
Seme ....ultimate 👏👏👏👏
Very nicely explained bro. Will use the tips you have given.
Superb brooo.... Clarity ahh solirukinga..... 👏👏👏
Sir thangs God arumai.plnnitinga.yarukkum idhu theyriyathu.very. Very thx 🙏🙏🙏🙏🙏👍👍👍
Very professional ❤️
அருமையான பதிவு சார்.ரொம்ப நன்றி சார் மற்றும் ஆங்கில புத்தாண்டு வாழ்த்துக்கள் சார் 🙏🙏🙏
நன்றி நண்பரே🙏🏼 புத்தாண்டு வாழ்த்துக்கள்!!
உங்களின் சேவை மிகவும் சிறப்பாக உள்ளது. இந்த calculation sheet copy செய்து வேறு எக்செல் ஷீட்ல amount, intrest rate change panni செய்ய முடியுமா?. அப்படி இருந்தால் please reply and option சொல்லுங்களேன்
Calculation sheet'யை பதிவிறக்கம் செய்து பயன்படுத்திக்கொள்ளுங்கள். பதிவிறக்கம் செய்ய File >> Save as >> Download a copy.
Excellent, clearly explained the details. Thanks
It is very useful to the society. Congratulation.
Mr.anand thanks very useful video and helpful.
Really very useful sir.tnq SIR
Awesome brother. What a clear explanation. Keep it up. 💯
Excellent sir your a great Teacher sir
Sir great sir. U have given eye opening to people who want to get loanhow to safeguard . Var mun kappathu. Great sir.
Thanks!
Great Explanation ...never saw such a detailed video like this..Thanks Sago
Super explanation..power of compounding
Thanks you so much very use full
Excellent sir
Your a great author
Really great information.
Very crystal clear.
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 🙏
Vera level explanation sir.... superb. Good work and keep it up
அருமையான விளக்கம் நன்றி 🙏
Really a very good content i watched on youtube after long time thank you
Spr anna clear aa explain panninga , intha excel epdi potinganu sollunga
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
excellent you are eye opener thanks lot
Thanks for your explanation. Super. Keep posting
very clean and clear explaination... thank you for such a video
Nalla purigiramathiri solranga sir thank u sir
Sir it is very usefull msg for me i received this msg in the right time thank you
Sir, your video is very useful for us. How to excel formula apply for prepayment calculation in excel sheet.
Arumayana vilakkam sir thank u sir
Bro formula eppad set paniga atha oru video pannuga bro athu romba uselfull irukkum
Kandippa antha video panra bro. Thanks!
Thanks for your useful information....
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😉😉😉.
super bro, it helps me a lot. Thank you so much.
Excellent video helped me a lot
Bro very good 😁
I have clean explaination for u r channel only