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

EPS (5-Year Growth, Annualized)

To be added
Returns the annualized percent change in EPS over the past 5 years.

How calculated

(sum of EPS from past 1 year minus sum of EPS for year ended 5 years ago) divided by sum of EPS for year ended 5 years ago, and divide this by 5.

Example usage

=EPSFiveYearAnnualizedGrowth("MSFT")
EPS (5-Year Growth, Annualized)
StockEPS (5-Year Growth, Annualized)
Advance Auto Parts Inc W/I logo

Advance Auto Parts Inc W/I

Sector: Consumer Cyclical   

Industry: Specialty Retail

50.79
 
USD
  
-0.79
  
(-1.53%)
Optionable: Yes  Market Cap: 3,073 M  90-day average vol: 2,119,111

Previous close: 51.58  Open: 51.87  Bid: 50.1  Ask: 50.78
52 week range    
47.73   
   158.22
Peers   
AZO / 
ORLY / 
GPC / 
MNRO / 
PRTS / 
Last updated: Friday 1st December 2023
50
MarketXLS Rank
80
Value
15
Technical
57
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