Question

A. What is Target Corporation's industry average balance sheet?

Rate Target corporation's performance against its competitors

Answer 1

TARGET CORPORATION BALANCE SHEET
Fiscal year ends in January. USD in millions except per share data.	2018-01	2017-01	2016-01	2015-01	2014-01
Assets
Current assets
Cash
Cash and cash equivalents	2643	2512	4046	2210	695
Total cash	2643	2512	4046	2210	695
Receivables	929	749	779	1122	1347
Inventories	8657	8309	8601	8790	8766
Deferred income taxes				188	177
Prepaid expenses	181	207	214	231	272
Other current assets	154	213	490	1546	316
Total current assets	12564	11990	14130	14087	11573
Non-current assets
Property, plant and equipment
Land	6095	6106	6125	6127	6234
Fixtures and equipment	8268	8154	7964	7899	8347
Other properties	28836	27811	27374	27038	31199
Property and equipment, at cost	43199	42071	41463	41064	45780
Accumulated Depreciation	-18181	-17413	-16246	-15106	-14402
Property, plant and equipment, net	25018	24658	25217	25958	31378
Equity and other investments	383	345	308	322	305
Goodwill	630	133	133	147	151
Intangible assets	152	126	144	155	206
Deferred income taxes					469
Prepaid pension costs	46	43	66
Other long-term assets	206	136	264	735	471
Total non-current assets	26435	25441	26132	27317	32980
Total assets	38999	37431	40262	41404	44553
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	270	1718	815	91	1160
Accounts payable	8677	7252	7418	7759	7683
Taxes payable	696	729	1076	576	890
Accrued liabilities	1872	1721	1793	1770	1733
Other current liabilities	1686	1288	1520	1540	1311
Total current liabilities	13201	12708	12622	11736	12777
Non-current liabilities
Long-term debt	11317	11031	11945	12705	12622
Deferred taxes liabilities	713	861	823	1321	1433
Other long-term liabilities	2059	1878	1915	1645	1490
Total non-current liabilities	14089	13770	14683	15671	15545
Total liabilities	27290	26478	27305	27407	28322
Stockholders' equity
Common stock	45	46	50	53	53
Additional paid-in capital	5858	5661	5348	4899	4470
Retained earnings	6553	5884	8188	9644	12599
Accumulated other comprehensive income	-747	-638	-629	-599	-891
Total stockholders' equity	11709	10953	12957	13997	16231
Total liabilities and stockholders' equity	38999	37431	40262	41404	44553
TARGET CORPORATION INCOME STATEMENT
Fiscal year ends in January. USD in millions except per share data.	2018-01	2017-01	2016-01	2015-01	2014-01
Revenue	71879	69495	73785	72618	72596
Cost of revenue	51125	48872	51997	51278	51160
Gross profit	20754	20623	21788	21340	21436
Operating expenses
Sales, General and administrative	14248	13356	14665	14676	15375
Other operating expenses	2194	2298	2213	2129	2223
Total operating expenses	16442	15654	16878	16805	17598
Operating income	4312	4969	4910	4535	3838
Other income (expense)	-666	-1004	13	-882	-735
Income before income taxes	3646	3965	4923	3653	3103
Provision for income taxes	718	1296	1602	1204	1132
Net income from continuing operations	2928	2669	3321	2449	1971
Net income from discontinuing ops	6	68	42	-4085
Net income	2934	2737	3363	-1636	1971
Net income available to common shareholders	2934	2737	3363	-1636	1971
Earnings per share
Basic	5.36	4.74	5.35	-2.58	3.1
Diluted	5.33	4.7	5.31	-2.58	3.07
Weighted average shares outstanding
Basic	547	578	628	635	635
Diluted	550	582	633	640	642
EBITDA	6757	7267	7123	6664	6061

TARGET CORPORATION PERFORMANCE COMPARASION WITH INDUSTRY AVERAGE
VALUATION RATIOS	TARGET CORP.	INDUSTRY AVERAGE
P/E Ratio TTM	15.79	24.59
Price to Sales TTM	0.54	0.88
Price to Cash Flow MRQ	12.8	32.89
Price to Free Cash Flow TTM	12.8	33.71
Price to Book MRQ	3.37	4.03
Price to Tangible Book MRQ	3.34	4.34
PROFITABILITY RATIO	TARGET CORP.	INDUSTRY AVERAGE
5 Year Avg. (%)
Gross margin TTM	28.96%	30.48%
Gross Margin 5YA	29.37%	31.48%
Operating margin TTM	5.83%	7.05%
Operating margin 5YA	6.68%	7.84%
Pretax margin TTM	5.07%	5.80%
Pretax margin 5YA	5.66%	6.84%
Net Profit margin TTM	3.53%	3.85%
Net Profit margin 5YA	3.81%	4.45%
PER SHARE DATA	TARGET CORP.	INDUSTRY AVERAGE
Revenue/Share TTM	130.64	82.81
Basic EPS	4.65	2.94
Diluted EPS	4.62	2.92
Book Value/Share MRQ	21.62	16.56
Tangible Book Value/Share MRQ	21.62	6.91
Cash/Share MRQ	4.88	3.53
Cash Flow/Share TTM	9.06	5.57
EFFECTIVENESS (5 YRS AGERAGE)	TARGET CORP.	INDUSTRY AVERAGE
Return on Equity TTM	22.42%	19.88%
Return on Equity 5YA	20.03%	18.84%
Return on Assets TTM	6.65%	6.97%
Return on Assets 5YA	6.61%	8.23%
Return on Investment TTM	10.06%	9.72%
Return on Investment 5YA	9.53%	10.97%
GROWTH	TARGET CORP.	INDUSTRY AVERAGE
EPS(MRQ) vs Qtr. 1 Yr. Ago	-10.16%	40.69%
EPS(TTM) vs TTM 1 Yr. Ago	0.43%	5.17%
5 Year EPS Growth	-1.58%	5.56%
Sales (MRQ) vs Qtr. 1 Yr. Ago	10.03%	22.35%
Sales (TTM) vs TTM 1 Yr. Ago	3.43%	20.35%
5 Year Sales Growth	-0.39%	6.98%
5 Year Capital Spending Growth	1.55%	4.35%
FINANCIAL STRENGTH	TARGET CORP.	INDUSTRY AVERAGE
Quick Ratio MRQ	0.3	0.41
Current Ratio MRQ	0.95	1.46
LT Debt to Equity MRQ	96.65%	97.39%
Total Debt to Equity MRQ	98.96%	104.56%
EFFICIENCY	TARGET CORP.	INDUSTRY AVERAGE
Asset Turnover TTM	1.88	1.75
Inventory Turnover TTM	6.02	5.55
Revenue/Employee TTM	208.34K	240.84K
Net Income/Employee TTM	7.36K	8.79K
Receivable Turnover TTM	-	376.28
Dividend	TARGET CORP.	INDUSTRY AVERAGE
Dividend Yield	3.40%	3.80%
Dividend Yield 5 Year Avg.	3.06%	1.64%
Dividend Growth Rate	8.70%	23.41%
Payout Ratio	53.39	41.95
TTM = Trailing Twelve Months 5YA = 5-Year Average MRQ = Most Recent Quarter