Question: 1 . Complete a vertical and horizontal analysis on the tabs labeled Balance Sheet and Income Statement, use total assets on the balance sheet and

1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement", use total assets on the balance sheet and net sales on the income statement for your vertical analysis.
2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios"Consolidated Balance Sheets (USD $) Feb. 01,2015 Vertical Analysis Feb. 01,2014 Vertical Analysis Horizontal Analysis
In Millions, unless otherwise specified
Current Assets:
Cash and Cash Equivalents $1,723 $1,929
Receivables, net 1,4841,398
Merchandise Inventories 11,07911,057
Other Current Assets 1,016895
Total Current Assets 15,30215,279
Property and Equipment, at cost 38,51339,064
Less Accumulated Depreciation and Amortization 15,79315,716
Net Property and Equipment 22,72023,348
Goodwill 1,3531,289
Other Assets 571602
Total Assets 39,94640,518
Current Liabilities:
Short-Term Debt 2900
Accounts Payable 5,8075,797
Accrued Salaries and Related Expenses 1,3911,428
Sales Taxes Payable 434396
Deferred Revenue 1,4681,337
Income Taxes Payable 3512
Current Installments of Long-Term Debt 3833
Other Accrued Expenses 1,8061,746
Total Current Liabilities 11,26910,749
Long-Term Debt, excluding current installments 16,86914,691
Other Long-Term Liabilities 1,8442,042
Deferred Income Taxes 642514
Total Liabilities 30,62427,996
STOCKHOLDERS' EQUITY
Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.768 billion shares at February 1,2015 and 1.761 billion shares at February 2,2014; outstanding: 1.307 billion shares at February 1,2015 and 1.380 billion shares at February 2,20148888
Paid-In Capital 8,8858,402
Retained Earnings 26,99523,180
Accumulated Other Comprehensive (Loss) Income -45246
Treasury Stock, at cost,461 million shares at February 1,2015 and 381 million shares at February 2,2014-26,194-19,194
Total Stockholders Equity 9,32212,522
Total Liabilities and Stockholders' Equity $39,946 $40,518

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!