Forecast Parameter

Description

The Forecast Parameter function uses forecasts of external parameters (such as a reference rate) to calculate business figures.

Using this Function

Syntax

In the Control File, the Forecast Parameter function is called up as follows:

CODE

[account] = [referenceAccount] * (Forecast parameter + spread)

Parameters

[account]

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

[referenceAccount]

Denotes the business figure on the basis of which the calculation should be made.
This must be included in the following input data: Input Files | Financial-Data

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.

spread

Optional parameter; specifies the premium or discount in percentage points by which the value of "parameter" should be adjusted.
The value of this parameter is entered directly in the Control File.

Examples

Example 1

CODE

[30002] = [10005] * (Forecast Reference rate + 0.75%)

calculation for 31/12/2024:
- value of the business figure [10005]: 12,400.00
- forecast of the reference rate: 4.2%
- new value of the business figure [30002]: 12,400.00 * (4.2% + 0.75%) = 613.80
calculation for 31/12/2025:
- value of the business figure [10005]: 12,400.00
- forecast of the reference rate: 4.0%
- new value of the business figure [30002]: 12,400.00 * (4.0% + 0.75%) = 589.00