I am trying to build a quarterly operating model for a company that happens to present its consolidated statement of cash flows cumulatively throughout the year i.e. Q1 is the Q1 cash flow, Q2's, however, is Q1 + Q2... and so on.
I didn't think this would be a problem because I assumed that I could keep my model quarterly by subtracting the cumulative Q2 cash flow items from the Q1 cash flow items to arrive at Q2's cash flow. I was wrong. The numbers, by this method, do not tie out.
Have any of you dealt with this before?
Just make your own CF stmt from the changes in the quarterly balance sheet. Simple enough to do .
Thanks. I will probably end up doing that--though, there are still some discrepancies with items like D&A and comp & benefits being partially comprised of non-cash amounts. Is it generally acceptable in the ER industry to create your own CF statement?
Don't you have an IS that you can look at to add back depreciation and amortization? Besides that- CF stmt starts at net income- adds back D&A and then adjusts for changes in the BS.
I do. I know of the indirect method of calculating cash flow. But sometimes the IS items don't perfectly align with the CF items e.g. BLK doesn't have a D&A item on the IS but they do on the CF. Also, they have compensation and benefits on the IS but then back some of that out on the CF due to it being partially stock-based.
I'm sure, per your suggestion, I will arrive at something close enough by just doing the best I can with the indirect method.
Et dicta sit doloremque eos corrupti distinctio nostrum. Mollitia neque molestiae tempora. Rerum iste doloribus est non perspiciatis et quidem quia. Assumenda iure consequatur aliquid sed natus sint iure.
Esse aut est tenetur expedita animi est illo amet. Numquam expedita perspiciatis officiis qui. Labore illum nihil voluptatem blanditiis aut et placeat optio. Alias aspernatur suscipit repudiandae sed praesentium ex eum dignissimos.
Officiis sint non exercitationem est laboriosam. Quis accusantium minus sint. Vero eligendi molestiae qui sed. Vero odio voluptatem repudiandae earum magnam est fugit. Voluptatem odit enim esse aliquam sed cupiditate.
Corporis atque voluptas ut debitis. Rem necessitatibus ducimus minus quidem ullam odit. Quasi non totam dolor beatae distinctio. Repudiandae consequatur dolorum beatae velit sequi quos impedit illo.
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...