strange cash flow numbers for ADUS

This is what I am getting. Cash flow from operation ~4, capex of 7.5, yet the FCF is around ~60?

What am I doing wrong?


The reason is because ADUS statements are not complete yet and CapEx for q0 is NA while OperCash is not NA.
So CapExTTM is for Q1-4 while OperCash is for Q0-3. The FCFTTM function ignores the Q0 NA for FCF and uses FCF from Q1-4. If you used the KEEPNA setting like FCF(0,TTM,KEEPNA) then it returns NA. I attached an excel file if you want to see the quarterly numbers.


ADUS FCF.xlsx (9.04 KB)

I see, thanks for the explanation.

So to prevent this company from showing up in my screen, do I use stalestatement = 0?
I don’t mind if all items have 1 qtr lookback, but this intermingling can cause a real headache. Actually since we cannot see raw numbers without expressly writing showvars, it is like flying blind. Not sure if I am making my point.

Regards

RTNL, you may try the completestmt flag also.

thanks - great thought Spaceman.