how are the blanks calculated for the following? There are two seperate sheets one for Target and one for Walmart.

Chapter 6 'lhrget Corporation nancial Statement Analysis I Income Statement (in millions of dollars) 2017 2016 2015 2014 2013 2012 2011 Revenues Depreciation & amortization Other operaljng expense Operating income $69,495 $73,785 U 4,535 $72,618 $71,279 $73,301 $59,855 $67,390 Interest expense, net Q2 Earnings before income taxes 3,353 Gainow)mdisoontirmeditems,noftax (4,035) Provision for income taxes 1204 Net earnings $0,536) Basic EPS Diluted EPS Target Corporation Balance Sheets (in millions ofnllars) Assets: Cash and cash equivalent 2017 2016 2014 2013 2012 Receivables Inventories Other current assets 'Ihtal current assets Property, plant, & equipment, at cost Less: accumulated depreciation Net property, plant, & equipment Other assets 'Ihtal assets Liabilities and Shareholders' Equity: Accounts payable Accrued liabilities (17 4131 (16m [15 31 14402 1 311 24.652 25,217 25,952 31,373_ 29,149 915 1,596 r 602 $40262 $41,172 $44553 $7.683 Other current liabilities Total current liabilities Long-term debt Other lamterm liabilities Total long term liabilities Total liabilities Shareholders' Equity: Common stock Capital in excess of par value Retained earnings Other comprehensive income 'Ibtal shareholders' equity Tbml liabilities & shareholders' equity \"53 5.661 4,899 4470 50 5,343 458.1.) 42.251 42.232 3,311 12,698 .1538}. 8188 64-4 12.599 ,1 9, $37,431 $40,262 $41 72 $44,553 $43,705 Cash Flow Dirt! Cash ow from operations Fixed aSSEt purchasw Cash dividends Introduction to Accounting and nance 2m 2m mm $5,329 $5,140 $5,131 $6,520 55.325 1.547 1,438 1,785 1348 1 ,362 $5,434 Depreciation and amortization Market Data 1205 1,006 859 2,129 2,223 2,142 2015 2.298 2,213 High market price $74 . 73 [AJW market price $55.25 Number of shares outstanding (millions) 635 Market capitalization 41,2752 40,4012 37,6712 Thrget Corporation Financial Metrics Earnings Quality Earnings per share Dividend payout ratio Cash ow adequacy Liquidity and Activity 201': 2016 2015 _EE- - 1.06 Working capital $0,204) $2,152 Current (working capital) ratio 0.91 1.15 Inventory turnover 5.71 504 Days in inventory 63.94 60.39 Accounts receivable turnover 11.79 Days in accounts receivable Inventory conversion cycle Accounts payable turnover Days in accounts payable Net cash conversion cycle Protability Operating prot margin Net prot margin Asset turnover Financial leverage -- _'il _7.3% _7.3% ____ 2.74 2.91 30.96 91.35 3.98 52.29 39.06 7.696 4.2% 1.50 2.95 Return on assets (based on NPM) 4.4% 6.296 6.396 Return on equity 12.196 18.1% 18.596 Sohency Debt to equity 1.947 Long-term debt to equity Debt to capital Long-term debt to capital Flimes interest teamed Valuation Price to earnings Price to book value - 2.49 2128 -- 0.958 1.061 mm mm 044 066 0.35 6.15 11.57 2.14 Chapter 6 nancial Statement Analysisl Wall-Mart Stores Income Statements (in millions of dollars) 2011 2016 2015 2014 2013 Net sales $481,317 $473,614 $482,229 $473,076 $463,114 Othe: incomenet 4 Eu 16 422 3,2 1g 3% Thtalrevenues 485,373 482,130 485,651 476,294 469,162 446,950 421,349 m m@ Opemngexpenses 101% 91,333 38m 85% 61m Opemngincnme 22,764 24,105 27,147 26,872 27,301 26,556 25,542 _ _ Basic EPS Diluted EPS WIl-Mart Stores Balance Sheets (in millions 01' dollm) 2017 2010 2015 2014 2012 2011 Assets: 03511 and C3511 equivalent $5,367 $3,705 $9,135 $7,281 $7,731 $5,550 $7,395 Receivables 5 ,835 6, 677 6,768 5,937 5,089 Inventm'ies 43, 0:5 44 ,469 45: 141 44, 2353 43,803 40,714 35,318 Thta'l current assets 57,689 60,239 63,273 61,185 59,940 54,975 51,393 Property, Flam; and eqUiPrnent, at cost 179,492 173,089 165,825 155,002 148,584 mummm m 4442- Netpmperty,plant,&equipment 107,710 110,171 114,230 115,364 113,929 109,003 105,098 vaerwmwpwlease: Property under capital lease 11,637 11,095 5, 239 5, 589 5,899 5,936 5,905 Less: accumulated amortization (5 lg) 4 7 1 [ } @2046 5431 g: 147 3 215 [:3 12m 2 Net property under capital leases 63,45 2, 375 2,752 2,721 2,730 Other assets and deferred charge. 131 5 4 _,_55_6,gg w M _4, $203, 490 $204, 751 $203,105 $193,406 $180,663 Liabilities and Shareholdem' Equity: Introduction to Accounting and nance Current liabilities: $7,070 Short-term borrowings $1,099 $2,708 $1,592 Acouuntspayable 41,433 38,437 33,410 37,415 18,793 $6,905 $4,047 $1,031 36,080 36,608 33,557 Accrued liabilities 20 ,654 19,607 19,152 Accrued income taxes 921 521 1,021 Long-term debt due within one year 2,253 4,791 4,103 5,537 4,555 966 13,308 12,154 13,701 2,211 1,164 157 Other current liabilities 5.815 55; 287 398. M 3.52 383 Total current liabilities 66,929 64,619 65,253 69,345 71,818 62,300 58,484 Long-tam debt 36,015 38,214 40,889 Long-term obligations under capital leases 6,003 5,816 2,606 Deferred income taxes and other 9,344 7,321 8,805 Other lungberm liabilities 54,067 'Dntal long-term liabilities 1 13,290 51,351 52,3 Shamholders' Equity: _.403 Common stock 305 317 323 323 332 342 352 Capital in excess of par value 2,371 1,805 2,462 2,362 3,520 3,692 3,577 Retained earnings 89,354 90,021 85,777 76,566 72,978 68,691 03,967 'Ibtalliabitiewslurehulders'equity $193,325 $199,531 $203,490 $204,751 $203,105 $193,406 $180,563 053111110me 2017 201 201$ 2014 2013 2012 2011 Cashowfrom Operations $31,530 $27,339 $28,564 $33,257 $25,591 $24,255m 1,3115 12.398 Cash dividends 6,215- 6,185 6,139 5,361 4,437 8,870 Depreciation and amortization 10,080 9,454 9,173 Market Data. 2017 2016 2015 $90.97 saw men 32.2 56.30 $72.31 Nmberofmoutmnmmnons) 3,101 3,207 3,230 3,239 3,374- 3,510 Market capitalization (millions) $213,829 $231,385 $364,182 2014 $68.93 8,501 8,130 7,641 2013 2012 2011 57.18 48.31 47177 $227,374 $190,836 Chapter 6 nancial Statement Analysisl 2017 2016 2015 2014 2013 2012 2011 Earnings Quality --- Dividend payout ratio . 31.596 322% . - - Liquidity and Activity Working capital (11,878.00) Current (working capital) latio . 0.83 Inventory turnover . 8.05 Net prot margin Asset turnover Financial leverage Return on assets (based on NPM) Return on equity Solvency Debt to capital Lam-term debt to capital Times interest earned Price to earnings Market to book value Required: Write an executive summary recommending retention or Lamination of Target's chief executive oicer. Base your decision on your analysis of Thrget's protability. liquidity, and solvency. Compute the nancial measures for both rms for 20152017 to assist in your analysis of these nancial statement areas and your decision