கடனை வேகமாக முடிக்க உதவும் வழிமுறைகள் | Loan Repayment Calculation (MS Excel) | Tamil
HTML-код
- Опубликовано: 12 сен 2020
- 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!AqsYJ-VmY-g5vAYLw...
---------------------------------------------------------------------------------------------------------------------
Loan Payment Calculator (version.2) - Floating interest rate (Click this link and save the file)
1drv.ms/x/s!AqsYJ-VmY-g5vDI5O...
---------------------------------------------------------------------------------------------------------------------
Google Sheets Link here:
Loan Payment Calculator v.1
docs.google.com/spreadsheets/...
---------------------------------------------------------------------------------------------------------------------
For EMI Calculation, Watch this:
• அறிவோம் தவணைக்கணக்கு |...
Attributions:
Music: www.bensound.com
Icons: iconscout.com/icon/emi-calcul...
icon-library.net/icon/interes...
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 useful calculation sheet and very useful video. Learnt a lot on how everything is calculated. Thanks bro.
சூப்பர் sir பல லட்சம் மதிப்புள்ள காணொளி இது நன்றி
அருமையான விளக்கம் நன்றி 🙏
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.
உண்மையில் மிக மிக பயனுள்ள தகவல் கோடான கோடி நன்றிகள்
பயனுள்ள தகவல் அருமையான விளக்கத்துடன்.
நன்றிகள் பல.
Hello Mr anand. Excellent eye opener of emi calculation.
இந்தத் தகவல் கொடுத்ததற்கு ரொம்ப நன்றி ஐயா எனக்கு மிகவும் பயனுள்ளதாக இருக்கும்
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 😊
Extremely impressive content delivery. Thanks a lot. Its was very useful...
Sir thangs God arumai.plnnitinga.yarukkum idhu theyriyathu.very. Very thx 🙏🙏🙏🙏🙏👍👍👍
Sir, you improved our confidence... Thank you so much
Great Explanation ...never saw such a detailed video like this..Thanks Sago
❤ மிகவும் பயனுள்ள தகவல் மிக்க நன்றி அண்ணா
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 uh explain seitheenga sir.... Kodanu Kodi nandrikal
Excellent, clearly explained the details. Thanks
நல்ல விளக்கம் நன்றி
Thanks bro. Romba theliva soneenga
Super bro
Nalla idea, Nalla Thagaval
Awesome bro super explain ...sathyama ennku eathula evvlo process earukunu thareyala.....
Awesome brother. What a clear explanation. Keep it up. 💯
Vera level anna video iruntha doubts laam clear rompa thank u anna
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...
very clean and clear explaination... thank you for such a video
Very well explained.Thanks a lot...Much appreciated
Super super simple way of easy tips I will follow this ideas.
Vera level bro! Very much appreciated!! 👍
Fabulously explained Anand. Seriously. Sooo helpful. Please keep doing such helpful works.
Very nicely explained bro. Will use the tips you have given.
Your PowerPoint and Excel Skills are awesome Anand Sir👍🏻👌🏻🤓
Really great information.
Very crystal clear.
Excellent video brother.. got clyster clear idea about loan.. please keep uploading such videos. Keep rocking..
Very very useful. Very neatly explained
Excellent job, keep it up. Keep doing it so useful for people like us.
Excellent! Appreciate your efforts.
Excellent video Sir. Clear cut information :)
Vera level explanation sir.... superb. Good work and keep it up
Hai sir,your explanation is very good .i am easily understood what you are trying to explain.thank you so much
Yenna Oru Declaration
Very very Use full content sir really good sir
Really a very good content i watched on youtube after long time thank you
Nalla purigiramathiri solranga sir thank u sir
Super explanation..power of compounding
Super super super !!!
Very clear presentation!! I’m New to ur channel .. but very impressed!!!
Hats off ..
Arumayana vilakkam sir thank u sir
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.
Superb brooo.... Clarity ahh solirukinga..... 👏👏👏
Nidhanam and Thelivana explaination, easily understand by everyone 👍
Super sir very useful sir thank you
Nice simple& very very useful to loan buyers
Very nice video. Useful to all. Thanks Anand sir
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. 🎉🎉
excellent you are eye opener thanks lot
It is very useful to the society. Congratulation.
Very clear explanation....
This is very useful and amazing to hear such a great explanation
Useful video. Kudos to the creator 👍
Very professional ❤️
Excellent Sir... Really Superb..! Useful advise..!! Thank u So..!😊
Romba Nandri anna 🙏 arumiyana pathivu🤝
Great very clear and up to the point.
Thanks for your explanation. Super. Keep posting
Excellent and indepth explanation.....
Very nice sir best approach super explain
excellent explanation. useful for many. . .
Awesome it’s easy to understand 💵
அருமையான பதிவு
Well explained 👍
Thank you 😊
Your expline excellent 👏👌👍
Thank you so much brother
Much helpful information. Thanks.
Clearly explained sir, thanks
Very nice explanation, superb thank you sir🎉
Outstanding explanation brother
Very useful information. Thank u very much
Very very use full bro, thank you so much😉😉😉.
வணக்கம் சார் ரொம்ப நன்றி.
sir excellent explanation thanks a lot......very useful
Sir, Really a good clarification. Thanks.
மிக்க நன்றி 🙏
Romba nanri bro super news
மிக்க நன்றி ஐயா மகிழ்ச்சி
Thank you for valuable suggestion. Really very useful.....
Nice explanation. Thank u sir.
Seme ....ultimate 👏👏👏👏
Thanks for your useful information....
Super explain.Thank u 🎉🎉
Hai sir, very detailed information thank you so much.
Excellent sir
Your a great author
Excellent advice sir thank you for your advice
Mr.anand thanks very useful video and helpful.