- Download my Personal 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 “3 Years” if you’re looking for a personal loan that you want to repay in 3 years’ time.
- You will now find two cells highlighted in yellow — one for the loan amount and the other for the interest rate. You need to provide your inputs in these two cells. Note that changing the data in one sheet will not affect the other sheets.
- The workbook automatically computes your Personal 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.
Hi Vinaya,
Thnx a lot for this xls , I guess I would be saving some 7k buck due to this.
Thnx again
Ankit
Hi Vinaya, This is a fantastic tool. It really works great.
I have been breaking my head with all sorts of formulas to get this bifurcation of Int Principle repayments from an EMI, but your Excel tool is just fantastic.
Thank you AGAIN
Ram
Thanks