Issuance Of Capital Stock (Historical)
Returns the cash proceeds from issuing common or preferred stock for a company. This includes secondary offerings, equity compensation exercises, and other stock issuances.
Understanding the Metric
Stock issuance includes:
- Secondary public offerings
- Private placements
- Employee stock option exercises
- Warrant conversions
- Preferred stock issuance
Positive values indicate cash received from stock issuance. This represents equity financing that doesn't require repayment but dilutes existing shareholders.
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker (e.g., AAPL, MSFT) |
| Year | Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1) |
| Quarter | Optional: 1, 2, 3, or 4 (default: 1) |
| TTM | Optional: "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last reported quarter |
| lq-1 | Quarter before last |
| ly | Last fiscal year |
| ly-1 | Year before last |
| lt | Last trailing twelve months |
| lt-1 | Prior trailing twelve months |
Syntax
=hf_Issuance_of_capital_stock(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year (e.g., 2023) or period code (lq, lq-1, ly, ly-1, lt, lt-1)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Proceeds from stock issuance (in currency units)
Examples
=hf_Issuance_of_capital_stock("TSLA", 2023, 4)=hf_Issuance_of_capital_stock("NVDA", "ly")=hf_Issuance_of_capital_stock("AMD", 2023, , "TTM")=hf_Issuance_of_capital_stock(A1, B1, C1)=hf_Issuance_of_capital_stock("COIN", "lq")When to Use
- Analyzing equity financing activity
- Understanding capital raising strategy
- Evaluating dilution from new issuances
- Calculating net equity change
- Assessing growth company financing patterns
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need share repurchases | hf_Repurchase_of_capital_stock() |
| Need shares outstanding | Check shares outstanding functions |
| Need debt issuance | hf_Issuance_of_debt() |
| Need stock compensation expense | Check income statement functions |
Common Issues & FAQ
Does this include stock compensation?
No, stock compensation is a non-cash expense. This shows actual cash received when employees exercise options or when the company issues new shares.
Why is this significant for growth companies?
Growth companies often rely on equity financing to fund expansion. High issuance indicates dilution risk but also access to capital without debt obligations.
How do I calculate net equity change?
Net = hf_Issuance_of_capital_stock() - hf_Repurchase_of_capital_stock(). Positive means net issuance (dilution); negative means net buybacks (returning capital).
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