Present value

Returns the present value of an investment.

Syntax

Pv <Type> (Rate, Nper, Pmt, FV)

Where:

Type is a value that indicates when payment is due.

Rate is the interest rate.

Nper is the number of payments.

Pmt is the periodic payment for an annuity.

FV is the future value of the loan.

Expression

If rate = 0

Else