Finance

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

Posted Vinaya HS
  1. Download my Car 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 “4 Years” if you’re looking for a car loan that you want to repay in 4 years’ time.
  4. 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.
  5. The workbook automatically computes your Car 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.

22 thoughts on “How to Calculate the Loan Amortization Schedule (EMI, Principal, and Interest Components) for Your Car Loan?”

  2. Many people that are in the market for a new or used car check out auto loans online. Applying for auto loans online gives you the opportunity to stay in the comfort of your own home while also saving time. Many people have their own bank or lending institution where they do all their banking business from checking and savings to loans. While this may be convenient, your bank may not be giving you the best possible deal. If you’re thinking of checking out a new bank, you’ll have to take time away from your busy schedule to go there, fill out an application and meet with a lender. Although this may not seem like something that takes a lot of time, if you’re checking at a couple different banks, it may take time. If you’re an employee that works during the day time, you’ll either have to lose time from work to see a lender or rush during your lunch hour.

    Applying for auto loans online can be done at your convenience, whether it’s morning, afternoon or the middle of the night. There are many different sites on the web that offer auto loans online. It’s relatively easy to apply for auto loans online, too. Although each site may be slightly different, they are all going to have a lot of similarities. You’ll choose which state you’re from and be given an online form to fill out. The form will request personal information such as your name and address. You’ll also need to fill out information on the auto you are thinking of purchasing, including the price. Once you fill out all the important information, you submit the form. You will be notified by email a list of different lending institutions along with what their loan terms are. As I said, it’s a very simple procedure.

    There are other online sites that offer you the opportunity to apply for auto loans online through a specific lending company rather than a site where you have no idea who you are doing business with. This is the day and age of the internet and more things are being done online every day. Getting auto loans online is just one of the many online transactions.

    Applying for auto loans online is often an opportunity for someone with less than perfect credit to obtain a loan. Many of the online lending institutions will give loans to poor credit individuals. The catch is that they charge a higher than normal interest rate. While this is not an ideal situation, it works well for those that couldn’t otherwise get an auto loan.

    Read more at http://loan.seuamigodopeito.com

  3. I wanted to say thanks for providing the Amortization schedule.
    Your Amortization schedule Excel sheet was immensely helpful for me to check the affect of part prepayments on my EMI/Duration etc..

    This is my first visit to your blog and it is very interesting and has lot of useful information. Thanks again

  5. Hi Its very good working on excel sheet. But as u are aware in india, interest rates are changing and people are also making downpayment. People also have choice of keeping the EMI same and extending the term longer. Can we manage to do this in excell sheet as this workings. so that individual can see and check various options before reachig the bank. In a way if it is possible in excell sheet then it is going to be lacs of favours in fellow india borrowers who really finds it difficult to make a choice about options perticularly in home loan.

  7. Ihave purchased honda city car under your lone A C LUCHD14027646B BEFORE FINALISE THE DEEL YOUR REP TOLD ME THAT YOUR EMI CONE NEAR 2600. OR 2700. PER LAC
    I SIRPRIES TO KNOW THAT THE EMI WAS TO HIGH THIS HAPPNE BECAUSE YOUR PEP GIVE SMALL BENIFET Y TO YOUR DEALER I APROCSED EVERTY CORNER OF YOUR BANK EVEN COMPLANTE BUT NO RESPONSE HAVE COME FROM YOUR BANK I OBGERV THAT EVERTY PERSON MAKING FOOL TO COSTMER OF YOUR BANK EVEN COSTMER CARE IF YOU ALSO CANT DO ENYTHING KINDLY REFER THIS MALE TO HIGHER OFFICER

    HOPE YOU WILL REPLY

  12. Hi,

    First of all thanks for the spread sheets (EMI and Tax calculators).

    Would like to know if these exists similar spread sheet, which will give the remaining loan amount if we need to repay the amount before schedule. For e.g. if EMI is 9595/- and we pay 50,000/- this month, how it would get adjusted etc.

    Appreciate your help.

  13. Hi Vinaya
    Your car loan EMI calculator is very useful.
    Now SBI is offering a car loan with 10% for 1st year and 12% for the sussequent years.
    i.e. If I take a 5 year loan, It will be 10% for initial 12 installments and 12% for the balance 48 installment.

    HDFC bank is offering a loan at 12% interest rate.

    How can i compare which one is beneficial

  18. Thanks Vinaya…

    Really a useful tool to calculate …Make it more customizable ( As some banks now a days are offering diffrerent slabs on yearly basis ).

    Eg : Bank A with offer of 8% for first year & 10/12% for 2nd/3rd year or even coming up with more typical equations.

  20. You have only Monthly reducing rate, adding yearly and daily, quarterly reducing rate option would make it even better.Fantastic tool by the way.
    Could also add a Company lease vehicle, Lease break calculation, like include the VAt that will be applicable when the lease is closed 1,2,3,4 years before normal lease term

Leave a Reply