Shares Outstanding (3 Year - Growth)

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

Interpretation

  • Negative values indicate net buybacks over 3 years
  • Positive values indicate net dilution over 3 years
  • Value is expressed as decimal (0.10 = 10% increase)

Data Source

Calculated from historical shares outstanding data.

Examples

=SharesOutstandingThreeYearChange("AAPL")
3-year share change
=SharesOutstandingThreeYearChange("MSFT")
Microsoft 3-year change

When to Use

  • Long-term dilution analysis
  • Evaluating capital allocation
  • Multi-year buyback assessment
  • Value creation analysis

When NOT to Use

Scenario Use Instead
1-year trend SharesOutstandingOneYearChange()
Current share count Shares_Outstanding()
Float shares FloatShares()

Common Issues & FAQ

Q: Why use 3-year vs 1-year? A: 3-year shows long-term capital allocation patterns, smoothing annual volatility.

Q: What causes share count changes? A: Stock buybacks (reduce), stock compensation (increase), secondary offerings (increase).

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

Related Functions