PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Time unit
  • Managing errors
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
FinPeriodInterest (Function)
In French: FinIntérêtPériode
Calculates for a given period the amount of interests due for a loan paid off by fixed periodic payments with a fixed interest rate.
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 Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
New in version 23
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
// Amount of interests due for the second year of a loan.
// This is a loan of $25000 with a 5% interest rate over 6 years.
ResInterestPeriod = FinPeriodInterest(25000, 5, 2, 6)
Syntax
<Result> = FinPeriodInterest([<Capital> [, <Rate> [, <Period> [, <Duration>]]]])
<Result>: Real or currency
Amount of interests. This amount can be:
  • negative: a payment must be made;
  • positive: a credit must be made.
<Capital>: Optional real or currency
Amount of the loan (0 by default).
<Rate>: Optional real
Interest rate, expressed in percentage (1 by default). For example, for a 5% rate, this parameter will be set to 5.
<Period>: Optional integer
Period over which the amount of interests must be calculated (1 by default).
<Duration>: Optional real
Number of periods for the loan (1 by default).
Remarks

Time unit

The calculations can be performed according to months or years. <Rate>, <Duration> and <Period> must correspond to the same unit.
Therefore, to get the amount of interests due on the 5th month of a 3-year loan, with a yearly interest rate of 5%, you can use:
  • units expressed in months (for a monthly payment for example):
    • <Duration> = 3 x 12 months = 36
    • <Period> = 5
    • <Rate> = 5% / 12
  • units expressed in years (for a yearly payment for example):
    • <Duration> = 3 years
    • <Period> = 5/36
    • <Rate> = 5%

Managing errors

Caution: FinPeriodInterest returns no error code. To find out whether errors have been generated by this function, use FinError. To find out the error details, use ErrorInfo associated with the errMessage constant.
Related Examples:
WD Loan Complete examples (WINDEV): WD Loan
[ + ] The power of WINDEV and the ease-of-use of WLanguage have allowed us to develop this application within a single day!

This example is used to simulate loans and to:
- calculate the amount of the monthly repayments from the amount borrowed
- calculate the amount that can be borrowed from a given monthly repayment
- calculate the income of an investment from a monthly payment

For each case, you have the ability to view the amortization table corresponding to your parameters.
The Financial functions Unit examples (WINDEV Mobile): The Financial functions
[ + ] Use of financial functions.
This example calculates the number of payments needed to pay back a loan, the total cost of a loan as well as the interests returned by an investment.
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