EPS Average Growth (4Q)
Returns the average earnings per share growth over the last four quarters. This provides a short-term view of earnings momentum.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Calculation
Averages the quarter-over-quarter EPS growth rates for the most recent four quarters.
Interpretation
| Growth Level | Interpretation |
|---|---|
| > 15% | Strong quarterly momentum |
| 5-15% | Solid growth |
| 0-5% | Moderate growth |
| < 0% | Declining earnings |
Notes
- Returns value as a decimal (0.12 = 12%)
- More responsive to recent trends than annual CAGR
- Good for identifying earnings acceleration/deceleration
Syntax
=EpsFourQuarterAverageGrowth(Symbol)Returns
Four-quarter average EPS growth as a decimal
Examples
=EpsFourQuarterAverageGrowth("MSFT")=EpsFourQuarterAverageGrowth("AAPL")=EpsFourQuarterAverageGrowth("NVDA")=EpsFourQuarterAverageGrowth(A1)=EpsFourQuarterAverageGrowth("MSFT")*100When to Use
- Identify recent earnings momentum
- Short-term growth screening
- Earnings acceleration analysis
- Quarter-over-quarter trend evaluation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Long-term annual CAGR | EpsFiveYearCAGR() |
| 4-year CAGR | EpsFourYearCAGR() |
| YoY quarterly growth | QuarterlyEarningsGrowthYOY() |
| One-year growth | EPSOneYearGrowth() |
Common Issues & FAQ
Why is the value less than 1?
Growth is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.12 = 12%).
Why does this differ from annual CAGR?
This averages recent quarters, while CAGR compounds over multiple years. Recent quarters may show different trends than long-term averages.
Is this affected by seasonality?
Yes, some businesses have seasonal patterns. Compare to same quarters of prior year using QuarterlyEarningsGrowthYOY for better comparison.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans