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 |
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
Q: Why is CFPS returning "NA"? A: Check that:
- The symbol is valid
- Cash flow data is available
- The company has reported cash flow statements
Q: How do I compare CFPS to EPS? A: 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.
Q: Is this operating or free cash flow? A: This typically returns operating cash flow per share. Free cash flow subtracts capital expenditures.
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?