Stock Analysis on Net
Stock Analysis on Net

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

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

Enterprise Value to FCFF (EV/FCFF)

Microsoft Excel

Free Cash Flow to The Firm (FCFF)

Walgreens Boots Alliance Inc., FCFF 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. 3,982 5,024 4,078 4,173 4,220 1,932
Net (earnings) loss attributable to noncontrolling interests (20) 7 23 18 59 99
Net noncash charges 2,372 1,293 1,532 1,974 890 1,652
Changes in operating assets and liabilities (740) 1,941 1,618 1,682 495 210
Net cash provided by operating activities 5,594 8,265 7,251 7,847 5,664 3,893
Interest paid, net of tax1 588 481 542 467 378 92
Additions to property, plant and equipment (1,702) (1,367) (1,351) (1,325) (1,251) (1,106)
Free cash flow to the firm (FCFF) 4,480 7,379 6,442 6,989 4,791 2,879

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).


The financial trajectory from 2014 to 2019 exhibits a period of significant expansion followed by a sharp contraction in cash generation capabilities. Net cash provided by operating activities and Free Cash Flow to the Firm (FCFF) moved in close correlation throughout the period, though FCFF experienced more pronounced volatility during the final year of the sequence.

Growth Phase (2014–2016)
A period of robust growth is observed between 2014 and 2016. FCFF increased from 2,879 million US$ to 6,989 million US$, representing a total increase of approximately 142%. This growth was mirrored by operating cash flows, which rose from 3,893 million US$ to 7,847 million US$ over the same interval, indicating a strong improvement in the core cash-generating capacity of the business.
Stabilization and Peak (2017–2018)
Following the initial growth phase, a period of relative stabilization occurred. After a slight dip in 2017, FCFF reached a peak of 7,379 million US$ in 2018. During this stage, operating cash flows remained elevated, peaking at 8,265 million US$ in 2018, suggesting that the operational efficiency achieved in the previous years was maintained.
Contraction Period (2019)
A significant downturn is evident in 2019, with FCFF falling to 4,480 million US$, a decrease of approximately 39% from the previous year's peak. While operating cash flows also declined to 5,594 million US$, the drop in FCFF was more severe, indicating that the reduction in cash flow was driven by both a decline in operating performance and potentially increased capital commitments.
Capital Expenditure Implications
The variance between net cash provided by operating activities and FCFF suggests a consistent requirement for capital reinvestment. Notably, the gap widened in 2019 to 1,114 million US$, the highest in the observed period. This indicates that despite a substantial decrease in operating cash flows, capital expenditures or other firm-level investments increased, further compressing the free cash flow available to the firm.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Interest Paid, Net of Tax

Walgreens Boots Alliance Inc., interest paid, net of tax 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
Effective Income Tax Rate (EITR)
EITR1 13.00% 16.70% 15.70% 19.40% 19.90% 42.90%
Interest Paid, Net of Tax
Interest paid, before tax 676 577 643 580 472 161
Less: Interest paid, tax2 88 96 101 113 94 69
Interest paid, net of tax 588 481 542 467 378 92

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 See details »

2 2019 Calculation
Interest paid, tax = Interest paid × EITR
= 676 × 13.00% = 88


A significant increase in interest paid, net of tax, is observed between 2014 and 2019, characterized by a general upward trajectory punctuated by a brief contraction in 2018. The total net interest cost expanded from 92 million US dollars in 2014 to a peak of 588 million US dollars in 2019.

Net Interest Expenditure Trends
The most substantial year-over-year increase occurred between 2014 and 2015, where expenditures rose from 92 million US dollars to 378 million US dollars. This growth continued steadily through 2017, reaching 542 million US dollars. Although a moderate decline to 481 million US dollars was recorded in 2018, the trend resumed its ascent in 2019, resulting in the highest expenditure of the period at 588 million US dollars.
Effective Income Tax Rate (EITR) Correlation
A pronounced downward trend in the effective income tax rate is evident, falling from 42.90% in 2014 to 13.00% in 2019. Because interest is typically tax-deductible, a lower EITR reduces the tax shield benefit, thereby increasing the net-of-tax cost of interest. The sharp reduction in the tax rate from 2014 to 2015 likely contributed to the surge in the net interest paid during that period.
Analysis of the 2018 Divergence
In 2018, the net interest paid decreased to 481 million US dollars despite a slight increase in the EITR to 16.70%. This suggests that the reduction in the net cost during this specific year was driven by a decrease in the gross interest obligations rather than changes in the tax environment.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Enterprise Value to FCFF Ratio, Current

Walgreens Boots Alliance Inc., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in millions)
Enterprise value (EV) 50,256
Free cash flow to the firm (FCFF) 4,480
Valuation Ratio
EV/FCFF 11.22
Benchmarks
EV/FCFF, Competitors1
Costco Wholesale Corp. 50.24
Target Corp. 25.52
Walmart Inc. 51.00

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

1 Click competitor name to see calculations.

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

Walgreens Boots Alliance Inc., historical EV/FCFF 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)
Enterprise value (EV)1 66,257 81,590 80,464 97,390 104,315 59,181
Free cash flow to the firm (FCFF)2 4,480 7,379 6,442 6,989 4,791 2,879
Valuation Ratio
EV/FCFF3 14.79 11.06 12.49 13.93 21.77 20.56
Benchmarks
EV/FCFF, 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 See details »

2 See details »

3 2019 Calculation
EV/FCFF = EV ÷ FCFF
= 66,257 ÷ 4,480 = 14.79

4 Click competitor name to see calculations.


The financial trajectory from 2014 to 2019 is characterized by significant volatility in enterprise valuation and a fluctuating capacity to generate free cash flow to the firm, resulting in a non-linear trend in the EV/FCFF multiple.

Enterprise Value (EV) Trends
A substantial increase in enterprise value occurred between 2014 and 2015, with the value rising from US$ 59,181 million to a peak of US$ 104,315 million. Following this peak, a general contraction is observed, with the value descending to US$ 66,257 million by 2019, representing a significant reduction from the 2015 high.
Free Cash Flow to the Firm (FCFF) Performance
FCFF exhibited a positive growth trend for the majority of the period, ascending from US$ 2,879 million in 2014 to a peak of US$ 7,379 million in 2018. However, this growth was reversed in 2019, with FCFF dropping sharply to US$ 4,480 million, indicating a marked decrease in the firm's ability to generate cash available to all capital providers in the final year of the analysis.
EV/FCFF Ratio Analysis
The EV/FCFF ratio remained elevated in 2014 and 2015, peaking at 21.77. A consistent downward trend followed, reaching a minimum of 11.06 in 2018, suggesting an improvement in valuation efficiency as cash flow growth outpaced the decline in enterprise value. This trend reversed in 2019, as the ratio climbed back to 14.79, driven primarily by the significant contraction in FCFF rather than an increase in enterprise value.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?