Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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."

image text in transcribedimage text in transcribedimage text in transcribed

B D E F Feb. 01, 2015 Vertical Analysis Feb. 01, 2014 Vertical Analysis Horizontal Analysis $1,723 1,484 11,079 1,016 $1,929 1,398 11,057 895 15,302 38,513 15,793 22,720 1,353 571 15,279 39,064 15,716 23,348 1,289 602 40,518 39,946 0 5,797 1,428 A 1 Consolidated Balance Sheets (USD $) 2 In Millions, unless otherwise specified 3 Current Assets: 4 Cash and Cash Equivalents 5 Receivables, net 6 Merchandise Inventories 7 Other Current Assets 8 Total Current Assets 9 Property and Equipment, at cost 10 Less Accumulated Depreciation and Amortization 11 Net Property and Equipment 12 Goodwill 13 Other Assets 14 Total Assets 15 Current Liabilities: 16 Short-Term Debt 17 Accounts Payable 18 Accrued Salaries and Related Expenses 19 Sales Taxes Payable 20 Deferred Revenue 21 Income Taxes Payable 22 Current Installments of Long-Term Debt 23 Other Accrued Expenses 24 Total Current Liabilities 25 Long-Term Debt, excluding current installments 26 Other Long-Term Liabilities 27 Deferred Income Taxes 28 Total Liabilities 29 30 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 31 shares at February 1, 2015 and 1.380 billion shares at February 2, 2014 32 Paid-In Capital 33 Retained Earnings 34 Accumulated Other Comprehensive (Loss) Income Treasury Stock, at cost, 461 million shares at February 1, 2015 and 381 million shares at 35 February 2, 2014 36 Total Stockholders Equity 37 Total Liabilities and Stockholders' Equity 290 5,807 1,391 434 1,468 35 38 1,806 11,269 396 1,337 12 33 1,746 10,749 14,691 2,042 16,869 1,844 6421 30,624 514 27,996 88 8,885 26,995 88 8,402 23,180 -452 46 -26,194 9,322 $39,946) -19,194 12,522 $40,518 A B C 1 2 3 Ratio Analysis 2015 Ratios 4. Current Ratio 5 Inventory Turnover Ratio 6 Debto to Equity Ratio 7 Return on Assets 8 Asset Turnover Ratio 9 Profit Margin Ratio 10 Gross Profit Ratio

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Essential Controller An Introduction To What Every Financial Manager Must Know

Authors: Steven M. Bragg

2nd Edition

1118169972, 9781118169971

More Books

Students also viewed these Accounting questions

Question

discuss how hotels communicate performance

Answered: 1 week ago