Name | Function | Description |
@fv(r,n,x[,fv,t]) | future value | future value of an  -period annuity with rate  , payments  , and optional final lump sum payment  .A non-zero value for the optional  indicates that the payments are made at the beginning of periods instead of ends. |
@nper(r,x,pv[,fv,t]) | number of periods | number of annuity periods required to produce the present value  with rate  , payments  and optional final lump sum payment  .A non-zero value for the optional  indicates that the payments are made at the beginning of periods. |
@pv(r,n,x[,fv,t]) | present value | present value of an  -period annuity with rate  , payments  , and optional final lump sum payment  .A non-zero value for the optional  indicates that the payments are made at the beginning of periods. |
@pmt(r,n,pv[,fv,t]) | payment amount | payment amount for an  -period,  present value annuity with rate  and optional final lump sum payment  .A non-zero value for the optional  indicates that the payments are made at the beginning of periods. |
@rate(n,x,pv[,fv,t]) | interest | interest rate for an  period annuity with payments  , present value  , and optional final lump sum payment  .A non-zero value for the optional  indicates that the payments are made at the beginning of periods. |