Microsoft Excel LibreOffice Calc

Boeing Co. (BA)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

  • Annual Data
  • Quarterly Data

    • 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
    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.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.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 – – –
    Source: Based on data from Boeing Co. Quarterly and Annual Reports
    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 Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
    Total asset turnover An activity ratio calculated as total revenue divided by total assets. Boeing Co.'s total asset turnover deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.
    Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Boeing Co.'s equity turnover deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Net Fixed Asset Turnover

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

    Microsoft Excel LibreOffice Calc
    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 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,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.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 – – –
    Source: Based on data from Boeing Co. Quarterly and Annual Reports

    Q2 2018 Calculations

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

    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 Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Total Asset Turnover

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

    Microsoft Excel LibreOffice Calc
    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 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 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.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 – – –
    Source: Based on data from Boeing Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Total asset turnover = (RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017 + RevenuesQ3 2017) ÷ Total assets
    = (24,258 + 23,382 + 25,368 + 24,309) ÷ 113,195 = 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 deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.

    Equity Turnover

    Boeing Co., equity turnover calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    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 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,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 – – –
    Source: Based on data from Boeing Co. Quarterly and Annual Reports

    Q2 2018 Calculations

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

    Ratio Description The company
    Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Boeing Co.'s equity turnover deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.