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

Target Corporation

Sector: Consumer Defensive   

Industry: Discount Stores

166.51
 
USD
  
-0.60
  
(-0.36%)
Optionable: Yes  Market Cap: 75,403 M  90-day average vol: 3,829,073

Previous close: 167.11  Open: 167.64  Bid: 166.02  Ask: 167.28
52 week range    
102.93   
   181.86
Peers   
DG / 
WMT / 
COST / 
KSS / 
M / 
DLTR / 
WMMVY / 
Last updated: Wednesday 24th April 2024
48
MarketXLS Rank
45
Value
38
Technical
63
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

TGT Cash Flow

Annual
Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24
(Increase) Decrease in inventories-512 M-316 M293 M-348 M-900 M505 M-1,661 M-3,249 M403 M1,613 M
(Increase) Decrease in other current assets-115 M227 M36 M-156 M-299 M18 M-137 M-78 M22 M-85 M
(Increase) Decrease in other working capital30 M-299 M18 M
(Increase) Decrease in payables777 M579 M-166 M1,307 M1,127 M140 M2,925 M2,628 M-2,237 M-1,216 M
Acquisitions-20 M-518 M
CapitalExpenditureReported1,786 M1,438 M1,547 M2,533 M3,516 M3,027 M2,649 M3,544 M5,528 M4,806 M
Cash at beginning of period695 M2,210 M4,046 M2,512 M2,643 M1,556 M2,577 M8,511 M5,911 M2,229 M
Cash at end of period2,210 M4,088 M2,580 M2,649 M1,563 M2,589 M12,879 M5,911 M2,229 M3,805 M
Cash flow5,131 M5,254 M5,329 M6,861 M5,970 M7,099 M14,893 M8,625 M4,018 M8,621 M
Cash from disc. investing activities-321 M19 M
CashFlowFromContinuingInvestingActivities-1,605 M489 M-1,473 M-3,075 M-3,416 M-2,944 M-2,591 M-3,154 M-5,504 M-4,760 M
CashFromDiscontinuedOperatingActivities-4,777 M746 M175 M80 M10 M30 M
ChangeInAccountPayable777 M579 M-166 M1,307 M1,127 M140 M2,925 M2,628 M-2,237 M-1,216 M
ChangeInAccruedExpense-350 M419 M89 M199 M1,931 M-746 M-624 M727 M
ChangeInInterestPayable419 M
ChangeInPayablesAndAccruedExpense777 M579 M-516 M1,726 M1,216 M339 M4,856 M1,882 M-2,861 M-489 M
ChangeInWorkingCapital150 M490 M-193 M1,222 M17 M862 M3,058 M-1,445 M-2,436 M1,039 M
CommonStockDividendPaid-1,205 M-1,362 M-1,348 M-1,338 M-1,335 M-1,330 M-1,343 M-1,548 M-1,836 M-2,011 M
CommonStockPayments-3,483 M-3,706 M-1,046 M-2,124 M-1,565 M-745 M-7,356 M-2,646 M
Current deferred income taxes7 M-322 M41 M-188 M322 M178 M-184 M522 M582 M298 M
Deferred income taxes7 M-322 M41 M-188 M322 M178 M-184 M522 M582 M298 M
Depreciation2,129 M2,213 M2,298 M2,476 M2,474 M2,604 M2,485 M2,642 M2,700 M2,801 M
Depreciation unreconciled2,129 M2,213 M2,298 M2,476 M2,474 M2,604 M2,485 M2,344 M2,700 M2,801 M
DepreciationAndAmortization2,129 M2,213 M2,298 M2,476 M2,474 M2,604 M2,485 M2,344 M2,700 M2,801 M
FinancingCashFlow-998 M-4,630 M-5,497 M-3,729 M-3,644 M-3,152 M-2,000 M-8,071 M-2,196 M-2,285 M
Free cash flow3,440 M4,590 M4,003 M4,439 M2,549 M4,165 M12,286 M5,108 M-1,502 M3,839 M
GainLossOnSaleOfBusiness-335 M
GainLossOnSaleOfPPE-620 M
IncomeTaxPaidSupplementalData1,251 M-127 M1,514 M934 M373 M696 M1,031 M2,063 M213 M374 M
InterestPaidSupplementalData871 M604 M999 M678 M476 M492 M939 M414 M449 M605 M
IssuanceOfDebt-86 M-85 M-664 M-1,453 M-281 M-330 M65 M825 M2,462 M-147 M
Net cash from financing activities-998 M-4,630 M-5,497 M-3,729 M-3,644 M-3,152 M-2,000 M-8,071 M-2,196 M-2,285 M
Net cash from investing activities-1,926 M508 M-1,473 M-3,075 M-3,416 M-2,944 M-2,591 M-3,154 M-5,504 M-4,760 M
Net cash from operating activities5,131 M6,000 M5,504 M6,941 M5,980 M7,129 M14,893 M8,625 M4,018 M8,621 M
Net change in cash & cash equivalents-2,570 M1,878 M-1,466 M137 M-1,080 M1,033 M10,302 M-2,600 M-3,682 M1,576 M
Net income from continuing operations2,449 M3,321 M2,669 M2,908 M2,930 M3,269 M8,736 M6,946 M2,780 M4,138 M
NetBusinessPurchaseAndSale-20 M1,875 M-518 M356 M
NetCommonStockIssuance-3,483 M-3,706 M-1,046 M-2,124 M-1,565 M-745 M-7,356 M-2,646 M
NetInvestmentPropertiesPurchaseAndSale106 M24 M28 M-55 M15 M20 M16 M7 M16 M22 M
NetInvestmentPurchaseAndSale106 M24 M28 M-55 M15 M20 M16 M7 M16 M22 M
NetIssuancePaymentsOfDebt-86 M-85 M-664 M-1,453 M-281 M-330 M65 M825 M2,462 M-147 M
NetLongTermDebtIssuance-86 M-85 M-664 M-1,453 M-281 M-330 M65 M825 M2,462 M-147 M
NetPPEPurchaseAndSale-1,691 M-1,410 M-1,501 M-2,502 M-3,431 M-2,964 M-2,607 M27 M-5,520 M-4,782 M
Operating (gains) losses285 M-620 M422 M123 M10 M512 M-335 M
Other financing charges net-80 M-180 M-127 M
Other investing changes net106 M24 M28 M-55 M15 M20 M16 M7 M16 M22 M
Other non-cash items111 M172 M92 M320 M227 M176 M286 M67 M392 M345 M
Payment of cash dividends1,205 M1,362 M1,348 M1,338 M1,335 M1,330 M1,343 M1,548 M1,836 M2,011 M
ProceedsFromStockOptionExercised373 M300 M221 M108 M96 M73 M23 M8 M4 M
Purchase of property plant & equipment-1,691 M-1,410 M-1,501 M-2,502 M-3,431 M-2,964 M-2,607 M-3,544 M-5,520 M-4,782 M
Purchase of short term investments1,993 M1,977 M739 M1,739 M2,480 M1,972 M2,625 M
PurchaseOfPPE-1,786 M-1,438 M-1,547 M-2,533 M-3,516 M-3,027 M-2,649 M-3,544 M-5,528 M-4,806 M
Repayment of debt-2,079 M-85 M-2,641 M-2,192 M-281 M-2,069 M-2,415 M-1,147 M-163 M-147 M
RepaymentOfDebt-2,079 M-85 M-2,641 M-2,192 M-281 M-2,069 M-2,415 M-1,147 M-163 M-147 M
Repurchase of capital stock-3,483 M-3,706 M-1,046 M-2,124 M-1,565 M-745 M-7,356 M-2,646 M
SaleOfBusiness1,875 M356 M
SaleOfPPE95 M28 M46 M31 M85 M63 M42 M27 M8 M24 M
StockBasedCompensation71 M115 M113 M112 M132 M147 M200 M228 M220 M251 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