Example

input FINANCE_DATA.xlsx financial
input forecast_INPUTS.xlsx

loop over 5 years
[10001] + 5%
[10002] = Forecast trend
[10003] + Volume change in relation to Oil Price
[10003] + Volume change in relation to Electricity Price
[11000] = sum [10001] to [10003]
[20003] + Volume change in relation to EURIBOR
        based on [10003] delayed by 1 year / 3

output forecast_OUTPUTS.xlsx

Use cases

USE CASES FOR SIMULATING BUSINESS FIGURES

Use case 0: Your first steps

  • Enter data for the calculation
  • Define simulation cycle
  • Enter simulation requirements in the control file 
  • Start simulation
Example Data

Save time with Jabatix NC

Imagine the following situation: After you have created your financial forecast, the market forecasts change. Now you have to react accordingly.Jabatix NC simply recalculates the positions that are affected by the change of market data in a matter of seconds using the updated market forecasts.

Jabatix NC is a calculation engine for users who create their financial forecast with Excel. For example, Jabatix NC can continue the trend of a time series in linear, exponential or logarithmic form in the best possible way by simply entering the command Forecast Trend – although trend continuation is also possible in Excel, it is much more time-consuming there.

A major added value of Jabatix NC lies in the consideration of multi-year forecasts, as the values of a period to be forecast always depend on the values already calculated for the previous period. Jabatix NC masters these chain calculations very well and quickly – especially when the values depend on market forecasts such as interest rates, commodity prices or similar.

In addition, Jabatix NC makes it very easy to stress-test forecasts by means of a scenario analysis. The user can specify for n scenarios how the forecasts should be adjusted for the respective scenario. The output file generated by Jabatix NC contains the forecasts for all scenarios and compares them in a common overview for each period.

Who benefits from Jabatix NC?

Jabatix NC is an easy-to-use calculation engine that can be used to forecast values, data and key figures. As a starting point, you have your historical balance sheets, profit and loss accounts, cash flow statements or other data to be forecast.

Individual items are dependent on market data (direct, indirect, with premiums or discounts). Now you want to calculate possible performences based on one or n market forecasts. Jabatix NC does this in a matter of seconds and provides the financial forecast in an output file (e.g. as Excel).

For the visual presentation of the results, you can continue to use Excel or tools based on it, such as Macabacus.

In Jabatix NC, you perform the mathematical operations in a time loop. For example, if you assume a constant growth rate of 10% over a period of 5 years, then the values for 2026 are based on the forecasts for 2025, which were also calculated with 10% growth. Of course, you can also use irregular growth rates such as 10% in the first two years, 5% in the third year and 12% in the last two years.

The financial forecast is thus calculated extremely quickly for n years – either in the simplest way as shown in the example above, but also using more complex mathematical techniques.

In addition, you can calculate rising or falling prices as well as the default of customers, suppliers, raw materials, borrowers, etc. if you supply the corresponding information in addition to your positions.

In the Standard Edition, Jabatix NC processes Excel, OpenOffice or csv files, whereas in the Enterprise Version you can also access existing databases.

Jabatix NC is super easy to use - you'll know how the programme works in an hour or less.

Forecasts subject to market prices

Do you have any items in your planning that are subject to market prices?

Jabatix NC is a tool that you can use to forecast balance sheets, income statements, cash flow statements or other data.

On the one hand, the programme can forecast the complete balance sheet or income statement, for example. On the other hand, it is also possible to use Jabatix NC to predict only financial ratios.

This is useful, for instance, if you have already created forecasts with other tools or Excel for items that are not subject to market price fluctuations and you want to continue using them. Jabatix NC then takes over the task of forecasting those positions that depend on market prices and their changes.

This is very useful in the event of sudden market price fluctuations, as it is not necessary to reforecast the entire balance sheet or income statement, but only the items (and their dependent items) that are affected by the changes.

This means that you can simply have Jabatix NC recalculate those forecasts that need to be adjusted due to certain events, while you can continue to trust the forecasts you have already created for all other items.

Future development

When is a forward transaction worthwhile?

Your annual result depends heavily on your purchase prices, e.g. for raw materials, energy and/or on interest rates, exchange rates or similar. If such price assumptions are included in your planning, you can use the “Optimise” function to permanently have Jabatix NC calculate in the background whether the costs of one or more forward transactions will stabilize the result or whether it is better to accept the market development.

Automatic market data

Jabatix NC automatically accesses historical market data from the EU or US Open Data Portal and calculates the future using various mathematical methods.
You can find more information here:
https://data.europa.eu/en
https://data.gov/
You can easily use any available data source here.

VAR (Loss risk)

Jabatix NC uses this parameter to calculate the planning risk. This allows potential losses to be more easily quantified and controlled.

Do you have a preference or do you have a different feature request? Share your wishes with us on our contact form