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.

Reply via email to