How to Calculate the Loan Amortization Schedule (EMI, Principal, and Interest Components) for Your Personal Loan?

  1. Download my Personal Loan EMI Calculator Excel workbook.
  2. This workbook has six sheets, one each for a loan duration ranging from one year to six years.
  3. 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.
  4. 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.
  5. The workbook automatically computes your Personal Loan Amortization Schedule.
  6. 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.


3 Responses to “How to Calculate the Loan Amortization Schedule (EMI, Principal, and Interest Components) for Your Personal Loan?”


  1. 1 Ankit Sharma Jul 27th, 2008 at 3:17 pm

    Hi Vinaya,

    Thnx a lot for this xls , I guess I would be saving some 7k buck due to this.

    Thnx again

    Ankit

  2. 2 Ram Jul 28th, 2008 at 10:07 pm

    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

  3. 3 Mahesh Aug 6th, 2008 at 4:04 pm

    Thanks


Subscribe

Subscribe to my RSS Feeds

Get new posts in your Inbox

Enter your email address:

Delivered by FeedBurner




Creative Commons License

This work is licensed under a Creative Commons License.