******https://corporate.target.com/annual-reports/2018*** Use for the 2018 annual report. All the information needed is here.

Vertical Analysis - Balance Sheets

Target Corporation

INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert additional rows based on the actual Target Consolidated statement.

FY 2018

%

FY 2017

%

ASSETS

Cash and cash equivalents

Inventory

Assets of discontinued operations

Other current assets

Total current assets

$-

$-

Property and equipment

Land

Buildings and equipment

Fixtures and equipment

Computer hardware and software

Construction-in-progress

Accumulated depreciation

Property and equipment, net

$-

$-

Noncurrent assets of discontinued operations

Other noncurrent assets

Total assets

$-

100.00%

$-

100.00%

LIABILITIES

Accounts payable

Accrued and other current liabilities

Current portion of long-term debt and other borrowings

Liabilities of discontinued operations

Total current liabilities

$-

$-

Long-term debt and other borrowings

Deferred income taxes

Noncurrent liabilities of discontinued operations

Other noncurrent liabilities

Total noncurrent liabilities

$-

$-

Total liabilities

$-

$-

SHAREHOLDERS' INVESTMENT

Common stock

Additional paid-in capital

Retained earnings

Accumulated other comprehensive loss

Pension and other benefit liabilities

Currency translation adjustment and cash flow hedges

Total shareholders' investment

$-

$-

Total liabilities and shareholders' investment

$-

100.00%

$-

100.00%

Horizontal Analysis of the Balance Sheets

Target Corporation

INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert additional rows based on the actual Target Consolidated statement.

FY 2018

FY 2017

$ Change

% Change

FY 2016

$ Change

% Change

ASSETS

Cash and cash equivalents

$-

#DIV/0!

$-

#DIV/0!

Inventory

$-

#DIV/0!

$-

#DIV/0!

Assets of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Other current assets

$-

#DIV/0!

$-

#DIV/0!

Total current assets

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Property and equipment

$-

Land

$-

#DIV/0!

$-

#DIV/0!

Buildings and equipment

$-

#DIV/0!

$-

#DIV/0!

Fixtures and equipment

$-

#DIV/0!

$-

#DIV/0!

Computer hardware and software

$-

#DIV/0!

$-

#DIV/0!

Construction-in-progress

$-

#DIV/0!

$-

#DIV/0!

Accumulated depreciation

$-

#DIV/0!

$-

#DIV/0!

Property and equipment, net

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Noncurrent assets of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Other noncurrent assets

$-

#DIV/0!

$-

#DIV/0!

Total assets

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

LIABILITIES

Accounts payable

$-

#DIV/0!

$-

#DIV/0!

Accrued and other current liabilities

$-

#DIV/0!

$-

#DIV/0!

Current portion of long-term debt and other borrowings

$-

#DIV/0!

$-

#DIV/0!

Liabilities of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Total current liabilities

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Long-term debt and other borrowings

$-

#DIV/0!

$-

#DIV/0!

Deferred income taxes

$-

#DIV/0!

$-

#DIV/0!

Noncurrent liabilities of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Other noncurrent liabilities

$-

#DIV/0!

$-

#DIV/0!

Total noncurrent liabilities

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Total liabilities

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

SHAREHOLDERS' INVESTMENT

Common stock

$-

#DIV/0!

$-

#DIV/0!

Additional paid-in capital

$-

#DIV/0!

$-

#DIV/0!

Retained earnings

$-

#DIV/0!

$-

#DIV/0!

Accumulated other comprehensive loss

$-

$-

Pension and other benefit liabilities

$-

#DIV/0!

$-

#DIV/0!

Currency translation adjustment and cash flow hedges

$-

#DIV/0!

$-

#DIV/0!

Total shareholders' investment

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Total liabilities and shareholders' investment

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Horizontal Analysis of the Balance Sheets

Target Corporation

INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert additional rows based on the actual Target Consolidated statement.

FY 2018

FY 2017

$ Change

% Change

FY 2016

$ Change

% Change

ASSETS

Cash and cash equivalents

$-

#DIV/0!

$-

#DIV/0!

Inventory

$-

#DIV/0!

$-

#DIV/0!

Assets of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Other current assets

$-

#DIV/0!

$-

#DIV/0!

Total current assets

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Property and equipment

$-

Land

$-

#DIV/0!

$-

#DIV/0!

Buildings and equipment

$-

#DIV/0!

$-

#DIV/0!

Fixtures and equipment

$-

#DIV/0!

$-

#DIV/0!

Computer hardware and software

$-

#DIV/0!

$-

#DIV/0!

Construction-in-progress

$-

#DIV/0!

$-

#DIV/0!

Accumulated depreciation

$-

#DIV/0!

$-

#DIV/0!

Property and equipment, net

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Noncurrent assets of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Other noncurrent assets

$-

#DIV/0!

$-

#DIV/0!

Total assets

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

LIABILITIES

Accounts payable

$-

#DIV/0!

$-

#DIV/0!

Accrued and other current liabilities

$-

#DIV/0!

$-

#DIV/0!

Current portion of long-term debt and other borrowings

$-

#DIV/0!

$-

#DIV/0!

Liabilities of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Total current liabilities

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Long-term debt and other borrowings

$-

#DIV/0!

$-

#DIV/0!

Deferred income taxes

$-

#DIV/0!

$-

#DIV/0!

Noncurrent liabilities of discontinued operations

$-

#DIV/0!

$-

#DIV/0!

Other noncurrent liabilities

$-

#DIV/0!

$-

#DIV/0!

Total noncurrent liabilities

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Total liabilities

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

SHAREHOLDERS' INVESTMENT

Common stock

$-

#DIV/0!

$-

#DIV/0!

Additional paid-in capital

$-

#DIV/0!

$-

#DIV/0!

Retained earnings

$-

#DIV/0!

$-

#DIV/0!

Accumulated other comprehensive loss

$-

$-

Pension and other benefit liabilities

$-

#DIV/0!

$-

#DIV/0!

Currency translation adjustment and cash flow hedges

$-

#DIV/0!

$-

#DIV/0!

Total shareholders' investment

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!

Total liabilities and shareholders' investment

$-

$-

$-

#DIV/0!

$-

$-

#DIV/0!