Return On Assets (LTM)
Returns the Return on Assets calculated over the last twelve months (trailing twelve months / TTM). This provides a more current view of asset efficiency than annual figures.
ROA (LTM) = Net Income (Last 12 Months) / Average Total Assets
LTM vs Annual ROA
| Metric | Period | Best For |
|---|---|---|
| ROA (LTM) | Rolling 12 months | Recent performance |
| ROA (Annual) | Fiscal year | Year-over-year comparison |
Notes
- LTM provides more current data than fiscal year figures
- Useful for companies with non-December fiscal years
- Eliminates seasonality effects by using full year
Examples
=ReturnOnAssetsLTM("AAPL")=ReturnOnAssetsLTM("MSFT")=ReturnOnAssetsLTM("GOOG")=ReturnOnAssetsLTM(A1)=ReturnOnAssetsLTM("AAPL")*100When to Use
- Current performance analysis
- Comparing companies with different fiscal year ends
- Tracking ROA trends over time
- Quarterly earnings analysis
- Building rolling performance metrics
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need fiscal year ROA | ReturnOnAssets() |
| Shareholder return | ReturnOnEquityLTM() |
| Historical comparison | hf_ReturnOnAssets() |
| Capital efficiency | ReturnOnCapitalLTM() |
Common Issues & FAQ
Q: What's the difference between ReturnOnAssets and ReturnOnAssetsLTM? A: Both measure ROA, but:
ReturnOnAssets()may use fiscal year dataReturnOnAssetsLTM()uses rolling last 12 months LTM is more current but may differ slightly.
Q: Why might ROA LTM differ from annual ROA? A: LTM updates quarterly as new data becomes available, while annual ROA only updates once per year after fiscal year end.
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?