Stock Analysis on Net

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

$22.49

This company has been moved to the archive! The financial data has not been updated since July 9, 2020.

Economic Value Added (EVA)

Microsoft Excel

EVA is registered trademark of Stern Stewart.

Economic value added or economic profit is the difference between revenues and costs,where costs include not only expenses, but also cost of capital.

Paying user area

The data is hidden behind: . Unhide it.

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


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Economic Profit

Walgreens Boots Alliance Inc., economic profit calculation

US$ in millions

Microsoft Excel
12 months ended: Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Net operating profit after taxes (NOPAT)1
Cost of capital2
Invested capital3
 
Economic profit4

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 NOPAT. See details »

2 Cost of capital. See details »

3 Invested capital. See details »

4 2019 Calculation
Economic profit = NOPAT – Cost of capital × Invested capital
= × =


The period under review demonstrates a consistent pattern of negative economic profit. While net operating profit after taxes (NOPAT) fluctuates, it does not generate sufficient returns to cover the cost of invested capital, resulting in economic losses each year.

NOPAT Trend
Net operating profit after taxes increased significantly from 2014 to 2015, rising from US$3,086 million to US$5,501 million. Subsequent years show more moderate fluctuations, with a decrease in 2016 to US$4,855 million, a slight increase in 2017 to US$5,246 million, a further increase to US$5,934 million in 2018, and a minor decline to US$5,719 million in 2019. Despite these variations, NOPAT remains positive throughout the analyzed period.
Cost of Capital Trend
The cost of capital initially increased from 11.24% in 2014 to 11.71% in 2015. It then experienced a slight decrease to 11.37% in 2016, followed by a further reduction to 11.30% in 2017 and 11.18% in 2018. A notable decrease occurred in 2019, with the cost of capital falling to 9.98%. This suggests improving capital market conditions or changes in the company’s risk profile.
Invested Capital Trend
Invested capital increased substantially from US$55,001 million in 2014 to US$80,730 million in 2015. It continued to rise to US$85,356 million in 2016 before decreasing to US$76,485 million in 2017. Invested capital remained relatively stable in 2018 at US$76,286 million and experienced a slight increase to US$77,429 million in 2019. The large initial increase in invested capital likely reflects significant strategic investments.
Economic Profit Trend
Economic profit consistently remained negative throughout the period. The magnitude of the loss decreased over time, moving from -US$3,095 million in 2014 to -US$2,011 million in 2019. This reduction in economic loss coincides with the decrease in the cost of capital, partially offsetting the consistently high level of invested capital. Despite the improvement, the company failed to generate returns exceeding its cost of capital in any of the analyzed years.

The decreasing trend in economic loss suggests some improvement in value creation, but the continued negative economic profit indicates that the company’s investments are not yet generating sufficient returns to satisfy investor expectations. The reduction in the cost of capital in 2019 contributed to a smaller economic loss, but sustained positive economic profit will require either increased NOPAT or more efficient capital utilization.


Net Operating Profit after Taxes (NOPAT)

Walgreens Boots Alliance Inc., NOPAT calculation

US$ in millions

Microsoft Excel
12 months ended: Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Net earnings attributable to Walgreens Boots Alliance, Inc.
Deferred income tax expense (benefit)1
Increase (decrease) in allowance for doubtful accounts2
Increase (decrease) in LIFO reserve3
Increase (decrease) in liabilities related to the exit and disposal activities4
Increase (decrease) in equity equivalents5
Interest expense, net
Interest expense, operating lease liability6
Adjusted interest expense, net
Tax benefit of interest expense, net7
Adjusted interest expense, net, after taxes8
(Gain) loss on marketable securities
Investment income, before taxes
Tax expense (benefit) of investment income9
Investment income, after taxes10
Net income (loss) attributable to noncontrolling interest
Net operating profit after taxes (NOPAT)

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Elimination of deferred tax expense. See details »

2 Addition of increase (decrease) in allowance for doubtful accounts.

3 Addition of increase (decrease) in LIFO reserve. See details »

4 Addition of increase (decrease) in liabilities related to the exit and disposal activities.

5 Addition of increase (decrease) in equity equivalents to net earnings attributable to Walgreens Boots Alliance, Inc..

6 2019 Calculation
Interest expense on capitalized operating leases = Operating lease liability × Discount rate
= × =

7 2019 Calculation
Tax benefit of interest expense, net = Adjusted interest expense, net × Statutory income tax rate
= × 21.00% =

8 Addition of after taxes interest expense to net earnings attributable to Walgreens Boots Alliance, Inc..

9 2019 Calculation
Tax expense (benefit) of investment income = Investment income, before tax × Statutory income tax rate
= × 21.00% =

10 Elimination of after taxes investment income.


Net earnings attributable to Walgreens Boots Alliance, Inc.
The net earnings exhibit volatility over the six-year period. Starting at 1,932 million USD in 2014, there is a significant increase to 4,220 million USD in 2015. This level is mostly sustained through 2016 and 2017, with values of 4,173 and 4,078 million USD respectively. In 2018, net earnings peak at 5,024 million USD, marking the highest point in the period analyzed. However, a decline occurs in 2019, where earnings fall to 3,982 million USD, indicating a downward shift after the 2018 peak.
Net operating profit after taxes (NOPAT)
The NOPAT shows an overall upward trend with some fluctuations. Beginning at 3,086 million USD in 2014, it rises sharply to 5,501 million USD in 2015. After this peak, it dips to 4,855 million USD in 2016, before increasing again in 2017 and 2018 to 5,246 and 5,934 million USD respectively. The highest NOPAT value is recorded in 2018. In 2019, NOPAT slightly decreases to 5,719 million USD but remains close to the peak level, indicating relatively stable operating profitability in recent years compared to net earnings.

Cash Operating Taxes

Walgreens Boots Alliance Inc., cash operating taxes calculation

US$ in millions

Microsoft Excel
12 months ended: Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Income tax provision
Less: Deferred income tax expense (benefit)
Add: Tax savings from interest expense, net
Less: Tax imposed on investment income
Cash operating taxes

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


Income Tax Provision
The income tax provision exhibited a general downward trend from 2014 to 2019. Beginning at $1,526 million in 2014, the figure decreased steadily through subsequent years, reaching $588 million in 2019. Notably, the most significant decline occurred between 2017 and 2019.
Cash Operating Taxes
Cash operating taxes remained relatively stable between 2014 and 2018, fluctuating within a narrow range from $1,667 million to $1,856 million. However, in 2019, there was a sharp decrease to $831 million, which represents a substantial reduction compared to the previous years.
Overall Observations
Both income tax provision and cash operating taxes showed significant declines by 2019 compared to earlier periods. While income tax provision steadily decreased over the years, cash operating taxes were stable for several years before dropping markedly in the last year observed. These trends may reflect changes in tax policies, operational adjustments, or shifts in taxable income and cash tax payments.

Invested Capital

Walgreens Boots Alliance Inc., invested capital calculation (financing approach)

US$ in millions

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Short-term debt
Long-term debt
Operating lease liability1
Total reported debt & leases
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Net deferred tax (assets) liabilities2
Allowance for doubtful accounts3
LIFO reserve4
Liabilities related to the exit and disposal activities5
Equity equivalents6
Accumulated other comprehensive (income) loss, net of tax7
Noncontrolling interests
Adjusted total Walgreens Boots Alliance, Inc. shareholders’ equity
Available-for-sale investments8
Invested capital

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Addition of capitalized operating leases.

2 Elimination of deferred taxes from assets and liabilities. See details »

3 Addition of allowance for doubtful accounts receivable.

4 Addition of LIFO reserve. See details »

5 Addition of liabilities related to the exit and disposal activities.

6 Addition of equity equivalents to total Walgreens Boots Alliance, Inc. shareholders’ equity.

7 Removal of accumulated other comprehensive income.

8 Subtraction of available-for-sale investments.


The financial data reveals several notable trends concerning the company's capital structure and invested capital over the six-year period ending in 2019.

Total reported debt & leases
This figure shows an overall increasing trend from 31,909 million USD in 2014 to 43,464 million USD in 2019, with a peak at 46,508 million USD in 2016. After reaching this peak, there is a decline in 2017 to 39,129 million USD, followed by a gradual increase again through 2018 and 2019. This pattern suggests a significant increase in leveraging activities up to 2016, some deleveraging or repayment in 2017, and subsequent additional borrowings or lease liabilities through 2019.
Total shareholders’ equity
Shareholders' equity exhibits a declining trend over the period. Starting at 20,457 million USD in 2014, the equity rose sharply to 30,861 million USD in 2015 but then continuously decreased each year thereafter to 23,512 million USD by 2019. This reduction over time indicates a depletion of equity capital, which could be attributed to factors such as sustained net losses, dividend distributions exceeding net income, share repurchases, or other equity-reducing activities.
Invested capital
The invested capital closely aligns with the combined effect of debt and equity, representing the total capital used in operations. It increased substantially from 55,001 million USD in 2014 to a peak of 85,356 million USD in 2016. Following this peak, invested capital decreased to 76,485 million USD in 2017 and remained relatively stable, with a slight increase, reaching 77,429 million USD by 2019. This behavior suggests expansion or acquisition activity up to 2016, followed by a period of consolidation or capital optimization in subsequent years.

In summary, the company experienced considerable growth in debt financing and invested capital until 2016, accompanied by an initial rise and then a steady decline in shareholders' equity. The data implies a strategic shift post-2016, characterized by deleveraging and stabilization of invested capital, while equity erosion continued, highlighting potential risks related to capital structure and financial sustainability.


Cost of Capital

Walgreens Boots Alliance Inc., cost of capital calculations

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Borrowings3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2019-08-31).

1 US$ in millions

2 Equity. See details »

3 Borrowings. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Borrowings3 ÷ = × × (1 – 25.70%) =
Operating lease liability4 ÷ = × × (1 – 25.70%) =
Total:

Based on: 10-K (reporting date: 2018-08-31).

1 US$ in millions

2 Equity. See details »

3 Borrowings. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Borrowings3 ÷ = × × (1 – 35.00%) =
Operating lease liability4 ÷ = × × (1 – 35.00%) =
Total:

Based on: 10-K (reporting date: 2017-08-31).

1 US$ in millions

2 Equity. See details »

3 Borrowings. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Borrowings3 ÷ = × × (1 – 35.00%) =
Operating lease liability4 ÷ = × × (1 – 35.00%) =
Total:

Based on: 10-K (reporting date: 2016-08-31).

1 US$ in millions

2 Equity. See details »

3 Borrowings. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Borrowings3 ÷ = × × (1 – 35.00%) =
Operating lease liability4 ÷ = × × (1 – 35.00%) =
Total:

Based on: 10-K (reporting date: 2015-08-31).

1 US$ in millions

2 Equity. See details »

3 Borrowings. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Borrowings3 ÷ = × × (1 – 35.00%) =
Operating lease liability4 ÷ = × × (1 – 35.00%) =
Total:

Based on: 10-K (reporting date: 2014-08-31).

1 US$ in millions

2 Equity. See details »

3 Borrowings. See details »

4 Operating lease liability. See details »


Economic Spread Ratio

Walgreens Boots Alliance Inc., economic spread ratio calculation, comparison to benchmarks

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Selected Financial Data (US$ in millions)
Economic profit1
Invested capital2
Performance Ratio
Economic spread ratio3
Benchmarks
Economic Spread Ratio, Competitors4
Costco Wholesale Corp.
Target Corp.
Walmart Inc.

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Economic profit. See details »

2 Invested capital. See details »

3 2019 Calculation
Economic spread ratio = 100 × Economic profit ÷ Invested capital
= 100 × ÷ =

4 Click competitor name to see calculations.


The period between August 31, 2014, and August 31, 2019, demonstrates a consistent pattern of negative economic profit. While the magnitude of the economic loss fluctuates, the company did not generate positive economic profit during this timeframe.

Invested Capital
Invested capital increased significantly from 2014 to 2015, rising from US$55,001 million to US$80,730 million. Following this substantial increase, invested capital remained relatively stable, fluctuating between US$76,286 million and US$85,356 million for the subsequent years. A slight upward trend is observable in invested capital from 2018 to 2019.
Economic Profit
Economic profit exhibited a worsening trend from 2014 to 2016, declining from a loss of US$3,095 million to a loss of US$4,848 million. A reduction in the magnitude of the loss occurred in 2017, improving to US$3,395 million. This improvement continued through 2019, with the economic loss decreasing to US$2,011 million. Despite this improvement, economic profit remained negative throughout the analyzed period.
Economic Spread Ratio
The economic spread ratio consistently registered negative values throughout the period, indicating that the company’s return on invested capital was less than its cost of capital. The ratio demonstrated a general improvement from -5.63% in 2014 to -2.60% in 2019. The most substantial improvement in the economic spread ratio occurred between 2018 and 2019, moving from -3.41% to -2.60%. The ratio experienced its most negative value in 2016 at -5.68%.

Overall, the trend suggests a gradual improvement in the company’s ability to generate returns relative to its cost of capital, as evidenced by the increasing economic spread ratio and decreasing economic loss. However, the continued negative economic profit and economic spread ratio indicate that the company still underperforms from an economic value creation perspective.


Economic Profit Margin

Walgreens Boots Alliance Inc., economic profit margin calculation, comparison to benchmarks

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Selected Financial Data (US$ in millions)
Economic profit1
Sales
Performance Ratio
Economic profit margin2
Benchmarks
Economic Profit Margin, Competitors3
Costco Wholesale Corp.
Target Corp.
Walmart Inc.

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Economic profit. See details »

2 2019 Calculation
Economic profit margin = 100 × Economic profit ÷ Sales
= 100 × ÷ =

3 Click competitor name to see calculations.


The economic profit margin exhibited a fluctuating, yet generally improving, trend over the observed period. While consistently negative, the magnitude of the economic loss decreased from 2014 to 2019. This suggests a gradual improvement in the company’s ability to generate returns exceeding its cost of capital, although profitability relative to sales remained a concern throughout the period.

Economic Profit Margin
The economic profit margin began at -4.05% in 2014 and decreased to -3.82% in 2015. A subsequent increase to -4.13% occurred in 2016, representing the lowest point in the observed period. From 2016 onward, the margin demonstrated a consistent improvement, reaching -2.87% in 2017, -1.97% in 2018, and finally -1.47% in 2019. This indicates a diminishing economic loss as a percentage of sales.

Sales experienced substantial growth throughout the period. Sales increased from US$76,392 million in 2014 to US$136,866 million in 2019. This growth in sales did not fully offset the cost of capital, as evidenced by the consistently negative economic profit. However, the improving economic profit margin alongside increasing sales suggests that the company became more efficient in converting sales into economic profit over time.

Economic Profit
Economic profit, while consistently negative, showed a decreasing trend in absolute terms. Starting at a loss of US$3,095 million in 2014, the loss peaked at US$4,848 million in 2016. Subsequent years saw reductions in the economic loss, with figures of US$3,395 million in 2017, US$2,598 million in 2018, and US$2,011 million in 2019. This reduction in the absolute economic loss, coupled with rising sales, contributed to the improvement in the economic profit margin.

The observed trend suggests that while the company consistently destroyed economic value during this period, the rate of value destruction lessened over time. The combination of increasing sales and a diminishing economic loss indicates potential improvements in operational efficiency or capital allocation strategies.