கடனை வேகமாக முடிக்க உதவும் வழிமுறைகள் | Loan Repayment Calculation (MS Excel) | Tamil
ฝัง
- เผยแพร่เมื่อ 12 ธ.ค. 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.
உண்மையிலேயே மிக பயனுள்ள காணொளி சகோ... நன்றி! ❤️🔥
தமிழ் வார்த்தைகளும் அதன் உச்சரிப்பும் அருமை....
மிக்க நன்றி திரு ஆனந்த்...மிகவும் தெளிவான விளக்கம் கொடுத்துள்ளீர்கள்.
Thank you for This good video is this applicable for all bank
It depends on the banks and their terms&conditions.
❤ மிகவும் பயனுள்ள தகவல் மிக்க நன்றி அண்ணா
சூப்பர் sir பல லட்சம் மதிப்புள்ள காணொளி இது நன்றி
Very nice video. Useful to all. Thanks Anand sir
Super Sir very useful message just now we have started our home loan this may help us a lot thank you.
அண்ணா,,,,என்ன சொல்ல ...வார்த்தையே வரல,,,,,உங்களுக்கு கோடானுகோடி நன்றிகள் ....
நன்றி
Very very useful. Very neatly explained
Yenna Oru Declaration
Very very Use full content sir really good sir
Super super simple way of easy tips I will follow this ideas.
Sir excellent uh explain seitheenga sir.... Kodanu Kodi nandrikal
Fabulously explained Anand. Seriously. Sooo helpful. Please keep doing such helpful works.
நல்ல விளக்கம் நன்றி
Awesome bro super explain ...sathyama ennku eathula evvlo process earukunu thareyala.....
Very neatly explained.
Hats off
Wish your channel many more success.🙏🙏
Sir, you improved our confidence... Thank you so much
Nice simple& very very useful to loan buyers
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...
Dedicated work clear explanation 👌
Hai sir,your explanation is very good .i am easily understood what you are trying to explain.thank you so much
Super super super !!!
Very clear presentation!! I’m New to ur channel .. but very impressed!!!
Hats off ..
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.
This is very useful and amazing to hear such a great explanation
Super explanation..power of compounding
It is very useful to the society. Congratulation.
Vera level anna video iruntha doubts laam clear rompa thank u anna
Thanks bro. Romba theliva soneenga
Superb brooo.... Clarity ahh solirukinga..... 👏👏👏
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.
Nidhanam and Thelivana explaination, easily understand by everyone 👍
Super sir very useful sir thank you
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.
Vera level explanation sir.... superb. Good work and keep it up
Great Explanation ...never saw such a detailed video like this..Thanks Sago
Great explanation 👌👌👌👌video of the year
Extremely impressive content delivery. Thanks a lot. Its was very useful...
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 😊
Very clear explanation....
Simple and great presentation bro
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. 🎉🎉
Really a very good content i watched on youtube after long time thank you
Very nicely explained bro. Will use the tips you have given.
Excellent and indepth explanation.....
Excellent video helped me a lot
Rembha mukkiyama na video poturikinga.. it will help many people.
Excellent sir your a great Teacher sir
Very clearly explained sir...thanks
Sir what a explanation ... awestruck.
விவரித்த விதம் அருமை.மிகவும் உதவியாக உள்ளது.வாழ்த்துகள்.,.!!
Sir great sir. U have given eye opening to people who want to get loanhow to safeguard . Var mun kappathu. Great sir.
Thanks!
Thank you for valuable suggestion. Really very useful.....
Very useful calculation sheet and very useful video. Learnt a lot on how everything is calculated. Thanks bro.
super bro, it helps me a lot. Thank you so much.
Thanks sir very very useful information sir I will try sir nan ipa than loan vankiruken sariyana time la than unga vedio parthiruken sir
Mr.Anand...Thank you so much for your valuable information...
Very good explain I need your advice. How to close car loan early
Excellent, clearly explained the details. Thanks
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. 👍
sir excellent explanation thanks a lot......very useful
Great very clear and up to the point.
Sir, I have got more useful information from you, thank you so much sir.
Very professional ❤️
Very useful information. Thank u very much
Your PowerPoint and Excel Skills are awesome Anand Sir👍🏻👌🏻🤓
அருமையான பதிவு சார்.ரொம்ப நன்றி சார் மற்றும் ஆங்கில புத்தாண்டு வாழ்த்துக்கள் சார் 🙏🙏🙏
நன்றி நண்பரே🙏🏼 புத்தாண்டு வாழ்த்துக்கள்!!
Bro very good 😁
I have clean explaination for u r channel only
Mr.anand thanks very useful video and helpful.
நண்பரே அருமையா தெழிவ படுத்தினீங்க
Sir, Really a good clarification. Thanks.
Super pa great this method is very useful
Very well explained.Thanks a lot...Much appreciated
congratulations good work. Nice explanation. Keep it up
It's more useful. Thank u.
Thank so much bro very very valuable information
very clean and clear explaination... thank you for such a video
Excellent Sir... Really Superb..! Useful advise..!! Thank u So..!😊
Very useful information sir. Thanks
Vera level bro! Very much appreciated!! 👍
Your expline excellent 👏👌👍
Thank you so much brother
Excellent video brother.. got clyster clear idea about loan.. please keep uploading such videos. Keep rocking..
excellent you are eye opener thanks lot
Useful video. Kudos to the creator 👍
excellent explanation. useful for many. . .
Very very use full bro, thank you so much😉😉😉.
Nalla purigiramathiri solranga sir thank u sir
Thanks for your explanation. Super. Keep posting
Sir thangs God arumai.plnnitinga.yarukkum idhu theyriyathu.very. Very thx 🙏🙏🙏🙏🙏👍👍👍
Thanks for your useful information....
Arumayana vilakkam sir thank u sir
Learned a lot bro thanks
Sir very thank for you
Please house loan quick
Solved a idea given. God
Blessings you. Valka valamudan.
VALARKA nalamuduan.
Very good explanation.