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
Syntax
=ReturnOnAssetsLTM(Symbol)Returns
number
Return on assets (LTM) as a decimal
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
What's the difference between ReturnOnAssets and ReturnOnAssetsLTM?
Both measure ROA, but:
ReturnOnAssets()may use fiscal year dataReturnOnAssetsLTM()uses rolling last 12 months LTM is more current but may differ slightly.
Why might ROA LTM differ from annual ROA?
LTM updates quarterly as new data becomes available, while annual ROA only updates once per year after fiscal year end.
Related Formulas
More MarketXLS Key Ratios formulas you can use in the same worksheet:
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?