amort(rate;remterm;months)
Returns the mortgage amortization.
Syntax
amort(rate;remterm;months)Input
| Argument | Type | Description |
|---|---|---|
rate |
integer or decimal | The annual rate expressed as a percentage A scalar value or the name of a column |
remterm |
integer | The remaining term in months A scalar value or the name of a column |
months |
integer | The number of months of amortization A scalar value or the name of a column |
Note: One of the arguments must reference a column.
Return Value
Returns the amortized balance expressed as a decimal fraction of the current balance.
If any argument is N/A, the result is N/A. If any argument is negative, the result is N/A.