Accounts Receivable
What are reasons for the AR on the balance sheet not matching what is on the cash flow? Do you just use the number on the CF for working cap calculations?
What are reasons for the AR on the balance sheet not matching what is on the cash flow? Do you just use the number on the CF for working cap calculations?
+72 | Q&A - Buyside Equity Research Analyst/PM | 27 | 1w | |
+31 | How the heck do you learn all of this stuff? | 5 | 5d | |
+28 | Getting Frustrated | 10 | 3w | |
+27 | My experience on the sell side | 20 | 1w | |
+22 | What’s my next move? | 6 | 2w | |
+18 | Biotech ER vs IB | 16 | 3w | |
+14 | Heard they don’t model at Oppenheimer | 10 | 1w | |
+14 | Am i fairly compensated? | 7 | 1d | |
+14 | Data Science to PM | 8 | 2d | |
+13 | ER time line and ways to break in help | 17 | 3w |
Career Resources
Google "Cash Flow Statement" real quick.
Are you trying to do a DCF without any knowledge of accounting?
Sorry. What I meant to say was that I can't get the change in AR to match the CF amount. Everything else matches up fine. Used the gross amounts and net and neither worked.
You're either mismatching time periods, or looking at inconsistent data. Make sure to use Edgar when looking at the financials.
I wouldn't worry about it, and just use the change in working capital for that period found on the cash flow statement.
There are reasons that change in A/R in CFO would not match the change on the balance sheet. For example, if a company acquires another, the A/R accounts would be merged but the change in A/R resulting from the acquisition would not be embedded in cash flow from operations. Another possible reason could be FX adjustments
Generally for complicated companies it's likely you are going to have many issues recreating the SCF from the balance sheet. You'll run into problems as a result of a) acquisitions, particularly non-cash acquisitions, which may not have any effect on the SCF, b) non-cash investing/financing activities [i.e., buy a building by borrowing directly from the seller], c) FCTAs [fx adjustments], and d) other OCI adjustments [for example, you'd have trouble reconciling the securities account if an unrealized loss had occurred].
Good analysis
Accounts Receivable Question (Originally Posted: 03/29/2010)
Hi,
I am working on a DCF model, and trying to project upside/downside cases. Couple of templates I have list a high days sales outstanding (and thus accounts receivable) numbers for an upside case, and low days sales outstanding as a downside case. Since AR is a use of cash, shouldn't a low AR be an upside case and a high AR be a downside case? Thanks for your help.
You are right. Also, I would add that the absolute value of AR is not really an issue. It's the change in AR that matters.
Facere at quis aut mollitia nam. Et cum recusandae iste. Sed sequi optio est praesentium amet. Maiores eum pariatur aspernatur totam est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...