Defining SAP Fiori Analytical Apps for Treasury and Risk Management Scope (1MN)

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Define the scope of SAP Fiori Analytical Apps for Treasury and Risk Management (1MN)
  • Get to know the scope of the Treasury Executive Dashboard

Foreign Exchange Overview App

Foreign Exchange Overview App

The SAP Fiori overview page is a new interaction in the SAP Fiori UX. It provides the big picture at a glance, and the details the user needs to take immediate action at a moment's notice, in a one-stop-shop page.

The overview page can be seen as a step between the basic information on the SAP Fiori launchpad and the full-blown information in the SAP Fiori app. While presenting the big picture at a glance, business users can also focus on the most important tasks, enabling faster decision-making as well as immediate action.

With the Foreign Exchange Overview app, you can display an overview of the foreign-exchange-related financial risks including FX instruments, financial status, cash position, and liquidity forecast at a selected key date.

To optimize the output you can filter the cards by various categories such as key date, display currency, exchange rate type, company code, and transaction currency.

Manage Cards for the Foreign Exchange Overview

It is possible to customize the overview page using the Manage Cards function. You'll find this function in the Me area by choosing the user icon in the upper left hand corner. There choose Manage Cards. This function allows you to rearrange, hide, and show the cards you want to see.

You define the display order for the currency pairs used in the Foreign Exchange Overview app with the Define Display Order tile.

There you can define the order in which the currency pairs, comprising a leading and a following currency, are displayed in the Foreign Exchange Overview app.

Navigation to Target App

With the Foreign Exchange Overview app, you get an overview of the foreign exchange related financial risks and in addition, you can navigate from one card to the respective target app.

To navigate to the target app of the key performance indicators, proceed as follows, for example, at the Credit Line Overview:

In the Credit Line Overview, at the Display Currency card, select one of the bars. This opens the Credit Line Analysis app.

The target app (in this case the Credit Line Analysis app) gives you all the details about the bar chart displayed in the Foreign Exchange Overview tile.

Reporting with SAP Fiori Analytical Apps

Market Data Overview App

With this app, you can display an overview of foreign exchange-related financial risks including current foreign exchange (FX) spot rate, historic FX spot rate, and FX swap rate on a selected key date. You can also get an overview of market data-related financial risks, including current security price and historic security price.

You can analyze several key performance indicators displayed on separate cards:

  • FX Spot Rate
  • Historic FX Spot Rate
  • FX Swap Rate
  • Historic Reference Interest Rate
  • Current Security Price
  • Historic Security Price

Furthermore, it is possible to define default values for the app using the Me Area via the user icon in the upper-left hand corner. Some of the default values available are:

  • Key Date
  • Exchange Rate Type
  • Price Type

The app offers several different KPIs displayed as a card. You can analyze the following:

  • FX Spot Rate

    The forex spot rate key figure on the key date and its percent different to the day before.

    In this card, you can see the KPI of FX spot rates of a currency pair on the key date. By default, the top six currency pairs of the FX spot rates are displayed. You can display more values by dragging the card.

    You can also see the percent difference of the exchange rate key figure to the rate on the day before the key day. By default, only the numbers of % Difference from Yesterday are displayed.

  • Historic FX Spot Rate

    With this card, you can see the KPI of FX spot rates of a currency pair before the key date. You can display the historic exchange rate key figure by period with drill-down options for several time periods.

  • FX Swap Rate

    With this card, you can see the KPI of FX swap rates in a term structure from the key date. By default, the term of 540 days of the FX swap rates is displayed. You can display more values by dragging the card.

  • Historic Reference Interest Rate

    With this card, you can see the KPI of reference interest rate before the key date. You can display the historic reference interest rate key figure by period with drill-down options for several time periods.

  • Current Security Price

    With this card, you can see the KPI of the current security prices by your favorite security classes in the corresponding exchange on the key date. By default, the top 6 security class and exchange data are displayed. You can display more values by dragging the card.

    You can also see the percent different of the price key figure to the price on the day before the key day.

  • Historic Security Price

    With this card, you can see the KPI of security prices in the corresponding exchange before the key date. You can display the price key figure by period with drill-down options for several time periods.

The Market Data Overview app offers the possibility to easily customize the overview page using the Manage Cards function. You can find this function in the Me Area by choosing the user icon in the upper-left hand corner. There, select Manage Cards. This function allows you to hide and show the cards that you want to see.

Furthermore, you can rearrange the overview page by dragging and dropping the cards to another position, reflecting the sequence that is most convenient for you.

In addition, the app supports the following technical features and options:

  • Navigation to the Enter FX Spot Rates app
  • Navigation to the Enter FX Swap Rates app
  • Navigation to Enter Reference Interest Rates app
  • Navigation to Enter Security Prices app

Interest Rate Overview

The Interest Rate Overview app works as a dashboard for interest-rate related transactions, which could help the end user to get an overview of company interest rate risk. It provides several different views, including the Debt / Investment Maturity Profile, Debt/Investment by Reference Interest Rate, or Yield Curves. Within the app, you can resize the cards to adjust views to your needs.

This card displays how much debt/investment amount will mature in the future. Only transactions whose start date <= key date, end date >= key date will be included. It is calculated based on the repayment flow/nominal decrease flow. Product category 510, 520, 530, 540, 550, 580 are included, however, 520 transactions before ‘giving notice’ are not included. The Number of Years parameter divides maturity flows into year groups but will not influence the total maturity amount in the future.

The tile provides the following views:

  • By Debt and Investment

  • By Debt

  • By Investment

It also supports navigation to Debt/Investment Maturity Profile.

This card shows how much debt/investment amount is currently open on a specified key date by product type. Only transactions whose start date <= key date, end date >= key date are included. Product category 510, 520, 530, 540, 550, 580 are included, and 520 transactions before ‘giving notice’ are also included.

This card displays the debt/investment amount based on a fixed or variable interest category, or to some specific reference interest rate. Product category 510, 520, 530, 540, 550, 580, 620 are included. Capitalized cash flow as well as installment repayment is considered as nominal changes. To keep consistency as position flow, a "Start date inclusive and end date exclusive" rule always applies here. The nominals happening on the activity start date will be counted, and those flows on activity end date are ignored.

Data in these two views might be slightly different from Cards 2 and 3, if there are parallel conditions in some transactions. The Net Open/Variable balance on the 4th view of Card 4 is always matched with the 4th view on Card 5 of total net open amount for all the reference interest rate. The card provides the following views:

  • By Debt and Investment

  • By Debt

  • By Investment

  • Risk Reduction by IR Swap

Capitalized cash flow as well as installment repayment are considered as nominal changes. To keep consistency as position flow, a "Start date inclusive and end date exclusive" rule always applies here. The nominals happening on an activity start date will be counted while those flows on the activity end date are ignored.

Card 6 shows the reference interest rate value that is effective on a specified key date and the deviation rate with previous effective reference interest rate value. Card 7 shows the reference interest rate trend in the last 7 days or last 12 months. Reference interest rates are sorted by total transaction nominal amount, which uses this rate as interest rate. Card 7 provides two views: Daily or Monthly.

This card shows the yield curve by yield curve type and yield curve currency.

Treasury Executive Dashboard

Overview

The Treasury Executive Dashboard visualizes real-time insights into treasury operations for treasury executives. The app shows key performance indicators (KPIs), such as liquidity, cash position, debt volume and structure, counterparty limits, volume of bank guarantees, and market trends.

The data presented from different application areas, such as Cash and Liquidity Management, Treasury and Risk Management, and Financial Accounting, is based on live data access, without data replication. The data is shown in the display currency and presented in the most appropriate way using a broad range of graphs, such as bar chart, column chart, pie chart, heat map, tables, or line chart.

The Treasury Executive Dashboard enables you to create different stories to analyze important treasury key figures in the SAC.

Along with these stories, pre-delivered, ready-to-use, standard dashboards are delivered. On the other hand, these dashboards are still flexible to cater for your reporting requirements.

Filter, sort, compare, or export the data of the various charts depending on your companies needs. You can also change the story variables to a user-defined set in order get an even deeper insight to your numbers.

Key features include the following:

Liquidity

Shows the liquidity as a KPI and analyzed by different attributes, such as regions, company codes, financial position groups, financial positions, and currencies. The liquidity is defined as the sum of financial positions representing assets.

Cash Management

Shows your cash position forecast, mid-term liquidity forecast, as well as actual cash flows.

Bank Relationship

Provides an overview of your banks and bank groups by different attributes, such as ratings, payment amounts, number of company codes and bank accounts.

Indebtedness

Monitors KPIs related to the debt of your company and analyzed by different attributes.

Counterparty Risk

Provides an overview of the limit utilization and free limits of a specific limit type by counterparty and counterparty ratings.

Market Risk

Provides you with the KPIs net present value and value at risk including charts analyzing these values by different aspects.

Bank Guarantee

Provides an overview of the volume and average fee rate of bank guarantees.

Market Overview

Shows the trend for different market rates as KPIs and analyzed by different attributes.

Liquidity

The Liquidity tab shows the liquidity as a key performance indicator and analyzed by different attributes, such as countries, regions, company codes, financial position groups, financial positions, and currencies.

The liquidity is the sum of financial positions representing assets in the display currency specified.

In the Liquidity Overview group, the app shows the liquidity for all countries or for a specific country as a key performance indicator. The delivered Standard view displays the liquidity for all countries. You can change this setting by choosing a country in the geographical map. The selected country is relevant for the shown key performance indicator Liquidity and for all other charts of the Liquidity Overview group. The charts of this group are interactive, if you choose, for example, a certain region in the Liquidity by Region chart, this choice is also reflected in all other charts of the group.

In the Liquidity Overview group, the following charts are available for analyzing the liquidity by different attributes.

Liquidity by Country (Geographical Map)

On this map, you can see the distribution of liquidity among the different countries. The liquidity is represented as bubbles, where the amount of liquidity determines the size of the bubbles. The liquidity of a country is the sum of the liquidity of all company codes in the country. The delivered Standard view shows the liquidity for all countries. You can change this setting by selecting a country in the geographical map. The selected country is then also relevant for the shown Liquidity measure and for all other charts in the Liquidity Overview group.

Liquidity

The liquidity is displayed as measure on the top of the page. The delivered Standard view displays the overall liquidity for all countries in all regions.

Liquidity by Region

This bar chart shows all regions the total liquidity of this region and the distribution of the liquidity across the different financial position groups, which are displayed in different colors.

Liquidity by Company Code

This bar chart shows for the all regions the liquidity at the company code level. It also shows the distribution of the liquidity of the company code on the different financial position groups, which are displayed in different colors. Only the top 5 company codes with the highest liquidity amounts are shown.

Liquidity by Financial Position Group

This bar chart shows the following for the selected regions: the liquidity on the level of the financial position group. Using the context menu, you can jump to the Financial Status - Book Value, Financial Status - Nominal Amount, and Define Financial Positions apps.

Liquidity by Currency

This bar chart shows for the selected regions the liquidity on the currency level. The currencies displayed are restricted to the top 10 currencies with the highest liquidity.

History of Liquidity

The History of Liquidity chart shows the development of the liquidity over the past four quarters.

In the Liquidity by Treasury Center and Financial Positions group, the app shows the distribution of the liquidity on financial positions for your top 5 treasury centers.

Cash Management

The Cash Management tab in the Treasury Executive Dashboard shows KPIs to help you understand the cash and liquidity status of your company.

On this tab, you can view cash management KPIs based on data from the One Exposure from Operations hub, for the following groups:

Cash Position Forecast

In this group, you can view cards that display the cash position figures by various dimensions, such as region, company code, bank, and so on.

Liquidity Forecast

In this group, you view cards that display the mid-term liquidity forecast for the next 90 days.

Actual Cash Flows

In this group, you can view cards that display the actual cash flows, namely the actual amounts of money that have been received by or paid from your bank accounts, for the past 90 days.

The Cash Position shows today's Forecast Closing Balance on the group level.

The following chart views are available for the Cash Position:

  • Cash Position by Region
  • Cash Position by Company Code
  • Cash Position by Bank Account Currency
  • Cash Position by Bank
  • Cash Position by Bank Account

The Balance Profile must be assigned for the Cash Position to define what cash flows are considered.

The Liquidity Forecast shows the forecasted balance and cash flows for the next 90 days. Cash flows can be broken down according to liquidity item which indicates use and source of cash flows.

For the Liquidity Forecast, the balance profile must be defined so that the cash flows are considered.

Actual Cash Flows shows the bank confirmed cash flows for the past 90 days.

Cash flows can be broken down according to liquidity item which indicates use and source of cash flows.

Bank Relationship

Click the on the elements of the interactive graphic to learn more about the elements of the Bank Relationship Overview tab of the Treasury Executive Dashboard.

Bank Relationship Overview

In the Bank and Bank Group Profile section, you can use cards to check your banks by bank rating, number of bank accounts, and payment amount. Figures for the total and average bank payments are also shown.

The app is delivered with a default Standard view. For the Bank Relationship tab, the display currency is set to EUR, the exchange rate to M Standard Translation at Average Rate. You can change the settings for cards of the Bank Profile group.

Note

In this group, only banks that are maintained with ratings are taken into consideration.

Only bank accounts with the statuses Active and Closing Request Sent to Bank are taken into account.

The company code information is taken from house bank data.

The incoming and outgoing payment amounts are calculated based on actual cash flows from the One Exposure from Operations hub.

In the table chart of the Financial Status, you get an overview of your assets, liabilities, and financial balances sorted by bank group and company code. You can quickly identify banks and bank groups with the highest balances. Get the distribution of assets/liabilities/credit line/unutilized credit line amounts per bank groups.

Gain insights into assets, liabilities, and credit line per bank group on a specific date by relying on customizing of Financial Positions. To do this, the Financial Position configuration was enhanced by an additional Asset/Liabilities category Not Specified to enable the introduction of additional sources for data other than assets or liabilities.

With the Financial Status table, you can view the following key figures in book value to understand your financial situation in each bank group:

Assets

Consists of asset financial positions, such as current account balances from Cash and Liquidity Management, and of investments managed in Treasury and Risk Management, such as money market investments, purchased money market funds, and bonds.

Liabilities

Borrowings managed in Treasury and Risk Management, such as money market borrowings or issued bonds.

Financial Balance

The sum of your assets and liabilities.

The Bank Fees tab offers various views on service charges from the banks or bank groups.

Most notably, you can find information on the following:

  • Service charge and tax per bank group in a period
  • Top / bottom N charges paid to the bank groups
  • Distribution of service charges per bank groups and service type / service common code

Amount of Financial Transactions: In this group, you compare your relationships with all your bank groups over all currencies based on the amounts of financial transactions. The charts in this group are interactive; for example, if you select a specific region on the left under Company Code by Region, this selection is reflected in all charts in the group. The following charts are available:

Distribution of Product Group Amount by Bank Groups

Display the percentages of the total amount for a product group by the different bank groups. The total amount of a product group is the sum of the amounts of all financial transactions belonging to the product group. The amount of a bank group is the sum of the amounts of financial transactions done with that bank group.

Moving the cursor over the different areas of the chart shows you the details for the product group amount of a bank group in separate text boxes.

History of Product Group Amount by Bank Group

Shows the development of the product group amount for the different bank groups within a period (default setting is the previous year). On the left under, Select Product Group, you can switch between the different product groups.

Moving the cursor over the different curves of the chart shows you the details for the product group amount of a bank group in separate text boxes.

In this group, you get an overview of your paid and forecasted financial transaction fees by bank group.

The following charts are available:

Paid Fees of Reporting Period - By Bank Group (Top 5)

This shows the five highest total amounts of financial transaction fees paid to bank groups in the reporting period.

Forecasted Fees - By Bank Group (Top 5)

This shows the five highest total amount of all financial transaction fee flows to the bank groups within the forecast period.

Distribution of Paid Fees of Reporting Period - By Bank Group

This shows how the paid fees are distributed among the different bank groups.

Distribution of Forecasted Fees - By Bank Group

This shows how the forecasted fees are distributed among the different bank groups.

History of Paid Fees by Bank Group

This shows the development of the amount of paid fees of financial transactions over the reporting period, sorted by bank group. You can choose the last year, quarter, or month as the reporting period.

Indebtness

Indebtness shows key performance indicators to help you understand and analyze the debt of your company. On this tab, you can view KPIs related to the debt of your company and organized into the following groups:

Total Amount of Debt by Different Attributes

In this group, you can view graphics that display the total amount of debt by various dimensions, that is, by company code, product type, and transaction currency. You can also view the debt maturity profile.

Structure of Interest Rate Debt

In this group, you can view graphics that display the structure of interest rate debt.

Total Credit Line and Credit Line Utilization

In this group, you can view graphics that display the total credit line by various dimensions, that is, by counterparty, company code, and by transaction currency. You can also view the utilized and available amount of the credit line as well as a forecast of the available amount in a time line.

Total Amount of Debt by Different Attributes: In this group, you can view graphics that display the total amount of debt by various dimensions, that is, by company code, product type, and transaction currency. You can also view the debt maturity profile.

Amount of Debt by Company Code

Shows you at a glance the 5 company codes with the highest outstanding nominal amount of debt (Top 5). You can also filter for the 5 company codes with the lowest amount of debt (Bottom 5).

Amount of Debt by Product Type

Shows you at a glance the 5 product types with the highest outstanding nominal amount of debt (Top 5). You can also filter for the 5 product types with the lowest amount of debt (Bottom 5).

Total Amount of Debt by Transaction Currency

Shows you at a glance the 5 transaction currencies in which you have the highest outstanding nominal amount of debt (Top 5). You can also filter for the 5 transaction currencies with the lowest amount of debt (Bottom 5).

Debt Maturity Profile

Shows you at a glance the debt maturity profile for the next 5 years and beyond. The outstanding nominal amount of debt is displayed in a bar chart, showing the proportional amounts for each product type and maturity year.

Structure of Interest Rate Debt: In this group, you can view graphics that display the structure of interest rate debt.

Structure of Interest Rate Debt

Shows you at a glance the outstanding nominal amount of interest rate instruments without interest rate swaps and their maturity for the next 5 years and beyond. The amount of interest rate debt is displayed in a bar chart, showing the proportional amounts for interest rate instruments with fixed interest category against the interest rate instruments with variable interest category.

Structure of Interest Rate Debt Including Swaps

Shows you at a glance the outstanding nominal amount of interest rate instruments including interest rate swaps and their maturity for the next 5 years and beyond. The amount of interest rate debt is displayed in a bar chart, showing the proportional amounts for interest rate instruments with fixed interest category against the interest rate instruments with variable interest category.

In the Total Credit Line and Credit Line Utilization group, you can view graphics that display the total credit line by various dimensions, that is, by counterparty, company code, and by transaction currency. You can also view the utilized and available amount of the credit line as well as a forecast of the available amount in a time line.

Total Credit Line

This displays the total credit line, the utilized amount, and the available amount.

Total Credit Line by Counterparty

This shows you at a glance the credit line, the utilized amount, and the available amount in display currency for the 5 counterparties with the largest credit line (Top 5). You can also filter for the 5 counterparties with the smallest credit line (Bottom 5).

Total Credit Line by Company Code

This shows you at a glance the credit line, utilized amount, and available amount in display currency for the 5 company codes with the largest credit line in million EUR (Top 5). You can also filter for the 5 company codes with the smallest credit line (Bottom 5).

Total Credit Line by Transaction Currency

This shows you at a glance the credit line, utilized amount, and available amount in display currency for the 5 transaction currencies with the largest credit line (Top 5). You can also filter for the 5 transaction currencies with the smallest credit line (Bottom 5).

Forecast of Available Amount

This shows you at a glance the total available amount in display currency over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

Counterparty Risk

The Counterparty Risk tab shows counterparty limit utilization, internal limits, and free limits of a specific limit type from different perspectives and also counterparty ratings.

Due to risk controlling regulations as well as for purely business reasons, you must measure, analyze, and control counterparty/issuer risks. The Treasury and Risk Management offers functions for controlling the counterparty risk by means of limits.

The Counterparty Risk tab only monitors limit utilizations and free limits of one specific limit type. This limit type must use the characteristics business partner and limit product group. Therefore, you can only monitor limits of the limit types BP./LPG. only assets and CoCd./BP/LPG only assets.

The counterparty limit utilizations and free limits are analyzed due to different aspects.

Note
  • Calculation of the internal limit amount, limit utilization amount, and the free limit amount: The determination of the valid internal limit amount on a specific date is complex. The internal limit amount is the sum of the limit specification amounts, the interim limit amounts, and the limit transfers (formula: Internal limit specification amount + internal interim limit amount + internal limit transfer amount = internal limit amount). The limit specifications, interim limits, and limit transfers are defined in the Manage Limits app. You can also define external limits in the Manage Limits app, but they are not shown in this app.
  • The limit utilization of the single record or transaction is the risk amount calculated for a single transaction by the attributable amount determination function. Using the limit characteristics and their values, the system combines the utilizations of the single records with the limit utilizations of the totals records or the limit. The limit utilization of a certain limit is, therefore, the total of the attributable amounts of all transactions attributed to the limit on the basis of their characteristic values.
  • The internal free limit amount is the internal limit amount minus the limit utilization.

To ensure that current data are available on the Counterparty Risk tab, you must run the End-of-Day Processing the same day before you start the Treasury Executive Dashboard.

The Counterparties with High and Low Utilizations section shows you at a glance the biggest risks and opportunities in the counterparty risk management:

  • Counterparties with the lowest free limits (Bottom 5)
  • Counterparties with the highest free limit (Top 5)
  • Counterparties with the highest limit utilization

The data is displayed as bar charts.

The names of the business partners are displayed at the left, and beside the displayed bars the amounts of the free limit/limit utilizations are also shown. For positive amounts, the bars are on the right of the plumb line. For negative amounts, the bars are on the left of the plumb line. A negative free limit indicates that the counterparty limit is exceeded.

In the Limit Utilizations, Free Limits and Ratings section, the charts of this group analyze the counterparty limit utilizations and free limits by different aspects.

Limit Utilizations by Counterparty

The bar chart shows for each counterparty the internal limit amount, the limit utilization, and the resulting free limit.

The charts of this group are responsive for the counterparty. If you set the cursor on a specific counterparty in this chart, all other charts only show the data relevant for the chosen counterparty.

Limit Utilization by Product Group

The graphic shows the internal limit amounts, the limit utilization, and the resulting free limits on the level of the limit product groups.

Free Limit by Counterparty and Product Group (Heat Map Chart)

This heat map shows you at a glance the current free limits by counterparty and limit product group.

The Utilization Overview by Counterparty and Product Group (table chart) shows you the limit utilization amount, internal limit amount, and the resulting free limit amount by counterparty and limit product group.

Note

If you set the cursor on a specific counterparty in the table chart, all rows in the table relevant for the counterparty are highlighted in the table. In addition, the Counterparty Rating table chart now only shows the rating for this specific counterparty.

The line chart for the History of Free Limits by Counterparty shows you the historic and current values of the free limits of your counterparties for the current year. This allows you to track the evolution of the free limit from the past to today. You can set the cursor on one or more counterparties, so you can see the values of these counterparties highlighted in the line chart.

You can also change the displayed Determination Period using the Set Chart Prompts function.

Market Risk

The Market Risk tab shows you the total net present value of your assets and liabilities and your overall value at risk at a glance and by different attributes.

There are generally the following two charts in the Market Risk area:

  • Net Present Value and Value at Risk by Different Attributes
  • History of Net Present Values

Prerequisites:

You must define market risk key figures sets using the Manage Market Risk Key Figure Sets app.

To ensure that current data is available on the Market Risk tab, you must calculate the market risk key figures before you start the Treasury Executive Dashboard using the job template Calculate Market Risk Key Figures in the Schedule Treasury Middle Office Jobs app, so that you can plan it as a periodic activity.

For the Net Present Value and Value at Risk by Different Attributes, there are several different measures and charts available to effectively control the Net Present Value and Value at Risk.

The single measures are as follows:

Net Present Value (NPV) (Measure)

The Net Present Value (NPV) measure shows the total net present value of all your assets and liabilities in the chosen display currency in millions EUR.

Value at Risk (VaR) (Measure)

The Value at Risk (VaR) measure shows the overall value at risk for all your assets and liabilities in the chosen display currency in millions EUR and you can compare this value directly to the overall NPV displayed beside.

Negative and Positive NPVs (Bar Chart)

You can see the total volume of the negative NPVs and of the positive NPVs.

Net Present Value by Product Category (Bar Chart)

You get an overview on the distribution of the NPV on the different product categories.

Value at Risk by Product Category (Bar Chart)

You get an overview on the distribution of the VaR on the different product categories and you can compare this values directly to the NPVs on same levels displayed beside.

Net Present Value by Key Figure Set and Product Category (Bar Chart)

As the other charts displayed the NPV and VaR for one market risk key figure set, you get in this chart the NPVs for different market risk key figure sets. Therefore, this chart enables you to see the effects of different market data scenarios and market data shifts on the NPVs of your assets and liabilities.

Value at Risk by Company Code and Product Category (Heat Map)

This heat map gives you an overview on the distribution of the VaR over your company codes and product categories. Dark colored fields imply a higher value at risk compared to the lighter colored fields.

The other option in the Market Risk tab is the History of Net Present Values. This chart shows the development of the NPVs over a specific time period. The chart shows the overall NPV for all calculation days of the selected market risk key figure sets. This enables you to see the trend.

Hovering over a single data point gives you more information on the item. From the legend at the top, you can also filter specific sets of information that are highlighted in the chart.

Bank Guarantee

The Bank Guarantee tab of the Treasury Executive Dashboard shows the key performance indicators related to bank guarantees and analyzed by different attributes.

They are organized into the following groups:

Total Volume of Bank Guarantees by Different Attributes

In this group, you can view bar charts displaying the total volume of bank guarantees by various dimensions, that is, by company code, counterparty, and currency. You can also view the number of bank guarantee transactions.

Average Fee Rate by Counterparty and by Calculation Types

In this group, you can view the average fee rate of bank guarantees by counterparty and filtered according to the selected fee calculation type. By default, linear interest calculation is selected as the fee calculation type. You can change this setting on the left in the Fee Calculation Type area.

In this group, you can view bar charts displaying the total volume of bank guarantees by various dimensions, that is, by company code, counterparty, and currency. You can also view the number of bank guarantee transactions.

Total Volume by Company Code

Shows you at a glance the 5 company codes with largest volume of bank guarantees (Top 5). You can also filter for the 5 company codes with the smallest volume of bank guarantees (Bottom 5).

Total Volume by Counterparty

Shows you at a glance the 5 counterparties with the largest volume of bank guarantees (Top 5). You can also filter for the 5 counterparties with the smallest volume of bank guarantees (Bottom 5). Using the context menu, you can jump to the Maintain Business Partner app to display the master data of the counterparty.

Total Volume by Currency

Shows you at a glance the 5 nominal currencies with the largest volume of bank guarantees (Top 5). You can also filter for the 5 nominal currencies with the smallest volume of bank guarantees (Bottom 5).

In the Average Fee Rate by Counterparty and Fee Calculation Type groups, you can view the average fee rate of bank guarantees by counterparty and filtered according to the selected fee calculation type. By default, linear interest calculation is selected as the fee calculation type. You can change this setting on the left in the Fee Calculation Type area.

Average Fee Rate by Counterparty

Shows you at a glance the 5 counterparties with the highest average fee rate in percent filtered by fee calculation type (Top 5). You can also filter for the 5 counterparties with the lowest average fee rate in percent (Bottom 5).

Volume and Average Fee Rate by Counterparty

Shows you at a glance the total volume of bank guarantees in million EUR in proportion to the average fee rate in percent. By default, the top 10 fee rates by counterparty are displayed. You can also filter for the top 5 or the bottom 5 fee rates by counterparty.

Market Overview

The Market Data Overview tab provides you with a historical trend of different market data categories. It shows the trend for different market rates as key performance indicators and analyzed by different attributes. On this tab, you can monitor the KPIs for the following market rates:

Foreign Exchange Rate

This shows you at a glance the trend for the foreign exchange rate for specified currency pairs over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

Reference Interest Rate

This shows you at a glance the trend of the reference interest rate for specified currencies over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

Security Price

This shows you at a glance the trend of the security price for specified security classes over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

Implied Volatility

This shows you at a glance the trend for implied volatility for the specified volatility name, volatility profile, and volatility type over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

Credit Spread

This shows you at a glance the trend for the credit spread for the specified reference entity and credit spread ID over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

Basis Spread

This shows you at a glance the trend for the basis spread for the specified basis spread ID over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

The chart on the Foreign Exchange Rate shows you, at a glance, the trend for the foreign exchange rate for specified currency pairs over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data.

For the Foreign Exchange Rate group, the following default values are set for the relevant variables:

  • The exchange rate type is set to M Standard Translation at Average Rate
  • The currency pair is set to EUR/USD
  • The calendar date is specified to lie between January 1 2018 and the current date

The Reference Interest Rate chart shows you at a glance the trend of the reference interest rate for specified currencies over the course of one year. You can also filter for a different time period, that is, one month, 3 months, 6 months, year to date, or for all data. For the Reference Interest Rate group, the following default values are set for the relevant variables:

  • The reference interest rate is set to EURBOND 2 Years.
  • The calendar date is specified to lie between January 1 2018 and the current date.

Log in to track your progress & complete quizzes