Financial Functions

The following series-only functions permit you to perform calculations commonly employed in financial analysis. The functions are evaluated for each observation in the workfile sample.

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. |