Free Cash Flow (1-Year Growth)
Returns the 1-year percentage change in free cash flow (operating cash flow minus capex).
Syntax
=FreeCashFlowOneYearGrowth(Symbol)Returns
number
1-year free cash flow growth as decimal
Examples
=FreeCashFlowOneYearGrowth("AAPL")=FreeCashFlowOneYearGrowth("MSFT")When to Use
- Free cash flow analysis
- Dividend sustainability
- Buyback capacity assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| FCF per share | FreeCashFlowPerShare() |
| Operating cash flow | CashFlowOneYearGrowth() |
Common Issues & FAQ
What's free cash flow?
Operating cash flow minus capital expenditures.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
- Gross Margin 5 Year Average
- Gross Profit Margin (1-Year Growth)
- Net Income Growth 5 Year CAGR
- Net Margin 5 Year Average
- Net Profit Margin (1-Year Growth)
- PE Ratio 5 Year Average
- Quarterly Revenue Growth YOY
- Return On Assets 5 Year Average
See FreeCashFlowOneYearGrowth used in a complete workbook: discounted cash flow excel: build a two-stage DCF model that updates itself
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?