Profitability analysis
You can ask questions about the profitability of your business up to the level of a single company code and hila returns calculated profitability metrics.
All profitability metrics
Include the terms profitability (or profitability analysis) to get a full table of profitability metrics for the company code you are interested in. For example, the following images show table and chart results for the query: Profitability analysis for 2023.
Individual profitability metrics
You can also ask for individual metrics. The results appear in the standard hila tables and charts.
Keywords for profitability metrics:
- Gross profit —
Revenue - Cost of Goods Sold (COGS)
- Gross Profit Margin (%) —
Gross Profit / Revenue * 100
- Operating Profit / Earnings before Interest and Tax (EBIT) —
Revenue - COGS - Operating Expenses
- Operating Profit Margin (%) —
EBIT / Revenue * 100
- Net Profit —
Revenue - Total Expenses (COGS, Operating Expenses, Interest Expense, Taxes)
- Net Profit Margin (%) —
Net Profit / Revenue * 100
- Operating Expense Ratio (%) —
Operating Expenses / Revenue * 100
The time scales for profitability analysis are:
- Year
- Quarter
- Month
- Year-to-Date (YTD)
- Quarter-to-Date (QTD)
- Month-to-Date (MTD)
TABLE OF CONTENTS