Price-Free Cash Flow Ratio (Historical)

Returns the ratio of stock price to free cash flow per share. Free cash flow is operating cash flow minus capital expenditures, representing cash available to shareholders.

Formula

P/FCF = Stock Price / (Free Cash Flow / Shares Outstanding) Free Cash Flow = Operating Cash Flow - Capital Expenditures

Notes

  • More stringent than P/CF (accounts for capex)
  • Lower values may indicate better value
  • Negative FCF makes ratio meaningless
  • Popular with value investors

Examples

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

When to Use

Free cash flow valuation, value investing screening, capital-intensive company analysis

When NOT to Use

| Need P/CF (operating) | hf_Price_Cash_Flow_Ratio() | | Need P/E | PERatio() |

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-Free Cash Flow Ratio (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions