Return On Assets 5 Year Average
Returns the five-year average Return on Assets (ROA) for a company. ROA measures how efficiently a company uses its total assets to generate profits.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Formula
ROA = Net Income / Total Assets
Interpretation
| ROA Level | Interpretation |
|---|---|
| > 10% | Excellent asset efficiency |
| 5-10% | Good asset efficiency |
| 2-5% | Average (varies by industry) |
| < 2% | Below average |
Notes
- Returns value as a decimal (0.10 = 10%)
- Asset-light companies typically have higher ROA
- Compare within same industry for meaningful analysis
Syntax
=ReturnOnAssetsFiveYearAverage(Symbol)Examples
=ReturnOnAssetsFiveYearAverage("AAPL")=ReturnOnAssetsFiveYearAverage("MSFT")=ReturnOnAssetsFiveYearAverage("WMT")Symbol from cell reference
=ReturnOnAssetsFiveYearAverage("AAPL")*100When to Use
- Assess long-term asset efficiency
- Compare asset utilization across companies
- Capital-intensive industry analysis
- DuPont analysis component
When NOT to Use
Common Issues & FAQ
Q: Why is the value less than 1? A: ROA is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.10 = 10%).
Q: Why do banks have low ROA? A: Banks are highly leveraged and asset-heavy by nature. 1-2% ROA is typical for banks, while tech companies may have 15%+ ROA.
Q: How does ROA differ from ROE? A: ROA measures profit relative to ALL assets; ROE measures profit relative to equity only. ROE is typically higher because it excludes debt-funded assets.
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?