Name | Function | Description |
@fv(r,n,x[,fv,t]) | future value | future value of an ![]() ![]() ![]() ![]() A non-zero value for the optional ![]() |
@nper(r,x,pv[,fv,t]) | number of periods | number of annuity periods required to produce the present value ![]() ![]() ![]() ![]() A non-zero value for the optional ![]() |
@pv(r,n,x[,fv,t]) | present value | present value of an ![]() ![]() ![]() ![]() A non-zero value for the optional ![]() |
@pmt(r,n,pv[,fv,t]) | payment amount | payment amount for an ![]() ![]() ![]() ![]() A non-zero value for the optional ![]() |
@rate(n,x,pv[,fv,t]) | interest | interest rate for an ![]() ![]() ![]() ![]() A non-zero value for the optional ![]() |