Walmart Inc. (WMT)

Goodwill represents the excess of the purchase price over the fair value of net assets acquired in business combinations and is allocated to the appropriate reporting unit when acquired. Other acquired intangible assets are stated at the fair value acquired as determined by a valuation technique commensurate with the intended use of the related asset. Goodwill and indefinite-lived intangible assets are not amortized; rather, they are evaluated for impairment annually and whenever events or changes in circumstances indicate that the value of the asset may be impaired. Definite-lived intangible assets are considered long-lived assets and are amortized on a straight-line basis over the periods that expected economic benefits will be provided.

Goodwill is evaluated for impairment using either a qualitative or quantitative approach for each of Walmart’s reporting units. Generally, a qualitative assessment is first performed to determine whether a quantitative goodwill impairment test is necessary. If management determines, after performing an assessment based on the qualitative factors, that the fair value of the reporting unit is more likely than not less than the carrying amount, or that a fair value of the reporting unit substantially in excess of the carrying amount cannot be assured, then a quantitative goodwill impairment test would be required. The quantitative test for goodwill impairment is performed by determining the fair value of the related reporting units. Fair value is measured based on the discounted cash flow method and relative market-based approaches. After evaluation, management determined the fair value of each reporting unit is greater than the carrying amount and, accordingly, Walmart has not recorded any impairment charges related to goodwill.

Indefinite-lived intangible assets are included in other assets and deferred charges in Walmart’s Consolidated Balance Sheets. These assets are evaluated for impairment based on their fair values using valuation techniques which are updated annually based on the most recent variables and assumptions. There were no significant impairment charges related to indefinite-lived intangible assets recorded for fiscal 2018, 2017 and 2016.

Source: 10-K (filing date: 2018-03-30).

Walmart Inc., adjustments to financial data

USD $ in millions

		Jan 31, 2018	Jan 31, 2017	Jan 31, 2016	Jan 31, 2015	Jan 31, 2014	Jan 31, 2013
	Adjustment to Total Assets
	Total assets (as reported)
	Less: Goodwill
	Total assets (adjusted)
	Adjustment to Total Walmart Shareholders’ Equity
	Total Walmart shareholders’ equity (as reported)
	Less: Goodwill
	Total Walmart shareholders’ equity (adjusted)

Based on: 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26).

Walmart Inc., Financial Data: Reported vs. Adjusted

Walmart Inc., adjusted ratios

		Jan 31, 2018	Jan 31, 2017	Jan 31, 2016	Jan 31, 2015	Jan 31, 2014	Jan 31, 2013
	Total Asset Turnover
	Reported total asset turnover
	Adjusted total asset turnover
	Financial Leverage
	Reported financial leverage
	Adjusted financial leverage
	Return on Equity (ROE)
	Reported ROE
	Adjusted ROE
	Return on Assets (ROA)
	Reported ROA
	Adjusted ROA

Based on: 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26).

Walmart Inc., Ratios: Reported vs. Adjusted

		Jan 31, 2018	Jan 31, 2017	Jan 31, 2016	Jan 31, 2015	Jan 31, 2014	Jan 31, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Net sales
	Total assets
	Ratio
	Total asset turnover1
	Adjusted for Goodwill
	Selected Financial Data (USD $ in millions)
	Net sales
	Adjusted total assets
	Ratio
	Adjusted total asset turnover2

Based on: 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26).

2018 Calculations

		Jan 31, 2018	Jan 31, 2017	Jan 31, 2016	Jan 31, 2015	Jan 31, 2014	Jan 31, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Total assets
	Total Walmart shareholders’ equity
	Ratio
	Financial leverage1
	Adjusted for Goodwill
	Selected Financial Data (USD $ in millions)
	Adjusted total assets
	Adjusted total Walmart shareholders’ equity
	Ratio
	Adjusted financial leverage2

Based on: 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26).

2018 Calculations

		Jan 31, 2018	Jan 31, 2017	Jan 31, 2016	Jan 31, 2015	Jan 31, 2014	Jan 31, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Consolidated net income attributable to Walmart
	Total Walmart shareholders’ equity
	Ratio
	ROE1
	Adjusted for Goodwill
	Selected Financial Data (USD $ in millions)
	Consolidated net income attributable to Walmart
	Adjusted total Walmart shareholders’ equity
	Ratio
	Adjusted ROE2

Based on: 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26).

2018 Calculations

		Jan 31, 2018	Jan 31, 2017	Jan 31, 2016	Jan 31, 2015	Jan 31, 2014	Jan 31, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Consolidated net income attributable to Walmart
	Total assets
	Ratio
	ROA1
	Adjusted for Goodwill
	Selected Financial Data (USD $ in millions)
	Consolidated net income attributable to Walmart
	Adjusted total assets
	Ratio
	Adjusted ROA2

Based on: 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26).

2018 Calculations