Stock Analysis on Net
Stock Analysis on Net

United Parcel Service Inc. (NYSE:UPS)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Beginner level

Short-term Activity Ratios (Summary)

United Parcel Service Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 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
Turnover Ratios
Receivables turnover 8.93 8.38 9.23 7.76 9.23 8.98 9.45 8.02 9.45 9.42 8.90 7.51 9.22 9.60 9.54 7.92 9.57 9.71 9.42 8.18
Payables turnover 3.66 3.73 4.02 3.44 4.61 4.57 5.06 3.84 5.26 4.90 4.98 4.24 5.51 5.63 5.99 4.54 5.84 5.45 6.33 5.00
Working capital turnover 17.95 19.57 21.16 43.84 54.39 59.92 42.42 33.85 40.05 29.08 27.39 23.19 86.10 47.96 702.31 28.74 30.56 18.77 20.90 23.23
Average No. Days
Average receivable collection period 41 44 40 47 40 41 39 45 39 39 41 49 40 38 38 46 38 38 39 45
Average payables payment period 100 98 91 106 79 80 72 95 69 75 73 86 66 65 61 80 63 67 58 73

Based on: 10-Q (filing date: 2020-11-02), 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-08), 10-K (filing date: 2020-02-20), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-30), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-05), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-07).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. United Parcel Service Inc.’s receivables turnover ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 not reaching Q1 2020 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. United Parcel Service Inc.’s payables turnover ratio decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Working capital turnover An activity ratio calculated as revenue divided by working capital. United Parcel Service Inc.’s working capital turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. United Parcel Service Inc.’s number of days of receivables outstanding deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 not reaching Q1 2020 level.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. United Parcel Service Inc.’s number of days of payables outstanding increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Receivables Turnover

United Parcel Service Inc., receivables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 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)
Revenue 21,238  20,459  18,035  20,568  18,318  18,048  17,160  19,848  17,444  17,456  17,113  18,829  15,978  15,750  15,315  16,931  14,928  14,629  14,418  16,054  14,237  14,095  13,977 
Accounts receivable, net 8,993  9,230  8,126  9,552  7,951  8,071  7,613  8,958  7,494  7,363  7,606  8,773  6,937  6,553  6,475  7,695  6,272  6,111  6,241  7,134  6,055  5,618  5,724 
Short-term Activity Ratio
Receivables turnover1 8.93 8.38 9.23 7.76 9.23 8.98 9.45 8.02 9.45 9.42 8.90 7.51 9.22 9.60 9.54 7.92 9.57 9.71 9.42 8.18
Benchmarks
Receivables Turnover, Competitors2
CSX Corp. 10.86 12.76 11.69 12.11 11.08 11.11 11.20 12.13 10.98 11.18 10.92 11.76 11.81 11.38 12.00 11.80 11.69 12.11 12.43 12.03
FedEx Corp. 7.47 7.13 7.48 7.65 7.66 7.18 7.71 7.72 7.37 7.20 7.61 7.94 7.76 7.29 7.29 6.94 8.79 8.28 8.55 8.30
Norfolk Southern Corp. 11.22 12.46 12.46 12.28 11.82 11.17 11.05 11.36 10.77 10.58 10.99 11.05 10.66 11.04 10.06 10.46 10.33 10.26 10.78 11.11
Union Pacific Corp. 12.53 14.55 12.91 13.61 13.49 12.53 13.60 13.01 12.57 13.47 13.74 14.23 14.68 15.27 15.83 15.85 14.79 14.84 15.52 16.09

Based on: 10-Q (filing date: 2020-11-02), 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-08), 10-K (filing date: 2020-02-20), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-30), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-05), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-07).

1 Q3 2020 Calculation
Receivables turnover = (RevenueQ3 2020 + RevenueQ2 2020 + RevenueQ1 2020 + RevenueQ4 2019) ÷ Accounts receivable, net
= (21,238 + 20,459 + 18,035 + 20,568) ÷ 8,993 = 8.93

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. United Parcel Service Inc.’s receivables turnover ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 not reaching Q1 2020 level.

Payables Turnover

United Parcel Service Inc., payables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 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)
Cost of revenue 5,507  5,124  4,638  5,277  4,639  4,652  4,541  5,594  4,841  4,805  4,690  5,075  3,968  3,715  3,676  4,124  3,387  3,203  3,108  3,656  3,146  3,003  3,142 
Accounts payable 5,609  5,271  4,779  5,555  4,218  4,291  3,907  5,188  3,689  3,785  3,501  3,872  2,808  2,648  2,404  3,042  2,287  2,405  2,040  2,587  2,058  2,150  2,055 
Short-term Activity Ratio
Payables turnover1 3.66 3.73 4.02 3.44 4.61 4.57 5.06 3.84 5.26 4.90 4.98 4.24 5.51 5.63 5.99 4.54 5.84 5.45 6.33 5.00
Benchmarks
Payables Turnover, Competitors2
CSX Corp. 2.20 2.54 2.48 2.58 2.57 2.97 2.93 3.17 3.05 3.49 3.23 3.51 3.22 3.55 3.20 3.45 3.31 3.87 3.80 4.31
FedEx Corp. 8.50 8.15 8.43 8.82 8.40 7.69 8.26 8.22 7.66 7.33 7.62 8.00 7.63 6.57 6.42 5.89 8.43 7.90 8.24 8.22
Norfolk Southern Corp. 1.84 1.88 2.02 1.88 1.93 1.99 2.12 1.87 1.87 1.85 1.92 1.61 1.82 1.91 1.91 1.85 2.02 2.20 2.26 2.46

Based on: 10-Q (filing date: 2020-11-02), 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-08), 10-K (filing date: 2020-02-20), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-30), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-05), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-07).

1 Q3 2020 Calculation
Payables turnover = (Cost of revenueQ3 2020 + Cost of revenueQ2 2020 + Cost of revenueQ1 2020 + Cost of revenueQ4 2019) ÷ Accounts payable
= (5,507 + 5,124 + 4,638 + 5,277) ÷ 5,609 = 3.66

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. United Parcel Service Inc.’s payables turnover ratio decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Working Capital Turnover

United Parcel Service Inc., working capital turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 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)
Current assets 19,930  20,226  19,389  17,103  14,184  14,843  14,904  16,210  13,991  13,874  13,620  15,548  12,910  12,394  11,494  13,849  12,853  13,123  13,912  13,208  13,581  13,768  13,915 
Less: Current liabilities 15,456  16,271  15,846  15,413  12,835  13,633  13,209  14,087  12,222  11,488  11,149  12,708  12,167  11,082  11,406  11,730  10,889  9,961  11,098  10,696  11,869  10,303  10,610 
Working capital 4,474  3,955  3,543  1,690  1,349  1,210  1,695  2,123  1,769  2,386  2,471  2,840  743  1,312  88  2,119  1,964  3,162  2,814  2,512  1,712  3,465  3,305 
 
Revenue 21,238  20,459  18,035  20,568  18,318  18,048  17,160  19,848  17,444  17,456  17,113  18,829  15,978  15,750  15,315  16,931  14,928  14,629  14,418  16,054  14,237  14,095  13,977 
Short-term Activity Ratio
Working capital turnover1 17.95 19.57 21.16 43.84 54.39 59.92 42.42 33.85 40.05 29.08 27.39 23.19 86.10 47.96 702.31 28.74 30.56 18.77 20.90 23.23
Benchmarks
Working Capital Turnover, Competitors2
CSX Corp. 5.50 7.60 7.32 10.59 10.56 10.90 7.98 18.85 14.25 10.08 6.91 543.24 119.40 12.06 29.56 24.76 12.45 11.65
FedEx Corp. 31.44 26.10 22.61 17.11 16.31 17.43 22.14 17.62 15.68 13.39 12.36 12.81 12.83 13.01 13.43 12.65 11.52 9.34 9.89 9.52
Norfolk Southern Corp. 17.26 24.68 117.51 116.66 76.55 76.77 26.15
Union Pacific Corp. 67.83 78.48 180.37 317.01 33.91 44.76 14.86 13.85 11.71 23.61

Based on: 10-Q (filing date: 2020-11-02), 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-08), 10-K (filing date: 2020-02-20), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-30), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-05), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-07).

1 Q3 2020 Calculation
Working capital turnover = (RevenueQ3 2020 + RevenueQ2 2020 + RevenueQ1 2020 + RevenueQ4 2019) ÷ Working capital
= (21,238 + 20,459 + 18,035 + 20,568) ÷ 4,474 = 17.95

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. United Parcel Service Inc.’s working capital turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Average Receivable Collection Period

United Parcel Service Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 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
Receivables turnover 8.93 8.38 9.23 7.76 9.23 8.98 9.45 8.02 9.45 9.42 8.90 7.51 9.22 9.60 9.54 7.92 9.57 9.71 9.42 8.18
Short-term Activity Ratio (no. days)
Average receivable collection period1 41 44 40 47 40 41 39 45 39 39 41 49 40 38 38 46 38 38 39 45
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
CSX Corp. 34 29 31 30 33 33 33 30 33 33 33 31 31 32 30 31 31 30 29 30
FedEx Corp. 49 51 49 48 48 51 47 47 50 51 48 46 47 50 50 53 42 44 43 44
Norfolk Southern Corp. 33 29 29 30 31 33 33 32 34 34 33 33 34 33 36 35 35 36 34 33
Union Pacific Corp. 29 25 28 27 27 29 27 28 29 27 27 26 25 24 23 23 25 25 24 23

Based on: 10-Q (filing date: 2020-11-02), 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-08), 10-K (filing date: 2020-02-20), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-30), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-05), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-07).

1 Q3 2020 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 8.93 = 41

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. United Parcel Service Inc.’s number of days of receivables outstanding deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 not reaching Q1 2020 level.

Average Payables Payment Period

United Parcel Service Inc., average payables payment period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 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
Payables turnover 3.66 3.73 4.02 3.44 4.61 4.57 5.06 3.84 5.26 4.90 4.98 4.24 5.51 5.63 5.99 4.54 5.84 5.45 6.33 5.00
Short-term Activity Ratio (no. days)
Average payables payment period1 100 98 91 106 79 80 72 95 69 75 73 86 66 65 61 80 63 67 58 73
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
CSX Corp. 166 144 147 142 142 123 125 115 120 105 113 104 113 103 114 106 110 94 96 85
FedEx Corp. 43 45 43 41 43 47 44 44 48 50 48 46 48 56 57 62 43 46 44 44
Norfolk Southern Corp. 198 194 181 195 189 184 172 195 196 197 191 227 201 191 192 197 181 166 162 148

Based on: 10-Q (filing date: 2020-11-02), 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-08), 10-K (filing date: 2020-02-20), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-30), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-05), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-07).

1 Q3 2020 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.66 = 100

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. United Parcel Service Inc.’s number of days of payables outstanding increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.