Calculated metrics
On the Calculated Metrics page, you define calculation formulas and apply them to existing foundational metrics, base metrics, and statistical accounts. In the formula definition, you can use mathematical operations such as addition, subtraction, multiplication, and division. For example, ([MAP_0001] + [MAP_0005]) / [MAPG_2100].
Select .
In the grid, you can change these metrics properties:
- ID
- Name
- Description
- Group
- Calculation
- Format
- String
- Order
- OLAP ID
- Growth Impact
- Has Currency Selection Enabled
- Has Unit of Measure Selection Enabled
- Unit of Measure
Loading the default package of calculated metrics
To load a predefined set of finance calculated metrics, select .
Each calculated metric includes a formula definition.
This table shows the included calculated metrics and their descriptions:
| ID | Name | Description | Group | Order | Calculation | Format |
|---|---|---|---|---|---|---|
| CALC_Working_Capital | Working Capital | Available cash and cash equivalents that cover current, short-term obligations. | Liquidity | 1 | [MAPG_1100 Current Assets] - [MAPG_2100 Current Liabilities] | #,##0.00 |
| CALC_Current_Ratio | Current Ratio | Comparison of total current assets with total current liabilities. | Liquidity | 2 | [MAPG_1100 Current Assets] / [MAPG_2100 Current Liabilities] | #,##0.00 |
| CALC_Acid_Test_Ratio | Acid-Test Ratio | Comparison of cash and accounts receivable with current liabilities. | Liquidity | 3 | ([MAP_0001 Cash and Cash Equivalents] + [MAP_0005 Trade Receivables]) / [MAPG_2100 Current Liabilities] | #,##0.00 |
| CALC_Cash_Ratio | Cash Ratio | Liquidity measure that indicates the ability to cover short-term obligations with cash and cash equivalents. | Liquidity | 4 | [MAP_0001 Cash and Cash Equivalents] / [MAPG_2100 Current Liabilities] | #,##0.00 |
| CALC_Operating_Cash_Flow_Ratio | Operating Cash Flow Ratio | Measure that indicates the ability to pay debts from existing cash flows. | Liquidity | 5 | [MAPG_5000 Operating Profit] / [MAPG_2100 Current Liabilities] | #,##0.00 |
| CALC_Liquidity_Ratios | Liquidity Ratios | Ratio that indicates the ability to pay short-term debt obligations. | Liquidity | 6 | [MAPG_5000 Operating Profit] / [MAPG_2100 Current Liabilities] | #,##0.00 |
| CALC_Debt_Ratio | Debt Ratio | Metric that measures the total debt as a percentage of total assets. | Leverage | 7 | ([MAPG_2100 Current Liabilities] + [MAPG_2200 Non-Current Liabilities]) / [MAPG_1000 Total Assets] | #,##0.00 |
| CALC_Debt_to_Equity_Ratio | Debt to Equity Ratio | Indicator of the debt level in relation to total assets. | Leverage | 8 | ([MAPG_2100 Current Liabilities] + [MAPG_2200 Non-Current Liabilities]) / [MAPG_2300 Total Shareholders Equity] | #,##0.00 |
| CALC_Interest_Coverage_Ratio | Interest Coverage Ratio | Measure of the ability to cover interest expenses. The ability is calculated by dividing EBIT, EBITDA, or EBIAT by the interest expense for the period.
Note: EBIT is Earnings Before Interest and Taxes. EBITDA is Earnings Before Interest, Taxes, Depreciation and Amortization. EBIAT is Earnings Before Interest After Taxes.
|
Leverage | 9 | [MAPG_5000 Operating Profit] / [MAPG_3300 Interest Expenses] | #,##0.00 |
| CALC_Asset_Turnover_Ratio | Asset Turnover Ratio | Measure of how efficiently owned resources generate revenue or sales. | Efficiency | 10 | [MAPG_7000 Revenue] / [MAPG_1000 Total Assets] | #,##0.00 |
| CALC_Inventory_Turnover_Ratio | Inventory Turnover Ratio | Measure of inventory efficiency, which is calculated by dividing cost of goods sold by the average inventory during the period. | Efficiency | 11 | [MAPG_8000 COGS] / [MAP_0006 Inventories] | #,##0.00 |
| CALC_Receivables_Turnover_Ratio | Receivables Turnover Ratio | Metric that measures the effectiveness of debt collection and credit extension. | Efficiency | 12 | [MAPG_7000 Revenue] / [MAP_0005 Trade Receivables] | #,##0.00 |
| CALC_Account_Payables_Turnover_Ratio | Account Payables Turnover Ratio | Measure of how quickly payments are made to credit-providing creditors and suppliers. | Efficiency | 13 | [MAPG_8000 COGS] / [MAP_0024 Trade Payables] | #,##0.00 |
| CALC_Capital_Turnover_Ratio | Capital Turnover Ratio | Ratio that measures how effectively working capital supports sales and growth. | Efficiency | 14 | [MAPG_7000 Revenue] / [MAPG_2300 Total Shareholders Equity] | #,##0.00 |
| CALC_Gross_Margin | Gross Margin | Percentage of revenue remaining after subtracting direct costs. | Profitability | 15 | [MAPG_6000 Gross Profit] / [MAPG_7000 Revenue] | 0.00% |
| CALC_Operating_Profit_Margin | Operating Profit Margin | Measure of profit from sales after variable production costs and before interest and tax. | Profitability | 16 | [MAPG_5000 Operating Profit] / [MAPG_7000 Revenue] | 0.00% |
| CALC_Return_on_Assets_ROA | Return on Assets ROA | Metric that indicates profitability relative to total assets. | Profitability | 17 | [MAPG_3000 Net Profit] / [MAPG_1000 Total Assets] | 0.00% |
| CALC_Return_on_Equity_ROE | Return on Equity ROE | Measure of financial performance as net income divided by shareholders' equity. | Profitability | 18 | [MAPG_3000 Net Profit] / [MAPG_2300 Total Shareholders' Equity] | 0.00% |