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 |
Syntax
=EarningsPerShare(Symbol)Returns
Trailing twelve month earnings per share
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
| Scenario | Use Instead |
|---|---|
| Need forward EPS estimates | Forward earnings functions |
| Need historical EPS by quarter | Historical fundamental functions |
| Need diluted vs basic distinction | Specific EPS functions |
| Need P/E ratio directly | PERatio() |
Common Issues & FAQ
Why is EPS returning "NA" or negative?
Check that:
- The company is profitable (unprofitable companies have negative EPS)
- The symbol is valid
- The company has reported earnings
Is this basic or diluted EPS?
This typically returns the diluted EPS which accounts for all convertible securities.
What does TTM mean?
Trailing Twelve Months - the sum of the last four quarters of earnings.
Excel Templates Using Earnings Per Share (TTM)
These ready-made MarketXLS templates call EarningsPerShare() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Key Ratios formulas you can use in the same worksheet:
- EBIT Margin
- EBITDA Margin
- Five Year Average Dividend Yield
- Forward PE
- Gross Margin
- Gross Profit
- Interest Coverage Ratio
- Invoice Turnover
See EarningsPerShare used in a complete workbook: ChatGPT Excel: How to Use AI with Financial Spreadsheets for Live Market Data
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today