Cash Flow Per Share (TTM)
Returns the Cash Flow Per Share for the trailing twelve months. This metric shows how much cash a company generates per share of stock.
CFPS Formula
Cash Flow Per Share = Operating Cash Flow / Shares Outstanding
CFPS vs EPS
| Metric | What It Measures | Manipulation Risk |
|---|---|---|
| EPS | Accounting earnings | Higher (accruals) |
| CFPS | Actual cash generated | Lower (cash is cash) |
Uses
- Quality of earnings: CFPS > EPS suggests high-quality earnings
- Dividend coverage: CFPS shows ability to pay dividends
- P/CF valuation: Price / Cash Flow Per Share multiple
- Cash generation: Assess actual cash-generating ability
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
Syntax
=CashFlowPerShare(Symbol)Returns
Cash flow per share
Examples
=CashFlowPerShare("AAPL")=CashFlowPerShare("MSFT")=CashFlowPerShare("GOOGL")=CashFlowPerShare("JNJ")=CashFlowPerShare(A1)When to Use
- Assess quality of earnings (compare to EPS)
- Calculate P/CF valuation multiple
- Evaluate dividend sustainability
- Screen for cash-generating companies
- Warren Buffett-style cash flow analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need accounting earnings | EarningsPerShare() |
| Need free cash flow | Free cash flow functions |
| Need total company cash flow | Fundamental functions |
| Need EBITDA | EBITDA() |
Common Issues & FAQ
Why is CFPS returning "NA"?
Check that:
- The symbol is valid
- Cash flow data is available
- The company has reported cash flow statements
How do I compare CFPS to EPS?
If CFPS is significantly higher than EPS, earnings quality is good (cash backs up accounting profits). If CFPS is much lower than EPS, investigate the difference.
Is this operating or free cash flow?
This typically returns operating cash flow per share. Free cash flow subtracts capital expenditures.
Excel Templates Using Cash Flow Per Share (TTM)
These ready-made MarketXLS templates call CashFlowPerShare() 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:
- Current Ratio
- Earnings Date
- EBIT Margin
- EBITDA Margin
- Five Year Average Dividend Yield
- Forward PE
- Gross Margin
- Gross Profit
See CashFlowPerShare used in a complete workbook: Dividend Safety Screener Excel: Payout Coverage and Recession Risk in May 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today