Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

WBA Stock Annual Balance Sheet. Download in Excel

Walgreens Boots Alliance Inc. logo

Walgreens Boots Alliance Inc.

Sector: Consumer Defensive   

Industry: Pharmaceutical Retailers

8.30
 
USD
  
0.06
  
(0.73%)
Previous close: 8.24  Open: 8.26  Bid: 8.27  Ask: 8.3
52 week range    
8.08   
   27.05
Mkt Cap: 7,168 M  Avg Vol (90 Days): 22,563,306
Peers   
CVS / 
PETS / 
CJJD / 
Last updated: Friday 22nd November 2024

Stock Rankings

44
MarketXLS Rank
80
Value
7
Technical
47
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

WBA Balance Sheet

Annual
Invalid dateAug-15Aug-16Aug-17Aug-18Aug-19Aug-20Aug-21Aug-22Aug-23
Accounts payable10,088 M11,000 M12,494 M13,566 M14,341 M10,145 M11,136 M11,255 M12,635 M
Accounts receivable6,849 M6,260 M6,528 M6,573 M7,226 M4,110 M5,663 M5,017 M5,381 M
Accrued expenses15,313 M16,484 M18,296 M19,701 M20,031 M16,101 M18,490 M19,238 M21,270 M
Accumulated depreciation & depletion-7,540 M-8,600 M-9,318 M-10,513 M-11,310 M-12,131 M-13,073 M-12,843 M-12,953 M
Additional paid in capital9,953 M10,111 M10,339 M10,493 M10,639 M10,761 M10,988 M10,950 M10,661 M
Cash and equivalents3,000 M9,807 M3,301 M785 M1,023 M469 M559 M1,358 M728 M
CashCashEquivalentsAndShortTermInvestments3,000 M9,807 M3,301 M785 M1,023 M469 M1,193 M2,472 M739 M
CashEquivalents184 M185 M202 M190 M1,023 M230 M
Common par12 M12 M12 M12 M12 M12 M12 M12 M12 M
Common stock equity30,863 M29,881 M27,466 M26,007 M23,512 M20,637 M23,419 M25,275 M20,021 M
CommonStock12 M12 M12 M12 M12 M12 M12 M12 M12 M
Cost in excess16,372 M15,527 M15,632 M16,914 M16,560 M12,013 M12,421 M22,280 M28,187 M
CurrentAccruedExpenses5,225 M5,484 M5,473 M5,862 M5,474 M5,861 M7,260 M7,899 M8,426 M
CurrentCapitalLeaseObligation3,141 M3,066 M3,210 M3,528 M3,484 M2,358 M2,259 M2,286 M2,347 M
CurrentDeferredTaxesAssets1,157 M1,348 M1,262 M847 M742 M5,964 M6,223 M6,338 M7,793 M
CurrentDeferredTaxesLiabilities176 M206 M2,274 M1,750 M1,724 M1,325 M7,985 M7,641 M7,596 M
Deferred revenues176 M206 M329 M
DividendsPayable1,748 M1,632 M-1,664 M-1,714 M
Float term debt13,315 M18,705 M12,684 M12,431 M11,098 M12,203 M
GoodwillAndOtherIntangibleAssets28,723 M25,829 M25,788 M28,697 M27,436 M22,085 M22,357 M33,010 M41,822 M
Gross fixed assets (Plant Property & Equipment)22,608 M22,935 M22,960 M24,424 M24,788 M33,584 M47,213 M45,831 M46,207 M
IncomeTaxPayable329 M273 M216 M95 M94 M84 M209 M
Intangibles12,351 M10,302 M10,156 M11,783 M10,876 M10,072 M9,936 M10,730 M13,635 M
Inventories8,678 M8,956 M8,899 M9,565 M9,333 M7,917 M8,159 M8,353 M8,257 M
Invested capital44,222 M48,618 M40,174 M38,461 M34,635 M54,254 M31,094 M35,890 M28,166 M
Leases725 M645 M678 M
LongTermCapitalLeaseObligation21,765 M22,153 M21,517 M22,124 M
LongTermDebtAndCapitalLeaseObligation13,315 M18,705 M12,684 M12,431 M11,098 M33,968 M29,828 M32,132 M30,269 M
Minority interest439 M401 M808 M682 M641 M498 M721 M5,133 M8,469 M
Net fixed assets (net PP&E)15,068 M14,335 M13,642 M13,911 M13,478 M21,453 M34,140 M32,988 M33,254 M
NetUnrealizedGainLossInvestments321 M559 M1,855 M
Non-current deferred income taxes3,538 M2,644 M2,281 M1,815 M1,785 M1,367 M1,850 M1,442 M1,318 M
NonCurrentDeferredLiabilities3,538 M2,644 M2,281 M1,815 M1,785 M1,367 M1,850 M1,442 M1,318 M
NonCurrentDeferredTaxesAssets1,282 M1,653 M1,670 M3,073 M7,380 M12,454 M13,462 M13,859 M15,153 M
NonCurrentPrepaidAssets805 M
Other current assets1,130 M859 M1,025 M923 M1,118 M5,577 M800 M1,059 M1,127 M
Other equity adjustments-214 M-2,992 M-3,051 M-3,002 M-3,897 M-3,771 M
Other fixed assets21,453 M34,140 M32,988 M33,254 M
Other non-current assets4,090 M467 M506 M1,060 M1,133 M5,564 M1,987 M1,730 M2,550 M
Other non-current liabilities4,072 M4,045 M4,223 M5,522 M4,795 M3,222 M3,413 M3,560 M12,018 M
Other receivable131,537 M136,866 M121,982 M132,509 M132,703 M139,081 M
OtherCurrentBorrowings1,068 M323 M251 M1,966 M5,738 M3,265 M1,305 M1,059 M917 M
OtherCurrentLiabilities3,868 M4,086 M4,245 M-302 M5,347 M-64 M326 M-157 M
OtherEquityInterest-3 M-73 M-21 M
OtherInventories2,500 M2,800 M8,159 M8,353 M8,257 M
OtherPayable1,251 M1,325 M1,351 M1,367 M1,702 M1,374 M
Payables10,088 M11,000 M12,823 M13,839 M14,557 M10,240 M11,230 M11,339 M12,844 M
Preferred securities of subsidiary trust32 M32 M
PreferredStock32 M32 M
RecievablesAdjustmentsAllowances-172 M-166 M-158 M-75 M-95 M-26 M-53 M-66 M-110 M
Restricted cash1,270 M2,558 M856 M
Retained earnings25,089 M27,684 M30,137 M33,551 M35,815 M34,210 M33,012 M34,996 M30,065 M
SecuritySoldNotYetRepurchased4,160 M1,589 M110 M
Short term debt1,068 M323 M251 M1,966 M5,738 M3,265 M1,305 M1,059 M917 M
Total assets68,780 M72,687 M66,009 M68,124 M67,598 M87,174 M81,286 M90,124 M96,628 M
Total current assets19,657 M25,882 M19,753 M17,846 M18,700 M18,073 M15,815 M16,901 M15,504 M
Total current liabilities16,557 M17,013 M18,547 M21,667 M25,769 M27,070 M22,054 M22,583 M24,534 M
Total equity30,863 M29,881 M27,466 M26,007 M23,512 M20,637 M23,419 M25,275 M20,021 M
Total liabilities37,482 M42,407 M37,735 M41,435 M43,447 M66,038 M57,145 M59,717 M68,139 M
Total non-current assets49,123 M46,805 M46,256 M50,278 M48,898 M69,101 M65,471 M73,223 M81,123 M
Total non-current liabilities20,925 M25,394 M19,188 M19,768 M17,678 M38,968 M35,091 M37,134 M43,605 M
TotalEquityGrossMinority31,302 M30,282 M28,274 M26,689 M24,153 M21,136 M23,822 M29,366 M28,490 M
TotalEquityGrossMinorityInterest31,302 M30,282 M28,274 M26,689 M24,153 M21,136 M23,822 M29,366 M28,490 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest68,784 M72,689 M66,009 M68,124 M67,598 M87,174 M81,286 M90,124 M96,627 M
TotalNonCurrentLiabilitiesNetMinorityInteres20,925 M25,394 M19,188 M19,768 M17,678 M38,968 M35,091 M37,134 M43,605 M
TotalTaxPayable329 M273 M216 M95 M94 M84 M209 M
Treasury stock-3,977 M-4,934 M-9,971 M-15,047 M-19,057 M-20,575 M-20,593 M-20,683 M-20,717 M
Working capital3,100 M8,869 M1,206 M-3,821 M-7,069 M-8,997 M-6,239 M-5,682 M-9,030 M
debtc1,068 M323 M251 M1,966 M5,738 M5,623 M3,564 M3,345 M3,264 M
ltinv1,242 M6,174 M6,320 M6,610 M6,851 M7,204 M6,987 M5,495 M3,497 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