Total Liabilities And Stock Equity (Historical)

Returns total liabilities and stockholders equity from historical balance sheets. This equals total assets.

Syntax

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

Examples

When to Use

  • Balance sheet verification
  • Total assets calculation

When NOT to Use

Scenario Use Instead
Need liabilities only hf_Total_liabilities()

Common Issues & FAQ

Why does this equal total assets?

Assets = Liabilities + Equity (fundamental accounting equation).

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Total Liabilities And Stock Equity (Historical) and Other Financial Formulas
How does MarketXLS work?