ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
This predefined function is used to calculate the value of regular monthly instalments for the depreciation of loan capital over a period.
This predefined function can also be used to calculate the total repayment made or the total amount of interest paid when the loan reaches its end of term.
Syntax
Result = &CAPITAL(Rate;Period;Capital;Result type)
Parameters
|
Description |
Contents |
Controls |
Result |
Numeric variable with decimals. |
The result value depends on the parameter Result type: Monthly instalments to be repayed if Result type = 1 Total repayment if Result type = 2 Cumulated interest (Total interest paid) if Result type = 3 |
|
Rate |
Numeric constant or variable with decimals. |
Rate of interest applied to calculate the repayment. |
Mandatory parameter. |
Period |
Numeric constant or variable with decimals. |
Number of monthly instalments required to repay the loan capital. |
Mandatory parameter. |
Capital |
Numeric constant or variable with decimals. |
Loan capital. |
Mandatory parameter. |
Result type |
One-position integer variable or constant. |
Possible values: 1 Monthly instalments 2 Total repayment 3 Cumulated interest |
Mandatory parameter. |
Example
RATE = 10.75
PERIOD = 240
CAPITAL = 900000
MONTHLY_VAL = &CAPITAL(RATE;PERIOD;CAPITAL;1)
TOTAL = &CAPITAL(RATE;PERIOD;CAPITAL;2)
INTEREST = &CAPITAL(RATE;PERIOD;CAPITAL;3)
*
* MONTHLY_VAL is equal to: 9137.06
* TOTAL is equal to: 2192894.54
* INTEREST is equal to: 1292894.54
*
* -----------------------------------------------
*
RATE = 6.32
PERIOD = 84
CAPITAL = 150000
MONTHLY_VAL = &CAPITAL(RATE;PERIOD;CAPITAL;1)
TOTAL = &CAPITAL(RATE;PERIOD;CAPITAL;2)
INTEREST = &CAPITAL(RATE;PERIOD;CAPITAL;3)
*
* MONTHLY_VAL is equal to: 2214.36
* TOTAL is equal to: 186006.82
* INTEREST is equal to: 36006.82
List of predefined functions by topic