Stephen, Thanks for the example, I will give it a try.
Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email ________________________________ From: Steve Butler <stephen.m.butle...@gmail.com> on behalf of Stephen M. Butler <kg...@arrl.net> Sent: Wednesday, July 26, 2023 3:17 PM To: Gyle McCollam <gmccol...@live.com>; gnucash-user@gnucash.org <gnucash-user@gnucash.org> Subject: Re: [GNC] Scheduled Transaction - Loan Amortization Not sure how GnC does it. I do nothing. Stephen M Butler stephen.m.butle...@gmail.com<mailto:stephen.m.butle...@gmail.com> kg...@arrl.net<mailto:kg...@arrl.net> 253-350-0166 ------------------------------------------- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 7/26/23 12:12, Gyle McCollam wrote: Stephen, How does Gnucash update the "i" value each month or do you have to do that manually? Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email ________________________________ From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org><mailto:gnucash-user-bounces+gylemc=gmail....@gnucash.org> on behalf of Stephen M. Butler <kg...@arrl.net><mailto:kg...@arrl.net> Sent: Wednesday, July 26, 2023 2:20 PM To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org><mailto:gnucash-user@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.butle...@gmail.com<mailto:stephen.m.butle...@gmail.com> kg...@arrl.net<mailto:kg...@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 > <gmccol...@live.com><mailto:gmccol...@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 >> >> gmccol...@live.com<mailto:gmccol...@live.com><mailto:gmccol...@gyleshomes.com> >> email >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@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@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.
