After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 506807 - LoanDruid amortization schedule is off by one month
LoanDruid amortization schedule is off by one month
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Scheduled Transactions
2.2.x
Other Linux
: Normal normal
: ---
Assigned To: Josh Sled
Josh Sled
Depends on:
Blocks:
 
 
Reported: 2008-01-02 05:55 UTC by Pierre Bossart
Modified: 2018-06-29 21:58 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Pierre Bossart 2008-01-02 05:55:03 UTC
Try setting up a 15-year 5.5 fixed-rate loan of $193,000. 
LoanDruid shows principal payments of 695.56, 698.75, 701.95
while Quicken and TCF yield :   692.39, 695.57, 698.75, 701.95
Same for the first random amortization tool I googled at http://ray.met.fsu.edu/~bret/amortize.html

The first split between principal and interest is wrong in LoadDruid. I have seen a number of bugs mentioning that this type of one-off issues occurred in the past (see bug 105225), but since the problem still exists and essentially makes this feature unusable I thought I would file a bug report.

Note that this loan amount/rate would break LoanDruid anyway as banks round up to one cent above what is predicted ans scheduled. It would be a better idea to let the user enter the monthly payment to avoid mismatches between the bank and scheduled transactions. This is what Quicken does, they must have a good reason for it :-)
Comment 1 Mike Evans 2011-11-24 10:23:27 UTC
Is this behaviour still in the latest version?  If not this will be closed as obsolete.
Comment 2 Pierre Bossart 2011-11-24 18:38:47 UTC
it seems to be fixed, just tried on 2.4.7. This bug can be closed.
Comment 3 Mike Evans 2011-11-25 08:52:28 UTC
Thank you for your feedback.  This bug will be closed as fixed.
Comment 4 John Ralls 2018-06-29 21:58:11 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=506807. Please update any external references or bookmarks.