MarketXLS

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])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Sales per share in USD

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

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.

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
MarketXLS Excel Add-in Tutorial - How to Use Sales Per Share (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions