- Download my Car Loan EMI Calculator Excel workbook.
- This workbook has six sheets, one each for a loan duration ranging from one year to six years.
- Select the sheet corresponding to the loan duration you’re thinking of. For example: select the sheet labeled “4 Years” if you’re looking for a car loan that you want to repay in 4 years’ time.
- You will now find three cells highlighted in yellow — one for the loan amount, one for the interest rate, and one for the type of EMI payment. You need to provide your inputs in these three cells. Note that changing the data in one sheet will not affect the other sheets.
- The workbook automatically computes your Car Loan Amortization Schedule.
- You can now Save/Print this sheet for your reference.
Let me know if you’re facing any difficulty. Drop a comment if you find this calculator useful.