EPS (1-Year Growth)
Returns the 1-year percentage change in earnings per share.
Syntax
=EPSOneYearGrowth(Symbol)Returns
number
1-year EPS growth as decimal
Examples
=EPSOneYearGrowth("AAPL")=EPSOneYearGrowth("GOOGL")When to Use
- Earnings momentum analysis
- Growth stock screening
- Valuation support
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current EPS | EarningsPerShare() |
| Revenue growth | SalesOneYearGrowth() |
Common Issues & FAQ
Does this account for share buybacks?
Yes, EPS reflects both earnings changes and share count changes.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
- EPS Average Growth (4Q)
- EPS CAGR 3 Year
- EPS CAGR Growth (4Y)
- EPS CAGR Growth (5Y)
- Free Cash Flow (1-Year Growth)
- Free Cash Flow Per Share (Past 12 Months)
- Gross Margin 5 Year Average
- Gross Profit Margin (1-Year Growth)
See EPSOneYearGrowth used in a complete workbook: MarketXLS New Release 9.3.4.5
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?