Principle payment

Returns the payment on the principal for an investment for one given period.

Syntax

Ppmt <Type = 0> (Rate, Per, Nper, PV, FV)

Where:

Type is a parameter that indicates when payment is due.

Rate is the interest rate.

Per is the period desired.

Nper is the number of payments.

PV is the present value of the loan.

FV is the future value of the loan.

Expression

Where:

i is the period desired