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
Examples
=EpsFourQuarterAverageGrowth("MSFT")=EpsFourQuarterAverageGrowth("AAPL")=EpsFourQuarterAverageGrowth("NVDA")Symbol from cell reference
=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
Common Issues & FAQ
Q: Why is the value less than 1? A: Growth is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.12 = 12%).
Q: Why does this differ from annual CAGR? A: This averages recent quarters, while CAGR compounds over multiple years. Recent quarters may show different trends than long-term averages.
Q: Is this affected by seasonality? A: Yes, some businesses have seasonal patterns. Compare to same quarters of prior year using QuarterlyEarningsGrowthYOY for better comparison.
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?