Welcome,
Guest
|
|
|
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
|
|
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 |
|
|
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
|
|
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). |
|
|
Thanks.
But how can I define an advanced variable that will calculate this for every company? |
Yoni
|
|
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
|
|