Earning Per Share (TTM) Formula in Excel

Understanding Earning Per Share (TTM)

Earning Per Share (TTM) is a crucial key ratio that reflects a company’s profitability over the trailing twelve months (TTM). By integrating this formula into your Excel spreadsheets with MarketXLS, you can:

• Evaluate a company’s performance quickly.
• Compare EPS across different companies or sectors.
• Track profitability trends over time.

Use this function when you want a quick snapshot of how much profit a company generates per share of its stock within the most recent 12-month period.

Syntax and Parameters

=EarningsPerShare(Symbol)

• Return Value: Returns a numerical value representing the Basic Earnings Per Share (EPS) TTM for the specified symbol.
• Errors: If the Symbol is invalid or there is a data retrieval issue, the function returns NA.

?? Note: Reliable internet connectivity is essential because MarketXLS retrieves real-time or delayed data from external sources.

Examples and Usage

Below are some practical examples of how you can use EarningsPerShare in Excel:

1. To view EPS for Microsoft:

   =EarningsPerShare("MSFT")

2. To assess the S&P 500 index’s EPS (if applicable):

   =EarningsPerShare("^SPX")

3. To evaluate an option contract’s EPS (though less common):

   =EarningsPerShare("@MSFT 110122C00020000")

4. For cryptocurrency data (depending on availability):

   =EarningsPerShare("BTCUSD:DEFAULT")

? Pro Tip: Combine the EarningsPerShare function with other key ratio functions, like Market Cap or Dividend Yield, for a more comprehensive analysis of a company’s financial health.

Common Questions

1. What if the EPS value seems incorrect or is not updating?

• Ensure your MarketXLS license is valid and you have an active internet connection.
• Refresh or recalculate your Excel sheet to update the data.

2. Does this function work with international symbols?

• Yes. If supported by MarketXLS data feeds, you can enter international ticker formats, e.g., "BMW.DE" for BMW traded on the German exchange.

3. Why am I getting “NA” as a result?

• The symbol might be invalid or not tracked by MarketXLS.
• A temporary data retrieval error could also cause “NA.” In such cases, try again after confirming the symbol and internet connection.

4. Are there any performance considerations?

• Complex sheets with multiple real-time data calls might take longer to update. Keep your usage optimized and refresh only when necessary.

For more in-depth analysis, pair Earning Per Share (TTM) data with other key fundamentals like P/E Ratio, Revenue, and Dividend information—all from MarketXLS.