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])
Excel Desktop (Windows)

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

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.

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