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

Item Description The company
FCFF Free cash flow to the firm is the cash flow available to the Walgreens Boots Alliance Inc. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made. Walgreens Boots Alliance Inc. FCFF increased from 2017 to 2018 but then decreased significantly from 2018 to 2019.

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


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. 46.01
Target Corp. 21.24
Walmart Inc. 30.62
EV/FCFF, Sector
Consumer Staples Distribution & Retail 36.67
EV/FCFF, Industry
Consumer Staples 32.02

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. 37.24 32.89
Target Corp. 17.80
Walmart Inc. 17.27
EV/FCFF, Sector
Consumer Staples Distribution & Retail 19.99
EV/FCFF, Industry
Consumer Staples 23.31

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.

Valuation ratio Description The company
EV/FCFF Enterprise value to free cash flow to the firm is whole company valuation indicator. Walgreens Boots Alliance Inc. EV/FCFF ratio decreased from 2017 to 2018 but then increased from 2018 to 2019 exceeding 2017 level.