Revenue To Assets (Historical)
Returns the asset turnover ratio, measuring how efficiently a company uses assets to generate revenue.
Syntax
=hf_Revenue_to_assets(Symbol, Year, [Quarter], [TTM])Examples
=hf_Revenue_to_assets("AAPL", 2023, 4)=hf_Revenue_to_assets("MSFT", 2022, , "TTM")When to Use
- Analyzing asset efficiency
- Comparing capital intensity
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need ROA | hf_Normalized_return_on_assets() |
Common Issues & FAQ
Higher or lower is better?
Higher values indicate more efficient asset utilization.
Related Formulas
More MarketXLS Historical Fundamentals 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?