Looking for a Compustat Line Item

Research
1

I’m looking for line item 34, Debt in Current Liabilities. Does P123 have that? I apologize if the answer is obvious.

2

Is it just short term debt?

3

Do you know the CompuStat code? Portfolio123’s Short-term Debt is CompuStat’s DLC, pretty much directly.

4

From page 293 here: http://econ.au.dk/fileadmin/Economics_Business/Education/Summer_University_2012/6308_Advanced_Financial_Accounting/Advanced_Financial_Accounting/2/Sloan_1996_TAR.pdf

I believe it is short term debt (which explains the STD…)

5

I see. That’s change in short-term debt, a cash flow item, and we don’t reveal it. That accrual line, in Portfolio123 terms, is:

((AstCurQ-AstCurPQ)-(CashEquivQ- CashEquivPQ))-((LiabCurQ-LiabCurPQ)-(DbtSTQ-DbtSTPQ)-(TxPayableQ-TxPayablePQ))- DepAmortQ )

Note that this one-quarter change.

For one 12-month period change, use TTM and PTM; e.g., AstCurTTM-AstCurPTM.

For year-over-year change in the interims, use Q and PYQ; e.g., AstCurQ-AstCurPYQ.

For year-over-year annual change, use A and PY; e.g., AstCurA-AstCurPY.

6

Thanks Paul. That’s exactly what I did! Good to know that I’m interpreting all the nomenclature correctly.

7

Be aware that the offset 0 factors ([font=courier new]AstCurQ[/font] & [font=courier new]AstCurA[/font]) employ [font=courier new]FALLBACK[/font] logic when the latest statement is preliminary (falling back to [font=courier new]AstCurPQ[/font] & [font=courier new]AstCurPY[/font] respectively). If you need a stricter implementation of the above, you will need to use factor functions ([font=courier new]AstCur(0, QTR, KEEPNA)[/font] & [font=courier new]AstCur(0, ANN, KEEPNA)[/font]) to override the default behavior (see “[font=courier new]CompleteStmt[/font]” for a way to identify companies with preliminary data).