[GNC] Scheduled Transaction - Loan Amortization

[David Carlson]

That stuff is explained in great detail somewhere on the GnuCash website
but I am on my cellphone and unable to sesrch for it.

On Wed, Jul 26, 2023, 2:17 PM Stephen M. Butler <kg7je at arrl.net> wrote:

> GnC appears to keep track of the number of months and updates it without
> any intervention on my end.
>
> Stephen M Butler
> Stephen.M.Butler51 at gmail.com
> kg7je at arrl.net
> 253-350-0166
> -------------------------------------------
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> On 7/26/23 12:11, Gyle McCollam wrote:
> > How does Gnucash update the "i" value each month or do you have to
> > adjust manually?
> >
> > Thank You,
> >
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > gmccollam at live.com <mailto:gmccollam at gyleshomes.com>email
> >
> > ------------------------------------------------------------------------
> > *From:* gnucash-user
> > <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on behalf of
> > Stephen M. Butler <kg7je at arrl.net>
> > *Sent:* Wednesday, July 26, 2023 2:20 PM
> > *To:* gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> > *Subject:* Re: [GNC] Scheduled Transaction - Loan Amortization
> > Here are the entries (3 splits) I use on my scheduled transaction:
> >
> > Split 1:    Assets:Checking:xxx        Credit -- $326.97 (payment
> > comes from checking account)
> > Split 2:    Liabilities:Loans:yyy         Debit -- 326.97 - ipmt( .04490
> > / 12.00 : i -2: 240.00 : 51,630.34 : 0 : 0 )
> > Split 3:   Expense:Interest Paid      Debit -- ipmt( .04490 / 12.00 : i
> > -2: 240.00 : 51,630.34 : 0 : 0 )
> >
> >                  Notes:  .04490/12 is the monthly interest
> >                              i-2 is the month number (found that
> > adjusting by 2 months gave me numbers that matched the bank much better
> > -- try with just i)
> >                              240 is the total number of months for loan
> > (20 yrs -- RV)
> >                              51,630.34 is the original loan amount
> >
> >
> > Stephen M Butler
> > Stephen.M.Butler51 at gmail.com
> > kg7je at arrl.net
> > 253-350-0166
> > -------------------------------------------
> > GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> >
> > On 7/26/23 07:09, Derek Atkins wrote:
> > > There are pmt, ppmt, and ipmt functions.
> > > -derek
> > > Sent using my mobile device. Please excuse any typos.
> > > On July 25, 2023 15:41:01 Gyle McCollam <gmccollam at live.com> wrote:
> > >
> > >> Is there a formula I can enter in SX that will automatically
> > >> calculate the principal or interest payment on a car loan?  Then is
> > >> there a way to deduct that from the total payment to get the other
> > >> value, other than TOTAL PAYMENT-the formula used above?
> > >>
> > >>
> > >> Thank You,
> > >>
> > >> Gyle McCollam
> > >>
> > >> Gyle McCollam
> > >>
> > >> gmccollam at live.com<mailto:gmccollam at gyleshomes.com
> > <mailto:gmccollam at gyleshomes.com>> email
> > >> _______________________________________________
> > >> gnucash-user mailing list
> > >> gnucash-user at gnucash.org
> > >> To update your subscription preferences or to unsubscribe:
> > >> 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.
> > >
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > 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.
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>