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

United Parcel Service Inc. (NYSE:UPS)

Analysis of Operating Leases

Advanced level

Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)

United Parcel Service Inc., future operating lease payments (before adoption of FASB Topic 842)

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Total undiscounted future operating lease payments 2,967  1,637  1,470 
Discount rate1 4.33% 7.43% 6.60%
 
Total present value of future operating lease payments 2,510  1,290  1,198 

Based on: 10-K (filing date: 2021-02-22), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-21), 10-K (filing date: 2017-02-21).

1 Weighted average discount rate, finance leases

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 4.33%
2019 578  2019 578  554 
2020 477  2020 477  438 
2021 399  2021 399  351 
2022 325  2022 325  274 
2023 262  2023 262  212 
2024 and thereafter 926  2024 262  203 
2025 262  195 
2026 262  187 
2027 140  96 
Total: 2,967  2,967  2,510 

Based on: 10-K (filing date: 2019-02-21).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 7.43%
2018 398  2018 398  370 
2019 305  2019 305  264 
2020 239  2020 239  193 
2021 186  2021 186  140 
2022 138  2022 138  96 
2023 and thereafter 371  2023 138  90 
2024 138  84 
2025 95  54 
Total: 1,637  1,637  1,290 

Based on: 10-K (filing date: 2018-02-21).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 6.60%
2017 368  2017 368  345 
2018 302  2018 302  266 
2019 221  2019 221  182 
2020 168  2020 168  130 
2021 111  2021 111  81 
2022 and thereafter 300  2022 111  76 
2023 111  71 
2024 78  47 
Total: 1,470  1,470  1,198 

Based on: 10-K (filing date: 2017-02-21).


Adjustments to Financial Statements for Operating Leases

United Parcel Service Inc., adjustments to financial statements

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Adjustment to Total Assets
Total assets (as reported) 62,408  57,857  50,016  45,403  40,377 
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 —  —  2,510  1,290  1,198 
Total assets (adjusted) 62,408  57,857  52,526  46,693  41,575 
Adjustment to Total Debt
Total debt (as reported) 24,654  25,238  22,736  24,289  16,075 
Add: Operating lease liability (before adoption of FASB Topic 842)2 —  —  2,510  1,290  1,198 
Add: Current maturities of operating leases 560  538  —  —  — 
Add: Non-current operating leases 2,540  2,391  —  —  — 
Total debt (adjusted) 27,754  28,167  25,246  25,579  17,273 

Based on: 10-K (filing date: 2021-02-22), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-21), 10-K (filing date: 2017-02-21).

1, 2 Equal to total present value of future operating lease payments.


United Parcel Service Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios for Operating Leases (Summary)

United Parcel Service Inc., adjusted financial ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Total Asset Turnover1
Reported total asset turnover 1.36 1.28 1.44 1.45 1.51
Adjusted total asset turnover 1.36 1.28 1.37 1.41 1.46
Debt to Equity2
Reported debt to equity 37.53 7.73 7.53 24.29 39.69
Adjusted debt to equity 42.24 8.62 8.36 25.58 42.65
Return on Assets3 (ROA)
Reported ROA 2.15% 7.67% 9.58% 10.81% 8.50%
Adjusted ROA 2.15% 7.67% 9.12% 10.52% 8.25%

Based on: 10-K (filing date: 2021-02-22), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-21), 10-K (filing date: 2017-02-21).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. United Parcel Service Inc.’s adjusted total asset turnover ratio deteriorated from 2018 to 2019 but then improved from 2019 to 2020 not reaching 2018 level.
Adjusted debt to equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. United Parcel Service Inc.’s adjusted debt to equity ratio deteriorated from 2018 to 2019 and from 2019 to 2020.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. United Parcel Service Inc.’s adjusted ROA deteriorated from 2018 to 2019 and from 2019 to 2020.

United Parcel Service Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Selected Financial Data (US$ in millions)
Revenue 84,628  74,094  71,861  65,872  60,906 
Total assets 62,408  57,857  50,016  45,403  40,377 
Activity Ratio
Total asset turnover1 1.36 1.28 1.44 1.45 1.51
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Revenue 84,628  74,094  71,861  65,872  60,906 
Adjusted total assets 62,408  57,857  52,526  46,693  41,575 
Activity Ratio
Adjusted total asset turnover2 1.36 1.28 1.37 1.41 1.46

Based on: 10-K (filing date: 2021-02-22), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-21), 10-K (filing date: 2017-02-21).

2020 Calculations

1 Total asset turnover = Revenue ÷ Total assets
= 84,628 ÷ 62,408 = 1.36

2 Adjusted total asset turnover = Revenue ÷ Adjusted total assets
= 84,628 ÷ 62,408 = 1.36

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. United Parcel Service Inc.’s adjusted total asset turnover ratio deteriorated from 2018 to 2019 but then improved from 2019 to 2020 not reaching 2018 level.

Adjusted Debt to Equity

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Selected Financial Data (US$ in millions)
Total debt 24,654  25,238  22,736  24,289  16,075 
Equity for controlling interests 657  3,267  3,021  1,000  405 
Solvency Ratio
Debt to equity1 37.53 7.73 7.53 24.29 39.69
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 27,754  28,167  25,246  25,579  17,273 
Equity for controlling interests 657  3,267  3,021  1,000  405 
Solvency Ratio
Adjusted debt to equity2 42.24 8.62 8.36 25.58 42.65

Based on: 10-K (filing date: 2021-02-22), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-21), 10-K (filing date: 2017-02-21).

2020 Calculations

1 Debt to equity = Total debt ÷ Equity for controlling interests
= 24,654 ÷ 657 = 37.53

2 Adjusted debt to equity = Adjusted total debt ÷ Equity for controlling interests
= 27,754 ÷ 657 = 42.24

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. United Parcel Service Inc.’s adjusted debt-to-equity ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Selected Financial Data (US$ in millions)
Net income 1,343  4,440  4,791  4,910  3,431 
Total assets 62,408  57,857  50,016  45,403  40,377 
Profitability Ratio
ROA1 2.15% 7.67% 9.58% 10.81% 8.50%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net income 1,343  4,440  4,791  4,910  3,431 
Adjusted total assets 62,408  57,857  52,526  46,693  41,575 
Profitability Ratio
Adjusted ROA2 2.15% 7.67% 9.12% 10.52% 8.25%

Based on: 10-K (filing date: 2021-02-22), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-21), 10-K (filing date: 2017-02-21).

2020 Calculations

1 ROA = 100 × Net income ÷ Total assets
= 100 × 1,343 ÷ 62,408 = 2.15%

2 Adjusted ROA = 100 × Net income ÷ Adjusted total assets
= 100 × 1,343 ÷ 62,408 = 2.15%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. United Parcel Service Inc.’s adjusted ROA deteriorated from 2018 to 2019 and from 2019 to 2020.