Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Debt Non Current (Historical) Formula in Excel

Leverage the Debt Non Current (Historical) formula in Excel with MarketXLS to effortlessly retrieve a company's noncurrent liabilities. This includes debentures, long-term loans, bonds payable, deferred tax liabilities, long-term lease obligations, and pension benefit obligations. Use this Excel function to make more informed investment and business decisions.

Understanding Debt Non Current (Historical)

The Debt Non Current (Historical) formula offers:

  • A quick view of a company’s long-term debt over previous periods
  • Insights into fixed obligations for risk assessment
  • The ability to identify trends in a company’s financing structure

Key Benefits:

  • Evaluate a company’s leverage and financial health
  • Complement other historical fundamentals like revenue and gross profit
  • Make well-rounded investment conclusions by analyzing long-term liabilities

? Pro Tip: Combine this with other MarketXLS fundamental formulas (e.g., Revenue, Gross Profit) for a comprehensive financial overview.

Syntax and Parameters

Use the following syntax in Excel:

=hf_Debt_Non_Current(Symbol, Year, [Quarter], [TTM])
Parameter Description Required Example
Symbol The stock or asset symbol. Can be an equity, index (^SPX), option (@MSFT 110122C00020000), or crypto (BTCUSD:DEFAULT). Yes "MSFT"
Year The fiscal year as text (e.g., "2022", "lq", "lq-1", "ly", "ly-1", "lt", "lt-1"). Yes "2022"
Quarter The quarter as text ("1", "2", "3", "4"). Defaults to "1" if omitted. No "2"
TTM Set to "TTM" for trailing twelve months. Leave blank for yearly/quarterly data. No "TTM"

Return Value:
Returns a numeric value representing the total noncurrent debt amount for the specified period. If the symbol is invalid or not supported by your MarketXLS plan, the function returns "NA".

?? Note: Ensure your MarketXLS subscription plan supports historical fundamentals. Otherwise, the formula may return “NA.”

Examples and Usage

Below are practical examples demonstrating how to implement this Excel formula.
Remember to use cell references, direct dates, or Excel date functions in scenarios where you need dynamically changing parameters. Although the primary focus here is yearly or quarterly data, you may still use Excel’s text manipulation functions if needed.

  1. Fetching Debt Non Current for a Specific Year:

    =hf_Debt_Non_Current("MSFT", 2022)

    Retrieves Microsoft’s noncurrent debt in the year 2022.

  2. Using Quarter Parameter:

    =hf_Debt_Non_Current("MSFT", 2022, 2)

    Retrieves Microsoft’s noncurrent debt in Q2 of 2022.

  3. Trailing Twelve Months (TTM):

    =hf_Debt_Non_Current("MSFT", 2022, 3, "TTM")

    Retrieves Microsoft’s noncurrent debt for the trailing twelve months from Q3 2022.

  4. Using Relative Periods:

    =hf_Debt_Non_Current("MSFT", "lq")

    Gets the last quarter’s noncurrent debt for Microsoft.

  5. Additional Relative Years/Quarters:

    =hf_Debt_Non_Current("MSFT", "lq-1")
    =hf_Debt_Non_Current("MSFT", "ly")
    =hf_Debt_Non_Current("MSFT", "ly-1")
    =hf_Debt_Non_Current("MSFT", "lt")
    =hf_Debt_Non_Current("MSFT", "lt-1")

    Retrieves the corresponding noncurrent debt values for previous quarters and years.

Using Different Date Inputs

Although the function typically takes a year as text, you can experiment with cell references or date conversions if needed in advanced use cases:

  • Cell Reference:
    =hf_Debt_Non_Current(A1,2022)
  • Direct Date:
    =hf_Debt_Non_Current("MSFT","2024-03-15")
  • Excel TEXT Function:
    =hf_Debt_Non_Current("MSFT", TEXT(A1,"yyyy-mm-dd"))

? Pro Tip: Use these methods to create more flexible spreadsheets when working with dynamic or calculated date values.

Common Questions

1. What if the function returns “NA”?

  • The symbol may be invalid or the data is unavailable. Also ensure your MarketXLS license supports historical data.

2. Are there any performance considerations?

  • Repeatedly calling multiple historical fundamental formulas can slow Excel. Try using caching or referencing cells that store results once computed.

3. Can I use this function for indices, options, or cryptocurrencies?

  • Yes. MarketXLS supports various symbol types: indexes like ^SPX, options like @MSFT 110122C00020000, and crypto like BTCUSD:DEFAULT.

4. Does the formula handle date-specific queries?

  • The primary structure uses a year/quarter-based period system. However, you can pass different date formats to handle advanced scenarios, though results are still aggregated by year or quarter.

5. Are there any special cases or limitations?

  • If MarketXLS cannot locate fundamental data for the specified symbol/year/quarter combination, the function will return “NA.” For lesser-known symbols or those outside standard exchanges, data may be unavailable.

?? Note: Always verify the published financial statements for accuracy when making critical financial decisions.


  • Related Functions:
    • Revenue (Historical): Retrieve total revenue for a specified period.
    • Cost Of Revenue (Historical): Obtain the total cost of revenue for the specified historical period.
    • Gross Profit (Historical): Review a company’s gross profit history.
    • R & D Expenses (Historical): Analyze historical research and development spending.
    • Selling General and Administrative Expense (Historical): Track SG&A expenses over time.

Use Debt Non Current (Historical) in tandem with these functions for a full financial picture of any publicly traded company.