Issuance Of Debt (Historical)
Returns the cash proceeds from issuing debt for a company. This includes bond offerings, bank loans, credit facility draws, and other debt financing.
Understanding the Metric
Debt issuance includes:
- Corporate bond offerings
- Bank term loans
- Credit facility borrowings
- Commercial paper issuance
- Private placements
Positive values indicate cash received from debt issuance. This is a key financing activity for companies raising capital.
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_debt("AAPL", 2023, 4)=hf_Issuance_of_debt("T", "ly")=hf_Issuance_of_debt("VZ", 2023, , "TTM")=hf_Issuance_of_debt(A1, B1, C1)=hf_Issuance_of_debt("BA", "lq")When to Use
- Analyzing capital structure changes
- Understanding financing strategy
- Evaluating debt financing activity
- Calculating net debt change
- Assessing capital raising patterns
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need debt repayment | hf_Repayment_of_debt() |
| Need total debt balance | hf_Total_Debt() |
| Need equity issuance | hf_Issuance_of_capital_stock() |
| Need interest expense | hf_Interest_Expense() |
Common Issues & FAQ
Q: Does this include all types of debt? A: This typically includes bonds, bank loans, and other formal debt instruments. Short-term credit lines may be reported separately or net in some cases.
Q: Why is this important for analysis? A: Debt issuance shows how a company finances growth or operations. High issuance combined with acquisitions or CapEx suggests debt-funded expansion; issuance for buybacks indicates levered shareholder returns.
Q: How do I calculate net debt financing?
A: Net = hf_Issuance_of_debt() - hf_Repayment_of_debt(). Positive means net new borrowing; negative means net debt reduction.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today