Return On Capital (ROC/ROCE)
Returns the Return on Capital for a company, which measures how efficiently it generates profit from its capital base (equity + debt).
Return on Capital = EBIT / (Total Assets - Current Liabilities)
or alternatively:
Return on Capital = Net Operating Profit / Total Capital Employed
ROC vs Other Return Metrics
| Metric | Denominator | Best For |
|---|---|---|
| ROC/ROCE | Total capital employed | Overall efficiency |
| ROIC | Invested capital | Investment decisions |
| ROE | Shareholder equity | Shareholder returns |
| ROA | Total assets | Asset efficiency |
Interpretation
| Range | Interpretation |
|---|---|
| > 20% | Excellent capital efficiency |
| 15% - 20% | Good capital usage |
| 10% - 15% | Average performance |
| < 10% | Below average or capital-intensive |
Syntax
=ReturnOnCapital(Symbol)Examples
=ReturnOnCapital("AAPL")=ReturnOnCapital("MSFT")=ReturnOnCapital("XOM")=ReturnOnCapital(A1)=ReturnOnCapital("AAPL")*100When to Use
- Evaluating overall capital efficiency
- Comparing companies across industries
- Assessing management effectiveness
- Value investing analysis
- Capital allocation decisions
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Focus on invested capital | ReturnOnInvestedCapitalOneYear() |
| Shareholder perspective | ReturnOnEquity() |
| Asset utilization | ReturnOnAssets() |
| Historical comparison | hf_ReturnOnCapital() |
Common Issues & FAQ
What's the difference between ROC and ROIC?
Both measure capital efficiency but:
- ROC uses total capital employed
- ROIC uses invested capital (more focused on operating assets) They often give similar results but ROIC is more precise for investment analysis.
Why might ROC be very high?
High ROC can indicate:
- Asset-light business model
- Strong competitive advantages
- Low capital requirements
- Or potentially aggressive accounting
How does leverage affect ROC?
ROC includes debt in the denominator, so it's less affected by leverage than ROE. This makes it better for comparing companies with different capital structures.
Excel Templates Using Return On Capital
These ready-made MarketXLS templates call ReturnOnCapital() in their worksheet formulas. Open one to see the function working inside a complete model.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?