Stock Analysis on Net

Union Pacific Corp. (NYSE:UNP)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 0.42 0.42 0.42 0.44 0.45 0.44 0.44 0.42 0.41 0.40 0.39 0.38 0.36 0.36 0.36 0.37 0.40 0.40
Net fixed asset turnover (including operating lease, right-of-use asset) 0.41 0.41 0.41 0.42 0.43 0.43 0.43 0.41 0.40 0.38 0.38 0.37 0.35 0.35 0.35 0.36 0.39 0.39
Total asset turnover 0.36 0.36 0.36 0.38 0.38 0.38 0.37 0.36 0.35 0.34 0.34 0.33 0.31 0.31 0.31 0.32 0.35 0.35
Equity turnover 1.54 1.63 1.72 1.88 2.01 2.05 2.08 1.84 1.90 1.54 1.52 1.44 1.19 1.15 1.14 1.23 1.35 1.20

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

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. net fixed asset turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
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. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Union Pacific Corp. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Union Pacific Corp. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Net Fixed Asset Turnover

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

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Operating revenues 6,031 6,159 5,941 5,963 6,056 6,180 6,566 6,269 5,860 5,733 5,566 5,504 5,001 5,141 4,919 4,244 5,229 5,212 5,516 5,596 5,384
Properties, net 57,590 57,398 57,010 56,641 56,274 56,038 55,689 55,315 55,064 54,871 54,362 54,148 54,062 54,161 54,375 54,270 54,121 53,916 53,488 53,115 52,856
Long-term Activity Ratio
Net fixed asset turnover1 0.42 0.42 0.42 0.44 0.45 0.44 0.44 0.42 0.41 0.40 0.39 0.38 0.36 0.36 0.36 0.37 0.40 0.40
Benchmarks
Net Fixed Asset Turnover, Competitors2
FedEx Corp. 2.15 2.22 2.32 2.37 2.44 2.45 2.45 2.41 2.37 2.35 2.25 2.16 2.09 2.06 2.09 2.13 2.20 2.29 2.32 2.34 2.34
Uber Technologies Inc. 17.98 17.12 16.54 15.80 15.31 14.96 13.73 11.55 9.42 8.33 7.21 6.14 6.14 6.40 7.07 7.72 8.17
United Parcel Service Inc. 2.46 2.58 2.71 2.83 2.89 3.01 2.99 2.94 2.91 2.87 2.83 2.76 2.62 2.50 2.46 2.43 2.43

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Net fixed asset turnover = (Operating revenuesQ1 2024 + Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023) ÷ Properties, net
= (6,031 + 6,159 + 5,941 + 5,963) ÷ 57,590 = 0.42

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. net fixed asset turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

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
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Operating revenues 6,031 6,159 5,941 5,963 6,056 6,180 6,566 6,269 5,860 5,733 5,566 5,504 5,001 5,141 4,919 4,244 5,229 5,212 5,516 5,596 5,384
 
Properties, net 57,590 57,398 57,010 56,641 56,274 56,038 55,689 55,315 55,064 54,871 54,362 54,148 54,062 54,161 54,375 54,270 54,121 53,916 53,488 53,115 52,856
Operating lease assets 1,453 1,643 1,670 1,651 1,700 1,672 1,703 1,706 1,727 1,787 1,630 1,635 1,581 1,610 1,642 1,700 1,773 1,812 1,931 2,076 2,146
Properties, net (including operating lease, right-of-use asset) 59,043 59,041 58,680 58,292 57,974 57,710 57,392 57,021 56,791 56,658 55,992 55,783 55,643 55,771 56,017 55,970 55,894 55,728 55,419 55,191 55,002
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 0.41 0.41 0.41 0.42 0.43 0.43 0.43 0.41 0.40 0.38 0.38 0.37 0.35 0.35 0.35 0.36 0.39 0.39
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
FedEx Corp. 1.51 1.55 1.62 1.65 1.69 1.71 1.70 1.68 1.67 1.64 1.58 1.51 1.47 1.46 1.47 1.49 1.53 2.29 2.32 2.34 2.34
Uber Technologies Inc. 11.25 10.70 10.26 9.73 9.03 8.68 7.65 6.50 5.39 4.95 4.25 3.57 3.61 3.75 3.97 4.16 4.25
United Parcel Service Inc. 2.20 2.32 2.42 2.53 2.61 2.73 2.71 2.66 2.63 2.60 2.55 2.52 2.40 2.28 2.25 2.21 2.22

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Operating revenuesQ1 2024 + Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023) ÷ Properties, net (including operating lease, right-of-use asset)
= (6,031 + 6,159 + 5,941 + 5,963) ÷ 59,043 = 0.41

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. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Total Asset Turnover

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

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Operating revenues 6,031 6,159 5,941 5,963 6,056 6,180 6,566 6,269 5,860 5,733 5,566 5,504 5,001 5,141 4,919 4,244 5,229 5,212 5,516 5,596 5,384
Total assets 67,266 67,132 66,540 66,033 65,968 65,449 65,343 64,440 64,051 63,525 62,360 62,073 61,793 62,398 63,714 63,555 62,216 61,673 61,978 61,708 61,319
Long-term Activity Ratio
Total asset turnover1 0.36 0.36 0.36 0.38 0.38 0.38 0.37 0.36 0.35 0.34 0.34 0.33 0.31 0.31 0.31 0.32 0.35 0.35
Benchmarks
Total Asset Turnover, Competitors2
FedEx Corp. 1.01 1.03 1.08 1.10 1.10 1.09 1.09 1.06 1.06 1.01 0.95 0.92 0.92 0.94 1.00 0.99 1.02 1.28 1.27 1.29 1.29
Uber Technologies Inc. 0.96 1.00 1.03 1.04 0.99 0.93 0.82 0.65 0.45 0.40 0.35 0.31 0.33 0.42 0.46 0.48 0.45
United Parcel Service Inc. 1.28 1.32 1.37 1.37 1.41 1.45 1.43 1.41 1.40 1.44 1.43 1.41 1.36 1.29 1.25 1.23 1.28

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Total asset turnover = (Operating revenuesQ1 2024 + Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023) ÷ Total assets
= (6,031 + 6,159 + 5,941 + 5,963) ÷ 67,266 = 0.36

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. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Equity Turnover

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

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Operating revenues 6,031 6,159 5,941 5,963 6,056 6,180 6,566 6,269 5,860 5,733 5,566 5,504 5,001 5,141 4,919 4,244 5,229 5,212 5,516 5,596 5,384
Common shareholders’ equity 15,665 14,788 14,004 13,194 12,454 12,163 11,743 12,710 11,897 14,161 13,917 14,303 16,254 16,958 17,199 16,452 15,991 18,128 18,016 18,171 17,742
Long-term Activity Ratio
Equity turnover1 1.54 1.63 1.72 1.88 2.01 2.05 2.08 1.84 1.90 1.54 1.52 1.44 1.19 1.15 1.14 1.23 1.35 1.20
Benchmarks
Equity Turnover, Competitors2
FedEx Corp. 3.34 3.46 3.74 3.90 3.77 3.75 3.74 3.59 3.56 3.47 3.58 3.55 3.67 3.78 3.70 3.71 3.84 3.92 3.48 3.56 3.51
Uber Technologies Inc. 3.31 3.84 4.04 4.51 4.34 4.65 3.84 2.40 1.21 1.07 0.90 0.79 0.91 1.35 1.37 1.26 1.00
United Parcel Service Inc. 5.26 4.86 4.80 4.93 5.07 5.96 6.15 6.41 6.83 7.84 8.56 12.52 128.81 14.36 17.74 22.72 22.68

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Equity turnover = (Operating revenuesQ1 2024 + Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023) ÷ Common shareholders’ equity
= (6,031 + 6,159 + 5,941 + 5,963) ÷ 15,665 = 1.54

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. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.