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

AAP Stock Annual Balance Sheet. Download in Excel

Advance Auto Parts Inc W/I logo

Advance Auto Parts Inc W/I

Sector: Consumer Cyclical   

Industry: Specialty Retail

41.96
 
USD
  
-1.01
  
(-2.35%)
Previous close: 42.97  Open: 43.45  Bid: 41.96  Ask: 42.1
52 week range    
35.59   
   88.56
Mkt Cap: 2,656 M  Avg Vol (90 Days): 2,649,015
Peers   
AZO / 
ORLY / 
GPC / 
MNRO / 
PRTS / 
Last updated: Friday 20th December 2024

Stock Rankings

60
MarketXLS Rank
100
Value
38
Technical
42
Quality
How are these ranks calculated?
Search for a stock

Financials

AAP Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable3,095 M3,204 M3,086 M2,895 M3,173 M3,422 M3,641 M3,922 M4,179 M4,178 M
Accounts receivable580 M598 M641 M606 M625 M689 M750 M783 M684 M800 M
Accrued expenses3,616 M3,757 M3,641 M3,428 M3,796 M3,958 M4,247 M4,699 M4,808 M4,849 M
Accumulated depreciation & depletion-1,919 M-2,038 M-2,189 M-2,404 M-2,590 M-2,858 M
Additional paid in capital563 M603 M631 M665 M695 M735 M784 M845 M898 M946 M
Cash and equivalents105 M91 M135 M547 M897 M419 M835 M601 M271 M503 M
CashCashEquivalentsAndShortTermInvestments105 M91 M135 M547 M897 M419 M835 M601 M271 M503 M
CashEquivalents105 M91 M135 M547 M897 M419 M835 M
Common par7000.07000.08000.08000.08000.08000.08000.08000.08000.08000.0
Common stock equity2,003 M2,461 M2,916 M3,415 M3,551 M3,549 M3,560 M3,128 M2,599 M2,520 M
CommonStock7000.07000.08000.08000.08000.08000.08000.08000.08000.08000.0
Cost in excess995 M989 M991 M994 M990 M992 M994 M994 M991 M992 M
CurrentAccruedExpenses521 M553 M554 M534 M623 M536 M607 M777 M629 M671 M
CurrentCapitalLeaseObligation521 M478 M-463 M-465 M-415 M-445 M
CurrentDeferredTaxesAssets110 M708 M714 M758 M732 M725 M
CurrentDeferredTaxesLiabilities89 M318 M334 M-1,056 M-1,169 M-1,143 M-1,087 M
Float term debt1,636 M1,206 M1,043 M1,044 M1,046 M747 M3,047 M3,372 M3,467 M4,002 M
GoodwillAndOtherIntangibleAssets1,744 M1,677 M1,632 M1,592 M1,541 M1,702 M1,675 M1,645 M1,611 M1,585 M
Gross fixed assets (Plant Property & Equipment)1,432 M1,435 M1,446 M1,394 M3,287 M5,836 M6,032 M6,604 M6,888 M7,085 M
IncomeTaxPayable119 M97 M100 M111 M84 M119 M
Intangibles748 M687 M641 M598 M551 M710 M681 M651 M621 M593 M
Inventories3,937 M4,175 M4,326 M4,168 M4,363 M4,432 M4,538 M4,659 M4,896 M4,858 M
InventoriesAdjustmentsAllowances-116 M
Invested capital3,639 M3,667 M3,959 M4,460 M4,597 M4,296 M7,640 M7,535 M7,254 M8,308 M
Leases45 M
LineOfCredit899 M1,000 M
LongTermCapitalLeaseObligation2,017 M2,014 M2,338 M2,278 M2,216 M
LongTermDebtAndCapitalLeaseObligation1,636 M1,206 M1,043 M1,044 M1,046 M2,764 M3,047 M3,372 M3,467 M4,002 M
Net fixed assets (net PP&E)1,432 M1,435 M1,446 M1,394 M1,369 M3,799 M3,843 M4,200 M4,298 M4,227 M
Non-current deferred income taxes446 M434 M454 M304 M318 M334 M342 M411 M411 M363 M
NonCurrentAccruedExpenses623 M536 M
NonCurrentDeferredLiabilities446 M434 M454 M304 M318 M334 M342 M411 M411 M363 M
NonCurrentDeferredTaxesAssets119 M712 M717 M761 M737 M730 M
Other current assets120 M77 M70 M105 M198 M155 M147 M232 M164 M216 M
Other equity adjustments-12 M-44 M-40 M-25 M-44 M-35 M-27 M
Other fixed assets3,843 M4,200 M4,298 M4,227 M
Other non-current assets46 M76 M64 M69 M48 M52 M52 M74 M62 M87 M
Other non-current liabilities222 M229 M226 M239 M240 M123 M146 M103 M89 M85 M
Other receivable9,581 M9,709 M750 M783 M684 M800 M
OtherCurrentLiabilities38 M40 M35 M52 M90 M520 M496 M481 M427 M458 M
OtherInventories4,010 M4,120 M4,120 M4,291 M4,538 M4,659 M4,896 M4,858 M
OtherPayable194 M270 M70 M121 M133 M
Payables3,095 M3,204 M3,086 M2,895 M3,173 M3,422 M3,641 M3,922 M4,179 M4,178 M
Preferred securities of subsidiary trust10 M10 M
PreferredStock10 M10 M
RecievablesAdjustmentsAllowances-18 M-14 M-12 M-10 M-17 M-28 M
Restricted cash271 M503 M
Retained earnings1,565 M2,021 M2,463 M2,920 M3,326 M3,773 M4,170 M4,583 M4,620 M4,507 M
SecuritySoldNotYetRepurchased281 M498 M
Short term debt582000.0598000.0306000.0185 M
Total assets7,962 M8,128 M8,315 M8,482 M9,041 M11,249 M11,840 M12,194 M11,986 M12,276 M
Total current assets4,741 M4,941 M5,173 M5,427 M6,082 M5,696 M6,270 M6,275 M6,015 M6,377 M
Total current liabilities3,654 M3,797 M3,676 M3,480 M3,886 M4,478 M4,744 M5,180 M5,421 M5,307 M
Total equity2,003 M2,461 M2,916 M3,415 M3,551 M3,549 M3,560 M3,128 M2,599 M2,520 M
Total liabilities5,959 M5,667 M5,399 M5,067 M5,490 M7,699 M8,280 M9,066 M9,387 M9,757 M
Total non-current assets3,221 M3,187 M3,142 M3,055 M2,958 M5,553 M5,570 M5,919 M5,972 M5,899 M
Total non-current liabilities2,305 M1,870 M1,723 M1,587 M1,604 M3,222 M3,536 M3,886 M3,966 M4,449 M
TotalEquityGrossMinority2,003 M2,461 M2,916 M3,415 M3,551 M3,549 M3,560 M3,128 M2,599 M2,520 M
TotalEquityGrossMinorityInterest2,003 M2,461 M2,916 M3,415 M3,551 M3,549 M3,560 M3,128 M2,599 M2,520 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest7,962 M8,128 M8,315 M8,482 M9,041 M11,249 M11,840 M12,194 M11,986 M12,276 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,305 M1,870 M1,723 M1,587 M1,604 M3,222 M3,536 M3,886 M3,966 M4,449 M
Treasury stock-113 M-120 M-138 M-145 M-426 M-924 M-1,394 M-2,300 M-2,919 M-2,933 M
Working capital1,087 M1,143 M1,497 M1,947 M2,197 M1,218 M1,526 M1,095 M594 M1,070 M
debtc582000.0598000.0306000.0185 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