Return On Sales (Historical)
Returns the historical return on sales (ROS) measuring operating efficiency.
Syntax
=hf_Return_on_Sales(Symbol, Year, [Quarter], [TTM])Examples
=hf_Return_on_Sales("AAPL", 2023, 4)=hf_Return_on_Sales("MSFT", "ly")When to Use
- Operating efficiency analysis
- Profitability comparisons
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Net profit margin | hf_Profit_Margin() |
Common Issues & FAQ
How is ROS different from profit margin?
ROS typically uses operating income, while profit margin uses net income.
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?