pmt formula description in scheduled transactions

Ross Palmer Mohn rpmohn at panix.com
Thu Jul 22 22:48:27 EDT 2004


Never mind, I found that these follow the Gnumeric formulas. So, the
last two parameters are FutureValue and Type (0=pay at end; 1=pay at
beginning). And "i" is an internal counter of the payment number to be
made. I resolved my problem by changing "i" to "i+1"!
-RPM


On Thu, 2004-07-22 at 13:15, Ross Palmer Mohn wrote:
> What are the last two parameters passed to these formulas? What is the
> "i" for in the ppmt and ipmt formulas?
> 
> pmt(periodic rate : # of periods : initial balance : ? : ?)
> ppmt(periodic rate : i : # of periods : initial balance : ? : ?)
> ipmt(periodic rate : i : # of periods : initial balance : ? : ?)
> 
> Are there any other formulas available for use in scheduled
> transactions?
> 
> Apologies if this is covered elsewhere -- I couldn't find it.
> 
> Thanks! -RPM
> 
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 



More information about the gnucash-user mailing list