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

Honeywell International Inc. (NYSE:HON)

Analysis of Operating Leases

Advanced level

An operating lease is treated like a rental contract. Neither the leased asset nor the associated liability is reported on the lessee balance sheet, but the rights may be very similar to the rights of an owner. The lessee only records the lease payments as a rental expense in income statement.


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

Honeywell International 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 856  1,126  1,123 
Discount rate1 2.62% 2.48% 2.98%
 
Total present value of future operating lease payments 789  1,040  1,017 

Based on: 10-K (filing date: 2021-02-12), 10-K (filing date: 2020-02-14), 10-K (filing date: 2019-02-08), 10-K (filing date: 2018-02-09), 10-K (filing date: 2017-02-10).

1 Weighted-average interest rate for Honeywell International Inc.’s debt

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 2.62%
2019 210  2019 210  205 
2020 168  2020 168  160 
2021 142  2021 142  131 
2022 109  2022 109  98 
2023 80  2023 80  70 
2024 and thereafter 147  2024 80  69 
2025 67  56 
Total: 856  856  789 

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 2.48%
2018 295  2018 295  288 
2019 226  2019 226  215 
2020 161  2020 161  150 
2021 121  2021 121  110 
2022 97  2022 97  86 
2023 and thereafter 226  2023 97  84 
2024 97  82 
2025 32  26 
Total: 1,126  1,126  1,040 

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 2.98%
2017 289  2017 289  281 
2018 216  2018 216  204 
2019 158  2019 158  145 
2020 110  2020 110  98 
2021 94  2021 94  81 
2022 and thereafter 256  2022 94  79 
2023 94  77 
2024 68  54 
Total: 1,123  1,123  1,017 

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


Adjustments to Financial Statements for Operating Leases

Honeywell International 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) 64,586  58,679  57,773  59,387  54,146 
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 —  —  789  1,040  1,017 
Total assets (adjusted) 64,586  58,679  58,562  60,427  55,163 
Adjustment to Total Debt
Total debt (as reported) 22,384  16,002  16,214  17,882  15,775 
Add: Operating lease liability (before adoption of FASB Topic 842)2 —  —  789  1,040  1,017 
Add: Current operating lease liabilities 187  171  —  —  — 
Add: Non-current operating lease liabilities 641  534  —  —  — 
Total debt (adjusted) 23,212  16,707  17,003  18,922  16,792 

Based on: 10-K (filing date: 2021-02-12), 10-K (filing date: 2020-02-14), 10-K (filing date: 2019-02-08), 10-K (filing date: 2018-02-09), 10-K (filing date: 2017-02-10).

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


Honeywell International Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios for Operating Leases (Summary)

Honeywell International 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 0.51 0.63 0.72 0.68 0.73
Adjusted total asset turnover 0.51 0.63 0.71 0.67 0.71
Debt to Equity2
Reported debt to equity 1.28 0.87 0.89 1.04 0.81
Adjusted debt to equity 1.32 0.90 0.94 1.10 0.87
Return on Assets3 (ROA)
Reported ROA 7.40% 10.47% 11.71% 2.79% 8.88%
Adjusted ROA 7.40% 10.47% 11.55% 2.74% 8.72%

Based on: 10-K (filing date: 2021-02-12), 10-K (filing date: 2020-02-14), 10-K (filing date: 2019-02-08), 10-K (filing date: 2018-02-09), 10-K (filing date: 2017-02-10).

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

Honeywell International 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)
Net sales 32,637  36,709  41,802  40,534  39,302 
Total assets 64,586  58,679  57,773  59,387  54,146 
Activity Ratio
Total asset turnover1 0.51 0.63 0.72 0.68 0.73
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net sales 32,637  36,709  41,802  40,534  39,302 
Adjusted total assets 64,586  58,679  58,562  60,427  55,163 
Activity Ratio
Adjusted total asset turnover2 0.51 0.63 0.71 0.67 0.71

Based on: 10-K (filing date: 2021-02-12), 10-K (filing date: 2020-02-14), 10-K (filing date: 2019-02-08), 10-K (filing date: 2018-02-09), 10-K (filing date: 2017-02-10).

2020 Calculations

1 Total asset turnover = Net sales ÷ Total assets
= 32,637 ÷ 64,586 = 0.51

2 Adjusted total asset turnover = Net sales ÷ Adjusted total assets
= 32,637 ÷ 64,586 = 0.51

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Honeywell International Inc.’s adjusted total asset turnover ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

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 22,384  16,002  16,214  17,882  15,775 
Total Honeywell shareowners’ equity 17,549  18,494  18,180  17,276  19,369 
Solvency Ratio
Debt to equity1 1.28 0.87 0.89 1.04 0.81
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 23,212  16,707  17,003  18,922  16,792 
Total Honeywell shareowners’ equity 17,549  18,494  18,180  17,276  19,369 
Solvency Ratio
Adjusted debt to equity2 1.32 0.90 0.94 1.10 0.87

Based on: 10-K (filing date: 2021-02-12), 10-K (filing date: 2020-02-14), 10-K (filing date: 2019-02-08), 10-K (filing date: 2018-02-09), 10-K (filing date: 2017-02-10).

2020 Calculations

1 Debt to equity = Total debt ÷ Total Honeywell shareowners’ equity
= 22,384 ÷ 17,549 = 1.28

2 Adjusted debt to equity = Adjusted total debt ÷ Total Honeywell shareowners’ equity
= 23,212 ÷ 17,549 = 1.32

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Honeywell International Inc.’s adjusted debt-to-equity ratio improved from 2018 to 2019 but then deteriorated significantly 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 attributable to Honeywell 4,779  6,143  6,765  1,655  4,809 
Total assets 64,586  58,679  57,773  59,387  54,146 
Profitability Ratio
ROA1 7.40% 10.47% 11.71% 2.79% 8.88%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net income attributable to Honeywell 4,779  6,143  6,765  1,655  4,809 
Adjusted total assets 64,586  58,679  58,562  60,427  55,163 
Profitability Ratio
Adjusted ROA2 7.40% 10.47% 11.55% 2.74% 8.72%

Based on: 10-K (filing date: 2021-02-12), 10-K (filing date: 2020-02-14), 10-K (filing date: 2019-02-08), 10-K (filing date: 2018-02-09), 10-K (filing date: 2017-02-10).

2020 Calculations

1 ROA = 100 × Net income attributable to Honeywell ÷ Total assets
= 100 × 4,779 ÷ 64,586 = 7.40%

2 Adjusted ROA = 100 × Net income attributable to Honeywell ÷ Adjusted total assets
= 100 × 4,779 ÷ 64,586 = 7.40%

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