Embedded Files
Description
Description
CorkscrewRxOλ() multiplies a rate times the opening in a corkscrew calculation. This example is a simple consumer loan (accrual method = 30/360) at 5% APR for 6 months. The CorkscrewRxOλ() function multiplies the opening balance by the rate divided by 12 months per year to calculate interest charges. The function adds the opening, interest charges and payments (negative) to calculate the closing. NOTE! Payments are the Payment amount multiplied by the Effective array.
Syntax
Syntax
Corkscrewλ( Opening, FLow1, [Flow2], [Flow3], [Flow4], [PositiveOnly])
Arguments:
Arguments:
Opening
(Required) First period's opening balance.
Rate
(Required) A percent or rate to multiple the opening balance by. If the result is to be subtracted from the opening balance make the rate negative.
Flows
(Required) A row, or VSTACKed rows of values to add to opening and applied rate result. If a row in Flows is to be subtracted make the row negative.
PositiveOnly
(Optional) TRUE = display flows as positive values. Default is FALSE.
Page updated
Google Sites
Report abuse