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

BBY Stock Annual Balance Sheet. Download in Excel

Best Buy Co. Inc. logo

Best Buy Co. Inc.

Sector: Consumer Cyclical   

Industry: Specialty Retail

86.51
 
USD
  
-0.26
  
(-0.30%)
Previous close: 86.77  Open: 86.8  Bid: 86.0  Ask: 86.99
52 week range    
67.80   
   103.71
Mkt Cap: 18,685 M  Avg Vol (90 Days): 2,825,885
Peers   
CONN / 
GME / 
AAN / 
AMZN / 
VOXX / 
Last updated: Friday 22nd November 2024

Stock Rankings

61
MarketXLS Rank
85
Value
38
Technical
60
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

BBY Balance Sheet

Annual
Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24
Accounts payable5,030 M4,450 M4,984 M4,873 M5,257 M5,288 M6,979 M6,803 M5,687 M4,637 M
Accrued expenses6,825 M6,173 M6,302 M6,820 M6,239 M6,194 M7,951 M7,749 M6,530 M5,539 M
Accumulated depreciation & depletion-5,365 M-5,761 M-5,850 M-6,279 M-6,690 M-6,900 M-6,996 M-6,091 M-4,624 M-4,816 M
Additional paid in capital437 M21 M31 M
Cash and equivalents2,432 M1,976 M2,240 M1,101 M1,980 M2,229 M5,494 M2,936 M1,874 M1,447 M
CashCashEquivalentsAndShortTermInvestments3,888 M3,281 M3,921 M3,133 M1,980 M2,229 M5,494 M2,936 M1,874 M1,447 M
CashEquivalents1,660 M1,208 M1,531 M524 M1,410 M1,668 M3,559 M1,584 M
Common par35 M32 M31 M28 M27 M26 M26 M23 M22 M22 M
Common stock equity4,995 M4,433 M4,709 M3,612 M3,306 M3,479 M4,587 M3,020 M2,795 M3,053 M
CommonStock35 M32 M31 M28 M27 M26 M26 M23 M22 M22 M
Cost in excess425 M425 M425 M425 M915 M984 M986 M1,384 M1,383 M1,383 M
CurrentAccruedExpenses1,565 M1,595 M1,292 M1,947 M982 M906 M972 M946 M843 M902 M
CurrentCapitalLeaseObligation873 M813 M803 M791 M39 M660 M693 M648 M638 M618 M
CurrentDeferredRevenue326 M357 M418 M453 M736 M281 M317 M316 M274 M253 M
CurrentDeferredTaxesAssets898 M901 M676 M389 M328 M1,009 M1,044 M1,076 M967 M1,065 M
CurrentDeferredTaxesLiabilities566 M510 M-359 M159 M-273 M-1,029 M-1,027 M-1,073 M-1,014 M-898 M
Deferred revenues326 M357 M418 M453 M736 M281 M317 M316 M274 M253 M
DividendsPayable-505 M
Float term debt1,572 M1,339 M1,321 M811 M1,332 M1,257 M1,253 M3,277 M3,324 M3,351 M
GoodwillAndOtherIntangibleAssets425 M425 M425 M425 M915 M984 M986 M1,384 M1,383 M1,383 M
Gross fixed assets (Plant Property & Equipment)7,660 M8,107 M8,143 M8,700 M9,200 M11,937 M11,868 M10,995 M9,722 M9,834 M
IncomeTaxPayable230 M128 M26 M137 M
Intangibles18 M373 M458 M476 M532 M532 M532 M
InterestPayable90 M80 M-72 M75 M-73 M-64 M-52 M-25 M-35 M-52 M
Inventories5,174 M5,051 M4,864 M5,209 M5,409 M5,174 M5,612 M5,965 M5,140 M4,958 M
Invested capital6,567 M5,772 M7,351 M4,423 M5,970 M5,993 M7,093 M7,513 M7,279 M7,556 M
Land & improvements2,201 M2,220 M2,227 M2,327 M2,119 M2,203 M2,192 M
Leases119 M272 M2,527 M340 M2,698 M2,203 M2,192 M2,160 M2,260 M2,275 M
LineOfCredit92 M81 M72 M74 M72 M71 M
LongTermCapitalLeaseObligation2,138 M2,012 M2,061 M2,164 M2,199 M
LongTermDebtAndCapitalLeaseObligation1,572 M1,339 M1,321 M811 M1,332 M3,395 M3,265 M3,277 M3,324 M3,351 M
LongTermProvisions37 M
Machinery furniture & equipment4,729 M5,002 M4,998 M5,410 M5,865 M6,286 M6,333 M5,419 M3,928 M4,002 M
Minority interest5 M
Net fixed assets (net PP&E)2,295 M2,346 M2,293 M2,421 M2,510 M5,037 M4,872 M4,904 M5,098 M5,018 M
NetUnrealizedGainLossForeignCurrency279 M
Non-current deferred income taxes251 M296 M-240 M163 M-184 M-237 M-258 M-270 M-169 M-49 M
NonCurrentDeferredRevenue49 M45 M121 M22 M11 M9 M7 M
NonCurrentDeferredTaxesAssets1,041 M1,009 M770 M488 M419 M1,105 M1,171 M1,204 M1,117 M1,240 M
Other current assets1,130 M392 M384 M438 M466 M305 M373 M596 M647 M553 M
Other equity adjustments382 M271 M279 M314 M294 M295 M328 M
Other fixed assets611 M613 M618 M623 M637 M3,448 M3,343 M3,416 M3,534 M3,557 M
Other non-current assets996 M807 M622 M374 M606 M713 M669 M677 M520 M669 M
Other non-current liabilities881 M877 M704 M809 M750 M657 M694 M533 M705 M654 M
Other receivable1,280 M1,162 M1,347 M1,049 M1,015 M1,149 M1,061 M1,042 M1,141 M939 M
OtherCurrentBorrowings110 M
OtherCurrentLiabilities585 M62 M358 M67 M482 M410 M725 M845 M405 M486 M
OtherEquityInterest382 M271 M279 M314 M294 M
OtherInventories4,864 M5,409 M5,174 M5,612 M5,965 M5,140 M4,958 M
OtherPayable561 M649 M-580 M688 M819 M743 M713 M737 M930 M
Payables5,260 M4,578 M5,010 M4,873 M5,257 M5,288 M6,979 M6,803 M5,687 M4,637 M
Preferred securities of subsidiary trust400000.0
PreferredStock400000.0
RecievablesAdjustmentsAllowances-13 M-14 M-32 M-31 M-22 M-23 M
Restricted cash2,433 M2,184 M2,355 M5,625 M3,205 M2,253 M1,793 M
Retained earnings4,141 M4,130 M4,678 M3,270 M3,279 M3,453 M4,561 M2,997 M2,752 M3,000 M
SecuritySoldNotYetRepurchased1,000 M698 M
Short term debt41 M395 M44 M544 M56 M14 M124 M13 M16 M13 M
Total assets15,245 M13,464 M13,856 M13,049 M12,901 M15,591 M19,067 M17,504 M15,803 M14,967 M
Total current assets11,472 M9,886 M10,516 M9,829 M8,870 M8,857 M12,540 M10,539 M8,802 M7,897 M
Total current liabilities7,777 M6,925 M7,122 M7,817 M7,513 M7,559 M9,810 M10,674 M8,979 M7,909 M
Total equity4,995 M4,433 M4,709 M3,612 M3,306 M3,479 M4,587 M3,020 M2,795 M3,053 M
Total liabilities10,245 M9,141 M9,147 M9,437 M9,595 M11,611 M14,480 M13,381 M11,892 M10,914 M
Total non-current assets3,773 M3,578 M3,340 M3,220 M4,031 M6,734 M6,527 M6,965 M7,001 M7,070 M
Total non-current liabilities2,468 M2,216 M2,025 M1,620 M2,082 M4,052 M3,959 M3,810 M4,029 M4,005 M
TotalEquityGrossMinority5,000 M4,433 M4,709 M3,612 M3,306 M3,479 M4,587 M3,020 M2,795 M3,053 M
TotalEquityGrossMinorityInterest5,000 M4,433 M4,709 M3,612 M3,306 M3,479 M4,587 M3,020 M2,795 M3,053 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest15,245 M13,574 M13,856 M13,049 M12,901 M15,591 M19,067 M17,504 M15,803 M14,967 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,468 M2,216 M2,025 M1,620 M2,082 M4,052 M3,959 M3,810 M4,029 M4,005 M
TotalTaxPayable230 M128 M26 M137 M
UnearnedIncome57 M18 M
UnearnedPremiums-7 M-6 M-12 M-11 M-9 M-8 M
Working capital3,695 M2,961 M3,394 M2,012 M1,357 M1,298 M2,730 M-135 M-177 M-12 M
debtc41 M395 M44 M544 M56 M674 M817 M661 M654 M631 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