Issuance Repayment Of Debt Securities (Historical)
Returns the historical net cash flow from debt activities - the difference between debt issued and debt repaid 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 debt issuance (borrowed more than repaid) |
| Negative | Net debt repayment (repaid more than borrowed) |
| Zero | No net change in debt |
Notes
- Part of financing activities in cash flow statement
- Includes bonds, term loans, credit facilities
- Negative values indicate deleveraging
- Watch for large issuances funding acquisitions
Examples
=hf_Issuance_Repayment_of_Debt_Securities("AAPL", 2023, 4)=hf_Issuance_Repayment_of_Debt_Securities("MSFT", "ly")=hf_Issuance_Repayment_of_Debt_Securities("T", 2023, , "TTM")=hf_Issuance_Repayment_of_Debt_Securities(A1, B1, C1)When to Use
- Tracking debt reduction progress
- Analyzing leverage changes
- Understanding capital structure shifts
- Monitoring refinancing activity
- Debt management analysis
When NOT to Use
Common Issues & FAQ
Q: How do I calculate net debt change?
A: This function already shows net debt activity. For balance sheet change, compare: =hf_Total_Debt("AAPL","ly") - hf_Total_Debt("AAPL","ly-1")
Q: What if a company issues debt and buys back stock?
A: They may show positive debt issuance here and negative equity repurchase in hf_Issuance_Purchase_of_Equity_Shares(). This is a common capital allocation strategy.
Q: Is negative debt activity good? A: Generally indicates deleveraging (paying down debt). Good for reducing risk, but may limit growth opportunities.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?