PPmt

The PPmt function returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate

Usage:

	= PPmt(<rate>,<per>,<nper>,<pv>,[<fv>],[<type>]);

Rate is the interest rate per period.

Per is the period for which you want to find the payment.

Nper is total number of payment periods in an annuity.

Pv is the present value -- the total amount that a series of future payments is worth now.

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 -75.62 */
	= Fixed(PPmt(0.1/12, 1, 24, 2000), 2)