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

5.0 (2)

18 learners

What you'll learn

This course includes

2.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Loan Repayment Calculation Loan Pay-off Calculation

Full Transcript

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: https://www.facebook.com/anandexplains Download Excel Worksheet here: --------------------------------------------------------------------------------------------------------------------- Loan Payment Calculator (version.1) (Click this link and save the file) https://1drv.ms/x/s!AqsYJ-VmY-g5vAYLwJ3ouxx98QMR?e=BzC9ew --------------------------------------------------------------------------------------------------------------------- Loan Payment Calculator (version.2) - Floating interest rate (Click this link and save the file) https://1drv.ms/x/s!AqsYJ-VmY-g5vDI5ODk6Y4YzDdMZ?e=bNRG2d --------------------------------------------------------------------------------------------------------------------- Google Sheets Link here: Loan Payment Calculator v.1 https://docs.google.com/spreadsheets/d/16iHGSDNXt6ceuDyhJSaMuOstOKlb297Ff8oZbZfagAw/edit?usp=sharing --------------------------------------------------------------------------------------------------------------------- For EMI Calculation, Watch this: https://www.youtube.com/watch?v=KFe-CdGS_7s Attributions: Music: https://www.bensound.com Icons: https://iconscout.com/icon/emi-calculator-1817364 https://icon-library.net/icon/interest-icon-png-18 DISCLAIMER This channel is for education purposes only and is not affiliated with any financial institution.