PMTB() - Remaining balance of constant amount towards principal

Calculates the remaining balance of a loan that each period receives a constant amount applied toward the principal and has varying amount of interest.

Returns

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

Arguments

Type	Field	Description
double	dPrincipal	Loan principal
double	dConstant	Constant repay amount
long	lPeriods	Total number of periods

16 bit DLL declarations

PowerBuilder Function declaration

function double PMTB(double dPrincipal, double dConstant, long lPeriods) library "IFL16.DLL"

Visual Basic Function declaration

Declare Function PMTB lib "IFL16" (ByVal dPrincipal As Double, ByVal dConstant As Double, ByVal lPeriods As Long) As Double

C/C++ Synopsis

#include "function.h"

double PMTB(double dPrincipal, double dConstant, long lPeriods)

32 bit DLL declarations

PowerBuilder Function declaration

function double PMTB(double dPrincipal, double dConstant, long lPeriods) library "IFL32.DLL"

Visual Basic Function declaration

Declare Function PMTB lib "IFL32" (ByVal dPrincipal As Double, ByVal dConstant As Double, ByVal lPeriods As Long) As Double

C/C++ Synopsis

#include "function.h"

double PMTB(double dPrincipal, double dConstant, long lPeriods)

Example:

dPrincipal	=	60,000
dConstant	=	5000
dPeriods	=	8

Result: $ 20,000