MarketXLS

Total Liabilities As A Percentage Of Total Assets (Historical)

Syntax

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

Parameters

symbolstringRequired
yearstringRequired
quarterstring
TTMstring

Returns

number

Total liabilities as % of total assets

Examples

=hf_Total_liabilities_as_a_percentage_of_total_assets("AAPL", 2023)

When to Use

  • Leverage analysis
  • Solvency assessment

When NOT to Use

Scenario Use Instead
Need leverage ratio hf_Leverage_ratio()

Excel Templates Using Total Liabilities As A Percentage Of Total Assets (Historical)

These ready-made MarketXLS templates call hf_Total_liabilities_as_a_percentage_of_total_assets() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

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 As A Percentage Of Total Assets (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions