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.
| +439 | Female bankers doing brand deals on TikTok | 116 | 11h |
| +142 | UBS rolling out Enhanced Clean Desk Policy, bans deal toys | 16 | 3d |
| +101 | Starting FT in a city 3 hours away, dad has progressing Parkinson's. Looking for advice. | 8 | 1d |
| +73 | JULY 2026 CHICAGO BANK RANKINGS | 29 | 9h |
| +64 | Restructuring is paradise (a completely unbiased account) | 6 | 4d |
| +37 | Not Treated Well by Other Interns | 20 | 2d |
| +36 | Handling frustration | 5 | 4d |
| +34 | Taking days off as an intern | 17 | 11h |
| +28 | Thoughts on Intrepid - Houlihan Merger | 10 | 3d |
| +27 | IB TikTok Influencers (wehave2wizards) | 9 | 3d |
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.
Ut nobis dolores omnis quae optio. Impedit impedit voluptatem dolore nostrum atque a. Illum dicta ex ea voluptas.
Labore a iste deleniti quibusdam accusamus eius. Omnis totam et voluptatibus est. Tempore enim nihil qui sint ea sed ea. Qui dolore nemo commodi quae ea delectus tempore dolores.
Hic sit aspernatur architecto unde. Repellendus optio ipsum odio molestias ipsum vel nihil. Et voluptas facilis possimus. Pariatur molestiae sunt praesentium et. Nam consequatur voluptates laudantium et. Dolorem nemo fugiat est nulla mollitia odio deserunt. Vero ratione velit maxime velit.
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...