Author Topic: What am I not understanding?  (Read 1449 times)

aileron

  • Newbie
  • *
  • Posts: 3
What am I not understanding?
« on: September 20, 2019, 03:46:34 PM »
I'm hoping this post isn't out of line and someone can help here. I'm trying to make a spreadsheet to do analysis with and while putting it all together I chose Boeing as my test company. When doing the cash flow statement I ran into issues of the Net Increase in Cash & Cash Equiv not adding up correctly. So I made a separate sheet to test the data and can't figure out why I'm 138 and 262 million off when I actually add up the numbers from Edgar using excel. 

I've attached a test spreadsheet and was wondering if someone could shed some light on why it doesn't add up? Is this normal for 10k filings to not add up if you actually do the math? Am I not understanding how to add a cash flow statement up? I thought it was pretty straight forward.

Anyways line 48 to be exact where I add up Operating, Investing, Financing, plus exchange rate . My error is happening in years 2018 and 2017. I'm using Cells F48 and F49 to check them.

Any help would be appreciated as I can't find any reason this shouldn't work outside of the numbers being wrong or me not understanding something. Which btw pouring over simple accounting examples doesn't seem to shed light on what I'm missing.


Schwab711

  • Hero Member
  • *****
  • Posts: 1626
Re: What am I not understanding?
« Reply #1 on: September 20, 2019, 04:53:38 PM »
Purchase of distribution rights should be -69 and -131
« Last Edit: September 20, 2019, 05:07:21 PM by Schwab711 »

aileron

  • Newbie
  • *
  • Posts: 3
Re: What am I not understanding?
« Reply #2 on: September 21, 2019, 11:42:50 AM »
My goodness... I feel embarrassed; easy X2 check.

I went back to the data at Edgar and sure enough in the 10-k its correct but in the interactive data that I downloaded its wrong.

Made the assumption it wouldn't be... now I know.

Thank you a bunch... :) I was pulling my hair out holding on to a false assumption.

Schwab711

  • Hero Member
  • *****
  • Posts: 1626
Re: What am I not understanding?
« Reply #3 on: September 21, 2019, 06:00:21 PM »
No problem, happens to all of us. You should let BA's investor relations know! They might have a coding error.

John Hjorth

  • Hero Member
  • *****
  • Posts: 2763
Re: What am I not understanding?
« Reply #4 on: September 21, 2019, 06:17:35 PM »
In short - CoBF at its best - members helping members!
”In the race of excellence … there is no finish line.”
-HH Sheikh Mohammed Bin Rashid Al Maktoum, Vice President and Prime Minister of the United Arab Emirates and Ruler of Dubai

Gamecock-YT

  • Hero Member
  • *****
  • Posts: 583
Re: What am I not understanding?
« Reply #5 on: September 21, 2019, 07:40:34 PM »
No problem, happens to all of us. You should let BA's investor relations know! They might have a coding error.

wouldn't be the first time that Boeing has had an error with their coding....

aileron

  • Newbie
  • *
  • Posts: 3
Re: What am I not understanding?
« Reply #6 on: September 22, 2019, 12:59:24 PM »
... You should let BA's investor relations know! They might have a coding error.

Ya I will be doing that.

EricSchleien

  • Sr. Member
  • ****
  • Posts: 371
Re: What am I not understanding?
« Reply #7 on: September 22, 2019, 01:55:19 PM »
No problem, happens to all of us. You should let BA's investor relations know! They might have a coding error.

wouldn't be the first time that Boeing has had an error with their coding....

MIC DROP...wow!! that's epic