First Steps

After the successful Installation of Jabatix NC and a corresponding licence, you are ready to calculate simulations for your own business figures with the programme.

In this section, we explain in brief how you can perform the corresponding calculations with Jabatix NC using the example of simulating a balance sheet.

Provision of the data

Firstly, transfer your existing balance sheets into the following format in Excel:

If only the balance sheet for the last business year is available, this is sufficient for most functions of Jabatix NC.
If you have more than three historical balance sheets, add the corresponding date columns with the values of the balance sheet items.

Name the worksheet BALANCE_SHEET, for example, and then save the file, e.g. as FINANCE_DATA.xlsx.

A First Simulation

As you now want to generate a first simulation, create a new directory (e.g. JAB-SIM1).

Now open a text editor and enter the following commands:

input FINANCE_DATA.xlsx financial

loop over 2 years
[10001] + 5%

output FORECAST_OUTPUTS.xlsx

Save this Control File in the JAB-SIM1 directory, for example under the name forecast_ctrl.txt, and then start the calculation with Jabatix NC.

You can view the result after just a few moments. In the above case, Jabatix NC has created the Output File FORECAST_OUTPUTS.xlsx in the JAB-SIM1 directory. This file contains a worksheet BALANCE_SHEET_FORECAST with the following values:

Since a Loop over 2 years was used in the Control File, the Output File contains the simulated balance sheets for the next two business years in addition to the balance sheet for the last business year.

Since a command for simulation was entered in the Control File only for the balance sheet item ‘Cash reserve’, only the values of this balance sheet item were adjusted in the output file for the next two business years – each with an increase of 5% compared to the previous year in accordance with the command entered.

Trend forecast for several years

After the successful first simulation of the balance sheet item ‘Cash reserve’, you now want to create another simulation. This time, however, with a somewhat more sophisticated calculation method: the balance sheet item ‘Receivables from banks’ should be simulated using a trend continuation. To realise this, adjust your Control File as follows:

input FINANCE_DATA.xlsx financial

loop over 2 years
[10001] + 5%
[10002] = Forecast Trend

output FORECAST_OUTPUTS.xlsx

After you have started a new calculation with Jabatix NC, take another look at the Output File. This now shows the following:

Now, in addition to the values of the balance sheet item ‘Cash reserve’, also the values of the balance sheet item ‘Receivables from banks’ have been adjusted for the next two business years according to the command in the Control File – in this case, a linear continuation of the trend was recognised and applied by the programme.

In order to use the Forecast Trend function for a balance sheet item, at least two historical values must be available for this balance sheet item.

Scenario analysis

Finally, you also want to perform a stress testing in your simulation by using different simulations for different scenarios.

• In a ‘good’ scenario, the balance sheet item ‘Receivables from banks’ should be increased by the amount 800 compared to the normal simulation. On the other hand, the risk provisioning can be reduced by 10% if the reference rate falls below 4%.

• Similarly, in a ‘bad’ scenario, the balance sheet item ‘Receivables from banks’ should be reduced by 500 compared to the normal simulation. On the other hand, the risk provisioning must be increased by 10% if the reference rate rises above 5%.

To perform the calculation, create another Excel file, for example named FORECAST_INPUTS.xlsx. This file contains a worksheet FORECASTS (this name must be used) in which you enter the following data:

Now you adapt your Control File as follows in order to generate the Scenario Analysis:

input FINANCE_DATA.xlsx financial
input FORECAST_INPUTS.xlsx

loop over 2 years
[10001] + 5%
[10002] = Forecast Trend
[10001]_BEST = [10001] + 800
[10003]_BEST = if Forecast reference rate < 0.04 then [10003] - 10% else [10003]
[10001]_WORST = [10001] - 500
[10003]_WORST = if Forecast reference rate > 0.05 then [10003] + 10% else [10003]

output FORECAST_OUTPUTS.xlsx

After you have started a new calculation with Jabatix NC, take another look at the Output File . This file now contains the following worksheets:

BALANCE_SHEET_FORECAST

In this worksheet there is no change compared to the previous situation, since the same commands were used in the Control File as for the normal simulation.

BALANCE_SHEET_FORECAST_BEST

This sheet contains the calculation results for the BEST scenario. Here, the values of the balance sheet item ‘Cash reserve’ are increased by the amount 800 compared to the normal simulation. In addition, the risk provisioning is reduced by 10% on 31/12/2024, since the reference rate on this date is below 4% according to the data provided.

BALANCE_SHEET_FORECAST_WORST

This sheet contains the calculation results for the WORST scenario. Here, the values of the balance sheet item ‘Cash reserve’ are reduced by the amount 500 compared to the normal simulation. In addition, the risk provisioning is increased by 10% on 31/12/2025, since the reference rate on this date is over 5% according to the data provided.

BALANCE_SHEET_FORECAST_ALL

In this sheet, the calculation results of the normal simulation are compared and contrasted with those of all scenarios.

Further Information

More detailed information on how to use Jabatix NC can be found in the Use Cases. A description of all available functions is available in the Reference Guide.