How is it possible that Showvar(@NumberEBITDA, ConsEstCnt(#EBITDANTM,0)) returns a fractional value, such as 3.5? Shouldn’t the number of analysts always be an integer? Thanks in advance for any help.
The NTM (next 12-month) period is largely a synthetic data point. In most cases, you can calculate the NTM value using the estimates for the next four quarters.
I included those quarterly values as ShowVars below. If you take their average, you’ll get the fractional analyst count you’re seeing for NTM. That’s where the fractional value comes from.
It gets a little less straightforward when one or more of the quarterly values are NA.
Showvar(@NumberEBITDA, ConsEstCnt(#EBITDANTM,0))
@NumberEBITDA!=NA
Showvar(@NumberEBITDA0, ConsEstCnt(#EBITDAQ,0))
Showvar(@NumberEBITDA1, ConsEstCnt(#EBITDAQ,1))
Showvar(@NumberEBITDA2, ConsEstCnt(#EBITDAQ,2))
Showvar(@NumberEBITDA3, ConsEstCnt(#EBITDAQ,3))
@Avg:Avg(@NumberEBITDA0,@NumberEBITDA1,@NumberEBITDA2,@NumberEBITDA3)
@NumberEBITDA=@Avg