Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Dollar Tree Inc. logo

Dollar Tree Inc.

Sector: Consumer Defensive   

Industry: Discount Stores

122.56
 
USD
  
0.87
  
(0.71%)
Optionable: Yes  Market Cap: 27,043 M  90-day average vol: 2,951,043

Previous close: 121.69  Open: 121.82  Bid: 121.61  Ask: 122.55
52 week range    
102.77   
   161.10
Peers   
DG / 
BIG / 
TGT / 
WMMVY / 
Last updated: Wednesday 24th April 2024
47
MarketXLS Rank
50
Value
23
Technical
68
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

DLTR Balance Sheet

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
"""debtc"""13 M108 M152 M916 M1,529 M1,348 M1,408 M1,450 M
Accounts payable394 M434 M1,252 M1,120 M1,175 M1,416 M1,337 M1,481 M1,884 M1,900 M
Accounts receivable101 M113 M
Accrued expenses441 M476 M1,265 M1,210 M1,206 M1,476 M1,399 M1,567 M1,967 M1,958 M
Accumulated depreciation & depletion-1,616 M-1,760 M-2,172 M-2,694 M-3,192 M-3,691 M-4,194 M-4,765 M-5,364 M-6,025 M
Additional paid in capital11 M43 M2,391 M2,472 M2,545 M2,603 M2,454 M2,139 M1,244 M668 M
Cash and equivalents268 M864 M736 M866 M1,098 M422 M539 M1,417 M985 M643 M
CashCashEquivalentsAndShortTermInvestments268 M864 M740 M870 M1,098 M422 M539 M1,417 M985 M643 M
CashEquivalents268 M864 M736 M554 M1,098 M170 M288 M1,135 M681 M317 M
Common par2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Common stock equity1,171 M1,785 M4,407 M5,390 M7,182 M5,643 M6,255 M7,285 M7,719 M8,752 M
CommonStock2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Cost in excess169 M165 M5,022 M5,024 M5,025 M2,297 M1,983 M1,984 M1,984 M1,983 M
CurrentCapitalLeaseObligation516 M559 M1,235 M1,370 M1,382 M1,436 M1,279 M1,348 M1,408 M1,450 M
CurrentDeferredAssets19 M28 M
CurrentDeferredTaxesAssets19 M28 M203 M248 M144 M166 M1,785 M1,878 M1,854 M1,851 M
CurrentDeferredTaxesLiabilities43 M59 M1,587 M-1,707 M985 M-1,139 M-2,745 M-2,868 M-2,821 M-2,941 M
Float term debt757 M683 M7,238 M6,170 M4,762 M4,300 M3,800 M3,250 M3,417 M3,422 M
GoodwillAndOtherIntangibleAssets169 M166 M8,697 M8,597 M8,501 M5,685 M5,083 M5,084 M5,084 M5,083 M
Gross fixed assets (Plant Property & Equipment)2,710 M2,970 M2,321 M5,810 M3,292 M7,136 M14,301 M15,205 M16,266 M17,456 M
IncomeTaxPayable47 M43 M13 M90 M32 M60 M63 M86 M83 M58 M
Intangibles3 M1 M3,675 M3,574 M3,475 M3,389 M3,100 M3,100 M3,100 M3,100 M
InterestPayable2 M48 M93 M85 M91 M29 M
Inventories1,035 M1,036 M2,886 M2,866 M3,169 M3,536 M3,522 M3,427 M4,367 M5,449 M
InventoriesAdjustmentsAllowances-73 M
Invested capital1,928 M2,468 M11,645 M17,729 M11,944 M14,208 M13,577 M13,762 M19,698 M20,850 M
Leases149 M124 M100 M79 M
LongTermCapitalLeaseObligation4,980 M5,066 M5,146 M5,255 M
LongTermDebtAndCapitalLeaseObligation757 M683 M7,238 M6,170 M4,762 M4,265 M8,502 M8,292 M8,563 M8,677 M
LongTermProvisions149 M
Net fixed assets (net PP&E)1,094 M1,211 M149 M3,116 M100 M3,445 M10,107 M10,440 M10,903 M11,430 M
Non-current deferred income taxes47 M49 M1,587 M1,459 M985 M973 M985 M1,014 M987 M1,106 M
NonCurrentAccruedExpenses6 M7 M71 M71 M44 M35 M29 M23 M21 M17 M
NonCurrentDeferredAssets24 M31 M24 M23 M20 M15 M
NonCurrentDeferredLiabilities1,587 M1,459 M985 M973 M985 M1,014 M987 M1,106 M
NonCurrentDeferredRevenue11 M13 M46 M123 M34 M46 M
NonCurrentDeferredTaxesAssets24 M31 M252 M298 M182 M209 M24 M23 M20 M15 M
Number of employees210565.0210565.0210565.0210565.0210565.0210565.0210565.0210565.0210565.0210565.0
Other current assets6 M67 M310 M9 M309 M335 M208 M207 M257 M275 M
Other equity adjustments-17 M-34 M-43 M-38 M-32 M
Other fixed assets106 M90.0130.03,116 M3,445 M10,107 M10,440 M10,903 M11,430 M
Other non-current assets106 M91 M131 M42 M55 M77 M91 M97 M105 M127 M
Other non-current liabilities152 M157 M353 M506 M400 M410 M258 M353 M256 M245 M
Other receivable22,246 M22,823 M23,611 M25,508 M26,310 M28,318 M
OtherCurrentLiabilities232 M385 M723 M744 M737 M698 M618 M815 M802 M818 M
OtherInventories1,035 M1,036 M2,886 M2,866 M3,169 M3,536 M3,522 M3,427 M4,367 M5,449 M
OtherPayable6,528 M-565 M632 M43 M51 M45 M68 M
Payables441 M476 M1,265 M1,210 M1,206 M1,476 M1,399 M1,567 M1,967 M1,958 M
Preferred securities of subsidiary trust10 M10 M10 M10 M10 M
PreferredStock10 M10 M10 M10 M10 M
Prepaid expenses57 M67 M310 M202 M309 M335 M
Retained earnings1,175 M1,774 M2,056 M2,915 M4,667 M3,038 M3,798 M5,145 M6,472 M8,082 M
SecuritySoldNotYetRepurchased200 M400 M950 M648 M
Short term debt13 M108 M152 M916 M250 M
Total assets2,772 M3,493 M15,901 M15,702 M16,333 M13,501 M19,575 M20,696 M21,722 M23,022 M
Total current assets1,379 M1,995 M3,936 M3,947 M4,576 M4,293 M4,269 M5,051 M5,609 M6,367 M
Total current liabilities686 M862 M2,095 M2,106 M2,859 M2,175 M3,547 M3,730 M4,177 M4,225 M
Total equity1,171 M1,785 M4,407 M5,390 M7,182 M5,643 M6,255 M7,285 M7,719 M8,752 M
Total liabilities1,601 M1,708 M11,494 M10,312 M9,151 M7,858 M13,320 M13,411 M14,003 M14,271 M
Total non-current assets1,393 M1,498 M8,989 M11,755 M8,656 M9,208 M15,305 M15,645 M16,113 M16,655 M
Total non-current liabilities915 M846 M9,250 M8,206 M6,191 M5,684 M9,773 M9,680 M9,827 M10,045 M
TotalEquityGrossMinority1,171 M1,785 M4,407 M5,390 M7,182 M5,643 M6,255 M7,285 M7,719 M8,752 M
TotalEquityGrossMinorityInterest1,171 M1,785 M4,407 M5,390 M7,182 M5,643 M6,255 M7,285 M7,719 M8,752 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,772 M3,493 M15,901 M15,702 M16,333 M13,501 M19,575 M20,696 M21,722 M23,022 M
TotalNonCurrentLiabilitiesNetMinorityInteres915 M846 M9,250 M8,206 M6,191 M5,684 M9,773 M9,680 M9,827 M10,045 M
TotalTaxPayable47 M43 M13 M90 M32 M60 M63 M86 M83 M58 M
UnearnedIncome300000.012 M9 M
UnearnedPremiums119 M70 M55 M35 M28 M24 M33 M28 M
Working capital692 M1,133 M1,841 M1,841 M1,717 M2,119 M723 M1,321 M1,433 M2,142 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