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|
Industry: Diagnostics & Research
Optionable: Yes Market Cap: 188,450 M 90-day average vol: 2,642,242
Previous close: 249.63 Open: 250.175 Bid: 245.25 Ask: 251.97
52 week range
Last updated: Sunday 24th September 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!
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today
Get started today