Function | Purpose | Param,Optional |
---|---|---|
FV | Get the future value of an investment | rate nper pmtpv type |
NPER | Get the number of periods for an investment | rate pmt pvfv type |
PMT | Get the periodic payment for a loan | rate pmt pvfv type |
PV | Get the present value of an investment | rate nper pmtfv type |
RATE | Get the interest rate per period of an annuity | nper pmt pvfv type guess |