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

EBITDA

Live
EBITDA, or earnings before interest, taxes, depreciation, and amortization, is a measure of a company's overall financial performance and is used as an alternative to net income in some circumstances.

How calculated

EBITDA = Net Income + Interest + Taxes + Depreciation + Ammortization

Example usage

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

Assets

Stocks
EBITDA
StockEBITDA
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: 
Healthcare
   

Industry: 
Diagnostics & Research

126.38
 
USD
  
5.04
  
(4.15%)
Optionable: Yes  Market Cap: 36,001 M  90-day average vol: 1,422,020

Previous close: 121.34  Open: 122.73  Bid: 129.57  Ask: 129.57
52 week range    
112.52   
   165.68
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Tuesday 4th October 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