Net Treasury - by Bank

The data model includes views such as "Position - by Bank" providing the current financial stance of each bank regarding assets and liabilities, and "Net Treasury - by Bank" determining the net cash and liquid assets held by each bank. Measures encompass variables like overdraft limit, bank balance, ST/MLT credit limits, financing, investments, and credit limit. It also evaluates bank positions in the short and long term, intercompany financial transactions, and available immediate, theoretical, and real funds or credit, alongside the utilization policy.

Benefits of This Data Model

• Improved Financial Visibility: The data model provides a clear view of each bank's current financial position in terms of assets and liabilities, enhancing transparency and enabling informed decision-making.
• Enhanced Risk Management: By evaluating bank positions in the short and long term, as well as intercompany financial transactions, the data model helps in identifying and mitigating potential risks associated with credit limits and investments.
• Optimized Cash Management: With measures like net cash, liquid assets, and available funds, the data model aids in managing cash effectively by understanding the immediate, theoretical, and real funds or credit available, thereby optimizing cash utilization strategies.

Key Performance Indicators (KPIs)

• Overdraft limit: The maximum amount of funds that a bank account can go negative before fees or restrictions are applied.
• Bank balance: The total amount of funds available in a bank account at a specific point in time.
• Bank position: The financial standing of the bank calculated based on its assets, liabilities, and capital.
• ST credit limit: The maximum amount of short-term credit available for borrowing.
• ST financing: The amount of short-term funds borrowed or provided by the bank.
• ST investment: The amount of short-term funds invested by the bank.
• ST position: The financial stance of the bank in the short term based on its assets and liabilities.
• MLT credit limit: The maximum amount of long-term credit available for borrowing.
• MLT financing: The amount of long-term funds borrowed or provided by the bank.
• MLT investment: The amount of long-term funds invested by the bank.
• MLT position: The financial stance of the bank in the long term based on its assets and liabilities.
• Interco limit: The maximum amount of funds available for intercompany transactions within the bank.
• Interco balance: The total amount of funds involved in intercompany transactions within the bank.
• Interco position: The financial standing of the bank in terms of intercompany transactions.
• Credit Limit: The total maximum amount of credit available to the bank.
• Immediate: The amount of funds or credit available for immediate use.
• Theoretical: The calculated amount of funds or credit available under ideal conditions.
• Real: The actual amount of funds or credit available in reality.
• Utilization Policy: The guidelines or rules governing the usage of available funds or credit by the bank.

Available Visualisations

View Name	Description
Position - by Bank	Displays the current financial position of each bank in terms of assets and liabilities.
Net Treasury - by Bank	Calculates the net amount of cash and other liquid assets held by each bank.