How to Calculate your Car Loan installment? (Excel)

Car Loan Installment Calculator – Excel (download)

Literally everyone I know has a car in Dubai ! Many of them bought the cars for the sake of convenience. Buying car is an exciting moment for the whole family.

I asked few of them as to how much did it cost? And I found out that an average family saloon car in  Dubai can cost anything between 30000 Dirhams to 120000 Dirhams! That’s a lot of money. Many of them prefer the tried and tested brands such as Toyota, Nissan, Honda; and they are right! These are the companies that produce good quality vehicles.


Few Startling Facts

I also came to know a startling fact from these same friends!!

Around 95% of them had a bank loan tied to their cars!! Meaning, they did not actually own the car by paying cash upfront; but had purchased a loan against the cars. Cool!

I went on to ask a further question: “What is the interest rate / profit rate?”

I saw blank faces! 60% of them did not exactly know what the interest rate was!!

Well, my queries did not stop at that point! I asked them another question…..”Is the interest rate quoted, Reducing BalanceOpens in a new tab. or Flat interest rateOpens in a new tab.?”

This was a bouncer!

Most of them did not know what Reducing Balance or a Flat rate of interest was. And some of them were BANKERS!!

I thought, when bankers themselves did not know what this was, I was not surprised about lay men!

What is a Reducing Balance Interest Rate?

Under reducing balance interest rate, the interest is charged on the reduced principal outstanding each month after you pay the monthly installment. Meaning, if your total principal outstanding is 50000 Dirhams and you have paid 3000 as monthly installment, the interest for the coming month’s installment is charged on 47000 (50000 minus 3000).

What is a Flat Interest rate?

Under Flat interest rate, the interest is charged on the entire loan amount and then this amount is divided by your number of installments.

Banks in UAEOpens in a new tab. – How do they treat Interest Rate on Car Loans?

When it comes to Car loans in UAE, most of the banks quote the interest rate in Flat Rate. Car Loan or Auto Loan is a lucrative business for Banks and Finance companies in UAE. Hence, there is a huge and cut-throat competition among banks.

How to calculate your Car Loan installment?

Below Excel has installment calculator, which will help you with calculation of your car loan installment.

Precautions you must take before making a decision for a Car Loan

  1. Make sure that you know and read the terms and conditions of the loan agreement
  2. Ask the bank what is the interest rate they are charging- Reducing Balance interest rate or Flat Interest rate
  3. Get everything in writing!
  4. Ask HUNDRED times for the best rate!!
  5. Shop around with many banks and finance companies rather than a single bank.

Hope this Car loan installment helps you in making better decisions.

To download the Calculator in Excel format, visit this postOpens in a new tab. or Download hereOpens in a new tab..


Deepak is a passionate blogger with interests in bitcoin, online marketing, and writing.

5 thoughts on “How to Calculate your Car Loan installment? (Excel)

  1. hi sir,
    i am finished contract already with my employer this March 2015,and just waiting for them to cancel my visa..Last Dec. 2014 to Jan.2015 my company send me to Jakarta to train people with separate salary amount and allowance, aside from that amount I’m still entitled to receive my regular monthly salary from my company.. The problem was I already finish my contract to them,but still they’re not giving my pending salary from Jakarta.They only pay me the allowance, but the salary always got the answer that still on process..I’m afraid I wont be able to get that big amount after they cancel me..Is there any possible way that I can fight for my rights..Thanks and more power

    1. Josh,
      Better to keep in touch with your HR as this is company internal matter.

  2. hi sir,i finished my 5 years contract here in i am waiting for my company to cancel me,i also trying to look and seek for a new job..i found 1 employer and i had interviewed already but i have’nt signed any offer later from the new employer.he ask for the copy of my passport and 3 pieces of photos,sir i just want to ask,?its okay to give a copy of passport and photos for new employer even i am not yet cancelled from my recent company..?

    1. Josebelle,
      You could ask the new employer to not apply for any approvals.
      Once your current visa is cancelled, then they could apply for any new approvals.

  3. Dear Loan Seekers,
    We are Cheng Loans Finance! We offer loans to Individual & Companies in need of financial assistance (Loan) at 2% interest rate for the duration of 1 to 25 years. Do you need a loan without stress or delay? Have you been turn down by your local banks? We offer International & Local Loans to interested clients for the amount of $5,000 USD to $100,000,000 USD OR (EUR, GBP, KWD, SGD, MYR), apply with us and get your loan approved without stress: Interested person should contact us via E-mails: {[email protected]} OR {[email protected]}

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts