Input Files
To create simulations, Jabatix NC needs some input data, these are provided in the form of input files. The following file types are supported:
Excel (.xlsx or .xls)
OpenOffice (.ods)
csv files (.csv)
In case you use .csv files, they have to be in a separate folder. The name of the .csv file corresponds to the name of a sheet in an Excel file and the folder name corresponds to the Excel filename. For example, both variants are equivalent:
Excel file myNumbers.xlsx with a sheet Balance
Folder myNumbers with a file Balance.csv
All needed input files are listed in the Control File which are then read and used by Jabatix NC.
The keyword input followed by the filename triggers the reading of the file content. If there is a financial at the end, these are considered as the historical business figures for which Jabatix NC then calculates future values.
If you want to work with .csv files and thus give the name of a folder, then the folder name must be followed by /, for example:
input myNumbers/
The path to the files and folders can be given as absolute path or as relative path to the control file. If the input files are in the same folder than the control file, then filenames are sufficient.
There are several types of input data, that are supported by Jabatix NC.
Financial Data
All business figures that are to be simulated must be provided as financial data. For each figure, at least one historical value must provided. When using certain functions (like Forecast Trend, Straight Line, Linear Regression or others), several historical values must be provided.
As mentioned earlier, financial data is recognized by the keyword financial.
The filename as well as the tab names can be freely chosen, for example:
BALANCE_SHEET
historical balance sheets of the company
INCOME_STATEMENT
historical profit and loss statements of the company
The business figures can be addressed within the Control File either by their name (column A) or by their number (column B).
All columns starting from column C are interpreted as historical values.
The same tab names will be used to generate results in the Output File.
Example
We want to simulate balance sheet and income statement for some future periods with Jabatix NC and provide historical statements of the last 5 years in an Excel file named “my_FINANCE_DATA.xlsx”:
Within the Control File we tell Jabatix NC to read this file with financial data using the instruction:
input my_FINANCE_DATA.xlsx financial
Calculation parameters (optional)
In case the calculation uses additional parameters, then they have to be provided as input files.
As mentioned earlier, input files are recognized by the keyword input followed by the filename..
In contrast to the financial data, the tab names for the calculation parameters are predefined and must not be changed.
Depending on the functions to be used, different types of calculation parameters are required.
Historical values
Historical values of external parameters.
tab name: HISTORICAL_VALUES
used within functions Volume Change, Linear Regression
Example
FORECASTS
Official forecasts for external parameters.
tab name: FORECASTS
used within functions Forecast Parameter, Volume Change, Linear Regression
Example
ESTIMATIONS_VOLUME
Individual estimates of the change in business figures depending on changes in external parameters
tab name: ESTIMATIONS_VOLUME
used within function Volume Change
Example
RISK_PARAMETER
Current probabilities of default per rating/scoring class
tab name: RISK_PARAMETER
used within functions Forecast PD, Default of Borrowers
Example
ESTIMATIONS_PD
Individual estimates of the change in default probabilities per rating/scoring class depending on changes in external parameters
tab name: ESTIMATIONS_PD
used within functions Forecast PD, Default of Borrowers, but only if they are called with the optional parameter with PD
Example
FIXED_VALUES
Fixed values per future date that are used in the simulation
tab name: FIXED_VALUES
used within function Amount
Example
DEPRECIATION
Type of amortisation including details per account
tab name: DEPRECIATION
used within function Depreciation
Example
Further Inputs (optional)
There are other input files having a more specific usage.
Customer List
A complete customer list, including remaining debt and rating/scoring is required for some functions. It works the same way as other parameters within Input Files | Calculation-parameters-(optional).
tab name: CUSTOMER_LIST
used within function Default of Borrowers, Forecast PD
Example
External Excel Files (optional)
It is possible to use an other Excel as input file in conjunction with the function Macro XLSX, which allows to use data from any Excel file within calculations.
Those files do not need to be loaded within the section Control File | Input, but can be addressed directly within the Control File | Calculation section.