How to Get Amortization Tables for Car Loans

So you've got your car and are looking for amortization tables for your car loan. You can try to do it yourself by creating a spreadsheet in a budgeting software like Microsoft Excel. There are also many online calculators that you can access, some are free and others cost only a nominal fee. Surfing the Internet will provide you with many choices.

What You Will Need

• Internet access
• Math knowledge
• Spreadsheet software

Using Your Own Software

If you are well versed in software for budgeting like Quicken, Quickbooks or even Microsoft Excel you can surely take care of an amortization table on your own. You will have to plug in the original loan amount and the interest rate. You will have to know the interest rate in order to figure the amortization of your account. Your car loan amortization spreadsheet will have to be setup with the beginning payment date to the end payment date and using formulas you will be able to put in a couple numbers and then copy fields, and allow for the math in the formulas to do their job. Looking online for Excel or other software for amortization templates will help to make this task easier because the formulas have already been created and tested out. Be aware, though, that some of those templates are created by users of the software and not by the manufacturer of the software and may not be 100% accurate.

Using Online Free Amortization Services

When you are surfing the Internet to find an amortization calculator the ones that do not charge are not as extensive as those that you would pay for, however you may be able to gain the information you need by just putting in the purchase price, less the down payment, times the interest rate of the purchase. The online service will then consider the amount of the note, if it is three or five years, or some other time frame and give you a table to work with.

Using Online Paid Amortization Services

As with most online services, you get many more features with a paid online amortization service than with a free one. You are able to put in more inputs. You are able to consider other options like if you pay every two weeks instead of once a month. You can plug in those numbers and gain more accurate information with a paid amortization table. 

Accountants

You can employ an accountant or a financial advisor if you have one available to help you with your amortization schedule as well. They will be able to use their sophisticated applications to give you the most accurate information about your amortization and give you a schedule that can be modified based on changes in interest rate, whether you have paid extra payments against your account or just added a few more dollars to a car note. Financial advisors and accountants have full knowledge of amortizations for any of your purchases and will guarantee their results are accurate, and will fix any flaws that have come up in their work.