Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Union Pacific Corp. (NYSE:UNP)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

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

Long-term Activity Ratios (Summary)

Union Pacific Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 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
Net fixed asset turnover 0.37 0.40 0.40 0.42 0.43 0.43 0.43 0.43 0.42 0.42 0.41 0.41 0.41 0.40 0.40 0.40 0.41 0.43 0.45 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 0.36 0.39 0.39 0.40 0.41 0.41 0.43 0.43 0.42 0.42 0.41 0.41 0.41 0.40 0.40 0.40 0.41 0.43 0.45 — — —
Total asset turnover 0.32 0.35 0.35 0.36 0.37 0.37 0.39 0.38 0.37 0.37 0.37 0.37 0.37 0.36 0.36 0.35 0.37 0.38 0.40 — — —
Equity turnover 1.23 1.35 1.20 1.24 1.25 1.28 1.12 1.09 1.11 0.88 0.85 1.09 1.06 1.03 1.00 0.99 1.00 1.03 1.05 — — —

Based on: 10-Q (filing date: 2020-07-23), 10-Q (filing date: 2020-04-23), 10-K (filing date: 2020-02-07), 10-Q (filing date: 2019-10-17), 10-Q (filing date: 2019-07-18), 10-Q (filing date: 2019-04-18), 10-K (filing date: 2019-02-08), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-19), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-09), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-20), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-20), 10-Q (filing date: 2016-07-21), 10-Q (filing date: 2016-04-21), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-22), 10-Q (filing date: 2015-07-24), 10-Q (filing date: 2015-04-23).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Union Pacific Corp.’s net fixed asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Union Pacific Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Union Pacific Corp.’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Union Pacific Corp.’s equity turnover ratio improved from Q4 2019 to Q1 2020 but then slightly deteriorated from Q1 2020 to Q2 2020 not reaching Q4 2019 level.

Net Fixed Asset Turnover

Union Pacific Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 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
Selected Financial Data (US$ in millions)
Operating revenues 4,244  5,229  5,212  5,516  5,596  5,384  5,757  5,928  5,672  5,475  5,450  5,408  5,250  5,132  5,168  5,174  4,770  4,829  5,208  5,562  5,429  5,614 
Net properties 54,270  54,121  53,916  53,488  53,115  52,856  52,679  52,210  51,947  51,696  51,605  51,036  50,814  50,550  50,389  49,939  49,461  49,071  48,866  48,149  47,512  46,928 
Long-term Activity Ratio
Net fixed asset turnover1 0.37 0.40 0.40 0.42 0.43 0.43 0.43 0.43 0.42 0.42 0.41 0.41 0.41 0.40 0.40 0.40 0.41 0.43 0.45 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
CSX Corp. 0.34 0.37 0.37 0.38 0.39 0.39 0.38 0.38 0.36 0.36 0.36 0.37 0.37 0.36 0.36 0.35 0.36 0.38 0.39 — — —
FedEx Corp. 2.13 2.20 2.29 2.32 2.34 2.34 2.32 2.31 2.28 2.32 2.32 2.25 2.18 2.13 2.07 2.19 2.18 2.24 2.27 — — —
Norfolk Southern Corp. 0.33 0.36 0.36 0.37 0.37 0.37 0.37 0.37 0.36 0.35 0.35 0.34 0.34 0.34 0.33 0.34 0.34 0.36 0.36 — — —
United Parcel Service Inc. 2.46 2.43 2.43 2.52 2.58 2.64 2.70 2.79 2.90 2.91 2.98 3.05 3.17 3.21 3.24 3.25 3.25 3.22 3.18 — — —

Based on: 10-Q (filing date: 2020-07-23), 10-Q (filing date: 2020-04-23), 10-K (filing date: 2020-02-07), 10-Q (filing date: 2019-10-17), 10-Q (filing date: 2019-07-18), 10-Q (filing date: 2019-04-18), 10-K (filing date: 2019-02-08), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-19), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-09), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-20), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-20), 10-Q (filing date: 2016-07-21), 10-Q (filing date: 2016-04-21), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-22), 10-Q (filing date: 2015-07-24), 10-Q (filing date: 2015-04-23).

1 Q2 2020 Calculation
Net fixed asset turnover = (Operating revenuesQ2 2020 + Operating revenuesQ1 2020 + Operating revenuesQ4 2019 + Operating revenuesQ3 2019) ÷ Net properties
= (4,244 + 5,229 + 5,212 + 5,516) ÷ 54,270 = 0.37

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Union Pacific Corp.’s net fixed asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Union Pacific Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 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
Selected Financial Data (US$ in millions)
Operating revenues 4,244  5,229  5,212  5,516  5,596  5,384  5,757  5,928  5,672  5,475  5,450  5,408  5,250  5,132  5,168  5,174  4,770  4,829  5,208  5,562  5,429  5,614 
 
Net properties 54,270  54,121  53,916  53,488  53,115  52,856  52,679  52,210  51,947  51,696  51,605  51,036  50,814  50,550  50,389  49,939  49,461  49,071  48,866  48,149  47,512  46,928 
Operating lease assets 1,700  1,773  1,812  1,931  2,076  2,146  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Net properties (including operating lease, right-of-use asset) 55,970  55,894  55,728  55,419  55,191  55,002  52,679  52,210  51,947  51,696  51,605  51,036  50,814  50,550  50,389  49,939  49,461  49,071  48,866  48,149  47,512  46,928 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 0.36 0.39 0.39 0.40 0.41 0.41 0.43 0.43 0.42 0.42 0.41 0.41 0.41 0.40 0.40 0.40 0.41 0.43 0.45 — — —
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
CSX Corp. 0.33 0.36 0.37 0.37 0.38 0.38 0.38 0.38 0.36 0.36 0.36 0.37 0.37 0.36 0.36 0.35 0.36 0.38 0.39 — — —
FedEx Corp. 1.49 1.53 2.29 2.32 2.34 2.34 2.32 2.31 2.28 2.32 2.32 2.25 2.18 2.13 2.07 2.19 2.18 2.24 2.27 — — —
United Parcel Service Inc. 2.25 2.21 2.22 2.32 2.37 2.41 2.70 2.79 2.90 2.91 2.98 3.05 3.17 3.21 3.24 3.25 3.25 3.22 3.18 — — —

Based on: 10-Q (filing date: 2020-07-23), 10-Q (filing date: 2020-04-23), 10-K (filing date: 2020-02-07), 10-Q (filing date: 2019-10-17), 10-Q (filing date: 2019-07-18), 10-Q (filing date: 2019-04-18), 10-K (filing date: 2019-02-08), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-19), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-09), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-20), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-20), 10-Q (filing date: 2016-07-21), 10-Q (filing date: 2016-04-21), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-22), 10-Q (filing date: 2015-07-24), 10-Q (filing date: 2015-04-23).

1 Q2 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Operating revenuesQ2 2020 + Operating revenuesQ1 2020 + Operating revenuesQ4 2019 + Operating revenuesQ3 2019) ÷ Net properties (including operating lease, right-of-use asset)
= (4,244 + 5,229 + 5,212 + 5,516) ÷ 55,970 = 0.36

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Union Pacific Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Total Asset Turnover

Union Pacific Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 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
Selected Financial Data (US$ in millions)
Operating revenues 4,244  5,229  5,212  5,516  5,596  5,384  5,757  5,928  5,672  5,475  5,450  5,408  5,250  5,132  5,168  5,174  4,770  4,829  5,208  5,562  5,429  5,614 
Total assets 63,555  62,216  61,673  61,978  61,708  61,319  59,147  59,312  58,689  57,789  57,806  57,397  56,478  55,900  55,718  56,305  55,690  55,772  54,600  53,763  54,177  53,145 
Long-term Activity Ratio
Total asset turnover1 0.32 0.35 0.35 0.36 0.37 0.37 0.39 0.38 0.37 0.37 0.37 0.37 0.37 0.36 0.36 0.35 0.37 0.38 0.40 — — —
Benchmarks
Total Asset Turnover, Competitors2
CSX Corp. 0.28 0.30 0.31 0.31 0.33 0.32 0.33 0.32 0.31 0.30 0.32 0.33 0.32 0.32 0.31 0.31 0.32 0.33 0.34 — — —
FedEx Corp. 0.99 1.02 1.28 1.27 1.29 1.29 1.25 1.23 1.24 1.24 1.24 1.23 1.19 1.16 1.09 1.31 1.27 1.29 1.28 — — —
Norfolk Southern Corp. 0.27 0.30 0.30 0.31 0.31 0.31 0.32 0.31 0.31 0.30 0.30 0.30 0.29 0.29 0.28 0.29 0.29 0.31 0.31 — — —
United Parcel Service Inc. 1.25 1.23 1.28 1.38 1.37 1.38 1.44 1.52 1.53 1.52 1.45 1.55 1.58 1.61 1.51 1.57 1.55 1.50 1.52 — — —

Based on: 10-Q (filing date: 2020-07-23), 10-Q (filing date: 2020-04-23), 10-K (filing date: 2020-02-07), 10-Q (filing date: 2019-10-17), 10-Q (filing date: 2019-07-18), 10-Q (filing date: 2019-04-18), 10-K (filing date: 2019-02-08), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-19), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-09), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-20), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-20), 10-Q (filing date: 2016-07-21), 10-Q (filing date: 2016-04-21), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-22), 10-Q (filing date: 2015-07-24), 10-Q (filing date: 2015-04-23).

1 Q2 2020 Calculation
Total asset turnover = (Operating revenuesQ2 2020 + Operating revenuesQ1 2020 + Operating revenuesQ4 2019 + Operating revenuesQ3 2019) ÷ Total assets
= (4,244 + 5,229 + 5,212 + 5,516) ÷ 63,555 = 0.32

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Union Pacific Corp.’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Equity Turnover

Union Pacific Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 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
Selected Financial Data (US$ in millions)
Operating revenues 4,244  5,229  5,212  5,516  5,596  5,384  5,757  5,928  5,672  5,475  5,450  5,408  5,250  5,132  5,168  5,174  4,770  4,829  5,208  5,562  5,429  5,614 
Common shareholders’ equity 16,452  15,991  18,128  18,016  18,171  17,742  20,423  20,645  19,909  24,389  24,856  19,151  19,615  19,723  19,932  20,284  20,422  20,475  20,702  20,599  20,990  21,057 
Long-term Activity Ratio
Equity turnover1 1.23 1.35 1.20 1.24 1.25 1.28 1.12 1.09 1.11 0.88 0.85 1.09 1.06 1.03 1.00 0.99 1.00 1.03 1.05 — — —
Benchmarks
Equity Turnover, Competitors2
CSX Corp. 0.90 0.99 1.01 1.03 1.01 1.00 0.98 0.87 0.83 0.79 0.78 1.06 1.00 0.97 0.95 0.93 0.95 0.98 1.01 — — —
FedEx Corp. 3.71 3.84 3.92 3.48 3.56 3.51 3.37 3.38 3.65 3.67 3.75 3.79 3.80 3.73 3.65 3.46 3.24 3.14 3.17 — — —
Norfolk Southern Corp. 0.69 0.74 0.74 0.75 0.76 0.76 0.75 0.73 0.66 0.65 0.64 0.81 0.81 0.80 0.80 0.80 0.82 0.85 0.86 — — —
United Parcel Service Inc. 17.74 22.72 22.68 13.20 16.46 20.74 23.79 22.87 29.80 50.35 65.87 42.39 50.58 115.52 150.39 21.88 22.60 23.93 23.63 — — —

Based on: 10-Q (filing date: 2020-07-23), 10-Q (filing date: 2020-04-23), 10-K (filing date: 2020-02-07), 10-Q (filing date: 2019-10-17), 10-Q (filing date: 2019-07-18), 10-Q (filing date: 2019-04-18), 10-K (filing date: 2019-02-08), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-19), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-09), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-20), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-20), 10-Q (filing date: 2016-07-21), 10-Q (filing date: 2016-04-21), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-22), 10-Q (filing date: 2015-07-24), 10-Q (filing date: 2015-04-23).

1 Q2 2020 Calculation
Equity turnover = (Operating revenuesQ2 2020 + Operating revenuesQ1 2020 + Operating revenuesQ4 2019 + Operating revenuesQ3 2019) ÷ Common shareholders’ equity
= (4,244 + 5,229 + 5,212 + 5,516) ÷ 16,452 = 1.23

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Union Pacific Corp.’s equity turnover ratio improved from Q4 2019 to Q1 2020 but then slightly deteriorated from Q1 2020 to Q2 2020 not reaching Q4 2019 level.