Car Loan Calculator - Works Well on PDA
#1
Pole Position
Thread Starter
Join Date: Sep 2006
Location: CA
Posts: 242
Likes: 0
Received 0 Likes
on
0 Posts
Car Loan Calculator - Works Well on PDA
Attached is a simple loan calculator that you can use to estimate total cost of purchase, total interest and most importantly, monthly payments. It's in Excel format and if you have a PDA (Microsoft PocketPC or Windows Mobile) it's a great tool to have when you're at the dealer.
I modified it from a calculator I found on http://www.carbuyingtips.com/ which happens to be an excellent resource for potential buyers.
Here are the variables you need to change:
State Sales Tax Rate (%) - You need to include taxes and fees here as well. I find that adding about 1% to your sales tax is pretty accurate. For example, I'm in Los Angeles county, CA so my sales tax is 8.25% of the vehicle so I use 9.25% in this field.
Selling Price of car - Cost before any miscellaneous taxes and fees
Rebate - Enter any manufacturer rebates
Down Payment - Up front $$ out of pocket. You can use this field for your trade-in value instead if needed.
Adjustment (+/-) - Use this field for added costs such as an extended warrantee or additional options at the time of purchase. This field is slightly confusing. If you pay $2200 for an extended warrantee, enter the number as a negative value (-2200).
Loan Years - Enter number of years
Interest Rate (APR) - Enter interest rate
Hope this helps all the prospectives out there!!
I modified it from a calculator I found on http://www.carbuyingtips.com/ which happens to be an excellent resource for potential buyers.
Here are the variables you need to change:
State Sales Tax Rate (%) - You need to include taxes and fees here as well. I find that adding about 1% to your sales tax is pretty accurate. For example, I'm in Los Angeles county, CA so my sales tax is 8.25% of the vehicle so I use 9.25% in this field.
Selling Price of car - Cost before any miscellaneous taxes and fees
Rebate - Enter any manufacturer rebates
Down Payment - Up front $$ out of pocket. You can use this field for your trade-in value instead if needed.
Adjustment (+/-) - Use this field for added costs such as an extended warrantee or additional options at the time of purchase. This field is slightly confusing. If you pay $2200 for an extended warrantee, enter the number as a negative value (-2200).
Loan Years - Enter number of years
Interest Rate (APR) - Enter interest rate
Hope this helps all the prospectives out there!!
Thread
Thread Starter
Forum
Replies
Last Post
lexi4darin
CL of Southern California
22
05-23-06 10:55 AM
auto, calculator, canada, car, generations, lexus, loan, online, payment, pda, powered, price, understanding, vbulletin, works