5 · Alerts
Alerts
Turn on alerts and set thresholds. A red dot appears next to the KPI when the threshold is crossed, and it is counted under “Alerts”.
| KPI | Latest | Alert when | Threshold | Active | |
|---|---|---|---|---|---|
| Profitability | |||||
| Total Revenue Sum of all revenue accounts | EGP 1,066,138 | is less than | EGP | ||
| Gross Profit Margin Gross Profit ÷ Revenue × 100 | 45.03% | is less than | % | ||
| Operating Profit Margin Operating Profit ÷ Revenue × 100 | 17.05% | is less than | % | ||
| EBIT Margin EBIT ÷ Revenue × 100 | 15.17% | is less than | % | ||
| Net Profit After Tax Margin Earnings After Tax ÷ Revenue × 100 | 10.95% | is less than | % | ||
| Activity | |||||
| Activity Ratio Annualised Revenue ÷ Average Invested Capital (equity + borrowing) | 5.3 times | is less than | times | ||
| Accounts Receivable Days* Average Accounts Receivable ÷ (1 + VAT rate) × Days ÷ Revenue (VAT-adjusted) | 15 days | exceeds | days | ||
| Inventory Days* Average Inventory × Days ÷ Cost of Sales (before depreciation) | 22 days | exceeds | days | ||
| Accounts Payable Days Average Accounts Payable ÷ (1 + VAT rate) × Days ÷ Cost of Sales (before depreciation) (VAT-adjusted) | 13 days | is less than | days | ||
| Efficiency | |||||
| Return on Equity Annualised Net Income ÷ Average Total Equity × 100 | 63.63% | is less than | % | ||
| Return on Capital Employed Annualised EBIT ÷ Average Invested Capital (equity + borrowing) × 100 | 80.73% | is less than | % | ||
| Gross Margin Return on Inventory Annualised Gross Profit ÷ Average Inventory × 100 | 1,365.82% | is less than | % | ||
| Asset Usage | |||||
| Asset Turnover Annualised Revenue ÷ Average Total Assets | 4.6 times | is less than | times | ||
| Working Capital Absorption* Operating Working Capital ÷ Annualised Revenue × 100 | 5.67% | exceeds | % | ||
| Liquidity | |||||
| Current Ratio Total Current Assets ÷ Total Current Liabilities | 4.84:1 | is less than | :1 | ||
| Quick Ratio (Cash & Equivalents + Accounts Receivable) ÷ Total Current Liabilities | 4.10:1 | is less than | :1 | ||
| Coverage | |||||
| Interest Cover EBIT ÷ Interest Expenses | 7.7 times | is less than | times | ||
| Cash Flow | |||||
| Cash on Hand Closing Cash & Equivalents | EGP 1,711,153 | is less than | EGP | ||
| Cash Flow Margin Operating Cash Flow (before interest) ÷ Revenue × 100 | 12.91% | is less than | % | ||
| Net Variable Cash Flow (Ann. Revenue − Ann. Variable COS − Ann. Variable Expenses − Operating Working Capital) ÷ Ann. Revenue × 100 | 34.83% | is less than | % | ||
| Growth | |||||
| Revenue Growth (Revenue − Prior Revenue) ÷ Prior Revenue × 100 | -7.05% | is less than | % | ||
| Gross Profit Growth (Gross Profit − Prior Gross Profit) ÷ Prior Gross Profit × 100 | -7.12% | is less than | % | ||
| EBIT Growth (EBIT − Prior EBIT) ÷ |Prior EBIT| × 100 | -16.83% | is less than | % | ||
| Asset Change (Total Assets − Opening Total Assets) ÷ Opening Total Assets × 100 | 3.58% | is less than | % | ||
| Equity Change (Total Equity − Opening Total Equity) ÷ Opening Total Equity × 100 | 5.74% | is less than | % | ||
* A result below target is favourable for this KPI.
The demo company is read-only.