Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Data

Net Profit Margin (5-Year Growth, Annualized)

Hidden
Returns the annualized percent change in Net Profit Margin over the past 5 years.

How calculated

(Net Profit Margin for past 1 year minus Net Profit Margin from 5 years ago) divided by Net Profit Margin from 5 years ago

Example usage

=NetProfitMarginFiveYearAnnualizedGrowth("MSFT")
Net Profit Margin (5-Year Growth, Annualized)
StockNet Profit Margin (5-Year Growth, Annualized)
AAON Inc. logo

AAON Inc.

Sector: Basic Materials   

Industry: Building Materials

65.23
 
USD
  
1.29
  
(2.02%)
Optionable: Yes  Market Cap: 5,152 M  90-day average vol: 388,145

Previous close: 63.94  Open: 63.83  Bid: 64.01  Ask: 66.37
52 week range    
46.87   
   71.39
Peers   
LII / 
AOS / 
IR / 
MCCK / 
LXU / 
JCI / 
Last updated: Friday 8th December 2023
53
MarketXLS Rank
40
Value
69
Technical
52
Quality

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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.
Get started today