Earnings Per Share (TTM)
Returns the Earnings Per Share for the trailing twelve months (TTM). EPS is calculated as Net Income divided by Weighted Average Shares Outstanding.
EPS Formula
EPS = (Net Income - Preferred Dividends) / Weighted Average Shares Outstanding
Understanding EPS
| EPS Type | Description |
|---|---|
| TTM (This function) | Last 4 quarters combined |
| Forward EPS | Analyst estimates |
| Diluted EPS | Includes all potential shares |
| Basic EPS | Current shares only |
Uses
- Valuation: Calculate P/E ratio = Price / EPS
- Profitability: Compare earnings across companies
- Growth: Track EPS growth over time
- Investment screening: Filter for profitable companies
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
Examples
=EarningsPerShare("AAPL")=EarningsPerShare("MSFT")=EarningsPerShare("GOOGL")=EarningsPerShare("AMZN")=EarningsPerShare(A1)When to Use
- Calculate P/E ratio for valuation
- Compare profitability across companies
- Screen for profitable companies (EPS > 0)
- Track earnings growth
- Fundamental analysis
When NOT to Use
Common Issues & FAQ
Q: Why is EPS returning "NA" or negative? A: Check that:
- The company is profitable (unprofitable companies have negative EPS)
- The symbol is valid
- The company has reported earnings
Q: Is this basic or diluted EPS? A: This typically returns the diluted EPS which accounts for all convertible securities.
Q: What does TTM mean? A: Trailing Twelve Months - the sum of the last four quarters of earnings.
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?