Pv

The Pv function returns the present value of an investment.

Usage:

	= Pv(<rate>,<nper>,<pmt>,[<fv>],[<type>]);

Rate is the interest rate per period.

Nper is total number of payment periods in an annuity.

Pmt is the payment made each period and cannot change over the life of the annuity.

Fv is the future value you want to attain after the last payment is made. Fv is optional and assumed to be 0.

Type is the number 0 or 1 and indicates when the payments are due. Type is optional and assumed to be 0. 0 is for the end of the period. 1 is for the beginning of the period.

Example:

	/* returns -$59,777.15 */
	= Pv(8% / 12, 12 * 20, 500)