5g: PctIncrDecrλ()

Description

PctIncrDecrλ() increase or decrease an initial value by one or more percentages over a set number of columns (usually, representing time). Use this to project percentages changes for things like inflation, sales growth, cost reductions, etc.

Syntax

PctIncrDecrλ( Actuals, Percents, [Columns])

Actuals (Required)

An opening value or array of numeric values representing the starting figures. If there are more than one actual value, only the last actual value will be increased or decreased by the Percents argument.

Percents (Required)

A single percentage value or array of percentage values that determine the rate of increase or decrease (negative percentages) to be applied. If Percents contains a single value, that percentage is consistently applied to the last actual value and the subsequent calculated values across all remaining columns.

If Percents contains multiple values, those values will be placed in columns starting with the first column. Percents values for columns prior to the last Actuals value are ignored.

If the number of Percents provided is less than the total number of columns, the last percentage in the list is repeated for the remaining columns.

Columns (Optional)

An integer representing the total number of columns in the resulting output. This includes columns displaying the initial Actuals values and those displaying the calculated values based on Percents.

Examples

One Prior Period Initial Value and One Percentage Increase Value

This example starts with a single value in the Actuals argument. When there is only 1 value in the Actuals argument, it is considered to be the prior period's closing value and will be increased/(decreased) the the Percents argument.

This example also only has one value in the Percents argument.

When there are fewer values in the Percents argument than the number of columns to apply it to, we must enter the number Columns argument.

One Prior Period Initial Value and Many Percentage Increase Values

This example starts with a single value in the Actuals argument and many values in the Percents argument. In this case the first percent value is applied to the single Actuals value. The second Percents value is applied to that result. The third Percents value is applied to that result and so on.

If there are as many Percents values as there are model columns, we do not need to enter the Columns argument.

Many Prior Period Initial Values and One Percentage Increase Value

This example starts with many non-zero values in the Actuals argument and one value in the Percents argument. In this case the Actuals values will remain unchanged. The last non-zero Actual value will provide the initial value for the next column. Because there is just one Percents value, that value will be applied to the remaining columns up to and including the number of columns in the Columns argument.

Many Prior Period Initial Values and Many Percentage Increase Values

This example starts with many non-zero values in the Actuals argument and many values in the Percents argument. The Actuals values will remain unchanged. The last non-zero Actual value will provide the initial value for the next column. The Percents value in the column after the last non-zero Actuals value will be applied that Actuals value.