Setting a car loan

Mike or Penny Novack stepbystepfarm at mtdata.com
Sat Feb 21 14:45:53 EST 2015


> • Your Payment Frequency (monthly?) monthly
> • Bank's Required Monthly Payment Amount $299.11
>
> Car was purchased on 12/22/2014.  First payment was due on 2/5/2015.
>
>>
>>> I tried to set up my car loan in Gnucash and the calculated monthly 
>>> payment
>>> doesn't match what the bank says I owe.  Gnucash says the monthly 
>>> payment
>>> should be $294.78, but the bank makes me pay $299.11.
And there you have it (the explanation you got before "sometimes the 
banks..."

HOW did you set up the program's amortization to account for the extra 
days in that first "month"? I bet you didn't. In fact, I doubt the 
programs even offered doing the calculation for 60 monthly payments 
preceded by one of 45 days.  As suggested, try increasing the loan 
principle by the interest for those extra 15 days (12/22 to /1/5). Rerun 
the program's amortization with that new amount and see if you don't 
come up with a payment closer to what the bank has.

But you STILL may need to adjust because there isn't one "right" way to 
do the amortization schedule. However that should be just a few cents 
one way or the other with the difference made up for in the final 
payment. A matter of how "rounding" is done.

Michael D Novack


More information about the gnucash-user mailing list