Current Liabilities Per Share (Historical) Formula in Excel

Current Liabilities Per Share (Historical) allows you to quickly retrieve a company’s short-term obligations per share from MarketXLS. This Excel formula is especially useful for investors and analysts who want to evaluate a company’s financial health by examining its per-share liabilities.

Understanding Current Liabilities Per Share (Historical)

• Purpose: The Current Liabilities Per Share (Historical) formula returns the total short-term liabilities a company holds on a per-share basis for a given period.
• Key Benefits:
  • Helps in assessing a company’s liquidity.
  • Allows for quick historical comparisons of short-term liabilities per share.
• When to Use: Ideal for fundamental analysis, especially when comparing how a company’s short-term financial position changes over different quarters or years.

Syntax and Parameters

Use the following syntax in Excel:

=hf_Current_Liabilities_per_Share(Symbol, Year, [Quarter], [TTM])

?? Note: If your MarketXLS license is invalid or if the symbol is not found, the function returns "NA".

Return Value

• Returns a numeric value indicating the company’s current liabilities per share for the specified period.
• Returns "NA" if data is not available, symbol is invalid, or license is not valid.

Special Cases and Limitations

• The function may return "NA" if the data for the requested period is not yet published.
• Historical data availability can vary depending on the symbol.
• Units may be impacted by forward or reverse splits over time.

Performance Considerations

• Each call fetches data from MarketXLS servers. Frequent multiple calls can slow down large spreadsheets.
• Consider batching or storing results if you need to reference them repeatedly.

Examples and Usage

Below are practical examples in Excel showcasing different ways to input the date:

1. Using a direct year and quarter:

   =hf_Current_Liabilities_per_Share("MSFT", 2022, 2)

   Retrieves MSFT’s current liabilities per share for Q2 of 2022.

2. Using trailing twelve months (TTM):

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

   Retrieves the trailing twelve months figure from Q3 of 2022.

3. Using special references for last quarter (lq) and last year (ly):

   =hf_Current_Liabilities_per_Share("MSFT", "lq")
   =hf_Current_Liabilities_per_Share("MSFT", "ly")

   Useful for returning the most recent quarter’s or year’s figure automatically.

4. Referencing cells containing dates or using Excel functions:

   • Cell reference:

     =hf_Current_Liabilities_per_Share(A1, 2022)

   • Direct date string:

     =hf_Current_Liabilities_per_Share("MSFT", "2024-03-15")

   • Excel date function with text conversion:

     =hf_Current_Liabilities_per_Share("MSFT", TEXT(A1,"yyyy-mm-dd"))

? Pro Tip: Combine this formula with other historical key metrics (like revenue or gross profit) to build a comprehensive financial dashboard in Excel.

Common Questions

1. Why am I getting “NA”?

   • Make sure your MarketXLS license is valid and the symbol is correct. Data for that period might not be available yet.

2. How do I get last quarter’s data without updating the year and quarter manually?

   • Use parameters like lq (last quarter) or lq-1 (last quarter minus one), which automatically fetch the correct reporting period based on the most recent data.

3. Can I use this formula for non-equity symbols like crypto or indexes?

   • Yes. Simply input the symbol in its respective format, such as "BTCUSD:DEFAULT" or "^SPX".

4. Does this function handle adjusted values for stock splits?

   • MarketXLS typically adjusts historical share counts for splits where applicable. However, always cross-check if a recent split occurred.

By leveraging the Current Liabilities Per Share (Historical) formula, you can seamlessly monitor a company’s short-term financial obligations over time—providing deeper insights into its operational and financial stability.