Old Sep 18, 2007 | 03:53 AM
  #7  
darkshadow's Avatar
darkshadow
Junior Member
 
Joined: Sep 2007
Posts: 1
Likes: 0
Default RE: Serious question here need financial experts opinion

Hi McDonald,

Do you have excel? It comes with a template for calculating loan payments. Very handy! What I usually do is put the "loan amount" in as a formula so I can change variables and see how it effects the payments. Example: instead of a loan amount of aprox. 25k, I would enter it as =(45000-4000) * 7.75 -20000

That is 45k price minus a trade in times sales tax. Then, subtract your down payment. The spreadsheet will calculate monthly payments. You can then adjust loan length and see what a 3 yr, 4 yr, and so forth would actually cost.

Also very handy for deciding between a rebate or special financing because it shows you what the "cost" of the loan in interest is.

...not that there will be any rebates or financing...
Reply