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",2019)- Returns the value for the year 2019.
=hf_Profit_Margin("MSFT",2019,2)- Returns the value for the year 2019 and the calendar quarter 2
=hf_Profit_Margin("MSFT",2019,3,"TTM")- Returns the value for the year 2019 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
Alcoa Corporation logo

Alcoa Corporation

Sector: 
Basic Materials
   

Industry: 
Aluminum

35.23
 
USD
  
0.53
  
(1.53%)
Optionable: Yes  Market Cap: 6,243 M  90-day average vol: 6,212,495

Previous close: 34.7  Open: 34.68  Bid: 35.23  Ask: 35.23
52 week range    
33.70   
   98.09
Peers   
ACH / 
KALU / 
CENX / 
NHYDY / 
AWCMY / 
BBL / 
Last updated: Thursday 29th September 2022
56
MarketXLS Rank marketxls
80
Value marketxls
30
Technical marketxls
60
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