Question: ******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

******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!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

https://corporate.target.com/annual-reports/2018 Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert...

Q:

Using the vertical analysis of the balance sheets, identify the significant trends. Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of the report you are...

Q:

Need help with this for Target using annual reports. Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert...

Q:

***Use https://corporate.target.com/annual-reports/2018*** Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to...

Q:

***Use: https://corporate.target.com/annual-reports/2018*** Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have...

Q:

Section 2. Ratio Analysis (35 points) Identify the appropriate formula and calculate the following ratios for the most recent two fiscal years (Market performance ratios (earnings per share, book...

Q:

% 100.00% % 100,00% Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS Change XX to the year of the report you are analyzing. You may have to insert additional rows FY 2010 3 hed on...

Q:

How do I fill out this with the given information? https://corporate.target.com/annual-reports/2018 Horizontal Analysis of the Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of...

Q:

https://corporate.target.com/annual-reports/2018*** Horizontal Analysis of the Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to...

Q:

FY 2017 % % 100.00% 100.00% Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert additional 3 rows based...

Q:

Indicate which of the following statements are true or false: ________ The IRS is a division of the Treasury Department. ________ The IRS has four major divisions. ________ The IRS local offices...

Q:

In what order are vouchers ordinarily filed (a) In the unpaid voucher file and (b) In the paid voucher file? Give reasons for the answers.

Q:

3.43 Pixar Animated Movies Again (Example 12) Find the median and interquartile range of the top seven Pixar animated movies; refer to Exercise 3.41 for the data.

Q:

Forum 9: E- Commerce challenges and entrepreneurial manager Due to the proliferation of the internet, the business community no longer has to depend on the customer to seek a brick and mortar...

Q:

1. Empirical or factual information,

Q:

1. To take in the necessary information,

Q:

7. Find four examples that illustrate the statement: Beyond a certain point, open-ness regarding information and communication can become detrimental to relationships.