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
Mar 31, 2019 Dec 31, 2018 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
Net fixed asset turnover 7.99 8.00 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 — — —
Total asset turnover 0.84 0.86 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 — — —
Equity turnover 805.30 298.31 — — 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 — — —

Based on: 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-02-08), 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).

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 Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Boeing Co.’s total asset turnover improved from Q3 2018 to Q4 2018 but then deteriorated significantly from Q4 2018 to Q1 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Boeing Co.’s equity turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (USD $ in millions)
Revenues 22,917  28,341  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 
Property, plant and equipment, net of accumulated depreciation 12,594  12,645  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 
Ratio
Net fixed asset turnover1 7.99 8.00 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 — — —

Based on: 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-02-08), 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).

Q1 2019 Calculations

1 Net fixed asset turnover = (RevenuesQ1 2019 + RevenuesQ4 2018 + RevenuesQ3 2018 + RevenuesQ2 2018) ÷ Property, plant and equipment, net of accumulated depreciation
= (22,917 + 28,341 + 25,146 + 24,258) ÷ 12,594 = 7.99

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 Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (USD $ in millions)
Revenues 22,917  28,341  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 
Total assets 120,209  117,359  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 
Ratio
Total asset turnover1 0.84 0.86 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 — — —

Based on: 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-02-08), 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).

Q1 2019 Calculations

1 Total asset turnover = (RevenuesQ1 2019 + RevenuesQ4 2018 + RevenuesQ3 2018 + RevenuesQ2 2018) ÷ Total assets
= (22,917 + 28,341 + 25,146 + 24,258) ÷ 120,209 = 0.84

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 Q3 2018 to Q4 2018 but then deteriorated significantly from Q4 2018 to Q1 2019.

Equity Turnover

Boeing Co., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (USD $ in millions)
Revenues 22,917  28,341  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 
Shareholders’ equity 125  339  (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 
Ratio
Equity turnover1 805.30 298.31 — — 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 — — —

Based on: 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-02-08), 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).

Q1 2019 Calculations

1 Equity turnover = (RevenuesQ1 2019 + RevenuesQ4 2018 + RevenuesQ3 2018 + RevenuesQ2 2018) ÷ Shareholders’ equity
= (22,917 + 28,341 + 25,146 + 24,258) ÷ 125 = 805.30

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Boeing Co.’s equity turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.