Price-Cash Flow Ratio (Historical)
Returns the ratio of stock price to operating cash flow per share, a valuation metric showing how the market values the company's cash generation ability.
Formula
P/CF = Stock Price / (Operating Cash Flow / Shares Outstanding)
Interpretation
| Value | Meaning |
|---|---|
| < 10 | Potentially undervalued |
| 10-20 | Typical range |
| > 20 | Premium valuation |
Notes
- Cash flow harder to manipulate than earnings
- Lower values may indicate value opportunities
- Compare within same industry
Syntax
=hf_Price_Cash_Flow_Ratio(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year
Quarter (1-4)
Use TTM for trailing twelve months
Examples
=hf_Price_Cash_Flow_Ratio("AAPL", 2023)=hf_Price_Cash_Flow_Ratio("MSFT", 2023, 2)=hf_Price_Cash_Flow_Ratio("GOOGL", "lq")=hf_Price_Cash_Flow_Ratio("TSLA", "ly")=hf_Price_Cash_Flow_Ratio(A1, B1, C1)When to Use
Cash flow-based valuation, value screening, comparing valuation metrics
When NOT to Use
| Need P/E ratio | PERatio() |
| Need P/FCF | hf_Price_Free_Cash_Flow_Ratio() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Excel Templates Using Price-Cash Flow Ratio (Historical)
These ready-made MarketXLS templates call hf_Price_Cash_Flow_Ratio() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today