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

by Vinaya HS on June 30, 2008

in Finance

  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.

Further reading:

  1. Tip Tuesdays: When’s a Good Time to Pre-close a Personal Loan?

{ 19 comments… read them below or add one }

1 Ankit Sharma 07.27.08 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 Ram 07.28.08 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 Mahesh 08.06.08 at 4:04 pm

Thanks

4 F Saxena 08.31.08 at 1:21 pm

hi
I am actually in search of EMI calculator for House Loan . Do u have ? if so please post i on my mail ID.

thanks

FS

5 Chandra 11.04.08 at 10:39 am

Extremely useful. Many thanks
Chandra

6 Sagar Mahindra 11.06.08 at 1:02 am

Thanks a Lot Vinaya this was extremly helpful the calculator cleared some doubts as to how the intrest is calculated on car loan and home Loan, also information on wrapping-up procedures after loan is good.

Good Stuff….Thanks Again

Regards,

Sagar Mahindra

7 Mohan 11.07.08 at 11:04 pm

Good easy, readymade one to copy and paste. tks

8 vivek gupta 02.06.09 at 10:30 pm

a useful tool on amortizaton and loans, especially useful for students and common man.

9 Mahesh Konda 03.31.09 at 7:18 pm

Hi Vinaya,

This EMI Calculator is very useful. Thanks….

Regards,
Mahesh

10 Harjinder Singh 04.01.09 at 2:10 pm

Very handy & useful tool thanx for the help. I have query as i wanted to apply for personal loan from more than one bank can it be possible as i wanted big amount.

11 Abhishek Dwivedi 04.18.09 at 2:09 am

Simply great!

12 Avinash 04.27.09 at 9:49 am

I need the personal load calc. fo fixed rate / flat rate rather than reducing balance. Can you please point me to right calc. or send me the same?

13 Anant 07.23.09 at 2:17 pm

thks it really helped me to re-consider the loan options

14 Rajesh 11.27.09 at 5:53 pm

Hi Vinaya,

Provided excel is really helpful.
Just for info. Can we bifurcate EMI amount into Principal & Interest by formula?

Thanks & Regards,
Rajesh.

15 Satish 12.11.09 at 6:24 pm

Hi Vinaya,

Your excel sheet is fantastic.

Thanks you very much

16 Sagar 01.19.10 at 4:53 pm

Thanks you for such a useful tool.

Thanks,
sagar.

17 boloroo 02.21.10 at 2:28 pm

hello… thank u .. its very useful… could u tell me how to calculate if payment is made from the second year…

18 aricept 06.15.10 at 3:34 pm

Where it is possible to buy the, http://www.nojazzfest.com/chat/member.php?u=6319 aricept, 8(,

19 shweta 07.12.10 at 3:48 pm

Thanks Vinaya! :)

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Previous post:

Next post: