Detailed Description of Auto Loan Calculator 2010 free
Auto Loan Calculator is 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.
Auto Loan Calculator's Microsoft Excel workbook contains three different worksheets:
1. Use the Auto Loan Calculator worksheet to calculate the amount you will need to finance, based on the sales price of the car, destination charge, fees, sales tax, down payment, cash rebate, and trade-in value of an older auto.
2. Use the Payment Calculator worksheet to create an amortization table based on the auto loan amount, annual interest rate, term of the loan, and payment frequency. See how making extra payments can help you pay off your car loan early and reduce the amount of total interest paid.
3. The third worksheet (Loan Comparisons) takes the inputs from the loan payment calculator and creates graphs showing you how different interest rates, number of payments, or the amount of down payment affect the monthly payment and total amount of interest.
Using the Auto Loan Calculator
Information about how to use the loan calculators are contained within the spreadsheet itself, mostly as cell comments. Basically, you just enter values in the white-background cells, and see what happens to the other numbers. In the Payment Calculator, you can also enter values in the yellow cells (the Extra Payments column). The spreadsheet has been left unlocked, to give you complete freedom to modify it as needed for your personal use.
Auto Loan Calculator is designed for: WinXP,Win2000,WinServer,WinVista,WinVista x64
Auto Loan Calculator has the following requirements :
Microsoft Excel?? 2002(XP), 2003, or 2007
TAGS OF AUTO LOAN CALCULATOR
tape calculator ,
gas price calculator ,
hours calculator ,
auto tunes ,
logic gate calculator ,
online diet calculator ,
date calculator ,
scintific calculator ,
loan calculator ,
log book calculator
|