Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the balance sheet and income statement, complete the ratios on the tab labeled Ratios 12 Months Ended Vertical Analysis Feb. 01, 2015 Feb. 02,

image text in transcribedimage text in transcribedimage text in transcribed

Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios"

12 Months Ended Vertical Analysis Feb. 01, 2015 Feb. 02, 2014 Vertical Analysis Horizontal Analysis $83,176 54,222 28,954 %100 %65.15 %34.85 $78,812 51,422 27,390 %100 %65.25 %34.75 +5.54 +5.45 +5.71 +1.43 +0.09 16,834 1,651 18,485 10,469 %20.25 %2.00 %22.25 %12.60 16,597 1,627 18,224 9,166 %21.06 %2.06 %23.12 %11.63 +1.43 +14.22 Consolidated Statements of Earnings In Millions, except Per Share data, unless otherwise specified Income Statement (Abstract] NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income Interest Expense Other Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Weighted Average Common Shares BASIC EARNINGS PER SHARE Diluted Weighted Average Common Shares -337 - 12 %-.41 %1.00 %-.02 %0.90 830 711 +270.83 %16.74 %0 %-29.47 0 493 0.60% 699 %0.88 %12.00 %4.37 9,976 3,631 $6,345 1,338 $4.74 8,467 3,082 $5,385 1,425 $3.78 %10.75 %3.91 %6.84 763.00% +17.83 +17.83 +17.83 %-6.11 +25.4 DILUTED EARNINGS PER SHARE 1,346 $4.71 1,434 $3.76 %-6.14 +25.27 Fiscal years ended February 1, 2015 and February 2, 2014 Ratio Analysis 2015 Ratios Current Ratio Inventory Turnover Ratio Debto to Equity Ratio Return on Assets Asset Turnover Ratio Profit Margin Ratio Gross Profit Ratio Feb. 01, Vertical Analysis Feb. 01. 2015 2014 Vertical Analysis Horizontal Analysis 10.68% $1.723 4.31%. 1,484 3.72%. 11,079 27.73%. 1,016 2.54%. 15,302 38,513 $1.929) 1,398 11,0571 895 15,279 39,064 4.76% 3.45% 27.29% 2.21% 13.52% Consolidated Balance Sheets (USD $) In Millions. unless otherwise specified Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets Property and Equipment, at cost Less Accumulated Depreciation and Amortization Net Property and Equipment Goodwill Other Assets Total Assets Current Liabilities: Short-Term Debt Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenue Income Taxes Payable Current Installments of Long-Term Debt 57.62% 15.793 22,720 56.88%. 1,353 3.39% 571 1.43%. 39.9461 100% 15,716 23,348 1,289 602 40,518 1.49% -5.15% 100% 290.73% 5,807 14.54%. 1,391 3.48%. 434 1.09% 1,468 3.67%. 35.09% 5,797 1,428 396 1,337 12 | 14.31% 3.52% 0.98% 3.30% 0.03% 0.17% -2.59% 9.60% 9.80% 191.67% 381.1%. 1,80614.52% 11,269 28.21%. 0.08% 4.31% 26.53% 15.15% 3.46% 1.7461 10.749 Other Accrued Expenses Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities 14.83% 16,869 42.23%. 1.84414.62%. 642 1.61% 30,624 76.68% 14,691 2.042 514 27,996 36.26% 5.06% 1.27% 69.1% 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, 2014 81.22% 8,885 22.24%. 26,995 67.58%. 8,402 23,180 0.22% 20.74% 57.21% 0% 5.75% 16.46% Paid-in Capital Retained Earnings Accumulated Other Comprehensive (Loss) Income Treasury Stock, at cost, 461 million shares at February 1, 2015 and 381 million shares at February 2, 2014 -452 -1.13%. 0.11% -108.2% -26,194 -65.57% 9,322 23.32% -19,194 12,522 -47.37% 30.90% -36.47% -25.56% Total Stockholders Equity Total Liabilities and Stockholders' Equity $39.946 100%. $40.518 100%)

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

Step: 3

blur-text-image

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

Data Analytics Using Microsoft Excel With Accounting And Finance Datasets Version 2.0

Authors: Joseph M. Manzo

1st Edition

1453395210, 9781453395219

More Books

Students also viewed these Accounting questions

Question

=+What is the brand's character or personality?

Answered: 1 week ago