Change to mortgage P&I caused by extra payment

david.carlson.417 david.carlson.417 at gmail.com
Fri Dec 23 17:39:15 EST 2016


    
Regardless of why a user wants to fiddle with an amortization type of scheduled transaction, how could it be done in GnuCash? 
e.g. If the PV is off by 30 dollars, can that be changed in the SX to correct future interest calculations?
David C
Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT&T 4G LTE smartphone

-------- Original message --------
From: Mike or Penny Novack <mpnovack at mtdata.com> 
Date: 12/23/16  9:02 AM  (GMT-06:00) 
To: gnucash-user at gnucash.org 
Subject: Re: Change to mortgage P&I caused by extra payment 

On 12/23/2016 1:33 AM, JimR wrote:
> Thanks Peter.  The mortgage is actually variable 2.75%, but locked at
> that rate for the first 5 years.  After that, it can only change once
> each year.
>

There are simply too many possibilities for how an amortization table is 
created for us to expect agreement to the penny << where rounded off, 
how the end condition (the final payment) is to be treated,  etc. >>

When you make an additional principle pyement, in effect you have 
eliminated a payment in whole or in part << if you make the extra amount 
match the principle payment you have eliminated that payment and are 
skipping to the next >>  You might try having gnucash recalculated as if 
it were a new loan for the new amount and the N remaining payments. If 
the extra payment you made is NOT the exact amount of principle for the 
next N payments the "new loan" is the only way you can do it. But do NOT 
expect agreeing to the penny << I have written programs to calculate 
payments and produce amortization tables in my day -- including ones 
where it was possible to induce them to readjust to match what a bank 
had, but THAT perforce a manual operation of the sort "try adjusting up 
(or down) a penny >>

Michael D Novack
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list