The free Auto Loan Calculator for Excel helps you plan your next car purchase. Calculate the amount you will need to finance, based on sales price, destination charge, fees, sales tax, down payment, cash rebate, and trade-in value of an older auto. Use the Payment Calculator worksheet to create an amortization table based on the amount you've financed. Analyze different loans to choose a suitable monthly payment and minimize the total interest.
What's new in this version:
This version is the first release on CNET Download.com.
For free financial calculators (budgets, amortization schedules, etc.) the Vertex42 is great. I am an above-average Excel user, and appreciate that I don't have to do these myself. All of the ones I've used, also work in OpenOffice.org, which is great since that's what I use on my Mac (I also use it in Excel on my PC).
For someone who doesn't understand spreadsheets, it could be frustrating and also confused, especially if the user tries to modify anything. The only thing I find frustrating is on the debt reducer calculator, when inserting or deleting line items. It seems I'm having to re-do some things manually.
In spite of a few frustrations, I love these spreadsheets and have been using them for several years. Vertex42 will continue to be a "favorite" on my PC and MAC.
Well - organized, easy to understand and use. Attractive but simple layout.
Must own MS Access.
This is a very cool calculator with an easy-to-understand layout. I ran across it by accident, downloaded it and found it to exceed my expectations. Very useful for doing 'what if' calculations you need to do to figure out what you can afford or what financial options would be best for you. Put it on your mini-laptop and take it with you to the dealer. It will drive them crazy.
It's a smart method to use spreadsheets as a simple mean of calculating and displaying the results of such an important financial desicion as taking a car loan. The interface is selfexplanatory and for the greter part simple. It says that the file works only in newer Excell, but I have found that OpenOffice.org Calc (at least the version I use: 2.0.2) also manage it.
It can be difficult to use some of the functions whithout proper knowledge about spreadsheets. The author recognize this however, and suplement links for learning about what is needed. But still it can be quite frustrating to battle whith it. It is also surprisingly narrow in it's use: one could argue that any kind of loan (particurlary big ones such as for houses or cars) is important to evaluate and compare. Certainly that is still possible in this spreadsheet, but in some cases it might force you to make changes in how the spreadsheet works, and that's not always easy.