GL - EBITDA to Sales Ratio

KPIQuantifiable measurements, agreed to beforehand, that reflect the critical success factors (of the company, department, project, individual). 146

This KPI provides the following default drill paths:

  • GL chart

  • division

  • territory

The metricA measure used to assess performance in a key area of a business. rank values displayed in the KPI History and KPI Definition screens is the aggregated value of the first item for the first drill path only. Additionally, displayed rank-based metric values in these screens are not applicable.

To viewA set of data connected to a cube, deliberately laid out to communicate business information. the actual values for each KPI drill path, click History, select a snapshot date, and click Drill Down.

The displayed value of each metric is an aggregation of the data, up to the viewed levelIn a hierarchy, a level indicates a group of common or related members. For example, in a Time level, members may include Year, Month, Day or Fiscal Year, Calendar Year, etc. of the selected drill path, as of the As At snapshot date.

Metric Definition

The actual parameters making up the ratios are as defined in the specified GL hierarchyIn Analytics Dashboards, regular dimensions contain descriptive and business key information and this information is organised into a hierarchy; from it's highest level of granularity, to its lowest. The hierarchy contains multiple levels. For example, a hierarchy that has three levels such as "All Products", "Product Group", and "Products"..

The formula for the ratio is:

Some investors add interest expense back into net EBITDA when performing this calculation because they'd like to use operating returns before cost of borrowing.

OB - EBITDA Ratio

The EBITDA ratio opening balanceopening balance at the start of the current financial year.

MTD - EBITDA Ratio

The EBITDA ratio end mtdon the last day of the current financial period.

YTD - EBITDA Ratio

The EBITDA ratio end ytdon the last day of the current financial year.

QTR - EBITDA Ratio

The EBITDA ratio end quarteron the last day of the current financial quarter.

HY - EBITDA Ratio

The EBITDA ratio end half yearon the last day of the current financial half year.

LY MTD - EBITDA Ratio

The EBITDA ratio end ly mtdon the last day of the same period of the previous financial year.

LY YTD - EBITDA Ratio

The EBITDA ratio end ly ytdon the last day of the previous financial year.

LY QTR - EBITDA Ratio

The EBITDA ratio end ly qtron the last day of the same quarter of the previous financial year.

LY HY - EBITDA Ratio

The EBITDA ratio end ly hyon the last day of the same half year of the previous financial year.

LY Full Year - EBITDA Ratio

The EBITDA ratio end ly ytdon the last day of the previous financial year.

OB - EBITDA

The EBITDA opening balanceopening balance at the start of the current financial year.

MTD - EBITDA

The EBITDA mtdsince the first day of the current financial period.

YTD - EBITDA

The EBITDA ytdsince the first day of the current financial year.

QTR - EBITDA

The EBITDA quartersince the first day of the current financial quarter.

HY - EBITDA

The EBITDA half yearsince the first day of the current financial half year.

LY MTD - EBITDA

The EBITDA for the same month to date period in the previous financial year.

LY YTD - EBITDA

The EBITDA for the same year to date period in the previous financial year.

LY QTR - EBITDA

The EBITDA ly quartersince the first day of the previous year's financial quarter year.

LY HY - EBITDA

The EBITDA ly half yearsince the first day of the previous year's financial half year.

LY Full Year - EBITDA

The EBITDA ly full yearat the end of the previous financial year.

OB - Revenue

The revenue opening balanceopening balance at the start of the current financial year.

MTD - Revenue

The revenue mtdsince the first day of the current financial period.

YTD - Revenue

The revenue .ytdsince the first day of the current financial year.

QTR - Revenue

The revenue quartersince the first day of the current financial quarter.

HY - Revenue

The revenue half yearsince the first day of the current financial half year.

LY MTD - Revenue

The revenue for the same month to date period in the previous financial year.

LY YTD - Revenue

The revenue for the same year to date period in the previous financial year.

LY QTR - Revenue

The revenue ly quartersince the first day of the previous year's financial quarter year.

LY HY - Revenue

The revenue ly half yearsince the first day of the previous year's financial half year.

LY Full Year - Revenue

The revenue ly full yearat the end of the previous financial year.