PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Creates an amortization matrix for a fixed-rate loan over a defined period of time.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 23 and later
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
New in version 23
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
// Amortization matrix for an "In Fine" loan of $25000
// with a fixed interest rate of 5% over 6 years
ResAmortization = FinRedemption("AmortMatrix", finInFine, 25000, 5, 6)
Syntax
<Result> = FinRedemption(<Matrix Name> , <Type of Amortization> [, <Capital> [, <Rate> [, <Duration>]]])
<Result>: Boolean
  • True if the amortization matrix was created,
  • False otherwise. To find out the error details, use ErrorInfo associated with the errMessage constant.
<Matrix Name>:
Name of amortization matrix. This matrix is automatically created when calculating the amortization. This matrix contains 5 columns. Each column corresponds to a specific information:
Column 1Year
Column 2Balance to repay
Column 3Benefit
Column 4Amortization
Column 5Yearly payment
<Type of Amortization>: Constant
Indicates the type of amortization:
finInFine"In Fine" repayment: During the entire loan duration, the borrower only pays the interests, the principal being paid the last year of the loan.
finConstantRedemptionConstant amortization: Each year, the value of the amortization is fixed; the other parameters are calculated accordingly.
finConstantAnnualPaymentConstant yearly payment: Each year, the borrower pays the same amount to the lender, including principal and interests.
<Capital>: Optional real or currency
Total capital borrowed (0 by default).
<Rate>: Optional real
Interest rate of the loan, expressed in percentage (1 by default). For example, for a 5% rate, this parameter will be set to 5.
<Duration>: Optional real
Duration of the loan, expressed in years (1 by default).
Remarks
The existence of the amortization matrix is not checked. This matrix is overwritten if it existed beforehand. To check the matrix existence, use MatExist.
Then, the content of amortization matrix can be read by the following functions:
  • MatRead: Reads the value of a matrix element.
  • MatReadColumn: Reads the value of all the elements found in a matrix column.
  • MatReadLine: Reads the value of all elements found in a matrix row.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230mat.dll
Windows Mobile wp230mat.dll
Java wd230java.jar
Linux wd230mat.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment