Debt to Equity RatioLive
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
Debt / Equity= Total Liabilities / Total Shareholders’ Equity
=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.
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
|Stock||Debt to Equity Ratio|
Sector: Consumer Cyclical
Industry: Specialty Retail
Optionable: Yes Market Cap: 1,238,120 M 90-day average vol: 62,956,910
Previous close: 125.3 Open: 125.07 Bid: 126.43 Ask: 126.46
52 week range
Last updated: Wednesday 7th June 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock
🎉 Exciting news! 🎉 Join our Discord
You are invited to join our Discord Channel.
Interact, learn, and grow with experts in the markets!
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.
Get started today
Get started today