Annual Financials for Target Corp.

View Ratios

Fiscal year is February-January. All values USD millions.	2013	2014	2015	2016	2017	5-year trend
Sales/Revenue	73.3B	71.28B	72.62B	73.79B	69.5B
Sales Growth	-	-2.76%	1.88%	1.61%	-5.81%
Cost of Goods Sold (COGS) incl. D&A	53.18B	52.04B	53.41B	54.21B	51.17B
COGS excluding D&A	51.04B	50.04B	51.28B	52B	48.87B
Depreciation & Amortization Expense	2.14B	2B	2.13B	2.21B	2.3B
Depreciation	2.12B	1.98B	2.11B	2.19B	2.28B
Amortization of Intangibles	22M	20M	22M	23M	18M
COGS Growth	-	-2.15%	2.64%	1.50%	-5.61%
Gross Income	20.12B	19.24B	19.21B	19.58B	18.33B
Gross Income Growth	-	-4.37%	-0.17%	1.89%	-6.39%
Gross Profit Margin	-	-	-	-	26.37%	NA

2013

2014

2015

2016

2017

5-year trend

SG&A Expense

14.88B

15.02B

15.04B

15.04B

13.95B

Research & Development

-

-

-

-

-

Other SG&A

14.88B

15.02B

15.04B

15.04B

13.95B

SGA Growth

-

0.99%

0.08%

0.03%

-7.28%

Other Operating Expense

-

-

-

-

-

Unusual Expense

(7M)

510M

237M

230M

472M

EBIT after Unusual Expense

5.25B

(510M)

(237M)

4.31B

3.91B

Non Operating Income/Expense

161M

1.04B

629M

1.26B

668M

Non-Operating Interest Income

-

-

-

-

-

Equity in Affiliates (Pretax)

-

-

-

-

-

Interest Expense

806M

633M

914M

645M

611M

Interest Expense Growth

-

-21.46%

44.39%

-29.43%

-5.27%

Gross Interest Expense

818M

647M

915M

661M

631M

Interest Capitalized

12M

14M

1M

16M

20M

Pretax Income

4.61B

4.12B

3.65B

4.92B

3.97B

Pretax Income Growth

-

-10.59%

-11.36%

34.77%

-19.46%

Pretax Margin

-

-

-

-

5.71%

NA

Income Tax

1.61B

1.43B

1.2B

1.6B

1.3B

Income Tax - Current Domestic

1.61B

1.36B

1.19B

1.92B

1.25B

Income Tax - Current Foreign

18M

13M

7M

7M

6M

Income Tax - Deferred Domestic

138M

56M

8M

(322M)

42M

Income Tax - Deferred Foreign

(152M)

2M

(1M)

-

(1M)

Income Tax Credits

-

-

-

-

-

Equity in Affiliates

-

-

-

-

-

Other After Tax Income (Expense)

-

-

-

-

-

Consolidated Net Income

3B

2.69B

2.45B

3.32B

2.67B

Minority Interest Expense

-

-

-

-

-

Net Income

3B

2.69B

2.45B

3.32B

2.67B

Net Income Growth

-

-10.17%

-9.09%

35.61%

-19.63%

Net Margin Growth

-

-

-

-

3.84%

NA

Extraordinaries & Discontinued Operations

-

(723M)

(4.09B)

42M

68M

Extra Items & Gain/Loss Sale Of Assets

-

-

-

-

-

Cumulative Effect - Accounting Chg

-

-

-

-

-

Discontinued Operations

-

(723M)

(4.09B)

42M

68M

Net Income After Extraordinaries

3B

1.97B

(1.64B)

3.36B

2.74B

Preferred Dividends

-

-

-

-

-

Net Income Available to Common

3B

1.97B

(1.64B)

3.36B

2.74B

EPS (Basic)

4.57

3.10

(2.58)

5.36

4.74

EPS (Basic) Growth

-

-32.17%

-183.23%

307.66%

-11.53%

Basic Shares Outstanding

656.7M

635.1M

634.7M

627.7M

577.6M

EPS (Diluted)

4.52

3.07

(2.56)

5.31

4.70

EPS (Diluted) Growth

-

-32.08%

-183.39%

307.42%

-11.49%

Diluted Shares Outstanding

663.3M

641.8M

640.1M

632.9M

582.5M

EBITDA

7.39B

6.22B

6.3B

6.75B

6.68B

EBITDA Growth

-

-15.87%

1.42%

7.04%

-1.04%

EBITDA Margin

Annual Financials for Target Corp.

View Ratios

Assets

Fiscal year is February-January. All values USD millions.	2013	2014	2015	2016	2017	5-year trend
Cash & Short Term Investments	784M	670M	2.21B	4.05B	2.51B
Cash Only	654M	667M	690M	1.04B	1.4B
Short-Term Investments	130M	3M	1.52B	3.01B	1.11B
Cash & Short Term Investments Growth	-	-14.54%	229.85%	83.08%	-37.91%
Cash & ST Investments / Total Assets	1.63%	1.50%	5.37%	10.05%	6.71%
Total Accounts Receivable	6.86B	1.11B	1.13B	779M	749M
Accounts Receivables, Net	6.46B	536M	426M	379M	385M
Accounts Receivables, Gross	6.46B	536M	426M	379M	385M
Bad Debt/Doubtful Accounts	-	-	-	-	-
Other Receivables	395M	570M	700M	400M	364M
Accounts Receivable Growth	-	-83.87%	1.81%	-30.82%	-3.85%
Accounts Receivable Turnover	10.69	64.45	64.49	94.72	92.78
Inventories	7.9B	8.28B	8.28B	8.6B	8.31B
Finished Goods	7.9B	8.28B	8.28B	8.6B	8.31B
Work in Progress	-	-	-	-	-
Raw Materials	-	-	-	-	-
Progress Payments & Other	-	-	-	-	-
Other Current Assets	844M	1.52B	2.01B	704M	420M
Miscellaneous Current Assets	534M	1.26B	1.78B	490M	213M
Total Current Assets	16.39B	11.57B	13.62B	14.13B	11.99B

	2013	2014	2015	2016	2017	5-year trend
Net Property, Plant & Equipment	30.65B	26.41B	25.95B	25.22B	24.66B
Property, Plant & Equipment - Gross	43.96B	40.48B	41.05B	41.46B	42.07B
Buildings	28.65B	25.98B	26.61B	27.06B	27.61B
Land & Improvements	6.21B	6.14B	6.13B	6.13B	6.11B
Computer Software and Equipment	2.57B	2.4B	2.55B	2.62B	2.65B
Other Property, Plant & Equipment	5.36B	5.2B	5.33B	5.35B	5.5B
Accumulated Depreciation	13.31B	14.07B	15.09B	16.25B	17.41B
Total Investments and Advances	354M	367M	387M	335M	345M
Other Long-Term Investments	354M	367M	387M	335M	345M
Long-Term Note Receivable	-	-	-	-	-
Intangible Assets	107M	331M	298M	277M	259M
Net Goodwill	59M	151M	147M	133M	133M
Net Other Intangibles	48M	180M	151M	144M	126M
Other Assets	455M	5.87B	911M	303M	179M
Tangible Other Assets	257M	5.87B	910M	237M	136M
Total Assets	48.16B	44.55B	41.17B	40.26B	37.43B
Assets - Total - Growth	-	-7.50%	-7.59%	-2.21%	-7.03%

Liabilities & Shareholders' Equity

	2013	2014	2015	2016	2017	5-year trend
ST Debt & Current Portion LT Debt	2.99B	1.14B	91M	815M	1.72B
Short Term Debt	970M	-	-	-	-
Current Portion of Long Term Debt	2.02B	1.14B	91M	815M	1.72B
Accounts Payable	7.06B	7.93B	7.76B	7.42B	7.25B
Accounts Payable Growth	-	12.41%	-2.18%	-4.39%	-2.24%
Income Tax Payable	272M	216M	26M	502M	158M
Other Current Liabilities	3.71B	3.49B	3.86B	3.89B	3.58B
Dividends Payable	232M	272M	333M	337M	334M
Accrued Payroll	1.1B	1.02B	1.1B	1.03B	953M
Miscellaneous Current Liabilities	2.38B	2.2B	2.42B	2.52B	2.29B
Total Current Liabilities	14.03B	12.78B	11.74B	12.62B	12.71B
Long-Term Debt	14.65B	11.43B	12.63B	11.95B	11.03B
Long-Term Debt excl. Capitalized Leases	12.72B	11.43B	12.63B	11.15B	11.03B
Non-Convertible Debt	12.72B	11.43B	12.63B	11.15B	11.03B
Convertible Debt	-	-	-	-	-
Capitalized Lease Obligations	1.93B	-	-	800M	-
Provision for Risks & Charges	170M	115M	151M	54M	46M
Deferred Taxes	1.11B	1.35B	1.16B	823M	861M
Deferred Taxes - Credit	1.31B	1.35B	1.16B	823M	861M
Deferred Taxes - Debit	206M	-	-	-	-
Other Liabilities	1.44B	2.65B	1.49B	1.86B	1.83B
Other Liabilities (excl. Deferred Income)	960M	2.16B	1.49B	1.2B	1.2B
Deferred Income	479M	491M	-	660M	630M
Total Liabilities	31.61B	28.32B	27.18B	27.31B	26.48B
Non-Equity Reserves	-	-	-	-	-
Total Liabilities / Total Assets	65.62%	63.57%	66.00%	67.82%	70.74%
Preferred Stock (Carrying Value)	-	-	-	-	-
Redeemable Preferred Stock	-	-	-	-	-
Non-Redeemable Preferred Stock	-	-	-	-	-
Common Equity (Total)	16.56B	16.23B	14B	12.96B	10.95B
Common Stock Par/Carry Value	54M	53M	53M	50M	46M
Retained Earnings	13.16B	12.6B	9.64B	8.19B	5.88B
ESOP Debt Guarantee	-	-	-	-	-
Cumulative Translation Adjustment/Unrealized For. Exch. Gain	-	(444M)	(16M)	(22M)	(21M)
Unrealized Gain/Loss Marketable Securities	-	-	-	-	-
Revaluation Reserves	-	-	-	-	-
Treasury Stock	-	-	-	-	-
Common Equity / Total Assets	34.38%	36.43%	34.00%	32.18%	29.26%
Total Shareholders' Equity	16.56B	16.23B	14B	12.96B	10.95B
Total Shareholders' Equity / Total Assets	34.38%	36.43%	34.00%	32.18%	29.26%
Accumulated Minority Interest	-	-	-	-	-
Total Equity	16.56B	16.23B	14B	12.96B	10.95B
Liabilities & Shareholders' Equity	48.16B	44.55B	41.17B	40.26B	37.43B

-

-

-

-

9.61%

NA

On a separate piece of paper, show me your calculations for the most current year for the following ratios:

Current Ratio (1:1)

Debt Ratio (%)