Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

Total Debt (Historical)

Live
Total debt is calculated by adding up a company's liabilities, or debts, which are categorized as short and long-term debt. Financial lenders or business leaders may look at a company's balance sheet to factor in the debt ratio to make informed decisions about future loan options. They calculate the debt ratio by taking the total debt and dividing it by the total assets.

How calculated

Total debt includes long-term liabilities, such as mortgages and other loans that do not mature for several years, as well as short-term obligations, including loan payments, credit card, and accounts payable balances

Example usage

=hf_Total_Debt("MSFT",2021) - Returns the value for the year 2021.
=hf_Total_Debt("MSFT",2021,2) - Returns the value for the year 2021 and the calendar quarter 2
=hf_Total_Debt("MSFT",2021,3,"TTM") - Returns the value for the year 2021 and trailing twelve months from the calendar quarter
=hf_Total_Debt("MSFT","lq") - Returns the value for the last quarter
=hf_Total_Debt("MSFT","lq-1") - Returns the value for the last quarter-1
=hf_Total_Debt("MSFT","ly") - Returns the value for the last year
=hf_Total_Debt("MSFT","ly-1") - Returns the value for the last year - 1
=hf_Total_Debt("MSFT","lt") - Returns the value for the last 12 months.
=hf_Total_Debt("MSFT","lt-1") - Returns the value for the previous last 12 months.

Assets

Stocks