So this is what's happening: AR in 2020 = 5 AR in 2021 = 3 Change in AR on the CF = 4
I'm doing a case study for a publicly traded company, and I know the disconnect is due to acquisitions, and there's no feasible way to reconcile it.
So now, I'm not sure if I should say screw it and use the historical CF or do the calculation myself. Thanks in advance.
| +116 | I think I’m logging off after ER visit | 23 | 19h |
| +97 | Is it Bad That I ALREADY Don’t Care? | 31 | 1h |
| +91 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 10 | 6h |
| +81 | AI Creating More Work | 27 | 4h |
| +61 | Shit PWP Culture | 43 | 2h |
| +59 | Consulting Son or CorpDev Daughter? | 6 | 4d |
| +44 | How easy was recruiting for you? | 21 | 4d |
| +36 | 22yo IB Analyst just had mental health breakdown | 11 | 1d |
| +30 | How tf do i control a stutter? | 14 | 2h |
| +29 | Uchicago is paradise | 4 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
In my experience historical CF and BS never reconcile properly. Most people that look at public companies input historicals as they report them or hardcode, for example, the reported operating CF and use the "other" line as a plug to make up the difference
The audit should tie out tho and if it doesn’t you can usually tell why by the footnotes
Could you clarify, are you saying I should manually calculate the Cash Flow an then add a line item called "other" that reconciles the difference between Historical CF and the manually calculated CF?
I don't think the firm I'm doing a case study for would approve of that unfortunately...
Typically don’t reconcile due to rounding. Just hard code it or adjust via new line item like above comment.
Deleniti aut dicta quod earum. Minus eum debitis in et et debitis dolores. Amet recusandae porro et qui maxime. Ut repudiandae quos omnis quo.
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...