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

165.34
 
USD
  
-1.17
  
(-0.70%)
Optionable: Yes  Market Cap: 76,876 M  90-day average vol: 3,828,779

Previous close: 166.51  Open: 165.03  Bid: 164.5  Ask: 166.0
52 week range    
102.93   
   181.86
Peers   
DG / 
WMT / 
COST / 
KSS / 
M / 
DLTR / 
WMMVY / 
Last updated: Thursday 25th 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 Balance Sheet

Annual
Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24
"""debtc"""815 M1,718 M281 M1,052 M161 M1,144 M171 M130 M1,116 M
Accounts payable7,759 M7,418 M7,252 M8,677 M9,761 M9,920 M12,859 M15,478 M13,487 M12,098 M
Accounts receivable498 M631 M835 M1,169 M891 M
Accrued expenses11,542 M11,654 M10,989 M12,771 M13,962 M14,326 M18,981 M21,576 M19,370 M18,188 M
Accumulated depreciation & depletion-15,093 M-16,246 M-17,413 M-18,398 M-18,687 M-19,664 M-20,278 M-21,137 M-22,631 M-24,413 M
Additional paid in capital4,899 M5,348 M5,661 M5,858 M6,042 M6,226 M6,329 M6,421 M6,608 M6,761 M
Building & improvements26,613 M27,059 M27,611 M28,131 M29,240 M30,603 M31,557 M32,985 M34,746 M37,066 M
Cash and equivalents2,210 M4,046 M2,512 M2,643 M1,556 M2,577 M8,511 M5,911 M2,229 M3,805 M
CashCashEquivalentsAndShortTermInvestments2,210 M4,046 M2,512 M2,643 M1,556 M2,577 M8,511 M5,911 M2,229 M3,805 M
CashEquivalents2,210 M4,046 M2,512 M2,643 M1,556 M
Common par53 M365 M46 M45 M43 M42 M42 M39 M38 M38 M
Common stock equity13,997 M12,957 M10,953 M11,651 M11,297 M11,833 M14,440 M12,827 M11,232 M13,432 M
CommonStock53 M365 M46 M45 M43 M42 M42 M39 M38 M38 M
Construction in progress424 M200 M440 M460 M533 M780 M1,257 M2,688 M1,703 M
Cost in excess147 M133 M133 M630 M633 M633 M631 M631 M631 M631 M
CurrentAccruedExpenses3,783 M4,236 M3,737 M4,094 M4,201 M4,406 M6,122 M6,098 M5,883 M6,090 M
CurrentCapitalLeaseObligation186 M186 M198 M148 M166 M200 M211 M2,075 M2,072 M2,653 M
CurrentDeferredRevenue840 M935 M
CurrentDeferredTaxesAssets188 M270 M258 M164 M157 M148 M141 M133 M125 M118 M
CurrentDeferredTaxesLiabilities1,130 M790 M-2,106 M659 M-2,523 M-2,877 M3,227 M-3,750 M-4,527 M-4,978 M
DefinedPensionBenefit3,834 M1,500 M1,566 M4,117 M3,925 M4,441 M4,599 M4,449 M3,708 M3,514 M
DividendsPayable333 M337 M-1,359 M336 M-1,347 M-1,345 M1,367 M-1,655 M-1,931 M-2,050 M
Float term debt12,725 M11,945 M11,031 M11,117 M12,227 M13,613 M13,549 M18,647 M18,201 M
GoodwillAndOtherIntangibleAssets2,617 M2,651 M2,645 M2,544 M2,692 M2,765 M2,505 M3,039 M3,428 M
Gross fixed assets (Plant Property & Equipment)41,045 M38,531 M39,420 M42,173 M43,641 M45,491 M46,619 M51,874 M53,761 M57,443 M
IncomeTaxPayable550 M574 M571 M670 M601 M129 M473 M
Intangibles405 M2,617 M2,651 M2,645 M2,544 M2,692 M2,765 M2,505 M3,039 M3,428 M
InterestPayable882 M607 M1,004 M653 M461 M69 M79 M77 M94 M122 M
Inventories8,282 M8,601 M8,309 M8,597 M9,497 M8,992 M10,653 M13,902 M13,499 M11,886 M
Invested capital28,872 M24,902 M33,015 M22,768 M33,747 M36,784 M25,976 M42,418 M45,888 M46,555 M
Land & improvements6,127 M6,125 M6,106 M6,095 M6,064 M6,036 M6,141 M6,164 M6,231 M6,547 M
Leases872 M1,180 M1,504 M1,652 M1,673 M1,470 M
LineOfCredit1,500 M2,000 M2,600 M1,600 M
LongTermCapitalLeaseObligation789 M859 M1,025 M1,924 M2,004 M2,275 M2,218 M2,493 M2,638 M3,279 M
LongTermDebtAndCapitalLeaseObligation12,725 M11,945 M11,031 M13,041 M12,227 M13,613 M13,754 M16,042 M18,647 M18,201 M
Machinery furniture & equipment5,329 M5,347 M5,503 M5,623 M5,912 M6,083 M5,914 M8,912 M7,439 M8,765 M
Net fixed assets (net PP&E)25,952 M22,285 M22,007 M23,775 M24,954 M25,827 M26,341 M30,737 M31,130 M33,030 M
NetOtherUnrealizedGainLoss620 M772 M837 M583 M696 M
Non-current deferred income taxes1,160 M823 M861 M693 M972 M1,122 M990 M1,566 M2,196 M2,480 M
NonCurrentAccruedExpenses128 M122 M125 M332 M312 M194 M436 M139 M168 M272 M
NonCurrentDeferredLiabilities1,160 M823 M861 M693 M972 M1,122 M990 M1,566 M2,196 M2,480 M
NonCurrentDeferredRevenue660 M630 M600 M570 M539 M509 M479 M449 M419 M
NonCurrentDeferredTaxesAssets1,246 M1,358 M1,281 M826 M1,563 M1,763 M2,257 M2,189 M2,337 M2,506 M
NonCurrentPensionAndOtherPostretirementBenefitPlans151 M54 M46 M41 M40 M107 M57 M45 M37 M33 M
Number of employees440000.0440000.0440000.0440000.0440000.0440000.0440000.0440000.0440000.0440000.0
Other current assets3,132 M1,483 M1,169 M1,300 M1,466 M1,333 M1,592 M1,760 M2,118 M1,807 M
Other equity adjustments-599 M-629 M-638 M-747 M-805 M-553 M
Other fixed assets1,884 M1,965 M2,236 M2,227 M2,556 M2,657 M3,362 M
Other non-current assets1,596 M915 M783 M1,343 M1,273 M1,358 M1,386 M1,501 M1,320 M1,400 M
Other non-current liabilities1,452 M1,897 M1,879 M1,866 M1,780 M1,724 M1,939 M1,629 M1,760 M1,939 M
Other receivable72,714 M75,356 M78,112 M93,561 M106,005 M109,120 M107,412 M
OtherCurrentLiabilities103 M153 M686 M796 M830 M826 M1,507 M1,620 M1,492 M1,535 M
OtherEquityInterest-599 M-629 M-638 M720 M772 M837 M735 M583 M
OtherInventories8,309 M9,497 M8,992 M10,653 M13,902 M13,499 M11,886 M
Payables7,759 M7,418 M7,252 M8,677 M9,761 M9,920 M12,859 M15,478 M13,487 M12,098 M
Prepaid expenses231 M214 M207 M157 M157 M154 M171 M170 M188 M201 M
Properties2,552 M2,617 M
Retained earnings9,644 M8,188 M5,246 M6,495 M5,212 M5,565 M8,069 M6,920 M4,586 M6,633 M
Short term debt815 M1,718 M281 M1,052 M161 M1,144 M171 M130 M1,116 M
Total assets41,172 M40,262 M37,431 M40,303 M41,290 M42,779 M51,248 M53,811 M53,335 M55,356 M
Total current assets13,624 M14,130 M11,990 M12,540 M12,519 M12,902 M20,756 M21,573 M17,846 M17,498 M
Total current liabilities11,645 M12,622 M12,707 M13,052 M15,014 M14,487 M20,125 M21,747 M19,500 M19,304 M
Total equity13,997 M12,957 M10,953 M11,651 M11,297 M11,833 M14,440 M12,827 M11,232 M13,432 M
Total liabilities27,175 M27,305 M26,478 M28,652 M29,993 M30,946 M36,808 M40,984 M42,103 M41,924 M
Total non-current assets27,548 M25,817 M25,441 M27,763 M28,771 M29,877 M30,492 M32,238 M35,489 M37,858 M
Total non-current liabilities15,530 M14,683 M13,771 M15,600 M14,979 M16,459 M16,683 M19,237 M22,603 M22,620 M
TotalEquityGrossMinority13,997 M13,272 M10,953 M11,651 M11,297 M11,833 M14,440 M12,827 M11,232 M13,432 M
TotalEquityGrossMinorityInterest13,997 M13,272 M10,953 M11,651 M11,297 M11,833 M14,440 M12,827 M11,232 M13,432 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest41,172 M40,262 M37,431 M40,303 M41,290 M42,779 M51,248 M53,811 M53,335 M55,356 M
TotalNonCurrentLiabilitiesNetMinorityInteres15,530 M14,683 M13,771 M15,600 M14,979 M16,459 M16,683 M19,237 M22,603 M22,620 M
Working capital1,979 M1,508 M-717 M-512 M-2,495 M-1,585 M631 M-174 M-1,654 M-1,806 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