Total Assets Per Share (Historical) Formula in Excel

Understanding Total Assets Per Share (Historical)

The Total Assets Per Share (Historical) formula in Excel, powered by MarketXLS, returns the net assets per share for a given stock symbol over a specific historical period. This function is especially helpful for fundamental analysis, enabling investors and analysts to:

• Track long-term asset performance trends
• Compare net assets across different securities or indices
• Evaluate a company’s net worth growth over time

By leveraging this Excel function, you can make more informed investment decisions and streamline your financial analysis workflow using MarketXLS.

Syntax and Parameters

Use the function in Excel as follows:

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

? Pro Tip: You can pass special parameters like "ly-1" to go one year prior to the last year, or "lq-2" to go two quarters prior to the last quarter.

Return Value

• Returns a numeric value indicating total (net) assets per share.
• Returns "NA" if data is not available, the symbol is invalid, licensing is not valid, or other errors occur.

Error Handling

• Invalid symbol or data not found ? returns "NA"
• License not valid ? returns "NA"
• All other runtime exceptions ? returns "NA"

?? Note: This function queries historical fundamental data. Multiple calls in a single workbook may affect performance. Consider caching results or referencing data in fewer cells when working with large datasets.

Examples and Usage

Below are several ways to use hf_Total_Assets_per_Share in Excel:

1. Retrieve the net assets per share for the current year of a symbol:

   =hf_Total_Assets_per_Share("MSFT", 2022)

2. Specify a quarter:

   =hf_Total_Assets_per_Share("MSFT", 2022, 2)

3. Request trailing 12 months (TTM):

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

4. Fetch last quarter’s value:

   =hf_Total_Assets_per_Share("MSFT", "lq")

5. Fetch one-quarter-ago:

   =hf_Total_Assets_per_Share("MSFT", "lq-1")

6. Fetch last year’s value:

   =hf_Total_Assets_per_Share("MSFT", "ly")

7. Fetch one-year-ago from last year:

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

8. Fetch last 12 months (most recent quarter) value:

   =hf_Total_Assets_per_Share("MSFT", "lt")

9. Fetch one set of trailing 12 months before the last TTM:

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

? Pro Tip: Combine this function with other MarketXLS formulas like Revenue (Historical) or Gross Profit (Historical) for comprehensive fundamental analysis.

Common Questions

1. What if the symbol is not recognized?

The function returns "NA" if the provided symbol cannot be validated.

2. Can I use references instead of directly typing in the Symbol or Year?

Absolutely. You can reference cells for each parameter. For instance:

=hf_Total_Assets_per_Share(A1, B1)

where A1 could be "MSFT" and B1 could be 2022.

3. Do I need a specific MarketXLS plan?

Some advanced fundamentals may require certain subscription levels. If your plan does not support a specific data point, you may receive "NA."

4. How often is the data updated?

MarketXLS updates fundamental data as information becomes available. For historical data, the values are static once reported, but sourcing deeper or more recent data points may depend on the company’s release schedule.

5. Can I use date functions for the Year or Quarter parameters?

Not directly for Year or Quarter, but you can implement logic like:

=hf_Total_Assets_per_Share("MSFT", YEAR(TODAY()), QUARTER(TODAY()))

to dynamically reference the current year and quarter.

?? Note: Always ensure you have the latest MarketXLS add-in version for the best performance and compatibility.