|
|
|
|
|
FinInterestRate (Function) In french: FinTauxIntérêt Calculates the interest rate for a loan over a specific period of time with fixed payments. Remark: The interest rate is assumed to be fixed over the period.
// Interest rate for a loan of 25000 Euros. Six payments // of 5000 Euros are required to pay off the loan. ResInterestRate = FinInterestRate(6, -5000, 25000)
Syntax
<Result> = FinInterestRate(<Number of Necessary Payments> [, <Payment Value> [, <Capital>]])
<Result>: Real or currency Interest rate sought. <Number of Necessary Payments>: Real or currency Total number of payments that must be done. <Payment Value>: Optional real Value of payment (0 by default). This value must be negative. <Capital>: Optional real or currency Amount of loan (1 by default). Remarks Caution: FinInterestRate 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|