PV

See also A-Z Spreadsheet Function List

Description Returns the present value of an annuity, considering a series of constant payments made over a regular payment period.

Syntax PV(interest, nper, pmt [, fv] [, type])

interest is the fixed periodic interest rate.

nper is the number of payment periods in the investment.

pmt is the fixed payment made each period.

fv is the future value, or the amount the annuity will be worth. When you omit this argument, a future value of 0 is assumed.

type indicates when payments are due. Use 0 if payments are due at the end of the period or 1 if payments are due at the beginning of the period. When you omit this argument, 0 is assumed.

Remarks The units used for interest must match those used for nper. For example, if the annuity has an 8% annual interest rate over a period of 5 years, specify 8%/12 for interest and 5*12 for nper.

         Cash paid out, such as a payment, is shown as a negative number. Cash received, such as a dividend check, is shown as a positive number.

See Also FV , IPMT , NPER , PMT , PPMT , and RATE functions

Examples PV(8%/12, 48, 439.43) returns -17999.89

         PV(8%/12, 48, -439.43) returns 17999.89