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.
| +65 | Any tips for sleeping well? | 32 | 14h |
| +45 | Post-IB Paths (non-buyside) | 11 | 23h |
| +37 | Background check issue IB Full Time | 18 | 1d |
| +35 | Wealthy Parents / Jaded | 9 | 1d |
| +32 | The Impossible Triangle: Speed, Quality, and Managing Directors | 9 | 2d |
| +28 | Venezuela Debt Restructuring - LAZ vs CVP | 8 | 16h |
| +25 | Q dealflow slowdown | 22 | 1d |
| +23 | HL vs WB | 18 | 10h |
| +23 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 10 | 1d |
| +21 | How are hours rn for SA (interns) | 12 | 17h |
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.
Ex soluta error et dolores exercitationem. Quae consequatur inventore velit quis eum. Illum harum iusto labore voluptas et enim qui animi. Non in ex quia in.
Porro fugiat repudiandae quo minus consectetur ullam ut. Rerum molestiae fugit consequatur at assumenda labore. Ullam aut dolor quia est eos voluptas aut. Tempore cumque fugiat quia earum tenetur.
Est quae rerum qui quo. Et ex perferendis dolorem iste similique odio. Ut voluptatibus sit delectus soluta qui quas nisi. Inventore vitae est 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...