Free Cash Flow Per Share (Past 12 Months)
Returns free cash flow divided by shares outstanding for trailing 12 months.
Syntax
=FreeCashFlowPerShare(Symbol)Returns
number
Free cash flow per share
Examples
=FreeCashFlowPerShare("AAPL")=FreeCashFlowPerShare("MSFT")When to Use
- FCF-based valuation
- Cash yield calculation
- Dividend coverage analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| FCF growth | FreeCashFlowOneYearGrowth() |
| Operating cash flow | CashFlowPerShare() |
Common Issues & FAQ
How to calculate FCF yield?
Divide this by stock price.
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 FreeCashFlowPerShare 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?