How do I calculate quarterly financing activities (equity and debt issue, repurchase etc)?
Posted: 02 June 2014 06:08 PM   [ Ignore ]
Newbie
Rank
Total Posts:  2
Joined  2014-06-02

Hi

I’m looking for the quarterly financing activities of firms under compustat.
The literature I referred to states that ‘the quarterly cash flow statements of the individual firms are examined to isolate equity issuance, equity repurchase, net debt increase and net debt reduction activities.’

However, under the quarterly data items there appears to be only 3 related items:
CSHOPQ—Total Shares Repurchased - Quarter
PRCRAQ—Repurchase Price - Average per share Quarter
CSHIQ—Common Shares Issued

Shall I multiply PRCRAQ by CSHOPQ to get the quarterly equity repurchase activities?
In addition, how do I obtain the quarterly equity issuance amount? (i.e. I cannot find the issue price of common shares under quarterly data items)
Finally, I am wondering how do I calculate the net debt increase or reduction per quarter? Which cash flow item should I use to obtain the debt related financing activities?

Thanks a lot for your help.

Profile
 
 
Posted: 02 June 2014 07:23 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Szhou,

I am forwarding your question to the Google group, and will post any replies in that group here.

best regards,

Joost

 Signature 

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

Profile
 
 
Posted: 03 June 2014 04:13 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  2
Joined  2014-06-02

Hi Joost´╝î

Thanks very much for your help.

I’m quite struggling with identifying these data as they are really vital to my research. I very much hope that some one can help me to sort it out.

I’m wondering if you have any thoughts on my questions as well?

Many thanks

Profile
 
 
Posted: 03 June 2014 12:04 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Szhou,

Did you go over the items on this page? http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65813

I have not constructed the variables you need before, so I don’t have much of an edge in knowing which ones you need/would work, but there are at least 20 cash flow statement variables in Fundq.

The ‘official’ wrds website also has a forum section where you could post your question.

best regards,

Joost

 Signature 

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

Profile