All,
First off, Happy New Year and all the best for 2022!
I’m trying to work out the overall sales per share for the S&P500. Seems simply enough, however the values I’m getting don’t match up with other sources (i.e. off by an order of magnitude). If you look at Ycharts or Guru Focus, the last quarter sales/share for S&P500 is around 385:
https://ycharts.com/indicators/sp_500_sales_per_share
In P123, in aggregate series, you can look at this a few ways, but all seem to provide a much lower value (using S&P500 universe):
univsum(“true”, “salesq”)/univsum(“true”,"SharesFDq ") = 11.4
univsum(“true”, “salesq”)/univsum(“true”,“SharesQ”) = 11.6
univmedian(“true”,"SalesPSq ") = 8.8
univsum(“true”, “salesttm”)/univsum(“true”,"SharesFDTTM ") = 43.6
The units should be the same, i.e. sales in $M, shares also in M.
I know there were some issues in the past around share counts, but there is considerable discrepancy here. Or, I’m misinterpreting the output of the aggregate series calculations.
Any help would be much appreciated!
Thanks,
Ryan