Data
Debt to Equity Ratio
Live4.21
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 |
| Stock | Debt to Equity Ratio |
|---|---|
CTXS | 4.21 |
IBM | 3.23 |
MSFT | 0.31 |
HPQ | -3.24 |
CSCO | 0.21 |
ORCL | -37.92 |
ADBE | 0.29 |
Citrix Systems Inc.
CTXS
NGS
Sector: Technology
Industry: Software - Infrastructure
103.90
USD
0.04
(0.04%)
Optionable: Yes Market Cap: 13,171 M 90-day average vol: 0
Previous close: 103.86 Open: 103.8 Bid: Ask:
52 week range
88.66 103.96
Last updated: Tuesday 30th May 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
🎉 Exciting news! 🎉
You are invited to join our Discord Channel.
Interact, learn, and grow with experts in the markets!
Join our DiscordCall: 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.
Get started today
Get started today