MarketXLS

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

Syntax

=hf_Issuance_Repayment_of_Debt_Securities(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Net debt issuance (positive) or repayment (negative)

Examples

=hf_Issuance_Repayment_of_Debt_Securities("AAPL", 2023, 4)
Q4 2023 debt activity
=hf_Issuance_Repayment_of_Debt_Securities("MSFT", "ly")
Last fiscal year
=hf_Issuance_Repayment_of_Debt_Securities("T", 2023, , "TTM")
Trailing 12 months
=hf_Issuance_Repayment_of_Debt_Securities(A1, B1, C1)
From cell references

When to Use

  • Tracking debt reduction progress
  • Analyzing leverage changes
  • Understanding capital structure shifts
  • Monitoring refinancing activity
  • Debt management analysis

When NOT to Use

Scenario Use Instead
Need total debt balance hf_Total_Debt()
Need total financing cash flow hf_Net_Cash_Flow_from_Financing()
Need equity issuance/buybacks hf_Issuance_Purchase_of_Equity_Shares()
Need current liabilities hf_Current_Liabilities()

Common Issues & FAQ

How do I calculate net debt change?

This function already shows net debt activity. For balance sheet change, compare: =hf_Total_Debt("AAPL","ly") - hf_Total_Debt("AAPL","ly-1")

What if a company issues debt and buys back stock?

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.

Is negative debt activity good?

Generally indicates deleveraging (paying down debt). Good for reducing risk, but may limit growth opportunities.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

See hf_Issuance_Repayment_of_Debt_Securities used in a complete workbook: Shareholder Yield Screener Excel: Total Cash Return Dashboard for June 2026

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 Repayment Of Debt Securities (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions