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

Profit Margin

Live
the amount by which revenue from sales exceeds costs in a business.

How calculated

You can calculate profit margin ratio by subtracting total expenses from total revenue, and then dividing this number by total expenses. The formula is: ( Total Revenue - Total Expenses ) / Total Revenue.

Example usage

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

Assets

Stocks
Profit Margin
StockProfit Margin
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: 
Healthcare
   

Industry: 
Diagnostics & Research

131.41
 
USD
  
5.03
  
(3.98%)
Optionable: Yes  Market Cap: 36,001 M  90-day average vol: 1,421,766

Previous close: 126.38  Open: 128.79  Bid: 132.2  Ask: 132.2
52 week range    
112.52   
   165.68
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Wednesday 5th October 2022
73
MarketXLS Rank marketxls
70
Value marketxls
69
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