PLEASE HELP CALCULATE THE RATIOS. Ratios years need to be changed 2016-2015 and 2017 to 2016 along with my balcance sheet. I thought the balance sheet given saying as of January 2017 meant it was for 2017.

January 28, 2017 January 30, 2016 $ (Dollars in Millions) Assets Current assets: Cash and cash equivalents Merchandise inventories Other Total current assets Property and equipment, net Other assets Total assets 1,074 $ 3,795 378 5,247 8,103 224 13,574 $ 707 4,038 331 5,076 8,308 222 13,606 $ $ Liabilities and Shareholders' Equity Current liabilities: Accounts payable Accrued liabilities Income taxes payable Current portion of capital lease and financing obligations Total current liabilities Long-term debt Capital lease and financing obligations Deferred income taxes Other long-term liabilities Shareholders' equity: Common stock - 371 and 370 million shares issued Paid-in capital Treasury stock, at cost, 197 and 184 million shares Accumulated other comprehensive loss Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 1,507 $ 1,224 112 131 2,974 2,795 1,685 272 671 1,251 1,206 130 127 2,714 2,792 1,789 257 563 4 4 3,003 (10,338) (14) 12,522 5,177 13,574 $ 2,944 (9,769) (17) 12,329 5,491 13,606 $ monto $ 556 $ 673 $ 867 938 41 (5) 13 934 48 (10) (38) 24 169 886 48 (3) 49 30 31 57 249 (45) 256 81 (23) 2,148 (215) 43 (260) 53 53 1,474 68 (30) 146 30 (68) 2,024 (768) (690) Operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization Share-based compensation Excess tax benefits from share-based compensation Deferred income taxes Other non-cash expenses, net Loss on extinguishment of debt Impairments, store closing and other costs Changes in operating assets and liabilities: Merchandise inventories Other current and long-term assets Accounts payable Accrued and other long-term liabilities Income taxes Net cash provided by operating activities Investing activities Acquisition of property and equipment Sales of investments in auction rate securities Other Net cash used in investing activities Financing activities Treasury stock purchases Shares withheld for taxes on vested restricted shares Dividends paid Proceeds from issuance of debt, net Reduction of long-term borrowings Premium paid on redemption of debt Capital lease and financing obligation payments Proceeds from stock option exercises Excess tax benefits from share-based compensation Proceeds from financing obligations Net cash used in financing activities Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid Non-Cash investing and financing activities Property and equipment acquired through additional liabilities (682) 82 7 (593) 12 (756) 9 (681) (557) (1,001) (677) (17) (27) (19) (358) (349) (317) 1,088 (1,085) (163) (127) (114) (114) 18 147 123 5 10 3 11 6 (1,025) (1,493) (995) 367 (700) 436 707 1,407 971 $ 1,074 $ 707 $ 1,407 1 $ 299 $ 314 318 $ 372 329 502 $ 54 $ 63 $ 41 4 Ratio Analysis 2017 2016 5 6 7 Liquidity Ratios Current Ratio Quick Ratio Cash Flow Liquidity Ratio 8 9 10 11 12 13 Activity Ratios Acct Receivable Turnover Days Sales Outstanding Inventory Turnover Acct Payable Turnover Days Payable Outstanding 14 15 16 17 18 19 Leverage Ratios Debt Ratio Debt to Equity Times Interest Earned 20 21 22 23 24 25 26 Profitablity Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Cash Flow Margin Return on Total Assets Return on Equity 27 28 29 30 31 32 Market Ratios Earning per Share Price to Earnings Ratio Dividend Yield 33 34 Net Revenues 2014 19,023 12,098 2015 19,204 12,265 100.0% 100.0% 63.6% 2016 18,686 11,944 100.0% Cost of Merchandise Sold 63.9% 63.9% =Gross Profit 6,925 36.4% 6,939 36.1% 6,742 36.1% 22.9% 23.2% 23.7% 4,350 886 4,452 934 4,435 938 Sell, Gen & Admin Exp Depreciation and amortization Impairments, store closing and other costs =Operating Income 186 1,689 8.9% 1,553 8.1% 1,183 6.3% 340 1.8% 327 1.7% 308 1.6% Interest Expense Other Expense 0.0% 169 0.9% 0 0.0% =Income before taxes 1,349 7.1% 1,057 5.5% 875 4.7% Provision for income taxes 482 2.5% 384 2.0% 319 1.7% =Net Income 867 4.6% 673 3.5% 556 3.0% 6 2014 19,023 12,098 % Change 1.0% 7 2015 19,204 12,265 Net Revenues Cost of Merchandise Sold % Change -2.7% 2016 18,686 11,944 8 1.4% -2.6% 9 10 =Gross Profit 6,925 6,939 0.2% 6,742 -2.8% 11 12 2.3% -0.4 4,350 886 4,452 934 13 Sell, Gen & Admin Exp Depreciation and amortization Impairments, store closing and other costs =Operating Income 4,435 938 186 14 15 1,689 1,553 -8.1% 1,183 -31.3% 16 17 340 327 (3.8%) 308 -5.8 Interest Expense Other Expense 18 0 169 0 -100.0 19 20 =Income before taxes 1,349 1,057 -21.6% 875 -17.2% 21 22 Provision for income taxes 482 384 -20.3% 319 -16.9 23 24 =Net Income 867 673 -22.4% 556 -17.4 UJ 2017 2016 % Change B 1 1,074 3,795 378 5,247 8,103 224 13,574 707 4,038 331 5,076 8,308 222 13,606 51.9% -6.0% 14.2% 3.4% -2.5% 0.9% -0.2% 3 6 1,507 1,224 112 1,251 1,206 130 Assets Cash & Equivalents Merchandise Inventory 0 Other Total Current Assets 2 Property & Equipment Other Assets 4 Total Assets 5 Liabilities 7 Accounts payable 8 Accrued liabilities Income taxes payable 0 Current portion of capital lease and financing obligations -1 Total current liabilities 2 Long-term capital leases, financing obligation and note payable 3 Long term debt 4 Deferred income taxes 5 Other long-term liabilities 6 Total liabilities 7 8 Stockholders' equity 9 Common Stock 0 Paid-in capital -1 Treasury stock 2 Accumulated other comprehensive loss 3 Retained earnings 4 Total stockholders' equity 5 Total liabilities and stockholders' equity 20.5% 1.5% -13.8% 3.1% 9.6% -5.8% 131 2,974 1,685 2,795 272 671 8,397 127 2,714 1,789 2,792 257 563 8,115 0.1% 5.8% 19.2% 3.5% 4 4 3,003 -10,338 -14 12,522 5,177 13,574 2,944 -9,769 -17 12,329 5,491 13,606 0.0% 2.0% 5.8% -17.6% 1.6% -5.7% -0.2%