Hi everyone, further thoughts on the 'as of date balance'. On 1/15/2014 12:12 AM, alessandro basili wrote: > [] >>> Uhm, isn't a 'balance as of date' automatically calculated? [] >> No, it is not. The P/I splits assume you always pay the exact >> amount. If you over-pay your principal the P/I splits do not >> reflect the lower principal (and therefore different P/I split >> ratio). E.g., if your mortgage is $995 (P+I) and you pay $1000, >> you've paid down your principal by $5 and therefore are paying >> interest on $5 less principal. GnuCash does not know how to >> handle this, so over time your auto-generated P/I splits get >> further and further from reality.
I have problem understanding how the formulas of PMT/IPMT/PPMT will reflect the over payment. Paying down the principal would either lead to a less amount of periods, or to a lower payment per period, is this correct? If this is the case how can we deal with this variability? Maybe the Loan Assistant should be done in such a way to 'handle' completely the loan/mortgage and operate on the variables to reschedule the remaining SXs accordingly. This would mean that already scheduled SXs need to be deleted or modified. Given the design change required for this to work I guess that is more realistic to fix the existing bugs before drafting a totally new approach. I'm open to feedback/suggestions. Al -- Alessandro Basili PGP Fingerprint DCBE 430E E93D 808B 45E6 7B8A F68D A276 565C 4450 PGP Public Key available at keys.gnugp.net _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
