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.
Related Formulas
More MarketXLS Key Ratios formulas you can use in the same worksheet:
- Return On Equity (Last 12 Months)
- Return on Invested Capital (Current Quarter)
- Revenue
- Revenue Per Share
- Revenue Per Share Five Years
- Revenue Per Share Three Years
- Total Cash
- Total Debt
See ReturnOnCapital used in a complete workbook: ROIC Screener Excel: Find High Return on Invested Capital Stocks for Quality Compounders in June 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today