Index | Recent Threads | Who's Online | Search |
|
New Thread |
|
RTNL
![]() |
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? ![]() |
||
|
danparquette
![]() |
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. ![]() Dan |
||
|
SpacemanJones
![]() |
RTNL, you may try the completestmt flag also. |
||
|
RTNL
![]() |
thanks - great thought Spaceman. |
||
|
|