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

149.73
 
USD
  
-2.36
  
(-1.55%)
Optionable: Yes  Market Cap: 71,713 M  90-day average vol: 4,004,275

Previous close: 152.09  Open: 151.46  Bid: 149.6  Ask: 149.99
52 week range    
102.93   
   181.86
Last updated: Monday 22nd July 2024
61
MarketXLS Rank
95
Value
23
Technical
65
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

TGT Income Statement

Annual
Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24
Amortization of intangibles-22 M-23 M133 M633 M633 M-15 M631 M631 M631 M
Basic EPS from continuing operations3.865.294.625.325.546.398.7214.236.028.96
Basic EPS total-4.145.354.745.556.418.7214.236.028.96
Basic weighted shares outstanding635 M628 M578 M547 M529 M511 M501 M488 M462 M462 M
BasicDiscontinuousOperations-6.440.070.120.010.010.02
Cost of sales51,278 M51,997 M49,145 M51,125 M53,299 M54,864 M66,177 M74,963 M82,229 M77,736 M
Depreciation2,129 M2,213 M2,025 M2,225 M2,224 M2,357 M2,230 M2,344 M2,385 M2,415 M
Depreciation unreconciled2,129 M2,213 M2,025 M2,225 M2,224 M2,357 M2,230 M2,344 M2,385 M2,415 M
DepreciationAndAmortization2,129 M2,213 M2,025 M2,225 M2,224 M2,357 M2,230 M2,344 M2,385 M2,415 M
Diluted EPS total-4.15.314.75.516.368.6414.15.988.94
Diluted normalized net income/share3.835.254.585.295.56.348.6414.15.988.94
Diluted weighted shares outstanding5 M5 M5 M550 M533 M516 M505 M493 M465 M463 M
DilutedDiscontinuousOperations-6.380.070.120.010.010.02
Dividends paid per share1.992.22.362.462.542.622.73.384.144.38
Fees32 M37 M42 M
GainOnSaleOfBusiness335 M
GainOnSaleOfPPE620 M
GainOnSaleOfSecurity11 M-1000000.04 M24 M
GeneralAndAdministrativeExpense-186 M-182 M13,356 M15,723 M16,233 M18,615 M19,752 M20,658 M21,554 M
Gross operating profit21,340 M21,788 M20,350 M21,589 M22,057 M23,248 M27,384 M31,042 M26,891 M29,676 M
ImpairmentOfCapitalAssets-124 M-54 M43 M-62 M
Income before tax3,653 M4,923 M3,965 M3,630 M3,676 M4,190 M5,546 M8,907 M3,418 M5,297 M
Income restructuring and M&A-138 M
Income taxes1,204 M1,602 M1,296 M722 M746 M921 M1,178 M1,961 M638 M1,159 M
InterestExpenseNonOperating882 M607 M1,004 M653 M461 M477 M977 M421 M478 M502 M
InterestExpenseOperating-38 M-42 M49 M
MiscOtherSpecialCharges-39 M4 M59 M27 M9 M-16 M382 M48 M92 M
Net income from total operations2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M4,138 M
NetIncomeCommonStockholders2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M4,138 M
NetIncomeContinuousOperations2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M4,138 M
NetIncomeDiscontinuousOperations-4,085 M42 M68 M7 M12 M
NetNonOperatingInterestIncomeExpense-882 M-607 M-1,004 M-653 M-461 M-477 M-977 M-421 M-478 M-502 M
Normalized income2,620 M4,185 M
Operating income4,535 M4,910 M4,969 M4,224 M4,110 M4,658 M6,539 M8,946 M3,848 M5,707 M
Operating income before depreciation (EBITDA)6,626 M7,701 M7,316 M6,759 M6,611 M7,271 M9,008 M11,970 M6,596 M8,600 M
OperatingExpense16,805 M16,878 M15,381 M17,365 M17,947 M18,590 M20,845 M22,096 M23,043 M23,969 M
Other income net-27 M-620 M-4 M-59 M-27 M-9 M16 M-382 M-48 M-92 M
Other special charges-48 M
OtherGainLossFromDispositionOfDiscontinuedOperations68 M7 M12 M
OtherGandA-186 M-182 M13,356 M15,723 M16,233 M18,615 M19,752 M20,658 M21,554 M
OtherImpairmentOfCapitalAssets-16 M-16 M
OtherOperatingExpenses-29 M-10 M-12 M-58 M-28 M-332 M-32 M-115 M-128 M
PromotionAndAdvertising-1,600 M-1,434 M1,465 M1,494 M1,600 M-1,500 M1,500 M1,500 M1,400 M
RentAndLandingFees-186 M-182 M-54 M
RestructringAndMnAIncome-138 M
Revenue per share-22 M-23 M133 M715 M715 M-105 M758 M764 M767 M
SalariesAndWages-73 M-118 M-43 M-26 M-27 M-96 M-45 M-52 M-56 M
Selling Gen & administrative expense14,676 M14,665 M13,356 M15,140 M15,723 M16,233 M18,615 M19,752 M20,658 M21,554 M
SellingAndMarketingExpense14,676 M14,665 M1,465 M15,140 M1,494 M1,600 M-1,500 M1,500 M1,500 M1,400 M
SellingExpense14,676 M14,665 M15,140 M
Special income/charges124 M192 M-43 M110 M
Total Income available for interest expense (EBIT)4,497 M5,488 M5,018 M4,283 M4,137 M4,667 M6,523 M9,328 M3,896 M5,799 M
Total common shares outstanding642 M600 M553 M539 M516 M501 M499 M462 M460 M462 M
Total net income2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M4,138 M
Total ordinary shares463 M463 M463 M463 M463 M463 M463 M463 M463 M463 M
Total revenues72,618 M73,785 M69,495 M72,714 M75,356 M78,112 M93,561 M106,005 M109,120 M107,412 M
TotalExpenses68,083 M68,875 M64,526 M68,490 M71,246 M73,454 M87,022 M97,059 M105,272 M101,705 M
TotalRevenue72,618 M73,785 M69,495 M71,786 M75,356 M78,112 M93,561 M106,005 M109,120 M107,412 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