Return On Sales (Historical)
Returns the historical return on sales (ROS) measuring operating efficiency.
Syntax
=hf_Return_on_Sales(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Quarter (1-4)
TTMstring
TTM for trailing twelve months
Returns
number
Return on sales as decimal
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?