Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Data

Long term debt per share

Live
9.13
It is a metric which shows financial leverage as total debt company has on its book per share issued

Example usage

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

Assets

Stocks
Long term debt per share
StockLong term debt per share

A

9.13

TMO

74.72

PKI

35.55

DHR

27.58

TER

0.4

NATI

3.59

ILMN

3.15

AME

9.3

BRKR

7.89

GE

25.14
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: 
Healthcare
   

Industry: 
Diagnostics & Research

121.61
 
USD
  
-0.70
  
(-0.57%)
Optionable: Yes  Market Cap: 37,935 M  90-day average vol: 1,419,789

Previous close: 122.31  Open: 123.87  Bid: 123.23  Ask: 123.23
52 week range    
112.52   
   165.68
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Wednesday 28th September 2022
58
MarketXLS Rank marketxls
70
Value marketxls
23
Technical marketxls
81
Quality marketxls

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

Get started today
Search for a stock
Are you?
twitterstocktwits
Call: 1-877-778-8358
Ankur Mohan MarketXLS
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.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today