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

Optionable: Yes  Market Cap: 67,453 M  90-day average vol: 3,543,143

Previous close: 148.51  Open: 150.0  Bid: 149.59  Ask: 150.75
52 week range    
DG / 
WMT / 
KSS / 
M / 
Last updated: Wednesday 21st February 2024
MarketXLS Rank

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


TGT Income Statement

Amortization of intangibles151 M-22 M-23 M133 M633 M633 M-15 M
Basic EPS from continuing operations3.13.865.294.625.325.546.398.7214.236.02
Basic EPS total3.1-4.145.354.745.556.418.7214.236.02
Basic weighted shares outstanding635 M635 M628 M578 M547 M529 M511 M501 M488 M462 M
Cost of sales50,039 M51,278 M51,997 M49,145 M51,125 M53,299 M54,864 M66,177 M74,963 M82,229 M
Depreciation1,996 M2,129 M2,213 M2,025 M2,225 M2,224 M2,357 M2,230 M2,385 M
Depreciation unreconciled1,996 M2,129 M2,213 M2,025 M2,225 M2,224 M2,357 M2,230 M2,344 M2,385 M
DepreciationAndAmortization1,996 M2,129 M2,213 M2,025 M2,225 M2,224 M2,357 M2,230 M2,344 M2,385 M
Diluted EPS total3.07-4.15.314.75.516.368.6414.15.98
Diluted normalized net income/share3.073.835.254.585.295.56.348.6414.15.98
Diluted weighted shares outstanding649 M5 M5 M5 M550 M533 M516 M505 M493 M465 M
Dividends paid per share1.651.992.22.362.462.542.622.73.384.14
Fees29 M32 M37 M42 M
GainOnSaleOfBusiness4 M
GainOnSaleOfPPE620 M
GainOnSaleOfSecurity-5 M11 M-1000000.0
GeneralAndAdministrativeExpense14,465 M-186 M-182 M13,356 M15,723 M16,233 M18,615 M20,658 M
Gross operating profit21,240 M21,340 M21,788 M20,350 M21,589 M22,057 M23,248 M27,384 M31,042 M26,891 M
ImpairmentOfCapitalAssets-124 M-54 M43 M-62 M-66 M
Income before tax4,121 M3,653 M4,923 M3,965 M3,630 M3,676 M4,190 M5,546 M8,907 M3,418 M
Income restructuring and M&A23 M-138 M
Income taxes1,427 M1,204 M1,602 M1,296 M722 M746 M921 M1,178 M1,961 M638 M
InterestExpenseNonOperating1,049 M882 M607 M1,004 M653 M461 M477 M977 M421 M478 M
InterestExpenseOperating39 M-38 M-42 M49 M
MiscOtherSpecialCharges4,103 M-39 M4 M59 M27 M9 M-16 M382 M48 M
Net income from total operations1,971 M2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M
NetIncomeCommonStockholders1,971 M2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M
NetIncomeContinuousOperations1,971 M2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M
NetIncomeDiscontinuousOperations-723 M-4,085 M42 M68 M7 M12 M
NetNonOperatingInterestIncomeExpense-1,049 M-882 M-607 M-1,004 M-653 M-461 M-477 M-977 M-421 M-478 M
Normalized income2,721 M2,620 M2,904 M3,310 M6,702 M
Operating income4,779 M4,535 M4,910 M4,969 M4,224 M4,110 M4,658 M6,539 M8,946 M3,848 M
Operating income before depreciation (EBITDA)7,205 M6,626 M7,701 M7,316 M6,759 M6,611 M7,271 M9,008 M11,970 M6,596 M
OperatingExpense16,461 M16,805 M16,878 M15,381 M17,365 M17,947 M18,590 M20,845 M22,096 M23,043 M
Other income net24 M-27 M-620 M-4 M-59 M-27 M-9 M16 M-382 M-48 M
Other special charges-48 M-49 M
OtherGainLossFromDispositionOfDiscontinuedOperations-723 M68 M7 M12 M
OtherGandA14,465 M-186 M-182 M13,356 M15,723 M16,233 M18,615 M20,658 M
OtherImpairmentOfCapitalAssets19 M-16 M-16 M
OtherOperatingExpenses-15 M-29 M-10 M-12 M-58 M-28 M-332 M-467 M
PromotionAndAdvertising1,548 M-1,600 M-1,434 M1,465 M1,494 M1,600 M-1,500 M-1,500 M
RentAndLandingFees-8 M-186 M-182 M-54 M
RestructringAndMnAIncome23 M-138 M
Revenue per share151 M-22 M-23 M133 M715 M715 M-105 M-133 M
SalariesAndWages-41 M-73 M-118 M-43 M-26 M-27 M-96 M-52 M
Selling Gen & administrative expense14,465 M14,676 M14,665 M13,356 M15,140 M15,723 M16,233 M18,615 M19,752 M20,658 M
SellingAndMarketingExpense1,548 M14,676 M14,665 M1,465 M15,140 M1,494 M1,600 M-1,500 M-1,500 M
SellingExpense14,676 M14,665 M15,140 M
Special income/charges-23 M124 M192 M-43 M110 M115 M
Total Income available for interest expense (EBIT)5,209 M4,497 M5,488 M5,018 M4,283 M4,137 M4,667 M6,523 M9,328 M3,896 M
Total common shares outstanding633 M642 M600 M553 M539 M516 M501 M499 M462 M460 M
Total net income1,971 M2,449 M3,321 M2,737 M2,908 M2,937 M3,281 M4,368 M6,946 M2,780 M
Total ordinary shares462 M462 M462 M462 M462 M462 M462 M462 M462 M462 M
Total revenues71,279 M72,618 M73,785 M69,495 M72,714 M75,356 M78,112 M93,561 M104,611 M109,120 M
TotalExpenses66,500 M68,083 M68,875 M64,526 M68,490 M71,246 M73,454 M87,022 M97,059 M105,272 M
TotalRevenue71,279 M72,618 M73,785 M69,495 M71,786 M75,356 M78,112 M93,561 M106,005 M109,120 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.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu


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.


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