Return On Invested Capital (ROIC)

Returns the Return on Invested Capital, which measures how efficiently a company generates returns on the capital invested in its operations.

ROIC = NOPAT / Invested Capital

Where:

  • NOPAT = Net Operating Profit After Tax
  • Invested Capital = Total Debt + Equity - Cash and Equivalents

Why ROIC Matters

ROIC is considered one of the most important profitability metrics because:

  • It focuses on operating efficiency
  • It's compared against WACC (cost of capital)
  • ROIC > WACC = creating shareholder value
  • ROIC < WACC = destroying shareholder value

Interpretation

Range Interpretation
> 20% Excellent capital allocation
15% - 20% Strong value creation
10% - 15% Good performance
< 10% May be below cost of capital

Notes

  • Warren Buffett's favorite metric for quality businesses
  • Look for consistent ROIC over multiple years
  • Compare ROIC to the company's WACC

Examples

=ReturnOnInvestedCapitalOneYear("AAPL")
Apple ROIC
=ReturnOnInvestedCapitalOneYear("MSFT")
Microsoft ROIC
=ReturnOnInvestedCapitalOneYear("WMT")
Walmart ROIC
=ReturnOnInvestedCapitalOneYear(A1)
Symbol from cell reference
=ReturnOnInvestedCapitalOneYear("AAPL")*100
Convert to percentage

When to Use

  • Quality investing analysis
  • Comparing capital allocation efficiency
  • Screening for high-quality businesses
  • Determining if company creates value
  • Long-term investment decisions

When NOT to Use

Scenario Use Instead
Shareholder returns ReturnOnEquity()
Asset efficiency ReturnOnAssets()
Total capital efficiency ReturnOnCapital()
Quarterly ROIC ReturnOnInvestedCapitalQuarter()

Common Issues & FAQ

Q: Why is ROIC considered the best profitability metric? A: ROIC:

  • Focuses on operating capital (excludes excess cash)
  • Uses after-tax operating profit
  • Is directly comparable to cost of capital
  • Measures true value creation/destruction

Q: How do I know if ROIC is good? A: Compare to the company's WACC (Weighted Average Cost of Capital):

  • ROIC > WACC = creating value
  • ROIC < WACC = destroying value Generally, ROIC > 15% is considered excellent.

Q: Why might two similar companies have different ROIC? A: ROIC differences can result from:

  • Competitive advantages (pricing power)
  • Operational efficiency
  • Capital intensity of business model
  • Industry dynamics

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Return On Invested Capital (ROIC - Last 12 Months) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions