Data
EPS (5-Year Growth, Annualized)
To be addedReturns 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") |
| Stock | EPS (5-Year Growth, Annualized) |
|---|
Advance Auto Parts Inc W/I
AAP
NYE
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
Last updated: Friday 1st December 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
🎉 Exciting news! 🎉
You are invited to join our Discord Channel.
Interact, learn, and grow with experts in the markets!
Join our DiscordCall: 1-877-778-8358
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
Get started today