Quarterly CAPEX and Acquisition data
Posted: 05 October 2014 03:35 PM   [ Ignore ]
Total Posts:  1
Joined  2014-10-05

Hi all,

These days I’m struggling with measuring quarterly firm investment, such as CAPEX and acquisitions. It seems that Compustat Quarterly only provides year-to-date info on these activities. Other variables such as the reduction / issuance of long-term debt, equity issuance are not readily available in the Quarterly module, either.

- If I really want to gauge firm investment and financing activities on the quarterly level, what should I do?
- How should I interpret the year-to-date data? If the year-to-date CAPEX in the 1st quarter is 100 and 2nd quarter 300, should I say the CAPEX in the 2nd quarter is 200 (=300-100)?

Many thanks!

Posted: 05 October 2014 05:41 PM   [ Ignore ]   [ # 1 ]
Total Posts:  901
Joined  2011-09-19

hi lcbmouse,

These fields are pretty well populated in the quarterly files: acquisitions (AQCY), capital exp (CAPXY), investing activities (total cash flows) (IVNCFY),
financing activities (total cash flows) (FINCFY). Somewhat well populated (assuming ‘missing’ means zero) is R&D exp (XRDY).

Please double-check by inspecting the records, but yes, for the year-to-date variables take the increase in that quarter (like you pointed out).

You could also use SDC to measure M&A activity.

hope this helps,



To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas