Current Assets Per Share (Historical) Formula in Excel

Current Assets Per Share (Historical) is a powerful Excel formula provided by MarketXLS that helps you retrieve the net current asset value per share for a given company, based on historical financial data. This formula is ideal for analysts and investors looking to evaluate a company’s short-term financial health and liquidity.

Understanding Current Assets Per Share (Historical)

• Purpose and Use Cases
  The net current asset value per share indicates how well a company can meet its short-term obligations. Use this formula to gain deeper insights into a company’s liquidity position.

• Key Benefits

  • Offers quick assessment of short-term financial stability.
  • Ideal for comparing liquidity trends across different companies or time periods.
  • Supports advanced filters (year, quarter, TTM) for robust historical analysis.

• When to Use

  • Analyzing a firm’s liquidity over multiple historical periods.
  • Quick checks before making short-term investment decisions.
  • Comparing multiple stocks side-by-side for their net current assets per share.

Syntax and Parameters

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

Return Value
This function returns a numeric value representing the net current asset value per share for the specified period. If the data is unavailable or an invalid symbol/license is detected, the function returns "NA".

?? Note: Ensure you have a valid MarketXLS subscription that supports historical fundamentals for this function to work properly.

Examples and Usage

Below are some examples demonstrating how to use hf_Current_Assets_per_Share in Excel:

1. Basic Usage with Year

   =hf_Current_Assets_per_Share("MSFT", 2022)

   Retrieves the net current asset value per share of Microsoft for the year 2022.

2. Specifying Quarter

   =hf_Current_Assets_per_Share("MSFT", 2022, 2)

   Retrieves the data specifically for Q2 of 2022.

3. Using TTM (Trailing Twelve Months)

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

   Calculates the trailing twelve months figure from Q3 2022.

4. Using Special Keywords for Years/Quarters

   • Last Quarter

     =hf_Current_Assets_per_Share("MSFT", "lq")

   • Last Year Minus One

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

   • Last Twelve Months

     =hf_Current_Assets_per_Share("MSFT", "lt")

5. Referencing Cells and Date Functions

   • Refer to a cell for year input:

     =hf_Current_Assets_per_Share(A1, A2)

   • Directly passing a date (extracting the year from it): » While the function expects a year, you can use Excel functions to format a date:

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

     This approach allows you to store a full date in cell A1 and extract only the year.

? Pro Tip: Use different symbol formats like "=hf_Current_Assets_per_Share("^SPX", 2022)" (index) or "=hf_Current_Assets_per_Share("BTCUSD:DEFAULT", "lq")" (crypto) to expand your analysis across various asset classes.

Common Questions

1. What happens if I use an invalid symbol?
   The function returns "NA" if the symbol is invalid or not found in the MarketXLS database.

2. Can I apply this function to historical option data?
   Yes, pass option symbols in the Symbol parameter using the correct format (e.g., "@MSFT 110122C00020000").

3. Does this formula affect Excel performance?

   • Each call queries MarketXLS servers. Overusing the function with large datasets may affect performance.
   • Use it selectively or in summary sheets for optimal performance.

4. Why is the function returning “NA” even with a valid symbol?

   • Possible reasons include:
     • Your MarketXLS plan does not support historical fundamentals of that symbol.
     • The data for the requested period is not available.
     • License validation issues.

5. Are there any limitations on years or quarters I can request?

   • MarketXLS maintains data going back multiple years, but the exact availability depends on the specific security.
   • If the data is too far in the past or does not exist, the function returns "NA".

?? Note: For more insight on coverage and data reliability, visit MarketXLS documentation or contact support.

• Related Functions
  • Revenue (Historical)
  • Cost Of Revenue (Historical)
  • Gross Profit (Historical)
  • R & D Expenses (Historical)
  • Selling General and Administrative Expense (Historical)

Use hf_Current_Assets_per_Share to quickly gauge a company’s position in covering short-term obligations and combine it with other fundamental metrics for a holistic analysis.