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

21.69
 
USD
  
0.67
  
(3.19%)
Optionable: Yes  Market Cap: 17,687 M  90-day average vol: 13,934,592

Previous close: 21.02  Open: 20.6  Bid: 21.7  Ask: 21.72
52 week range    
19.68   
   36.58
Peers   
CVS / 
PETS / 
CJJD / 
Last updated: Friday 29th March 2024
54
MarketXLS Rank
55
Value
69
Technical
39
Quality

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

Financials

WBA Cash Flow

Annual
Invalid dateAug-15Aug-16Aug-17Aug-18Aug-19Aug-20Aug-21Aug-22Aug-23
(Increase) Decrease in inventories719 M-644 M98 M331 M141 M63 M165 M-433 M287 M
(Increase) Decrease in other current liabilities-11 M58 M67 M-311 M-154 M-16 M-288 M137 M-228 M
(Increase) Decrease in payables103 M2,087 M1,606 M2,333 M174 M762 M2,048 M55 M1,123 M
(Increase) Decrease in receivables-338 M115 M-153 M-391 M-789 M163 M-1,451 M808 M72 M
Acquisitions-4,461 M
Amortization of intangibles-779 M516 M
AssetImpairmentCharge2,016 M49 M1,214 M1,293 M
CapitalExpenditureReported1,251 M1,325 M1,351 M1,367 M1,702 M1,374 M1,379 M1,734 M2,117 M
Cash at beginning of period2,646 M3,000 M9,807 M3,496 M975 M1,207 M746 M1,270 M2,558 M
Cash at end of period3,000 M9,807 M3,301 M975 M1,207 M747 M1,271 M2,558 M856 M
Cash flow6,227 M7,847 M7,251 M8,264 M5,594 M5,484 M5,555 M4,518 M3,182 M
CashFlowFromContinuingInvestingActivities-4,276 M-3,517 M-843 M-5,501 M-2,307 M-1,297 M4,072 M-1,065 M-3,093 M
ChangeInAccountPayable438 M1,885 M1,562 M1,639 M580 M983 M1,888 M106 M682 M
ChangeInIncomeTaxPayable-335 M202 M44 M694 M-406 M-221 M160 M-51 M441 M
ChangeInPayablesAndAccruedExpense103 M2,087 M1,606 M2,333 M174 M762 M2,048 M55 M1,123 M
ChangeInPrepaidAssets22 M66 M-22 M-112 M-31 M-46 M-72 M-188 M
ChangeInTaxPayable-335 M202 M44 M694 M-406 M-221 M160 M-51 M441 M
ChangeInWorkingCapital495 M1,682 M1,618 M1,940 M-740 M941 M428 M495 M1,066 M
CommonStockDividendPaid-1,384 M-1,563 M-1,723 M-1,739 M-1,643 M-1,747 M-1,617 M-1,659 M-1,659 M
CommonStockPayments-1,226 M-1,152 M-5,220 M-5,228 M-4,160 M-1,589 M-110 M-2,295 M-1,466 M
Current deferred income taxes-32 M-442 M-434 M-322 M100 M-43 M233 M-366 M-2,371 M
Deferred income taxes-32 M-442 M-434 M-322 M100 M-43 M233 M-366 M-2,371 M
Depreciation1,742 M1,718 M1,654 M1,770 M2,038 M1,927 M1,973 M1,990 M2,257 M
Depreciation unreconciled963 M2,234 M1,654 M1,770 M2,038 M1,927 M1,973 M1,990 M2,257 M
DepreciationAndAmortization963 M2,234 M1,654 M1,770 M2,038 M1,927 M1,973 M1,990 M2,257 M
EarningsLossesFromEquityInvestments-187 M-382 M177 M-1,027 M-2,141 M
Effect of exchange rate changes-119 M-129 M20 M11 M-9 M-1000000.0-66 M-47 M20 M
FinancingCashFlow-1,478 M2,606 M-12,934 M-5,295 M-3,046 M-4,646 M-9,036 M-1,499 M-887 M
Free cash flow5,160 M6,677 M5,959 M7,552 M4,009 M4,200 M4,629 M3,499 M4,636 M
GainLossOnInvestmentSecurities-337 M
GainLossOnSaleOfBusiness-322 M
Issuance of capital stock503 M235 M217 M174 M174 M55 M59 M27 M45 M
Issuance of debt-226 M29 M33 M586 M536 M-161 M-909 M-11 M-1000000.0
IssuanceOfCapitalStock503 M235 M217 M174 M174 M55 M59 M27 M45 M
IssuanceOfDebt1,587 M5,229 M-6,163 M1,596 M2,508 M-1,208 M-3,440 M3,587 M-2,703 M
Net cash from financing activities-1,478 M2,606 M-12,934 M-5,295 M-3,046 M-4,646 M-9,036 M-2,118 M-1,811 M
Net cash from investing activities-4,276 M-3,517 M-843 M-5,501 M-2,307 M-1,297 M4,072 M-1,065 M-3,093 M
Net cash from operating activities6,227 M7,847 M7,251 M8,264 M5,594 M5,484 M5,555 M3,899 M2,258 M
Net change in cash & cash equivalents354 M6,807 M-6,506 M-2,521 M232 M-460 M525 M1,288 M-1,702 M
Net income from continuing operations4,279 M4,191 M4,101 M5,031 M3,962 M424 M2,512 M4,065 M-3,528 M
NetBusinessPurchaseAndSale-3,647 M74 M5,527 M
NetCommonStockIssuance-723 M-917 M-5,003 M-5,054 M-3,986 M-1,534 M-51 M-2,268 M-1,421 M
NetInvestmentPropertiesPurchaseAndSale438 M-2,421 M449 M-4,789 M-722 M-13 M-529 M-665 M-5,471 M
NetInvestmentPurchaseAndSale438 M-2,421 M449 M-4,789 M-722 M-13 M-529 M-665 M-5,471 M
NetIssuancePaymentsOfDebt1,587 M5,229 M-6,163 M1,596 M2,508 M-1,208 M-3,440 M3,587 M-2,703 M
NetLongTermDebtIssuance1,813 M5,200 M-6,196 M1,010 M1,972 M-1,047 M-2,531 M3,598 M-2,702 M
NetPPEPurchaseAndSale-1,067 M-1,170 M-1,292 M-712 M-1,585 M-1,284 M-926 M-400 M2,378 M
Operating (gains) losses-337 M-187 M-382 M269 M-1,021 M-2,141 M
Other financing charges net-958 M-143 M-45 M-98 M75 M-157 M-241 M-187 M3,972 M
Other investing changes net438 M-61 M449 M-4,789 M-722 M-13 M-529 M-665 M-5,471 M
Other non-cash items522 M182 M312 M182 M421 M2,617 M140 M-645 M7,899 M
Payment of cash dividends1,384 M1,563 M1,723 M1,739 M1,643 M1,747 M1,617 M1,659 M1,659 M
Purchase of Float term investments-2,360 M
Purchase of property plant & equipment-1,067 M-1,170 M-1,292 M-712 M-1,585 M-1,284 M-926 M-400 M2,378 M
Purchase of short term investments12,285 M5,991 M5,900 M12,433 M20,367 M12,726 M11,958 M6,276 M
PurchaseOfInvestment-49 M-2,360 M
PurchaseOfLongTermInvestments-49 M
PurchaseOfPPE-1,251 M-1,325 M-1,351 M-1,367 M-1,702 M-1,374 M-1,379 M-1,734 M-2,117 M
Repayment of debt-10,472 M-791 M-6,196 M-4,890 M-10,461 M-21,414 M-15,257 M-8,360 M-8,978 M
RepaymentOfDebt-10,698 M-762 M-6,163 M-4,304 M-9,925 M-21,575 M-15,257 M-8,360 M-8,978 M
Repurchase of capital stock-1,226 M-1,152 M-5,220 M-5,228 M-4,160 M-1,589 M-110 M-2,295 M-1,466 M
Revenue per share-779 M516 M
Sale of Float term investments50 M
SaleOfBusiness814 M74 M5,527 M
SaleOfInvestment50 M
SaleOfPPE184 M155 M59 M655 M117 M90 M453 M1,334 M4,495 M
ShortTermDebtIssuance-909 M-11 M-1000000.0
ShortTermDebtPayments-226 M29 M33 M586 M536 M-161 M
StockBasedCompensation109 M115 M91 M130 M119 M137 M155 M391 M385 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.

We respect your privacy and will never share your email.
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