Margin & Cost

This widget displays the YTD data for four KPIs. These KPIs based on the YTD data, from start of fiscal year until today.

Note: 
  • The KPI displays the data for the selected fiscal period as well as all prior fiscal periods within the same year.
  • The Group Company and Taxonomy fields must be defined in the Filter section.

These KPIs are displayed in this widget:

EBITDA
EBITDA evaluates the profitability of the operating business. This KPI displays the YTD EBITDA value and trend between the current year and previous year. You can view the EBITDA % and target % in this KPI.

Formula: EBITDA% =100 * EBITDA / Revenues

For this KPI:

  • If the actual value is negative, the value is displayed in Red colour.
  • If the actual value is positive, the value is displayed in Green colour.
COGS
COGS indicates the efficiency of production processes and the ability to manage costs. This KPI displays the YTD COGS value and trend between the current year and previous year. You can view the COGS % and target % in this KPI.

Formula: COGS %= 100 * Cost of goods sold / Revenues

For this KPI:

  • If the actual value is positive, the value is displayed in Red colour.
  • If the actual value is negative, the value is displayed in Green colour.
Gross Margin
Gross Margin measures the ability to generate profit from products or services. This KPI displays the YTD gross margin value and trend between the current year and previous year. You can view the gross margin % and target % in this KPI.

Formula: Gross profit %= Gross profit / Revenues

For this KPI:

  • If the actual value is negative, the value is displayed in Red colour.
  • If the actual value is positive, the value is displayed in Green colour.
OPEX
OPEX measures how much of sales revenue is consumed by operating expenses and indicates operational efficiency and profitability. You can view the operating expenses for fiscal periods, financial companies, dimensions, and subaccounts in the OPEX summary window. You can view the opex % and target % in this KPI.

Formula: OPEX %= 100 * Operating expense / Revenues

For this KPI:

  • If the actual value is positive, the value is displayed in Red colour.
  • If the actual value is negative, the value is displayed in Green colour.

The OPEX forecast provides a 12 month forward forecast of current year operating expenses in the form of a bar chart. The forecast count is displayed when you rest the pointer on the bar chart. This forecast enables the CFO to anticipate the expenses and plan the financial strategies.

In this KPI you can view:

  • Fiscal Period: Displays the YTD OPEX values and trend between the current year and previous year.
  • Financial Companies: Displays OPEX values for the select group company, for the current period and year-to-date, based on the selected filters.
  • Dimensions: Displays the top 10 dimensions with the highest OPEX for the current period and year-to-date, based on the selected filters.
    Note: You can select the dimension type, available for the selected company in the user settings to view the top 10 highest opex contributing dimensions.
  • Sub-Accounts: Displays OPEX values by sub-taxonomy accounts for the current period and year-to-date, based on the selected filters.

You can use the OPEX insights option in this widget to access the Open insights window wherein you can view the unusual spending patterns, variances, and potential financial risks, based on the historical data.

You can select one of these three standard prompts in the Open insights window:

  • Which sub-accounts are highly contributing the OPEX?
  • Which months show potential anomalies?
  • Which expense types are increasing month over month?