| Function group | Execute on client | Platform(s) |
|---|---|---|
| Financial | NO | All |
anna(rate,nper,pmt,pv,fv)
Evaluates an unknown for an annuity in advance and returns the result.
This function works in the same way as the ann() function except that the annuity is calculated in advance. The payments are assumed to be made at the start of each period instead of the end of each period.
The following example shows what the monthly payment is, using the same arguments as those used for the example for ann(), but using the anna() function, where the mortgage payments are assumed to be made in advance.
Calculate lAmount as rnd(anna(.11/12,25*12,'?',30000,0),2)
# returns -291.36