Volume Change

Description

The Volume Change function calculates a percentage value by which the value of a business figure is adjusted depending on changes to an external parameter (such as a reference rate). Forecasts of the external parameter are used to reflect individual estimations of the change.

Using this Function

Syntax

In the Control File, the Volume Change function is called up as follows:

CODE

[account] + Volume change in relation to parameter
[account] + Volume change in relation to parameter based on [referenceAccount] delayed by delayPeriod]

Parameters

[account]

Business figure for which the value should be calculated.
This must be contained in the following input data: Input Files | Financial-Data

{in relation to} parameter

Name of the external parameter used for the calculation.
This must correspond to an entry in the ‘Parameter’ column from the sheet Input Files | FORECASTS.
In addition, the individual estimations for adjusting the business figure depending on the changes to the parameter must be available in the sheet Input Files | ESTIMATIONS_VOLUME.

{based on} [referenceAccount]

Optional parameter; denotes the business figure on the basis of which the estimation of the change should be made.
This must be included in the following input data: Input Files | Financial-Data
If this parameter is not transmitted, the estimation is made based on the business figure for which the value should be calculated (see [account]).

{delayed by} delayPeriod

Optional parameter; specifies the period of time that must elapse before a change is made to the value of the business figure.
The value of this parameter is entered directly in the Control File:

k year(s) → delay of k years
k month(s) → delay of k months

If this parameter is not transmitted, no delay is taken into account in the calculation.

Examples

Example 1

CODE

[10003] + Volume change in relation to reference rate

historical data from 31/12/2023:
- value of the business figure [10003]: 47,600.00
calculation for 31/12/2024:
- forecast of the reference rate: 4.2%
- individual estimations of the change of the business figure:
  - reference rate 4% → volume change 5%
  - reference rate 4.5% → volume change 0%
- linear interpolated value of the volume change: 3%
- new value of the business figure [10003]: 47,600.00 * (1 + 0.03) = 49,028.00

Example 2

CODE

[10005] + Volume change in relation to unemployment rate based on [10003] delayed by 1 year / 2

historical data from 31/12/2023:
- value of the business figure [10005]: 12,400.00
calculation for 31/12/2024:
- No change in the value of the business figure [10005], as the change is only implemented with a delay of one year.
calculation for 31/12/2025:
- forecast of the unemployment rate for 31/12/2024: 6.4%
- individual estimations of the change of the business figure based on the business figure [10003]:
  - unemployment rare 6% → volume change 0%
  - unemployment rate 7% → volume change -1%
- linear interpolated value of the volume change: -0.4%
- new value of the business figure [10005]: 12,400.00 * (1 - 0.004/2) = 12,375.20