This content has been translated automatically. Click here to view the French version.
• Time unit
• Managing errors
WINDEV
WEBDEV
WINDEV Mobile
Others
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.
// 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:
 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 paymentFor each case, you have the ability to view the amortization table corresponding to your parameters.
 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.
Component: wd260mat.dll
Minimum version required
• Version 9