Not at the individual ticker level, I'm talking about:
https://ycharts.com/indicators/sp_500_eps_ttm $197.87, which they got from https://www.spglobal.com/spdji/en/documents/additional-material/sp-500-eps-est.xlsx
- 12/31/21 - $53.94
- 9/30/21 - $49.59
- 6/30/21 - $48.39
- 3/31/21 - $45.95
I have all the tickers of the S&P in a spreadsheet with their shares outstanding (or shares float, it's only a touch off) + EPS TTM. You can use this to calculate P/E for a stock, and P/E for S&P by sector, etc.
Example:
- AAPL $6.20 EPS TTM, 16.185b shares outstanding, $100.347b earnings TTM
I have all duplicate tickers removed (NWSA, FOXA, GOOGL)
I have ~322.447b for shares outstanding and $1.776t for earnings. That data makes no sense because it doesn't divide cleanly into $197.87
Some more fun facts: 18 companies in the S&P have negative trailing-twelve month earnings:
- STZ - beer/wine/spirits distribution
- BIO - chemical production for biochemical / pharmaceutical
- CDAY - human capital management software
- AES - power generation and utility services through renewable and thermal generation facilities?
- LYV - live concerts
- WYNN - casino resorts
- CAH - healthcare services
- LVS - casinos
- CZR - casinos
- PEG - electric and gas services
- UAL - airline
- GE - high-tech industrial company
- AAL - airline
- EBAY - online marketplace
- NCLH - cruiseline
- BA - aerospace
- RCL - cruiseline
- CCL - cruiseline
I couldn't find any data on:
- CEG
- FDS
- FDX
- TJX
Once I have EPS data that calculates through, I'm going to analyze what % of EPS is driven by the top 10, 20, 30, 40, 50, 100 stocks by market cap. My guess is... quite a lot.
Submitted June 28, 2022 at 02:28AM by waltwhitman83 https://ift.tt/GdNChqE
