Long Term Debt Per Share (Historical) Formula in Excel

Understanding Long Term Debt Per Share (Historical)

Long-term debt per share refers to the amount of a company’s long-term debt allocated on a per-share basis. This metric helps you:

• Assess the company’s leverage on a per-share level
• Compare long-term obligations across different companies
• Make more informed investment decisions by factoring in capital structure

You can use the Long Term Debt Per Share (Historical) formula to look up historical values for various years, quarters, or trailing periods.

? Pro Tip: Use this function alongside other historical fundamentals (e.g., revenue, cost of revenue, gross profit) to get a more comprehensive view of a company's financial health.

Syntax and Parameters

=hf_Long_Term_Debt_per_Share(Symbol, year, [quarter], [TTM])

• Return Value:
Returns the long-term debt per share based on the specified inputs. If the symbol is invalid or data is unavailable, the formula returns "NA".

?? Note: Make sure you have a valid MarketXLS subscription with access to historical fundamentals. An invalid or expired license will return an error or “NA”.

Examples and Usage

Basic Examples

1. Retrieve annual data for a regular symbol:

   =hf_Long_Term_Debt_per_Share("MSFT","2022")

   Returns the long-term debt per share for Microsoft in 2022.

2. Retrieve data for an index with a specific quarter:

   =hf_Long_Term_Debt_per_Share("^SPX","2021",3)

   Returns the Q3 2021 long-term debt per share metric for the S&P 500 Index (if applicable).

3. Fetch TTM (trailing twelve months) data for a crypto symbol:

   =hf_Long_Term_Debt_per_Share("BTCUSD:DEFAULT","2023",4,"TTM")

   Returns the trailing 12-month long-term debt per share for the specified crypto symbol, if data is available.

Date Input Variations

You can reference dates in multiple ways: • Using cell references:

=hf_Long_Term_Debt_per_Share(A1, A2)

• Direct year input:

=hf_Long_Term_Debt_per_Share("MSFT","2024")

• Combining Excel date functions:

=hf_Long_Term_Debt_per_Share("MSFT", TEXT(A1,"yyyy"))

? Pro Tip: For custom date calculations, you can create dynamic formulas that adjust year or quarter automatically based on current date or user input cells.

Advanced Scenarios

• Retrieve last quarter automatically:

  =hf_Long_Term_Debt_per_Share("MSFT","lq")

• Retrieve last year minus one:

  =hf_Long_Term_Debt_per_Share("MSFT","ly-1")

• Retrieve the previous trailing 12 months:

  =hf_Long_Term_Debt_per_Share("MSFT","lt-1")

Common Questions

1. What if the function returns "NA"?

• The symbol might be invalid, or data is not available for the specified period.
• Check your MarketXLS license to confirm you have access to historical fundamentals.

2. How can I improve performance when pulling data frequently?

• Use cell references or named ranges instead of typing symbols repeatedly.
• Cache or store results in cells, and reference those cells in other formulas.

3. Can I use this formula for non-US stocks or other markets?

Yes. MarketXLS supports many global tickers, but availability may depend on your plan. If data is unavailable, the function returns "NA".

4. Are there limitations on how many calls I can make?

This depends on your MarketXLS subscription. Higher plans generally allow more data pulls.

?? Note: If you encounter rate limits, consider upgrading your plan or caching data for repeated use.

By incorporating the Long Term Debt Per Share (Historical) formula into your spreadsheet, you’ll be equipped with insightful leverage data for informed decision-making. Combine it with other historical metrics like revenue and R&D expenses for a more holistic analysis of a company's financial position.