Retrieve Free Cash Flow Per Share for Stocks in Excel

The FreeCashFlowPerShare function (fn_00811) calculates the company’s Free Cash Flow (FCF) allocated on a per-share basis, summed over the last four quarters. In a single Excel formula, you can quickly see a company’s FCF/share, making it simpler to compare profitability across different periods or among multiple stocks. This function taps into MarketXLS’s powerful fundamental database to bring real-time, on-demand data directly into your Excel spreadsheets.

Why Use This Function?

• Quickly Pull Per-Share FCF Data: Automate fundamental analysis by retrieving Free Cash Flow Per Share for U.S.-listed stocks.
• Compare Profitability: Compare the most recent quarterly free cash flow generation of different companies on a per-share level.
• Make Better Investment Decisions: Allows quick scanning of free cash flow trends, which many investors deem a critical measure of a company’s financial health.
• Flexible and Automated: Once set up in your Excel sheet, the function updates with each new MarketXLS refresh, saving you from manual data entry.
• Error Handling: If an invalid symbol is entered or the data is unavailable, the function returns “NA” so you can spot data issues easily.

How to Use in Excel

=FreeCashFlowPerShare("Symbol")

1. In any Excel cell, type the function name “FreeCashFlowPerShare”.
2. Within the parentheses, supply a valid stock ticker symbol as a text string (e.g., "AAPL" for Apple).
3. Press Enter. Excel will display the latest 4-quarter sum of Free Cash Flow Per Share for the given symbol, subject to your MarketXLS license status.

Make sure that you have a valid MarketXLS license and the symbol is correct. If the license has expired or the symbol is invalid, “NA” or an error message will appear.

Parameters Explained

• Symbol is the only parameter. Passing a missing or invalid symbol returns “NA” because MarketXLS cannot fetch the data.
• A valid MarketXLS license is required; otherwise, you may receive a licensing-related message.

Example Usage

Basic Examples

1. =FreeCashFlowPerShare("AAPL")
   • Fetches the total Free Cash Flow Per Share for Apple Inc. for the latest four quarters.

2. =FreeCashFlowPerShare("MSFT")
   • Retrieves the result for Microsoft Corporation.

3. =FreeCashFlowPerShare("TSLA")
   • Displays the latest free cash flow per share sum for Tesla, Inc.

Enjoy the flexibility of referencing cells, for example:
=FreeCashFlowPerShare(A2)
If cell A2 contains a valid stock ticker, e.g. "AMZN".

Advanced Scenarios

• Integrating with Other Metrics: Combine with functions like =Price("Symbol") to compare share price to free cash flow, for a quick pseudo “P/FCF” ratio in Excel.
• Multiple Symbols in a Dashboard: Build watchlists or dashboards by referencing different cells that each contain separate ticker symbols. Display the FCFPS for each ticker side by side.
• Period Comparisons: Even though this function retrieves four quarters by default, you can compare the data over time using additional MarketXLS fundamental functions for longer trends.

Common Questions and Troubleshooting

• Q: Why am I getting “NA”?
A: An invalid or unrecognized symbol returns “NA”. Double-check the ticker and verify that your license is valid.

• Q: Why does the function return a licensing message?
A: If your MarketXLS license is expired or not validated, the function will display a related message. Update or confirm your license to fix it.

• Q: How current is the data?
A: The function pulls the latest available fundamental data from MarketXLS servers, typically reflecting the company’s recent quarterly filings.

• Q: Can I use the function for non-U.S. stocks?
A: This function primarily targets U.S.-listed stocks. Depending on your data package, some international symbols may not be supported.

By leveraging FreeCashFlowPerShare, you gain immediate access to a powerful financial measure—Free Cash Flow Per Share—right inside your Excel workflow. This lets you make timely, informed comparisons and decisions whenever you need them.