Total Assets Per Share (Historical)

Returns total assets divided by shares outstanding.

Syntax

=hf_Total_assets_per_share(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Use TTM for trailing twelve months

Returns

number

Total assets per share in dollars

Examples

=hf_Total_assets_per_share("AAPL", 2023, 4)

When to Use

  • Per-share valuation
  • Asset-based analysis

When NOT to Use

Scenario Use Instead
Need current assets only hf_Current_assets_per_share()

Common Issues & FAQ

Does this include intangibles?

Yes, total assets includes all assets on the balance sheet.

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Total Assets Per Share (Historical) and Other Financial Formulas
▶
How does MarketXLS work?