Index | Recent Threads | Who's Online | Search

New Thread
This topic has been viewed 101 times and has 4 replies
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?

Attachment adus.JPG (32621 bytes) (Download count: 27)

Nov 5, 2020 3:08:49 PM       
Re: strange cash flow numbers for ADUS

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.

Attachment ADUS FCF.xlsx (9259 bytes) (Download count: 3)


Nov 5, 2020 4:18:22 PM       
Re: strange cash flow numbers for ADUS

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.


Nov 5, 2020 9:54:18 PM       
Re: strange cash flow numbers for ADUS

RTNL, you may try the completestmt flag also.

Nov 6, 2020 12:45:37 AM       
Re: strange cash flow numbers for ADUS

thanks - great thought Spaceman.

Nov 6, 2020 8:54:49 AM