கடனை வேகமாக முடிக்க உதவும் வழிமுறைகள் | Loan Repayment Calculation (MS Excel) | Tamil

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)
https://1drv.ms/x/s!AqsYJ-VmY-g5vAYLw...
---------------------------------------------------------------------------------------------------------------------
Loan Payment Calculator (version.2) - Floating interest rate (Click this link and save the file)
https://1drv.ms/x/s!AqsYJ-VmY-g5vDI5O...
---------------------------------------------------------------------------------------------------------------------
Google Sheets Link here:
Loan Payment Calculator v.1
https://docs.google.com/spreadsheets/...
---------------------------------------------------------------------------------------------------------------------

For EMI Calculation, Watch this:
   • அறிவோம் தவணைக்கணக்கு | Understanding EMI C...  

Attributions:
Music: https://www.bensound.com
Icons: https://iconscout.com/icon/emi-calcul...
https://icon-library.net/icon/interes...

DISCLAIMER
This channel is for education purposes only and is not affiliated with any financial institution.