Free Cash Flow (Historical)
Returns the historical free cash flow (FCF) for a company. Free cash flow represents cash generated after accounting for capital expenditures.
Formula
FCF = Operating Cash Flow - Capital Expenditures
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 |
Importance
- Indicates financial health and flexibility
- Cash available for dividends, buybacks, debt repayment
- Key metric for DCF valuation models
Syntax
=hf_Free_Cash_Flow(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 in USD
Examples
=hf_Free_Cash_Flow("AAPL", 2023, 4)=hf_Free_Cash_Flow("MSFT", "ly")=hf_Free_Cash_Flow("GOOGL", 2023, , "TTM")When to Use
- DCF valuation modeling
- Assessing dividend sustainability
- Analyzing financial flexibility
- Comparing cash generation across companies
When NOT to Use
| Scenario | Use Instead |
|---|---|
| FCF per share | hf_Free_Cash_Flow_per_Share() |
| Operating cash flow | hf_Net_Cash_Flow_from_Operating() |
| Current FCF | FreeCashFlow() |
Common Issues & FAQ
Why is FCF negative?
High capital expenditures or negative operating cash flow can result in negative FCF, common in growth companies.
What's a good FCF?
Depends on industry and company size. Positive and growing FCF is generally preferred.
Excel Templates Using Free Cash Flow (Historical)
These ready-made MarketXLS templates call hf_Free_Cash_Flow() 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:
- Goodwill And Intangible Assets (Historical)
- Gross Fixed Assets Plant Property And Equipment (Historical)
- Gross Margin (Historical)
- Gross Profit (Historical)
- Gross Profit Indicator (Historical)
- Gross Profit Margin (Historical)
- Hf Auditors Name Aud Name And Aud Op
- Hf Auditors Report Aud Name And Aud Op
See hf_Free_Cash_Flow used in a complete workbook: DCF Model Excel: Build a Discounted Cash Flow Valuation Template (2026)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today