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

Examples

=hf_Price_Cash_Flow_Ratio("AAPL", 2023)
Annual data for 2023
=hf_Price_Cash_Flow_Ratio("MSFT", 2023, 2)
Q2 2023 data
=hf_Price_Cash_Flow_Ratio("GOOGL", "lq")
Last quarter
=hf_Price_Cash_Flow_Ratio("TSLA", "ly")
Last year
=hf_Price_Cash_Flow_Ratio(A1, B1, C1)
Cell references

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

Q: What year formats are accepted? A: Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).

Q: Why am I getting "NA"? A: The company may not report this metric, or data may not be available for the requested period.

Q: What's the difference between quarterly and TTM? A: Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Price-Cash Flow Ratio (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions