Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Walgreens Boots Alliance Inc. for $13.99, or

  • get full access to the entire website for at least 3 months from $49.99.

We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey
Unlock

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

Analysis of Goodwill and Intangible Assets

Advanced level

Accounting Policy on Goodwill and Intangible Assets

Goodwill represents the excess of the purchase price over the fair value of assets acquired and liabilities assumed in business combinations. Acquired intangible assets are recorded at fair value.

Goodwill and indefinite-lived intangible assets are evaluated for impairment annually during the fourth quarter, or more frequently if an event occurs or circumstances change that could more likely than not reduce the fair value of a reporting unit or intangible asset below its carrying value. As part of Walgreens Boots Alliance’s impairment analysis, fair value of a reporting unit is determined using both the income and market approaches. The income approach requires management to estimate a number of factors for each reporting unit, including projected future operating results, economic projections, anticipated future cash flows and discount rates. The market approach estimates fair value using comparable marketplace fair value data from within a comparable industry grouping.

Finite-lived intangible assets are amortized on a straight-line basis over their estimated useful lives.

Source: 10-K (filing date: 2019-10-28).

Goodwill and Intangible Asset Disclosure

Walgreens Boots Alliance Inc., balance sheet: goodwill and intangible assets

US$ in millions

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Customer relationships and loyalty card holders
Favorable lease interests and non-compete agreements
Trade names and trademarks
Purchasing and payer contracts
Other amortizable intangible assets
Gross amortizable intangible assets
Accumulated amortization
Amortizable intangible assets, net
Trade names and trademarks
Pharmacy licenses
Indefinite-lived intangible assets
Intangible assets, net
Goodwill
Goodwill and other intangible assets

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

Item Description The company
Intangible assets, net Sum of the carrying amounts of all intangible assets, excluding goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Walgreens Boots Alliance Inc.’s intangible assets, net increased from 2017 to 2018 but then slightly decreased from 2018 to 2019 not reaching 2017 level.
Goodwill Amount after accumulated impairment loss of an asset representing future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognized. Walgreens Boots Alliance Inc.’s goodwill increased from 2017 to 2018 but then slightly decreased from 2018 to 2019.
Goodwill and other intangible assets Sum of the carrying amounts of all intangible assets, including goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Walgreens Boots Alliance Inc.’s goodwill and other intangible assets increased from 2017 to 2018 but then slightly decreased from 2018 to 2019.

Adjustments to Financial Statements: Removal of Goodwill

Walgreens Boots Alliance Inc., adjustments to financial statements

US$ in millions

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Adjustment to Total Assets
Total assets (as reported)
Less: Goodwill
Total assets (adjusted)
Adjustment to Total Walgreens Boots Alliance, Inc. Shareholders’ Equity
Total Walgreens Boots Alliance, Inc. shareholders’ equity (as reported)
Less: Goodwill
Total Walgreens Boots Alliance, Inc. shareholders’ equity (adjusted)

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

Walgreens Boots Alliance Inc., Financial Data: Reported vs. Adjusted

Adjusted Financial Ratios: Removal of Goodwill (Summary)

Walgreens Boots Alliance Inc., adjusted financial ratios

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
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: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Walgreens Boots Alliance Inc.’s adjusted total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.		 Walgreens Boots Alliance Inc.’s adjusted financial leverage ratio increased from 2017 to 2018 and from 2018 to 2019.
Adjusted ROE A profitability ratio calculated as net income divided by adjusted shareholders’ equity. Walgreens Boots Alliance Inc.’s adjusted ROE improved from 2017 to 2018 and from 2018 to 2019.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Walgreens Boots Alliance Inc.’s adjusted ROA improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Walgreens Boots Alliance Inc., Financial Ratios: Reported vs. Adjusted

Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Sales
Total assets
Activity Ratio
Total asset turnover1
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Sales
Adjusted total assets
Activity Ratio
Adjusted total asset turnover2

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

2019 Calculations

1 Total asset turnover = Sales ÷ Total assets
= ÷ =

2 Adjusted total asset turnover = 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. Walgreens Boots Alliance Inc.’s adjusted total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.

Adjusted Financial Leverage

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Total assets
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Solvency Ratio
Financial leverage1
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted total assets
Adjusted total Walgreens Boots Alliance, Inc. shareholders’ equity
Solvency Ratio
Adjusted financial leverage2

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

2019 Calculations

1 Financial leverage = Total assets ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =

Solvency ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.		 Walgreens Boots Alliance Inc.’s adjusted financial leverage ratio increased from 2017 to 2018 and from 2018 to 2019.

Adjusted Return on Equity (ROE)

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Net earnings attributable to Walgreens Boots Alliance, Inc.
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Profitability Ratio
ROE1
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net earnings attributable to Walgreens Boots Alliance, Inc.
Adjusted total Walgreens Boots Alliance, Inc. shareholders’ equity
Profitability Ratio
Adjusted ROE2

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

2019 Calculations

1 ROE = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= 100 × ÷ =

2 Adjusted ROE = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Adjusted total Walgreens Boots Alliance, Inc. shareholders’ equity
= 100 × ÷ =

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as net income divided by adjusted shareholders’ equity. Walgreens Boots Alliance Inc.’s adjusted ROE improved from 2017 to 2018 and from 2018 to 2019.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Net earnings attributable to Walgreens Boots Alliance, Inc.
Total assets
Profitability Ratio
ROA1
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net earnings attributable to Walgreens Boots Alliance, Inc.
Adjusted total assets
Profitability Ratio
Adjusted ROA2

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

2019 Calculations

1 ROA = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Total assets
= 100 × ÷ =

2 Adjusted ROA = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Adjusted total assets
= 100 × ÷ =

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Walgreens Boots Alliance Inc.’s adjusted ROA improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.