Could you please answer the following accounting assignment?

profilejohn3_10
AnalyticalReviewExample11.xlsx
Home>Business & Finance homework help>Accounting homework help> Could you please answer the following accounting assignment?

balance sheet

Target Balance Sheet
Consolidated Statements of Financial Position - USD ($) Jan. 28, 2017 Jan. 30, 2016
$ in Millions
Assets
Cash and cash equivalents, including short-term investments of $1,110 and $3,008 $2,512 6.71% $4,046
Inventory 8,309 22.20% 8,601
Assets of discontinued operations 69 0.18% 322
Other current assets 1,100 2.94% 1,161
Total current assets 11,990 32.03% 14,130
Property and equipment
Land 6,106 16.31% 6,125
Buildings and improvements 27,611 73.77% 27,059
Fixtures and equipment 5,503 14.70% 5,347
Computer hardware and software 2,651 7.08% 2,617
Construction-in-progress 200 0.53% 315
Accumulated depreciation -17,413 -46.52% -16,246
Property and equipment, net 24,658 65.88% 25,217
Noncurrent assets of discontinued operations 12 0.03% 75
Other noncurrent assets 771 2.06% 840
Total assets 37,431 100.00% 40,262
Liabilities and shareholders' investment
Accounts payable 7,252 19.37% 7,418
Accrued and other current liabilities 3,737 9.98% 4,236
Current portion of long-term debt and other borrowings 1,718 4.59% 815
Liabilities of discontinued operations 1 0.00% 153
Total current liabilities 12,708 33.95% 12,622
Long-term debt and other borrowings 11,031 29.47% 11,945
Deferred income taxes 861 2.30% 823
Noncurrent liabilities of discontinued operations 18 0.05% 18
Other noncurrent liabilities 1,860 4.97% 1,897
Total noncurrent liabilities 13,770 36.79% 14,683
Shareholders' investment
Common stock 46 0.12% 50
Additional paid-in capital 5,661 15.12% 5,348
Retained earnings 5,884 15.72% 8,188
Accumulated other comprehensive loss
Pension and other benefit liabilities -601 -1.61% -588
Currency translation adjustment and cash flow hedges -37 -0.10% -41
Total shareholders' investment 10,953 29.26% 12,957
Total liabilities and shareholders' investment $37,431 100.00% $40,262

Income statement

Target Income Statements
Consolidated Statements of Operations - USD ($) 12 Months Ended
shares in Millions, $ in Millions Jan. 28, 2017 Jan. 30, 2016 % Change
Income Statement [Abstract]
Sales $69,495 $73,785 -5.81%
Cost of sales 48,872 51,997 -6.01%
Gross margin 20,623 21,788 -5.35%
Selling, general and administrative expenses 13,356 14,665 -8.93%
Depreciation and amortization 2,298 2,213 3.84%
Gain on sale 0 -620 -100.00%
Earnings from continuing operations before interest expense and income taxes 4,969 5,530 -10.14%
Net interest expense 1,004 607 65.40%
Earnings from continuing operations before income taxes 3,965 4,923 -19.46%
Provision for income taxes 1,296 1,602 -19.10%
Net earnings from continuing operations 2,669 3,321 -19.63%
Discontinued operations, net of tax 68 42 61.90%
Net earnings / (loss) $2,737 $3,363 -18.61%

Ratios

Target Ratios
Current Ratio
Current Assets / Current Liabilities
11,990 divided by 12,708 = 94.35%
Debt to Equity Ratio
Total Debt / Total Equity
Debt
current liabilities 12,708
non current liabilities 13,770
26,478 divided by 10,953 = 2.42
Operating profit percentage
Operating profit / Net sales
4,969 divided by 69,495 = 7.15%
Net profit percentage
Net income / Net sales $2,737 divided by 69,495 = 3.94%