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 |
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
Q: Does this include stock compensation? A: No, stock compensation is a non-cash expense. This shows actual cash received when employees exercise options or when the company issues new shares.
Q: Why is this significant for growth companies? A: Growth companies often rely on equity financing to fund expansion. High issuance indicates dilution risk but also access to capital without debt obligations.
Q: How do I calculate net equity change?
A: Net = hf_Issuance_of_capital_stock() - hf_Repurchase_of_capital_stock(). Positive means net issuance (dilution); negative means net buybacks (returning capital).
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today