Sales Per Share (Historical)
Returns the historical sales (revenue) per share for a company. This normalizes revenue by share count.
Formula
Sales per Share = Total Revenue / Weighted Average Shares Outstanding
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Quarter 1-4 |
| TTM | No | "TTM" for trailing twelve months |
Syntax
=hf_Sales_per_Share(Symbol, Year, [Quarter], [TTM])Examples
=hf_Sales_per_Share("AAPL", 2023, 4)=hf_Sales_per_Share("MSFT", "ly")=hf_Sales_per_Share("GOOGL", 2023, , "TTM")When to Use
- Per-share valuation analysis
- Comparing companies of different sizes
- Price to sales calculations
- Revenue trend per share
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Total revenue | hf_Revenue() |
| Earnings per share | hf_Earnings_per_Basic_Share() |
| P/S ratio | PricePerSales() |
Common Issues & FAQ
How is this different from revenue?
Sales per share normalizes revenue by shares outstanding for comparability.
When is this useful?
When comparing revenue generation efficiency across companies.
Excel Templates Using Sales Per Share (Historical)
These ready-made MarketXLS templates call hf_Sales_per_Share() in their worksheet formulas. Open one to see the function working inside a complete model.
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?