CPMT() - Periodic payment amount (Canadian Mortgage)

Calculates the amount of a periodic payment for a Canadian mortgage. In Canada interest is compounded on a semi-annual basis, with payments made monthly.

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

16 bit DLL declarations

PowerBuilder Function declaration

function double CPMT(double dPrincipal, double dInt, long lTerm, int iBasis) library "IFL16.DLL"

Visual Basic Function declaration

Declare Function CPMT lib "IFL16" (ByVal dPrincipal As Double, ByVal dInt As Double, ByVal lTerm As Long, ByVal iBasis As Integer) As Double

C/C++ Synopsis

#include "function.h"

double CPMT(double dPrincipal, double dInt, long lTerm, int iBasis)

32 bit DLL declarations

PowerBuilder Function declaration

function double CPMT(double dPrincipal, double dInt, long lTerm, int iBasis) library "IFL32.DLL"

Visual Basic Function declaration

Declare Function CPMT lib "IFL32" (ByVal dPrincipal As Double, ByVal dInt As Double, ByVal lTerm As Long, ByVal iBasis As Integer) As Double

C/C++ Synopsis

#include "function.h"

double CPMT(double dPrincipal, double dInt, long lTerm, short sBasis)

Example:

dPrincipal	=	50,000
dInt	=	0.09	(9%)
lTerm	=	360
iBasis	=	0

Result: $ 396.42