Links are not active on this page.
 PAYMENT( ) Function

Returns the amount of each periodic payment on a fixed-interest loan.

PAYMENT(nPrincipal, nInterestRate, nPayments)

Parameters

nPrincipal

Specifies the beginning principal of the loan.

nInterestRate

Specifies the fixed interest rate per period. If monthly payments are made on the loan but the interest rate is annual, divide the annual interest rate by 12.

nPayments

Specifies the total number of payments to be made on the loan.

Expand imageReturn Value

Numeric

Expand imageRemarks

PAYMENT( ) assumes a constant periodic interest rate and assumes that payments are made at the end of each period.

Expand imageExample

 CopyCode imageCopy Code
STORE 100000 to gnPrincipal     && $100,000 beginning principal
STORE .105/12 TO gnInterest  && 10.5% annual interest rate
STORE (20*12) TO gnPayments     && 20 years of monthly payments
CLEAR
? PAYMENT(gnPrincipal, gnInterest, gnPayments)  && Displays 998.38

Expand imageSee Also