contents.gifprev1.gifnext1.gif

PMTS() - Periodic payment amount (Amortize Schedule)

Calculates the amount of a periodic payment and the amortization schedule.

Returns

Double value if successful. If an error occurs, this function returns a zero.

Arguments

Type
Field
Description
double
dPrincipal
Initial capital
double
dInt
Interest percentage
long
lTerm
Total number of periods
integer
iBasis
Value:
0 = end
1 = begin
double
dRepay[]
Return repay values by period
double
dInterest[]
Return interest values by period
16 bit DLL declarations

PowerBuilder Function declaration

function double PMTS(double dPrincipal, double dInt, long lTerm, int dBasis, REF double dRepay, REF double dInterest) library "IFL16.DLL"

Visual Basic Function declaration

Declare Function PMTS lib "IFL16" (ByVal dPrincipal As Double, ByVal dInt As Double, ByVal lTerm As Long, ByVal dBasis As Integer, ByRef dRepay[] As Double, ByRef dInterest[] As Double) As Double

Access Function declaration

Declare Function PMTS lib "IFL16" (ByVal dPrincipal As Double, ByVal dInt As Double, ByVal lTerm As Long, ByVal dBasis As Integer, dRepay[] As Any, dInterest[] As Any) As Double

C/C++ Synopsis

#include "function.h"

double PMTS(double dPrincipal, double dInt, long lTerm, int iBasis, double *dRepay, double *dInterest)

32 bit DLL declarations

PowerBuilder Function declaration

function double PMTS(double dPrincipal, double dInt, long lTerm, int dBasis, REF double dRepay, REF double dInterest) library "IFL32.DLL"

Visual Basic Function declaration

Declare Function PMTS lib "IFL32" (ByVal dPrincipal As Double, ByVal dInt As Double, ByVal lTerm As Long, ByVal dBasis As Integer, ByRef dRepay[] As Double, ByRef dInterest[] As Double) As Double

Access Function declaration

Declare Function PMTS lib "IFL32" (ByVal dPrincipal As Double, ByVal dInt As Double, ByVal lTerm As Long, ByVal dBasis As Integer, dRepay[] As Any, dInterest[] As Any) As Double

C/C++ Synopsis

#include "function.h"

double PMTS(double dPrincipal, double dInt, long lTerm, short sBasis, double *dRepay, double *dInterest)

Example:

dPrincipal
=
8,000

dInt
=
0.01167
(1.167%)
dTerm
=
36

dBasis
=
0
end
dRepay[]
=
0
all values
dInterest[]
=
0
all values
Result: $ 273.44

Repay[1] $ 180.08

Interest[1] $ 93.36

etc.