subject:"\[GNC\] Scheduled Transaction \- Loan Amortization"

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread 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  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.butle...@gmail.com
> kg...@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
> >
> > gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email
> >
> > 
> > *From:* gnucash-user
> >  on behalf of
> > Stephen M. Butler 
> > *Sent:* Wednesday, July 26, 2023 2:20 PM
> > *To:* 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:xxxCredit -- $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
> > 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  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...@gyleshomes.com
> > <mailto:gmccol...@gyleshomes.com>> email
> > >> ___
> > >> 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.
> > >
> > > ___
> > > 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.
> >
> > ___
> > 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.
> ___
> 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.
>
___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Gyle McCollam

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  on behalf of Stephen M. 
Butler 
Sent: Wednesday, July 26, 2023 3:17 PM
To: Gyle McCollam ; 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 
<mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org>
 on behalf of Stephen M. Butler <mailto:kg...@arrl.net>
Sent: Wednesday, July 26, 2023 2:20 PM
To: gnucash-user@gnucash.org<mailto: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:xxxCredit -- $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 
> <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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Stephen M. Butler


Not sure how GnC does it.  I do nothing.

Stephen M Butler
stephen.m.butle...@gmail.com
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 
 on behalf of 
Stephen M. Butler 

*Sent:* Wednesday, July 26, 2023 2:20 PM
*To:* 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
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  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...@gyleshomes.com 
<mailto:gmccol...@gyleshomes.com>> email

>> ___
>> 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.
>
> ___
> 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.

___
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.

___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Stephen M. Butler

GnC appears to keep track of the number of months and updates it without 
any intervention on my end.


Stephen M Butler
stephen.m.butle...@gmail.com
kg...@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

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of 
Stephen M. Butler 

*Sent:* Wednesday, July 26, 2023 2:20 PM
*To:* 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
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  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...@gyleshomes.com 
<mailto:gmccol...@gyleshomes.com>> email

>> ___
>> 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.
>
> ___
> 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.

___
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.

___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Gyle McCollam

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  on 
behalf of Stephen M. Butler 
Sent: Wednesday, July 26, 2023 2:20 PM
To: 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:xxxCredit -- $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
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  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...@gyleshomes.com> email
>> ___
>> 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.
>
> ___
> 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.

___
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.
___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Gyle McCollam

How does Gnucash update the "i" value each month or do you have to adjust 
manually?

Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email

From: gnucash-user  on 
behalf of Stephen M. Butler 
Sent: Wednesday, July 26, 2023 2:20 PM
To: 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:xxxCredit -- $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
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  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...@gyleshomes.com> email
>> ___
>> 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.
>
> ___
> 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.

___
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.
___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Stephen M. Butler


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
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  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 email
___
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.


___
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.


___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

2023-07-26 Thread Derek Atkins


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  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   email
___
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.


___
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.

[GNC] Scheduled Transaction - Loan Amortization

2023-07-25 Thread Gyle McCollam

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   email
___
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.

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

Re: [GNC] Scheduled Transaction - Loan Amortization

[GNC] Scheduled Transaction - Loan Amortization

9 matches

Site Navigation

Mail list logo

Footer information