Amortization tool glitch?

Steve Juniper snijuniper at comcast.net
Fri Nov 27 18:13:47 EST 2009


Thank you -Making payment a negative number solved the problem and 140 
is exactly correct. It was a partially paid 20 year note but I was 
thinking it was for 30 years.

Steve J

Mike C. wrote:
> I get 140 payments using both the GNUcash calculator and Excel.  You 
> have to make the payment a negative number.  The 277 payments seem 
> wrong for the parameters you stated.  Am I missing something?
> Mike
>
> Steve Juniper wrote:
>> I misplaced the amortization table I have been using for loan 
>> payments being made to me and have been trying to reconstitute it but 
>> get weird result from GC tool. Withe present value of $41,822.91, 
>> monthly payments of $419.55, interest at 6.25% and future value of 
>> zero I am given 4,294,967,216 for the total number of payments - 
>> obviously absurd. Should come out to about 277.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>> ------------------------------------------------------------------------
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com Version: 8.5.426 / Virus Database: 
>> 270.14.83/2528 - Release Date: 11/26/09 09:10:00
>>
>>   
>


More information about the gnucash-user mailing list