Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Operating Leases

Microsoft Excel

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.


Adjustments to Financial Statements for Operating Leases

Walmart Inc., adjustments to financial statements

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Adjustment to Total Assets
Total assets (as reported) 252,399 243,197 244,860 252,496 236,495 219,295
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 8,533
Total assets (adjusted) 252,399 243,197 244,860 252,496 236,495 227,828
Adjustment to Total Debt
Total debt (as reported) 46,891 44,622 42,831 48,871 54,469 58,033
Add: Operating lease liability (before adoption of FASB Topic 842)2 8,533
Add: Operating lease obligations due within one year 1,487 1,473 1,483 1,466 1,793
Add: Long-term operating lease obligations, excluding due within one year 12,943 12,828 13,009 12,909 16,171
Total debt (adjusted) 61,321 58,923 57,323 63,246 72,433 66,566

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-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

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Total Asset Turnover1
Reported total asset turnover 2.55 2.49 2.32 2.20 2.20 2.33
Adjusted total asset turnover 2.55 2.49 2.32 2.20 2.20 2.24
Debt to Equity2
Reported debt to equity 0.56 0.58 0.51 0.60 0.73 0.80
Adjusted debt to equity 0.73 0.77 0.69 0.78 0.97 0.92
Return on Assets3 (ROA)
Reported ROA 6.15% 4.80% 5.58% 5.35% 6.29% 3.04%
Adjusted ROA 6.15% 4.80% 5.58% 5.35% 6.29% 2.93%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-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 improved from 2022 to 2023 and from 2023 to 2024.
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 2022 to 2023 but then slightly improved from 2023 to 2024.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Walmart Inc. adjusted ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Walmart Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Total assets 252,399 243,197 244,860 252,496 236,495 219,295
Activity Ratio
Total asset turnover1 2.55 2.49 2.32 2.20 2.20 2.33
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Adjusted total assets 252,399 243,197 244,860 252,496 236,495 227,828
Activity Ratio
Adjusted total asset turnover2 2.55 2.49 2.32 2.20 2.20 2.24

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

2024 Calculations

1 Total asset turnover = Net sales ÷ Total assets
= 642,637 ÷ 252,399 = 2.55

2 Adjusted total asset turnover = Net sales ÷ Adjusted total assets
= 642,637 ÷ 252,399 = 2.55

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 improved from 2022 to 2023 and from 2023 to 2024.

Adjusted Debt to Equity

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Total debt 46,891 44,622 42,831 48,871 54,469 58,033
Total Walmart shareholders’ equity 83,861 76,693 83,253 80,925 74,669 72,496
Solvency Ratio
Debt to equity1 0.56 0.58 0.51 0.60 0.73 0.80
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 61,321 58,923 57,323 63,246 72,433 66,566
Total Walmart shareholders’ equity 83,861 76,693 83,253 80,925 74,669 72,496
Solvency Ratio
Adjusted debt to equity2 0.73 0.77 0.69 0.78 0.97 0.92

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

2024 Calculations

1 Debt to equity = Total debt ÷ Total Walmart shareholders’ equity
= 46,891 ÷ 83,861 = 0.56

2 Adjusted debt to equity = Adjusted total debt ÷ Total Walmart shareholders’ equity
= 61,321 ÷ 83,861 = 0.73

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 2022 to 2023 but then slightly improved from 2023 to 2024.

Adjusted Return on Assets (ROA)

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Total assets 252,399 243,197 244,860 252,496 236,495 219,295
Profitability Ratio
ROA1 6.15% 4.80% 5.58% 5.35% 6.29% 3.04%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Adjusted total assets 252,399 243,197 244,860 252,496 236,495 227,828
Profitability Ratio
Adjusted ROA2 6.15% 4.80% 5.58% 5.35% 6.29% 2.93%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

2024 Calculations

1 ROA = 100 × Consolidated net income attributable to Walmart ÷ Total assets
= 100 × 15,511 ÷ 252,399 = 6.15%

2 Adjusted ROA = 100 × Consolidated net income attributable to Walmart ÷ Adjusted total assets
= 100 × 15,511 ÷ 252,399 = 6.15%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Walmart Inc. adjusted ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.