அறிவோம் தவணைக்கணக்கு | Understanding EMI Calculation and Amortization Table (MS Excel) | Tamil
Автор: Anand Explains
Загружено: 2020-04-28
Просмотров: 45802
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...
Attribution:
Music by: http://instrumentalsfree.com
DISCLAIMER:
This channel is for education purpose only and is not affiliated with any financial institution.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: