|
|
|
|
|
|
|
|
|
|
The financial functions are as follows:
| | | FinCurrentVal | Returns the current value of investment. | | FinDecreasingRedemption | Calculates the amortization value of a good over a specific period of time, via the formula for fixed-rate decreasing amortization. | | FinError | Returns the number of the last error caused by a Finxxx function (financial functions). | | FinFutureVal | Returns the future value of an investment. | | FinInterestRate | Calculates the interest rate for a loan over a specific period of time with fixed payments. | | FinLinearRedemption | Calculates the value of linear amortization of a product over a specific period of time. | | FinNetCurrentVal | Returns the net current value of investment. | | FinPaymentNb | Returns the number of payments required to pay off a capital according to a given rate. | | FinPeriodInterest | Calculates for a given period the amount of interests due for a loan paid off by fixed periodic payments with a fixed interest rate. | | FinRedemption | Creates an amortization matrix for a fixed-rate loan over a defined period of time. | | FinRepayVal | Returns the amount of each regular payment for an investment with fixed interest rate and fixed payment. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|