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?
+81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 5d | |
+32 | How the heck do you learn all of this stuff? | 10 | 4h | |
+28 | Getting Frustrated | 10 | 4w | |
+28 | My experience on the sell side | 20 | 2w | |
+24 | Clues in Financial Reporting Analysis | 7 | 1d | |
+17 | Am i fairly compensated? | 9 | 2d | |
+14 | Data Science to PM | 8 | 1w | |
+14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
+12 | ER - Remote Jobs? | 8 | 5d | |
Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 21h |
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.
Qui et maiores id recusandae omnis natus quia. Deserunt nobis autem deserunt nihil.
Iusto sunt et et perspiciatis. Eos molestiae aut ipsum dicta ullam reprehenderit modi. Id quia labore accusantium. Eos vitae natus iste suscipit quia omnis. Aut dolor earum quia iusto alias.
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...