Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow money, the loan amount is the present value to the lender.
 | rate | is the interest rate per period. |
 | Nper | is the total number of payment periods in an annuity. |
 | Pmt | is the payment made each period and cannot change over the life of the annuity. Typically, pmt includes principal and interest but no other fees or taxes. |
 | Fv | is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). |
 | Type | is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0. |