Return on Capital Employed formula
\[ \dfrac{\text{EBIT}}{\text{Average total assets} - \text{Average current liabilities}} \]
Terms
- EBIT, period total: Earnings before interest and taxes: operating profit plus other income and expenses such as investment income and currency results. It is the profit available to pay lenders, the state and owners.
- Current liabilities, average of opening and closing: Obligations due within a year: trade payables, short-term borrowings, tax and payroll liabilities, accruals.
- Total assets, average of opening and closing: Everything the company owns or controls: non-current plus current assets.
Result
Return on Capital Employed is a percentage. Higher is better.
Target
A ROCE below the cost of borrowing means growth funded by debt destroys value.
Return on Capital Employed in Business Central
Cost of sales (period total)
- Category Cost of Goods Sold (26) and every category below it
- Plus 3 accounts assigned directly: 50310 Project Costs, 50320 Project Cost Applied, 50410 Purchase Variance, Retail
10 posting accounts in total.
The full account list is on the Cost of sales page.
Current liabilities (average of opening and closing)
- Category Current Liabilities (11) and every category below it
- Category Payroll Liabilities (12) and every category below it
- Plus 8 accounts assigned directly: 23850 Employees Payable, 26100 Accrued wages/salaries, 26200 Accrued Holiday pay, 26300 Accrued Pension costs, 26400 Accrued Interest Expense, 26500 Deferred Income, 26600 Accrued Contractual costs, 26700 Other Accrued Expenses and Deferred Income
29 posting accounts in total.
The full account list is on the Current liabilities page.
Operating expenses (period total)
- Category Expense (31) and every category below it
- Plus 3 accounts assigned directly: 60410 Utilities Expense - Power Plant, 66200 Depreciation, Equipment, 67400 Miscellaneous
- Except category Interest Expense, account 91000 Currency Losses
102 posting accounts in total.
The full account list is on the Operating expenses page.
Other income and expenses, net (period total)
- Category Income, Interest (24) and every category below it
- Plus 6 accounts assigned directly: 40310 Income from securities, 40320 Management Fee Revenue, 40380 Currency Gains, 40390 Other Incidental Revenue, 81200 Gains and Losses, 91000 Currency Losses
7 posting accounts in total.
The full account list is on the Other income and expenses, net page.
Revenue (period total)
- Category Income, Services (19) and every category below it
- Category Income, Product Sales (20) and every category below it
- Category Income, Jobs (21) and every category below it
- Category Sales Discounts (22) and every category below it
- Category Sales Returns & Allowances (23) and every category below it
- Category Job Sales Contra (25) and every category below it
- Plus 8 accounts assigned directly: 40410 Job Sales, 40420 Job Sales Applied, 40430 Sales of Service Contracts, 40440 Sales of Service Work, 40910 Discounts and Allowances, 40920 Invoice Rounding, 40930 Payment Tolerance, 40940 Sales Returns
13 posting accounts in total.
The full account list is on the Revenue page.
Total assets (average of opening and closing)
- Category Assets (1) and every category below it
- Plus 1 account assigned directly: 17120 Decreases during the Year
55 posting accounts in total.
The full account list is on the Total assets page.
Add Return on Capital Employed to a Power BI report
I build Power BI finance reports on Business Central data, with Return on Capital Employed, its trend and, where it helps, a forecast with a likely range. See it on your data