| Name: | FV |
| Syntax: | FV(rate, nper, pmt[,pv[,type]]) |
| Description: | Returns the future value of an investment based on periodic, constant payments and a constant interest rate. |
| Version: | 1.3 |
| Name: | NPER |
| Syntax: | NPER(rate,pmt,pv[,fv[,type]]) |
| Description: | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
| Version: | 1.3 |
| Name: | PMT |
| Syntax: | PMT(rate,nper,pv[,fv[,type]]) |
| Description: | Calculates the payment for a loan based on constant payments and a constant interest rate. |
| Version: | 1.3 |
| Name: | PV |
| Syntax: | PV(rate,nper,pmt[,fv[,type]]) |
| Description: | Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. |
| Version: | 1.3 |
| Name: | RATE |
| Syntax: | RATE(nper,pmt,pv[,fv[,type]]) |
| Description: | Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. |
| Version: | 1.3 |