|
|
|
|
|
|
|
|
|
|
- Time unit
- Error management
FinRepayVal (Function) In french: FinValRemboursement Returns the amount of each regular payment for an investment with fixed interest rate and fixed payment. Note The value returned by FinRepayVal includes principal repayment and interest.
ResValRemboursement = FinRepayVal(100000, 24, 8)
Syntax
<Result> = FinRepayVal([<Initial capital> [, <Number of periods> [, <Rate>]]])
<Result>: Real or currency Amount of regular payments. <Initial capital>: Optional real or currency Initial capital (0 by default). This parameter indicates the amount on which the calculation must be performed.In the "standard" case of a borrower, this capital is borrowed and therefore it corresponds to a negative value. If this parameter is positive, the calculation is performed for a lender. The value returned is negative: this value corresponds to the amount to be paid. <Number of periods>: Optional integer Total number of periods for the operation (1 by default). <Rate>: Optional real Interest rate of investment expressed in percentage (1 by default). For example, for a 5% rate, this parameter will be set to 5. Remarks The calculations can be performed according to months or years. <Rate> and <Period> must correspond to the same unit. Therefore, for monthly payments of a 4-year loan with a yearly interest rate set to 12%, use: - <Rate> = 12% / 12,
- <Number of periods> = 4*12
For the same loan with yearly payments, use: - <Rate> = 12%,
- <Number of periods> = 4
For all the parameters, the payments are represented by a negative number while the collections are represented by a positive number. Caution: FinRepayVal returns no error code. To determine if this function has generated errors, use FinError. To get more details on the error, use ErrorInfo 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 payment For 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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|