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.

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Walgreens Boots Alliance Inc., liquidity ratios (quarterly data)

Microsoft Excel
May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013
Current ratio 0.69 0.66 0.66 0.73 0.76 0.78 0.80 0.82 0.93 0.90 0.96 1.07 1.30 1.56 1.50 1.52 1.25 1.25 1.20 1.19 1.30 1.24 2.36 1.38 1.42 1.42 1.33
Quick ratio 0.29 0.29 0.28 0.32 0.32 0.34 0.32 0.34 0.42 0.40 0.42 0.53 0.86 0.99 0.89 0.94 0.62 0.63 0.56 0.59 0.70 0.60 1.66 0.66 0.61 0.54 0.42
Cash ratio 0.03 0.03 0.03 0.04 0.03 0.03 0.04 0.04 0.08 0.08 0.09 0.18 0.56 0.67 0.54 0.58 0.21 0.22 0.15 0.18 0.28 0.18 1.30 0.30 0.25 0.21 0.11

Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walgreens Boots Alliance Inc. current ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Walgreens Boots Alliance Inc. quick ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Walgreens Boots Alliance Inc. cash ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Current Ratio

Walgreens Boots Alliance Inc., current ratio calculation (quarterly data)

Microsoft Excel
May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013
Selected Financial Data (US$ in millions)
Current assets 18,326 18,909 19,604 18,700 19,021 19,851 20,083 17,846 19,988 20,358 19,681 19,753 28,152 27,509 26,668 25,883 19,713 20,378 20,231 19,657 21,029 20,715 23,280 12,242 11,928 12,036 11,722
Current liabilities 26,649 28,662 29,494 25,769 25,060 25,303 25,099 21,667 21,482 22,559 20,517 18,547 21,713 17,678 17,729 17,013 15,811 16,272 16,874 16,557 16,157 16,690 9,877 8,895 8,409 8,499 8,821
Liquidity Ratio
Current ratio1 0.69 0.66 0.66 0.73 0.76 0.78 0.80 0.82 0.93 0.90 0.96 1.07 1.30 1.56 1.50 1.52 1.25 1.25 1.20 1.19 1.30 1.24 2.36 1.38 1.42 1.42 1.33
Benchmarks
Current Ratio, Competitors2
Costco Wholesale Corp. 1.11 1.04 1.01 1.01 0.98 0.96 1.02 1.02 1.01 1.00 0.98
Target Corp. 0.83 0.84 0.88 0.83 0.83 0.82 0.90
Walmart Inc. 0.81 0.76 0.77 0.80 0.81 0.93 0.73

Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).

1 Q3 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= 18,326 ÷ 26,649 = 0.69

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walgreens Boots Alliance Inc. current ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level.

Quick Ratio

Walgreens Boots Alliance Inc., quick ratio calculation (quarterly data)

Microsoft Excel
May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013
Selected Financial Data (US$ in millions)
Cash and cash equivalents 768 792 811 1,023 839 818 980 785 1,818 1,749 1,830 3,301 12,253 11,822 9,598 9,807 3,291 3,586 2,570 3,000 4,449 3,005 12,861 2,646 2,126 1,777 969
Accounts receivable, net 6,982 7,572 7,435 7,226 7,239 7,828 7,144 6,573 7,159 7,281 6,858 6,528 6,339 5,674 6,138 6,260 6,508 6,733 6,821 6,849 6,899 7,017 3,579 3,218 3,029 2,774 2,727
Total quick assets 7,750 8,364 8,246 8,249 8,078 8,646 8,124 7,358 8,977 9,030 8,688 9,829 18,592 17,496 15,736 16,067 9,799 10,319 9,391 9,849 11,348 10,022 16,440 5,864 5,155 4,551 3,696
 
Current liabilities 26,649 28,662 29,494 25,769 25,060 25,303 25,099 21,667 21,482 22,559 20,517 18,547 21,713 17,678 17,729 17,013 15,811 16,272 16,874 16,557 16,157 16,690 9,877 8,895 8,409 8,499 8,821
Liquidity Ratio
Quick ratio1 0.29 0.29 0.28 0.32 0.32 0.34 0.32 0.34 0.42 0.40 0.42 0.53 0.86 0.99 0.89 0.94 0.62 0.63 0.56 0.59 0.70 0.60 1.66 0.66 0.61 0.54 0.42
Benchmarks
Quick Ratio, Competitors2
Costco Wholesale Corp. 0.58 0.47 0.45 0.47 0.43 0.41 0.43 0.45 0.44 0.41 0.41
Target Corp. 0.06 0.12 0.09 0.10 0.05 0.08 0.09
Walmart Inc. 0.17 0.18 0.18 0.18 0.17 0.29 0.15

Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).

1 Q3 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 7,750 ÷ 26,649 = 0.29

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Walgreens Boots Alliance Inc. quick ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.

Cash Ratio

Walgreens Boots Alliance Inc., cash ratio calculation (quarterly data)

Microsoft Excel
May 31, 2020 Feb 29, 2020 Nov 30, 2019 Aug 31, 2019 May 31, 2019 Feb 28, 2019 Nov 30, 2018 Aug 31, 2018 May 31, 2018 Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013
Selected Financial Data (US$ in millions)
Cash and cash equivalents 768 792 811 1,023 839 818 980 785 1,818 1,749 1,830 3,301 12,253 11,822 9,598 9,807 3,291 3,586 2,570 3,000 4,449 3,005 12,861 2,646 2,126 1,777 969
Total cash assets 768 792 811 1,023 839 818 980 785 1,818 1,749 1,830 3,301 12,253 11,822 9,598 9,807 3,291 3,586 2,570 3,000 4,449 3,005 12,861 2,646 2,126 1,777 969
 
Current liabilities 26,649 28,662 29,494 25,769 25,060 25,303 25,099 21,667 21,482 22,559 20,517 18,547 21,713 17,678 17,729 17,013 15,811 16,272 16,874 16,557 16,157 16,690 9,877 8,895 8,409 8,499 8,821
Liquidity Ratio
Cash ratio1 0.03 0.03 0.03 0.04 0.03 0.03 0.04 0.04 0.08 0.08 0.09 0.18 0.56 0.67 0.54 0.58 0.21 0.22 0.15 0.18 0.28 0.18 1.30 0.30 0.25 0.21 0.11
Benchmarks
Cash Ratio, Competitors2
Costco Wholesale Corp. 0.52 0.38 0.38 0.41 0.36 0.32 0.35 0.36 0.36 0.31 0.34
Target Corp. 0.06 0.12 0.09 0.10 0.05 0.08 0.09
Walmart Inc. 0.10 0.12 0.12 0.10 0.11 0.22 0.10

Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).

1 Q3 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 768 ÷ 26,649 = 0.03

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Walgreens Boots Alliance Inc. cash ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.