5g: Growthλ()

Description

Growthλ() projects growth or decreases over time by assumed percentages. Below, we see three examples of how to use this function.

Example #1 - Single Actual, Single Percentage - The growth percentage is applied to the single actual value, placed in the next period and carried through all subsequent periods.

Example #2 - Multiple Actuals, Single Percentage - The growth percentage is applied to the last Actual value, placed in the next period and carried through all subsequent periods.

Example #3 - Multiple Actuals, Multiple Percentage - There is a row of Growth percent assumptions and an array of Actuals. Growth percentages in Actuals columns are ignored. Growth percentages in the forecast columns are applied to prior period's values.

Syntax

Growthλ( Actuals, Percentages, [Timeline])

Arguments:

Actuals
(Required) A single number or an array of actuals placed under the timeline.

NOTE! If a single number, it is the first period's actual (not forecast) value. if an array of actuals, select only actuals columns. Exclude forecast columns. Increases or decreases are not applied to actuals columns, only forecast.

Percentages
(Required) A single number or an array of change percentages placed under the timeline.

NOTE! Positive percentages are increases, negative percentages are decreases.

TImeline
(Optional) Include if either Actuals or Percents have fewer columns than the timeline

Page updated

Google Sites

Report abuse