Microsoft Excel LibreOffice Calc

Boeing Co. (BA)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Ratios (Summary)

Boeing Co., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Net fixed asset turnover 7.81 7.72 7.59 7.37 7.18 7.09 7.24 7.38 7.46 7.72 7.87 7.96 8.35 8.37 8.27 8.25 8.41 8.46 8.59 8.47 – – –
Total asset turnover 0.86 0.86 0.84 1.01 1.00 1.01 1.04 1.05 1.07 1.08 1.06 1.02 0.98 0.97 0.95 0.91 0.97 0.95 0.96 0.93 – – –
Equity turnover – – 78.39 263.08 84.08 – 978.05 115.75 45.41 165.49 23.89 15.17 14.39 15.16 11.69 10.47 6.21 6.29 6.07 5.82 – – –

Based on: 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-12), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-08), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22), 10-K (filing date: 2015-02-12), 10-Q (filing date: 2014-10-22), 10-Q (filing date: 2014-07-23), 10-Q (filing date: 2014-04-23), 10-K (filing date: 2014-02-14), 10-Q (filing date: 2013-10-23), 10-Q (filing date: 2013-07-24), 10-Q (filing date: 2013-04-24).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Boeing Co.'s net fixed asset turnover improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Boeing Co.'s total asset turnover improved from Q1 2018 to Q2 2018 but then slightly deteriorated from Q2 2018 to Q3 2018.
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity.

Net Fixed Asset Turnover

Boeing Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Revenues 25,146  24,258  23,382  25,368  24,309  22,739  20,976  23,286  23,898  24,755  22,632  23,573  25,849  24,543  22,149  24,468  23,784  22,045  20,465  23,785  22,130  21,815  18,893 
Property, plant and equipment, net of accumulated depreciation 12,571  12,605  12,628  12,672  12,712  12,820  12,842  12,807  12,713  12,533  12,269  12,076  11,614  11,338  11,172  11,007  10,707  10,449  10,263  10,224  9,987  9,814  9,736 
Ratio
Net fixed asset turnover1 7.81 7.72 7.59 7.37 7.18 7.09 7.24 7.38 7.46 7.72 7.87 7.96 8.35 8.37 8.27 8.25 8.41 8.46 8.59 8.47 – – –

Based on: 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-12), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-08), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22), 10-K (filing date: 2015-02-12), 10-Q (filing date: 2014-10-22), 10-Q (filing date: 2014-07-23), 10-Q (filing date: 2014-04-23), 10-K (filing date: 2014-02-14), 10-Q (filing date: 2013-10-23), 10-Q (filing date: 2013-07-24), 10-Q (filing date: 2013-04-24).

Q3 2018 Calculations

1 Net fixed asset turnover = (RevenuesQ3 2018 + RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017) ÷ Property, plant and equipment, net of accumulated depreciation
= (25,146 + 24,258 + 23,382 + 25,368) ÷ 12,571 = 7.81

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Boeing Co.'s net fixed asset turnover improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Total Asset Turnover

Boeing Co., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Revenues 25,146  24,258  23,382  25,368  24,309  22,739  20,976  23,286  23,898  24,755  22,632  23,573  25,849  24,543  22,149  24,468  23,784  22,045  20,465  23,785  22,130  21,815  18,893 
Total assets 114,659  113,195  113,549  92,333  91,007  90,036  89,673  89,997  88,950  89,609  91,547  94,408  98,998  98,102  97,775  99,198  92,653  92,737  91,575  92,663  94,633  92,091  90,447 
Ratio
Total asset turnover1 0.86 0.86 0.84 1.01 1.00 1.01 1.04 1.05 1.07 1.08 1.06 1.02 0.98 0.97 0.95 0.91 0.97 0.95 0.96 0.93 – – –

Based on: 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-12), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-08), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22), 10-K (filing date: 2015-02-12), 10-Q (filing date: 2014-10-22), 10-Q (filing date: 2014-07-23), 10-Q (filing date: 2014-04-23), 10-K (filing date: 2014-02-14), 10-Q (filing date: 2013-10-23), 10-Q (filing date: 2013-07-24), 10-Q (filing date: 2013-04-24).

Q3 2018 Calculations

1 Total asset turnover = (RevenuesQ3 2018 + RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017) ÷ Total assets
= (25,146 + 24,258 + 23,382 + 25,368) ÷ 114,659 = 0.86

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Boeing Co.'s total asset turnover improved from Q1 2018 to Q2 2018 but then slightly deteriorated from Q2 2018 to Q3 2018.

Equity Turnover

Boeing Co., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Revenues 25,146  24,258  23,382  25,368  24,309  22,739  20,976  23,286  23,898  24,755  22,632  23,573  25,849  24,543  22,149  24,468  23,784  22,045  20,465  23,785  22,130  21,815  18,893 
Shareholders’ equity (1,289) (1,441) 1,222  355  1,086  (2,037) 95  817  2,089  585  4,043  6,335  6,740  6,264  7,906  8,665  14,511  14,061  14,520  14,875  8,951  7,526  7,462 
Ratio
Equity turnover1 – – 78.39 263.08 84.08 – 978.05 115.75 45.41 165.49 23.89 15.17 14.39 15.16 11.69 10.47 6.21 6.29 6.07 5.82 – – –

Based on: 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-12), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-08), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22), 10-K (filing date: 2015-02-12), 10-Q (filing date: 2014-10-22), 10-Q (filing date: 2014-07-23), 10-Q (filing date: 2014-04-23), 10-K (filing date: 2014-02-14), 10-Q (filing date: 2013-10-23), 10-Q (filing date: 2013-07-24), 10-Q (filing date: 2013-04-24).

Q3 2018 Calculations

1 Equity turnover = (RevenuesQ3 2018 + RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017) ÷ Shareholders’ equity
= (25,146 + 24,258 + 23,382 + 25,368) ÷ -1,289 = –

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity.