EPS NTM in Snapshot doesn't match quarterly estimates
closed
Y
Yolk Lynx
I believer, none of the estimated EPS Normalized Consensus (NTM) Averages is exactly what we need. We need the NTM EPS, shifted over to the next quarter, then the next next, and so on. "Future" is the key for estimates. I have been doing by pencil-n-paper myself. Really crazy, I think. Is it available somewhere else that I have missed? If yes, can you point me in the right direction to find them? If not, would you consider adding such variable?
Conor MacNeil
closed
T
Tetiana Afanasieva
under review
Conor MacNeil
Hi Lewis, can you explain a little more to help me understand? Because that's what we display already.
Y
Yolk Lynx
Conor MacNeil, really appreciate it. Below illustrates what I think might be where the issue is. The top figure is what is plotted-- limited to last Friday, not a day further. As a result, the estimated NTM is plotted up to last Friday, 2024; your estimated EPS data of up to 2026 isn't plotted. The middle figure is your "calendar" that limits the plots. The bottom figure shows the future EPS estimates up to 2026 (on the table of the upper-right corner).
Conor MacNeil
Yolk Lynx: Hey Lewis, maybe it's due to lack of coffee but I am, struggling to follow what the issue is. Could you please explain it to me like I am 5?
The NTM plot will show the consensus estimated next twelve months for EPS on a given date, plotted over a period.
I am not sure what relevance 2026 has here also. The date 14th July, 2024 shows the NTM EPS on that date. If you wish to plot 2026 estimates, we have that data to chart as well (yellow line).
Y
Yolk Lynx
Conor MacNeil, fiscal year plots are not what I'm talking about.
We are dealing with EPS (NTM = next twelve months) estimate. To get the up-todate EPS "NTM" estimate of this quarter, I add up the estimates of the next 4 quarters, totalling 20.40, as encircled in red in the figure below, corresponding to your plot, EPS Norm - Est Avg (NTM), shown in blue.
20.40 = 4.68+4.80+5.95+4.97
For the next quarter, that "NTM" number is 21.02. That is,
21.02 = 4.80+5.95+4.97+5.29
(You can repeat this all the way up to 2026 or 2027.)
Now, how do you show these numbers on the plot?
Conor MacNeil
Yolk Lynx: Thanks for your patience, I fully understand you now. Will move this to bugs channel and investigate.
Y
Yolk Lynx
Conor MacNeil, the calendar setup, shown in my previous pix, prevents the plot to go beyond today's date. If you could open it up, this issue may go away.
Conor MacNeil
Yolk Lynx: Following up here Lewis after spending some time investigating.
All estimated data come from CapitalIQ. There is no calculation on our side.
Quarterly EPS estimates look the same as those from our data provider for META:
FQ2 2024: 4.7
FQ3 2024: 4.84
FQ4 2024: 5.97
FQ1 2025: 5.07
NTM EPS data is also obtained from CIQ. Latest is 20.58 .