Issuance Purchase Of Equity Shares (Historical)

Returns the historical net cash flow from equity activities - the difference between stock issuance proceeds and stock repurchase spending during the period.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

Value Interpretation

Sign Meaning
Positive Net equity issuance (raised equity capital)
Negative Net share repurchases (buybacks exceeded issuance)
Zero No net change in equity

Notes

  • Large negative values indicate significant buyback programs
  • Positive values common for growing companies raising capital
  • May include employee stock option exercises
  • Part of financing activities in cash flow statement

Examples

=hf_Issuance_Purchase_of_Equity_Shares("AAPL", 2023, 4)
Q4 2023 buyback activity
=hf_Issuance_Purchase_of_Equity_Shares("MSFT", "ly")
Last fiscal year
=hf_Issuance_Purchase_of_Equity_Shares("BRK.B", 2023, , "TTM")
Trailing 12 months
=hf_Issuance_Purchase_of_Equity_Shares(A1, B1, C1)
From cell references

When to Use

  • Analyzing buyback programs
  • Understanding shareholder returns
  • Tracking dilution from stock issuance
  • Capital allocation analysis
  • Comparing buybacks to dividends

When NOT to Use

Scenario Use Instead
Need current shares Shares_Outstanding()
Need total financing cash flow hf_Net_Cash_Flow_from_Financing()
Need debt activity hf_Issuance_Repayment_of_Debt_Securities()
Need dividend payments hf_Payment_of_Dividends_and_Other_Cash_Distributions()

Common Issues & FAQ

Q: Why are Apple's buybacks so large? A: Apple has one of the largest buyback programs in history, regularly spending $20B+ quarterly on share repurchases.

Q: Are buybacks better than dividends? A: Tax efficiency often favors buybacks. Buybacks are flexible (can stop anytime), while dividend cuts signal trouble.

Q: How do I calculate total shareholder returns? A: Total Returns = Buybacks + Dividends: =ABS(hf_Issuance_Purchase_of_Equity_Shares("AAPL","ly")) + ABS(hf_Payment_of_Dividends_and_Other_Cash_Distributions("AAPL","ly"))

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 Issuance Purchase Of Equity Shares (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions