Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Walgreens Boots Alliance Inc. logo

Walgreens Boots Alliance Inc.

Sector: Consumer Defensive   

Industry: Pharmaceutical Retailers

15.55
 
USD
  
0.1
  
(0.00647249)
Optionable: Yes  Market Cap: 13743023920.0  90-day average vol: 11941891.0

Previous close: 15.45  Open: 15.37  Bid: 15.48  Ask: 15.54
52 week range    
14.62   
   32.8899
Last updated: Sunday 16th June 2024

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Valuation

0.388

1.02

-2.0

15.63

NA , NA

Returns

-0.024466750313676212

-0.14030451464523053

-0.23795055254710737

-0.49137629322892645

-0.6579749034961343

-0.6268271669822436

-0.4044427422443508

Risk

0.7375

0.8008

Ranks

39.0

30.0

Dividends

1.46

0.0643

2024-05-20

2024-06-12

0.0939

1.0

-27.46

Analyst Estimates

3.21

3.07

0.64

0.68

21.64

5.0

22.36

22.57

22.57

Financial Health

0.12

0.7

0.3

2.49

34.02

Technicals

38.0605248998

15.7114285714

15.9074

41.1075350106

0.503141902

17.161

20.93255

32.9022875193

0.802006036579

Growth

Profitability

-6.54

-9.5

-34.85

-11.17

18.6

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

WBA Income Statement

Annual
Invalid dateAug-15Aug-16Aug-17Aug-18Aug-19Aug-20Aug-21Aug-22Aug-23
AccretionOnPreferredStock19 M179 M442 M
AcquisitionExpense54 M223 M323 M
Amortization of intangibles-706 M-396 M-385 M-493 M-552 M-384 M523 M639 M815 M
Basic EPS from continuing operations4.053.850.22.315.02-3.57
Basic EPS total4.053.853.85.074.320.522.945.02-3.57
Basic weighted shares outstanding1,043 M1,083 M1,074 M991 M922 M879 M865 M864 M863 M
BasicDiscontinuousOperations0.310.63
Cost of sales76,691 M87,477 M89,052 M100,745 M106,790 M95,905 M104,442 M104,437 M112,009 M
Depreciation-1,742 M-1,718 M-1,654 M-1,770 M-2,038 M-1,927 M
Depreciation unreconciled-1,500 M-1,400 M
DepreciationAndAmortization-1,742 M-1,718 M-1,654 M-1,770 M-1,500 M-1,400 M
Diluted EPS total4.03.823.785.054.310.522.935.01-3.57
Diluted normalized net income/share4.03.820.22.35.01-3.57
Diluted weighted shares outstanding1,054 M1,091 M1,079 M995 M924 M880 M866 M866 M863 M
DilutedDiscontinuousOperations0.310.63
Dividends paid per share1.371.461.531.641.781.841.881.911.92
Earnings from equity interest24 M534 M1,040 M1,315 M187 M382 M321 M559 M1,855 M
EarningsFromEquityInterestNetOfTax24 M534 M1,040 M1,315 M187 M382 M321 M559 M1,855 M
GainOnSaleOfBusiness-17 M322 M
GainOnSaleOfSecurity563 M
GainsLossOnDisposalOfDiscontinuedOperations286 M
GeneralAndAdministrativeExpense-3,176 M-3,366 M-3,263 M-3,448 M-3,631 M24,586 M27,295 M34,205 M
Gross operating profit26,753 M29,874 M29,162 M30,792 M30,076 M26,078 M28,067 M28,265 M27,072 M
ImpairmentOfCapitalAssets-110 M-30 M11 M-73 M-2,016 M
Income before tax5,916 M5,740 M5,546 M6,591 M5,231 M1,060 M2,900 M3,985 M-5,419 M
Income restructuring and M&A-559 M-424 M-835 M-100 M-196 M-53 M
Income taxes1,056 M997 M760 M998 M588 M339 M667 M-30 M-1,858 M
InterestExpenseNonOperating605 M596 M693 M616 M704 M613 M905 M400 M580 M
InterestExpenseOperating-472 M-580 M-643 M-577 M-676 M-584 M-916 M-420 M-606 M
MinorityInterests-59 M-18 M-23 M-7 M20 M33 M30 M271 M448 M
MiscOtherSpecialCharges39,360 M41,889 M43,571 M302 M233 M77 M558 M2,998 M2,043 M
Net income from total operations4,279 M4,191 M4,101 M5,031 M3,982 M456 M2,542 M4,337 M-3,080 M
NetIncomeCommonStockholders4,220 M4,173 M4,078 M5,024 M3,982 M457 M2,542 M4,337 M-3,080 M
NetIncomeContinuousOperations4,279 M4,191 M4,101 M5,031 M3,982 M456 M2,542 M4,337 M-3,080 M
NetIncomeDiscontinuousOperations286 M557 M
NetIncomeFromOtherGainsLosses24 M44 M8 M54 M23 M31 M
NetNonOperatingInterestIncomeExpense-605 M-596 M-693 M-616 M-704 M-613 M-905 M-400 M-580 M
NonRecurringOperationExpense-47 M284 M31 M75 M768 M7,466 M
Normalized income-133,272 M-129,251 M-133,464 M
Operating income4,668 M6,001 M5,557 M6,289 M4,998 M982 M2,342 M1,389 M-6,881 M
Operating income before depreciation (EBITDA)7,012 M7,990 M7,250 M8,400 M7,297 M3,016 M4,862 M5,955 M-3,188 M
OperatingExpense22,085 M23,873 M23,605 M24,503 M25,078 M25,095 M25,725 M26,877 M33,953 M
Other income net-587 M-42,525 M-45,085 M-302 M-233 M-77 M-558 M-2,998 M-2,043 M
Other special charges-685 M261 M11 M-177 M302 M464 M-64 M326 M-157 M
OtherGainLossFromDispositionOfDiscontinuedOperations557 M
OtherGandA-3,176 M-3,366 M-3,263 M-3,448 M-3,631 M24,586 M27,295 M34,205 M
OtherImpairmentOfCapitalAssets-328 M-462 M203 M783 M495 M
OtherOperatingExpenses-285 M-214 M-166 M-84 M-136 M-3,252 M-446 M-619 M-925 M
OtherunderPreferredStockDividend19 M179 M442 M
PreferredStockDividends19 M179 M442 M
PromotionAndAdvertising-491 M-598 M-571 M-665 M-585 M-532 M772 M862 M775 M
RentAndLandingFees-3,176 M-3,366 M-3,263 M-3,448 M-3,631 M
RestructringAndMnAIncome-559 M-424 M-835 M-100 M-196 M-53 M
Revenue per share-1,191 M-765 M-717 M-493 M-1,045 M-768 M1,046 M1,494 M1,941 M
SalariesAndWages-315 M-37 M-135 M-191 M-164 M-341 M1,139 M-418 M-252 M
Selling Gen & administrative expense22,400 M23,910 M23,740 M24,694 M25,242 M25,436 M24,586 M27,295 M34,205 M
SellingAndMarketingExpense22,400 M23,910 M23,740 M24,694 M25,242 M25,436 M772 M862 M775 M
SellingExpense22,400 M23,910 M23,740 M24,694 M25,242 M25,436 M
Special income/charges685 M-261 M-11 M-184 M-55 M1,605 M-11 M-1,094 M-7,309 M
Total Income available for interest expense (EBIT)6,049 M5,756 M5,596 M6,630 M5,259 M1,089 M2,889 M3,965 M-5,445 M
Total common shares outstanding1,089 M1,083 M1,083 M949 M893 M866 M866 M865 M864 M
Total net income4,279 M4,191 M4,101 M5,031 M3,982 M456 M2,542 M4,337 M-3,080 M
Total ordinary shares863 M863 M863 M863 M863 M863 M863 M863 M863 M
Total revenues103,444 M117,351 M118,214 M131,537 M136,866 M121,982 M132,509 M132,703 M139,081 M
TotalExpenses98,776 M111,350 M112,657 M125,248 M131,868 M121,000 M130,167 M131,314 M145,962 M
TotalRevenue103,444 M117,351 M118,214 M131,537 M136,866 M121,982 M132,509 M132,703 M139,081 M
WriteDown-4 M-9 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University