PV(rate, NPER, PMT, FV, type) Returns the present value of an investment resulting from a series of regular payments.
- rate defines the interest rate per period.
- nper is the total number of periods. *pmt is the regular payment made per period.
- fv (optional) defines the future value remaining after the final installment has been made.
- type (optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.