Shares Outstanding (1 Year - Growth)

Returns the 1-year percentage change in shares outstanding for a company.

Interpretation

  • Negative values indicate share buybacks (shareholder-friendly)
  • Positive values indicate dilution (new shares issued)
  • Value is expressed as decimal (0.05 = 5% increase)

Data Source

Calculated from historical shares outstanding data.

Examples

=SharesOutstandingOneYearChange("AAPL")
Apple share change
=SharesOutstandingOneYearChange("MSFT")
Microsoft share change
=SharesOutstandingOneYearChange(A1)
From cell reference

When to Use

  • Analyzing dilution risk
  • Evaluating buyback programs
  • Assessing shareholder value creation
  • Stock-based compensation impact

When NOT to Use

Scenario Use Instead
3-year trend SharesOutstandingThreeYearChange()
Current share count Shares_Outstanding()
Float shares FloatShares()

Common Issues & FAQ

Q: What does a negative value mean? A: The company has reduced shares outstanding (buybacks).

Q: How is this calculated? A: (Current shares - Shares 1 year ago) / Shares 1 year ago.

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 Shares Outstanding (1 Year - Growth) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions