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

121.69
 
USD
  
-0.70
  
(-0.57%)
Optionable: Yes  Market Cap: 26,716 M  90-day average vol: 2,936,737

Previous close: 122.39  Open: 122.78  Bid: 120.11  Ask: 121.39
52 week range    
102.77   
   161.10
Peers   
DG / 
BIG / 
TGT / 
WMMVY / 
Last updated: Friday 26th 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 Cash Flow

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
(Increase) Decrease in inventories-68 M-6 M-88 M22 M-301 M-369 M14 M97 M-940 M-1,085 M
(Increase) Decrease in other current assets26 M-12 M-63 M117 M-21 M-8 M2 M-50 M-18 M
(Increase) Decrease in other current liabilities-3 M88 M-164 M30 M-23 M-105 M24 M203 M-36 M-2 M
(Increase) Decrease in other working capital117 M-115 M3 M-6 M81 M-101 M-21 M
(Increase) Decrease in payables3 M28 M197 M-32 M-14 M271 M-77 M166 M400 M-8 M
Acquisitions-6,528 M
AssetImpairmentCharge19 M2,727 M313 M
CapitalExpenditureReported331 M324 M480 M566 M632 M817 M1,035 M899 M1,021 M1,249 M
Cash at beginning of period400 M268 M864 M736 M866 M1,098 M447 M586 M1,464 M1,038 M
Cash at end of period268 M864 M736 M866 M1,098 M447 M586 M1,464 M1,038 M711 M
Cash flow794 M927 M803 M1,673 M1,510 M1,766 M1,870 M2,716 M1,432 M1,615 M
CashFlowFromContinuingInvestingActivities-325 M-315 M-6,978 M-484 M-628 M-817 M-1,020 M-890 M-1,020 M-1,254 M
ChangeInAccountPayable35 M33 M194 M-109 M44 M243 M-80 M143 M404 M17 M
ChangeInIncomeTaxPayable-32 M-5 M3 M77 M-58 M29 M3 M24 M-4 M-24 M
ChangeInPayablesAndAccruedExpense3 M28 M197 M-32 M-14 M271 M-77 M166 M400 M-8 M
ChangeInTaxPayable-32 M-5 M3 M77 M-58 M29 M3 M24 M-4 M-24 M
ChangeInWorkingCapital-41 M97 M-119 M138 M-452 M-222 M-54 M550 M-727 M-1,134 M
CommonStockPayments-1,112 M-200 M-400 M-950 M-647 M
Current deferred income taxes7 M-18 M26 M-124 M-473 M-12 M9 M31 M-23 M123 M
Deferred income taxes7 M-18 M26 M-124 M-473 M-12 M9 M31 M-23 M123 M
Depreciation191 M206 M488 M638 M611 M621 M645 M687 M716 M768 M
Depreciation unreconciled191 M206 M552 M693 M627 M678 M652 M691 M725 M773 M
DepreciationAndAmortization191 M206 M552 M693 M627 M678 M652 M691 M725 M773 M
Effect of exchange rate changes-3 M-800000.0-900000.01 M600000.0-500000.0-500000.0900000.0-400000.0-1 M
FinancingCashFlow-598 M-15 M6,049 M-1,060 M-651 M-1,600 M-710 M-950 M-836 M-687 M
Free cash flow463 M603 M323 M1,108 M878 M949 M835 M1,818 M410 M366 M
IncomeTaxPaidSupplementalData373 M372 M138 M502 M552 M278 M267 M358 M363 M401 M
InterestPaidSupplementalData15 M34 M487 M329 M287 M383 M170 M153 M176 M132 M
IssuanceOfDebt499 M-13 M6,204 M-1,080 M-659 M-1,439 M-500 M-550 M197 M
Net cash from financing activities-598 M-15 M6,049 M-1,060 M-651 M-1,600 M-710 M-950 M-836 M-687 M
Net cash from investing activities-325 M-315 M-6,978 M-484 M-628 M-817 M-1,020 M-890 M-1,020 M-1,254 M
Net cash from operating activities794 M927 M803 M1,673 M1,510 M1,766 M1,870 M2,716 M1,432 M1,615 M
Net change in cash & cash equivalents-132 M596 M-128 M130 M231 M-651 M139 M878 M-425 M-326 M
Net income from continuing operations597 M599 M282 M896 M1,714 M-1,591 M827 M1,342 M1,328 M1,615 M
NetBusinessPurchaseAndSale-6,528 M
NetCommonStockIssuance-1,112 M-200 M-400 M-950 M-647 M
NetForeignCurrencyExchangeGainLoss-100000.0
NetInvestmentPropertiesPurchaseAndSale6 M9 M29 M82 M4 M400000.015 M9 M1 M-5 M
NetInvestmentPurchaseAndSale6 M9 M29 M82 M4 M400000.015 M9 M1 M-5 M
NetIssuancePaymentsOfDebt499 M-13 M6,204 M-1,080 M-659 M-1,439 M-500 M-550 M197 M
NetLongTermDebtIssuance499 M-13 M6,204 M-1,080 M-659 M-1,439 M-500 M-550 M197 M
NetPPEPurchaseAndSale-331 M-324 M-480 M-566 M-632 M-817 M-1,035 M-899 M-1,021 M-1,249 M
Operating (gains) losses-100000.0115 M44 M
Other financing charges net10 M5 M-9 M-22 M-27 M-178 M-25 M-17 M-102 M-49 M
Other investing changes net-300000.0400000.015 M9 M1 M-5 M
Other non-cash items42 M249 M61 M71 M95 M2,798 M435 M104 M86 M238 M
ProceedsFromStockOptionExercised6 M6 M14 M42 M35 M18 M15 M17 M18 M9 M
Purchase of property plant & equipment-331 M-324 M-480 M-566 M-632 M-817 M-1,035 M-899 M-1,021 M-1,249 M
Purchase of short term investments770 M12,130 M2,963 M4,776 M1,197 M
PurchaseOfInvestment-9 M-7 M-24 M-36 M
PurchaseOfLongTermInvestments-9 M-7 M-24 M-36 M
PurchaseOfPPE-331 M-324 M-480 M-566 M-632 M-817 M-1,035 M-899 M-1,021 M-1,249 M
Repayment of debt-271 M-13 M-5,927 M-4,042 M-659 M-6,215 M-500 M-550 M-1,000 M
RepaymentOfDebt-271 M-13 M-5,927 M-4,182 M-659 M-6,265 M-500 M-1,300 M-1,000 M-555 M
Repurchase of capital stock-1,112 M-200 M-400 M-950 M-647 M
Revenue per share65 M55 M15 M57 M7 M4 M9 M5 M
Sale of Float term investments15 M16 M53 M118 M4 M
SaleOfInvestment15 M16 M53 M118 M4 M
ShortTermDebtIssuance140 M50 M750 M555 M
ShortTermDebtPayments-140 M-50 M-750 M-555 M
StockBasedCompensation37 M38 M53 M62 M66 M63 M61 M84 M80 M110 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