Manuals/calci/PMT

PMT(Rate, NoPayments, PresentValue, FutureValue, Type)

where,

Rate - represents the interest rate for the loan.

NoPayments - the total number of payments for the loan.

PresentValue - represents the present value.

FutureValue - represents the future value.

If omitted cosidered as a 0.

Type - represents payments due.

Type Payment Due

0 or omitted end of the period

1 beginning of the period

It returns the payment for a loan based on constant interest rate and constant payments.

If Type other than 0 or 1, PMT returns the #ERROR.

PMT

Lets see an example in (Column1, Row6)

=PMT(0.2/12, R2C1, R3C1, R4C1, R5C1)

PMT returns -10333.287654.

Consider another example

=NPER(0.1/12,50,52000,1,4)

It returns #ERROR.

Syntax

Remarks

Examples

Description