Basic Finance - நிதிக்கல்வி - அறிவோம் தவணைக்கணக்கு | Understanding EMI Calculation and Amortization Table (MS Excel) | Tamil

This video has information on how to calculate EMI using MS Excel Spreadsheet. It also has details of how you can create Amortization Table on your own. Hope this videos helps you out understanding the basics of EMI/Loan repayment calculation. Error Correction: 2:42 When substituting the interest rate in the formula, the value is not 0.833, it should be 0.00833. Since 0.83 is percentage value, when you use this as an integer in the formula it should be 0.00833. Contents: 0:18 EMI calculation (Reducing Balance EMI) 5:39 Amortization Table Excel Worksheet EMI Calculator: (To download, click this link and save the file) https://1drv.ms/x/s!AqsYJ-VmY-g5vDYWt_3BAJw5HG2Y?e=HhNKof Attribution: Music by: http://instrumentalsfree.com DISCLAIMER: This channel is for education purpose only and is not affiliated with any financial institution.