- Download my Car 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 “4 Years” if you’re looking for a car loan that you want to repay in 4 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 Car 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.
Note: If you have already downloaded my Personal Loan EMI Calculator workbook, you can continue to use the same workbook for your Car Loan calculations as well.
HI Vinaya,
Keep the blogs flowing….
Home loans- EMI calculator would be usefulll…
Thanks,
Girish
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
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