Welcome, Guest

ttm free cash flow use only the last 2 quarters
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: ttm free cash flow use only the last 2 quarters

ttm free cash flow use only the last 2 quarters 6 years, 10 months ago #321

  • yonil
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Karma: 0
It seems that the 3 fields below use only the last 2 quarters instead of using last 4 quarters:
e.g. for MSFT, "Free Cash Flow-trailing 12 month" = 14B - this is the cash flow in the last 2 quarters

Free Cash Flow-trailing 12 month
Free Cash Flow per share-trailing 12 month
Price to Free Cash Flow per Share-trailing 12 months
Yoni

Re: ttm free cash flow use only the last 2 quarters 6 years, 10 months ago #322

  • admin
  • OFFLINE
  • Administrator
  • Posts: 290
  • Karma: 18
Yonil,

I do not think that is correct. Microsoft had ~$9.9B of dividends paid in 2015; that roughly accounts for the discrepancy you observed. Reuters subtracts out dividends paid to get to free cash flow, as per the data definitions. You can use the financial statement fields to add dividends paid back, to get a more standard value for free cash flow.

See screener.co/component/content/article/55...985-text-and-article

Re: ttm free cash flow use only the last 2 quarters 6 years, 10 months ago #324

  • yonil
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Karma: 0
Thanks.
regarding: "You can use the financial statement fields to add dividends paid back, to get a more standard value for free cash flow"
Can you please explain how can I do this?
As some companies report every quarter and some twice/three times a year.
I also tried to add "Dividends per share-trailing 12 month" but it seems this field shows the amount of dividends that were distributed in the last 12 months and this period is not the same as the period covered by the last 2/3/4 interim reported. (the last interim reported can end few months back from today)
Yoni

Re: ttm free cash flow use only the last 2 quarters 6 years, 10 months ago #326

  • admin
  • OFFLINE
  • Administrator
  • Posts: 290
  • Karma: 18
For companies/markets that report quarterly, you can use the Free Form Formula below:

Free Cash Flow-trailing 12 month - ( Dividends Paid(I) + Dividends Paid(I-1) + Dividends Paid(I-2) + Dividends Paid(I-3) )

It is "minus" because Dividends Paid is a negative item on the cash flow statement. If you are looking at markets with a different reporting schedule, you can adjust the formula accordingly (removing the excess number of Dividends Paid periods for semi-annual or tri-annual reporters).

Re: ttm free cash flow use only the last 2 quarters 6 years, 10 months ago #327

  • yonil
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Karma: 0
Thanks.
But how can I define an advanced variable that will calculate this for every company?
Yoni

Re: ttm free cash flow use only the last 2 quarters 6 years, 10 months ago #328

  • yonil
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Karma: 0
Ok, I managed to calculate this using:
[Free Operating Cash Flow Ex Dividends/Revenue-TTM] * [Revenue-trailing 12 month]
Is there a "cleaner" way to get this data?
Yoni
  • Page:
  • 1
  • 2
Time to create page: 0.09 seconds