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

AutoSave OFF OES project 5 - Saved to my Mac Insert Draw Page Layout Formulas Home - Data Review View Tell me Share Comments X X v 11 Calibri (Body) v AP a Wras Text Ceneral Insert v v AYO 2x Delete Paste BIU A Merge & Center Conditional Format Cell Formatting as Table Styles Ideas Sort Filter Format v Find Select Sensitivity v Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left aff? Yes No BS B D E F G H 1 1 j K L M N 0 P 0 R S 1 2 3 Please Complete the following: 4 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" 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Instructions Consolidated Balance Shoots Consolidated_Statements of ans Ratios + C + 150% 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 D E F 1 12 Months Ended Feb. 01, 2015 Vertical Analysis Feb. 02, 2014 Vertical Analysis Horizontal Analysis 2. Consolidated Statements of Earnings (USD $) In Millions, except Per Share data, unless otherwise specified Income Statement [Abstract] NET SALES 3 4 5 Cost of Sales $83,176 54,222 28,954 $78,812 51,422 27,390 16,834 1,651 18,485 10,469 16,597 1,627 18,224 9,166 -337 -12 830 711 0 0 6 GROSS PROFIT 7 Operating Expenses: 8 Selling, General and Administrative 9 Depreciation and Amortization 10 Total Operating Expenses 11 OPERATING INCOME 12 Interest and Other (Income) Expense: 13 Interest and Investment Income 14 Interest Expense 15 Other 16 Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME 17 TAXES 18 Provision for Income Taxes 19 NET EARNINGS 20 Weighted Average Common Shares 21 BASIC EARNINGS PER SHARE 22 Diluted Weighted Average Common Shares 23 DILUTED EARNINGS PER SHARE 24 25 [1] 493 699 9,976 3,631 $6,345 1,338 $4.74 1,346 $4.71 8,467 3,082 $5,385 1,425 $3.78 1,434 $3.76 Fiscal years ended February 1, 2015 and February 2, 2014 include 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 AutoSave OFF OES project 5 - Saved to my Mac Insert Draw Page Layout Formulas Home - Data Review View Tell me Share Comments X X v 11 Calibri (Body) v AP a Wras Text Ceneral Insert v v AYO 2x Delete Paste BIU A Merge & Center Conditional Format Cell Formatting as Table Styles Ideas Sort Filter Format v Find Select Sensitivity v Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left aff? Yes No BS B D E F G H 1 1 j K L M N 0 P 0 R S 1 2 3 Please Complete the following: 4 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" 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Instructions Consolidated Balance Shoots Consolidated_Statements of ans Ratios + C + 150% 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 D E F 1 12 Months Ended Feb. 01, 2015 Vertical Analysis Feb. 02, 2014 Vertical Analysis Horizontal Analysis 2. Consolidated Statements of Earnings (USD $) In Millions, except Per Share data, unless otherwise specified Income Statement [Abstract] NET SALES 3 4 5 Cost of Sales $83,176 54,222 28,954 $78,812 51,422 27,390 16,834 1,651 18,485 10,469 16,597 1,627 18,224 9,166 -337 -12 830 711 0 0 6 GROSS PROFIT 7 Operating Expenses: 8 Selling, General and Administrative 9 Depreciation and Amortization 10 Total Operating Expenses 11 OPERATING INCOME 12 Interest and Other (Income) Expense: 13 Interest and Investment Income 14 Interest Expense 15 Other 16 Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME 17 TAXES 18 Provision for Income Taxes 19 NET EARNINGS 20 Weighted Average Common Shares 21 BASIC EARNINGS PER SHARE 22 Diluted Weighted Average Common Shares 23 DILUTED EARNINGS PER SHARE 24 25 [1] 493 699 9,976 3,631 $6,345 1,338 $4.74 1,346 $4.71 8,467 3,082 $5,385 1,425 $3.78 1,434 $3.76 Fiscal years ended February 1, 2015 and February 2, 2014 include 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