Free Cash Flow Per Share (Historical)

Returns the historical free cash flow per share. This metric normalizes FCF by the number of shares outstanding.

Formula

FCF per Share = Free Cash Flow / Weighted Average Shares Outstanding

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Quarter 1-4
TTM No "TTM" for trailing twelve months

Examples

=hf_Free_Cash_Flow_per_Share("AAPL", 2023, 4)
Q4 2023 FCF per share
=hf_Free_Cash_Flow_per_Share("MSFT", "ly")
Last year FCF/share
=hf_Free_Cash_Flow_per_Share("GOOGL", 2023, , "TTM")
TTM FCF per share

When to Use

  • Comparing FCF across companies of different sizes
  • Per-share valuation analysis
  • Dividend coverage analysis
  • Historical per-share trends

When NOT to Use

Scenario Use Instead
Total FCF hf_Free_Cash_Flow()
Earnings per share hf_Earnings_per_Basic_Share()
Cash flow per share CashFlowPerShare()

Common Issues & FAQ

Q: How is this different from cash flow per share? A: FCF per share specifically uses free cash flow (operating cash flow minus capex), while cash flow per share may use operating cash flow.

Q: Why is FCF per share lower than EPS? A: FCF accounts for capital expenditures which EPS does not.

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

Related Functions