IFinance.Cumprinc

Syntax

Cumprinc(Rate: Double;

PeriodCount: Integer;

PresentValue: Double;

StartPeriod: Integer;

EndPeriod: Integer;

Type: Integer): Double;

Parameters

Parameters Description Constraints
Rate Interest rate. Must be positive.
PeriodCount Number of payment periods. Must be positive.
PresentValue Current investments value. Must be positive.
StartPeriod The number of the first period, included into calculations. Payment periods are numbered, starting from 1. Must be in the [1;PeriodCount] interval.
EndPeriod The number of the last period, included into calculations. Must be in the [StartPeriod;PeriodCount] interval.
Type Selecting time of payment:
0 - in the end of the period.
1 - in the beginning of the period.		 Must take the value 0 or 1.

Description

The Cumprinc method returns cumulative sum paid in satisfaction of the original amount of the loan between two periods.

Comments

Cumprinc is calculated using the following formula:

Where Pmt - monthly payment on loan.

To get monthly payment on loan, use the IFinance.Pmt method.

Example

To execute the example, add a link to the MathFin system assembly.

Sub UserProc;
Var
    r: Double;
Begin
    r := Finance.Cumprinc(0.01, 24, 12000, 1, 1, 0);
    Debug.WriteLine(r);
End Sub UserProc;

After executing the example the console window displays the cumulative sum equal to -444.8817.

See also:

IFinance