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 |
Syntax
=hf_Free_Cash_Flow_per_Share(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Free cash flow per share in USD
Examples
=hf_Free_Cash_Flow_per_Share("AAPL", 2023, 4)=hf_Free_Cash_Flow_per_Share("MSFT", "ly")=hf_Free_Cash_Flow_per_Share("GOOGL", 2023, , "TTM")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
How is this different from cash flow per share?
FCF per share specifically uses free cash flow (operating cash flow minus capex), while cash flow per share may use operating cash flow.
Why is FCF per share lower than EPS?
FCF accounts for capital expenditures which EPS does not.
Excel Templates Using Free Cash Flow Per Share (Historical)
These ready-made MarketXLS templates call hf_Free_Cash_Flow_per_Share() 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