Analysis of Operating Leases
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.
Paying users area
Try for free
Walmart Inc. pages available for free this week:
- Balance Sheet: Assets
- Analysis of Long-term (Investment) Activity Ratios
- Price to FCFE (P/FCFE)
- Present Value of Free Cash Flow to Equity (FCFE)
- Total Asset Turnover since 2005
- Debt to Equity since 2005
- Price to Earnings (P/E) since 2005
- Price to Book Value (P/BV) since 2005
- Analysis of Property, Plant and Equipment
- Analysis of Goodwill and Intangible Assets
The data is hidden behind: . Unhide it.
Get 1-month access to Walmart Inc. for $19.99, or
get full access to the entire website for at least 3 months from $49.99.
This is a one-time payment. There is no automatic renewal.
We accept:
Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)
Walmart Inc., future operating lease payments (before adoption of FASB Topic 842)
US$ in millions
| Jan 31, 2021 | Jan 31, 2020 | Jan 31, 2019 | Jan 31, 2018 | Jan 31, 2017 | Jan 31, 2016 | ||
|---|---|---|---|---|---|---|---|
| Total undiscounted future operating lease payments | |||||||
| Discount rate1 | |||||||
| Total present value of future operating lease payments | |||||||
Based on: 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31), 10-K (reporting date: 2016-01-31).
1 Weighted-average discount rate, finance leases
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 | 2022 | |||
| 2023 | 2023 | |||
| 2024 | 2024 | |||
| 2025 and thereafter | 2025 | |||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| 2031 | ||||
| Total: |
Based on: 10-K (reporting date: 2019-01-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 | 2022 | |||
| 2023 | 2023 | |||
| 2024 and thereafter | 2024 | |||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2018-01-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2018 | 2018 | |||
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 | 2022 | |||
| 2023 and thereafter | 2023 | |||
| 2024 | ||||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2017-01-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2017 | 2017 | |||
| 2018 | 2018 | |||
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 and thereafter | 2022 | |||
| 2023 | ||||
| 2024 | ||||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2016-01-31).
Adjustments to Financial Statements for Operating Leases
Walmart Inc., adjustments to financial statements
US$ in millions
Based on: 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31), 10-K (reporting date: 2016-01-31).
1, 2 Equal to total present value of future operating lease payments.
Walmart Inc., Financial Data: Reported vs. Adjusted
Adjusted Financial Ratios for Operating Leases (Summary)
Walmart Inc., adjusted financial ratios
Based on: 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31), 10-K (reporting date: 2016-01-31).
| Financial ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Walmart Inc. adjusted total asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021. |
| Adjusted debt to equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Walmart Inc. adjusted debt to equity ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level. |
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Walmart Inc. adjusted ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021. |
Walmart Inc., Financial Ratios: Reported vs. Adjusted
Adjusted Total Asset Turnover
Based on: 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31), 10-K (reporting date: 2016-01-31).
2021 Calculations
1 Total asset turnover = Net sales ÷ Total assets
= ÷ =
2 Adjusted total asset turnover = Net sales ÷ Adjusted total assets
= ÷ =
| Activity ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Walmart Inc. adjusted total asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021. |
Adjusted Debt to Equity
Based on: 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31), 10-K (reporting date: 2016-01-31).
2021 Calculations
1 Debt to equity = Total debt ÷ Total Walmart shareholders’ equity
= ÷ =
2 Adjusted debt to equity = Adjusted total debt ÷ Total Walmart shareholders’ equity
= ÷ =
| Solvency ratio | Description | The company |
|---|---|---|
| Adjusted debt-to-equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Walmart Inc. adjusted debt-to-equity ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level. |
Adjusted Return on Assets (ROA)
Based on: 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31), 10-K (reporting date: 2016-01-31).
2021 Calculations
1 ROA = 100 × Consolidated net income attributable to Walmart ÷ Total assets
= 100 × ÷ =
2 Adjusted ROA = 100 × Consolidated net income attributable to Walmart ÷ Adjusted total assets
= 100 × ÷ =
| Profitability ratio | Description | The company |
|---|---|---|
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Walmart Inc. adjusted ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021. |