5g: CorkscrewAλ()

Description

CorkscrewAλ() creates a corkscrew section using actual closing balances to start the corkscrew instead of first period opening balance.

NOTE! CorkscrewAλ() will mimic Corkscrewλ() if Actuals contains only 1 value and ActualsPeriods is set to 0. Be aware that because CorkscrewAλ() is more complicated than Corkscrewλ(), using CorkscrewAλ() instead Corkscrewλ() when Corkscrewλ() is appropriate will result in slightly reduced performance.

Syntax

CorkscrewAλ( Actuals, [ActualsPeriods], [InFlows], [OutFlows])

Arguments:

Actuals
(Required) Closing balances from historic periods.
NOTE! To treat this as an opening balance, set ActualPeriods to 0 in which case, this should be a single number

ActualsPeriods
(Optional) The number of periods (columns) occupied by Actuals. Set to zero to treat Actuals as the opening balance. This defaults to the number of columns in Actuals.
NOTE! If this is omitted then Actuals must not include columns reserved for forecasted values.

InFlows
(Optional) One or more rows of values to add to the opening balance.
NOTE! If omitted, OutFlows are required.
NOTE! Flows for actuals periods are normally not supplied. If supplied flows in actual periods do not impact forecasts.

OutFlows
(Optional) One or more rows of values to subtract from the opening balance. NOTE! If omitted, Inflows are required.
NOTE! If omitted, InFlows are required.
NOTE! Flows for actuals periods are normally not supplied. If supplied flows in actual periods do not impact forecasts.

Example

In this example the Actuals occupy the first three columns. If Actuals are keyed in, as opposed to imported from an ERP, they are typically fixed ranges and not dynamic ranges. Such is the case with this example. Because we are selecting only the three columns as a range reference, instead of a dynamic array reference, we can let CorkscrewAλ determine how many actuals periods there are and so, omit the ActualsPeriods argument.

NOTE! In this example we are supplying flows for actual periods. This looks better but most models do not supply flows for actuals. If flows are supplied they will change the opening balances in actuals, but not the closing balances and only the last closing balance in actuals is used to calculate forecast periods.

Page updated

Google Sites

Report abuse