Data

Debt to Equity Ratio

Live
-63.57
It is used to evaluate a company's financial leverage and is calculated by dividing a company’s total liabilities by its shareholder equity. It is a measure of the degree to which a company is financing its operations through debt versus wholly owned funds

How calculated

Debt / Equity= Total Liabilities / Total Shareholders’ Equity ​ ​

Example usage

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

Notes

A “good” debt-to-equity (D/E) ratio will depend on the nature of the business and its industry. Generally speaking, a D/E ratio below 1.0 would be seen as relatively safe, whereas ratios of 2.0 or higher would be considered risky. Some industries, such as banking, are known for having much higher D/E ratios than others. Note that a D/E ratio that is too low may actually be a negative signal, indicating that the firm is not taking advantage of debt financing to expand and grow

Assets

Stocks
StockDebt to Equity Ratio

-63.57

Absolute Software Corp

ABST
NGS

Industry: Data Processing, Hosting, and Related Services

11.96

USD

0.07

(0.59%)
Optionable: Yes  Market Cap: 607 M  90-day average vol: 100,189

Previous close: 11.89  Open: 11.96  Bid: 12.25  Ask: 12.25
52 week range
6.79
12.59
Peers
Last updated: Friday 3rd February 2023
54
MarketXLS Rank
40
Value
84
Technical
39
Quality

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

Search for a stock
Are you?
Call: 1-877-778-8358
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.