Resend: Loan payments vs financial calculator mismatch

Derek Atkins warlord at MIT.EDU
Mon Oct 19 11:28:30 EDT 2009


Geert Janssens <janssens-geert at telenet.be> writes:

> I never got an answer on the question below and I'm still having trouble with 
> this. So I take the liberty to resend my original message:
>
> Hi,
>
> I am trying to setup a scheduled transaction for a loan.
>
> At this moment I didn't receive the full table of payments from my bank yet, 
> but the first payment has been made.
>
> Using the financial calculator in GnuCash, I find that the numbers fit:
> I have 12 payments, for the amount that I loaned, with the interest we agreed, 
> the monthly payment calculated very closely matches what the bank charged me.
>
> However, if I try to set this up using the Mortgage and Loan druid, I end up 
> with one payment less (11 instead of 12) and the amount per payment is too 
> high.
>
> Just for reference:
> The loan is:
> Amount: 4.000 €
> Intrest: 6.6% (or near to it, I didn't get the final number yet)
> To be paid in 12 monthly payments of 343,53 € each.
>
> The financial calculator gets very close to this.
>
> However the druid gives me 11 monthly payments of 345,37 € each.
>
> Where's the difference ?

Sounds like a fencepost error..  Not sure who's error it is.

> Thanks,
>
> Geert

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list