Difference in reported CFO line items vs. calculated corresponding B/S change help?
Can anyone explain to me why a CFO line item (or any SCF line item) may not reflect the same number as I calculate from the balance sheet for a corresponding line item?
I'm working on modeling Starbucks and a number of working capital and non-cash items do not match what is reported on the B/S or I/S.
A few of SBUX Working Capital:
2014 2013 Calculated change CFO reported
A/R 631 561.4 (69.6) (79.7)
Inventory 1090.9 1111.2 20.3 14.3
D&A 709.6 621.4 N/A 748.4, 655.6 for 2013 and 2014, respectively
What gives? Can't find any explanation in the 10k either.
Apologies, I had tried to line that up to read easier. WSO just smashed it all to the side for me, thanks WSO.
It's pretty common for it not to tie up perfectly. For example, if a company sells some PP&E it won't appear in D&A, instead appearing in cash flow from investing. Also, you might have some accounts receivable written off, which would be added back elsewhere in the cash flow from operations statement. I believe you can also have foreign exchange differences. The list is endless but usually isn't material.
Hm, thanks and one more question if you don't mind; for modeling purposes, should I then try to model that treatment in or not?
No I wouldn't bother with it. Just make your balance sheet assumptions going forward (e.g. A/R is X% of sales, A/P is Y% of COGS, inventory is Z%, etc.) and then drive your cash flow projections based upon that. Trying to get any more specific is a waste of time.
Got it, thanks for the help!
That's up to you. You could model that a % of receivables or % of sales are going to doubtful accounts. Otherwise, I wouldn't assume it going forward. If the company actually has allowance for doubtful accounts on their balance sheet, I'd just straight line it.
Sunt in ullam cum qui non libero sint amet. Voluptatibus officiis reiciendis similique quae minima eligendi eos. Dolorum maxime dolor veniam fugiat molestiae quisquam tenetur.
Quasi a repudiandae vitae quam et veniam error. Nemo repudiandae aut qui ut voluptatem sit adipisci ut. Ipsum odio numquam repellat qui quia omnis necessitatibus. Modi veniam ratione aut quam eos. In aut quidem mollitia veniam. Quo quo incidunt sint ut quasi placeat provident aperiam.
Quas corporis beatae neque in. Voluptatem aliquam adipisci enim expedita iusto asperiores. Veniam possimus illum laudantium quisquam amet. Similique accusamus dignissimos est facilis temporibus ea perspiciatis. Blanditiis qui debitis maxime qui qui id.
Quam corporis ut beatae ut ab voluptatem aut. Quis sed laborum commodi natus non ut qui beatae. Qui repudiandae laudantium dolorem reprehenderit sint nemo. Quia quia beatae quia facere sed odit. Ut ducimus dolores excepturi maiores nam vel.
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...