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

Examples

=hf_Sales_per_Share("AAPL", 2023, 4)
Q4 2023 sales/share
=hf_Sales_per_Share("MSFT", "ly")
Last year sales/share
=hf_Sales_per_Share("GOOGL", 2023, , "TTM")
TTM sales per share

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

Q: How is this different from revenue? A: Sales per share normalizes revenue by shares outstanding for comparability.

Q: When is this useful? A: When comparing revenue generation efficiency across companies.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Sales Per Share (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions