Hello,
I want to know the numbers of the picture1. The data file is up as picture 2 and 3.
picture1
Ratio analysis for MEN'S WEARHOUSE INC Dec2074 Dec2075 Dec2016 Deczu]] Deczone Industry average 2078 Return on Equity ( ROEL ( % ) = 16.5%/0 Profitability ratios Profit margin ( %/ ) 7.0% ROA ( % ) 11.9% ROIC ( %/0) 15.5% Gross margin ( 9/0) 40.5% Operating margin ( 9/0 ) 10.4%0 Asset efficiency ratios Asset turnover ( times ) 1.9 Fixed asset turnover ( times ) 3. 8 Inventory turnover ( times ) 4 . 1 Inventory days ( days ) 89. 0 Acct. receivable days ( days ) 3.2 Acct. payable days ( days ) 24.9 Operating cycle ( days ) 92.2 Cash conversion cycle ( days ) 67.3 Days' sales in cash ( days ) 17.2 _everage and liquidity ratios Assets - to - equity ( times ) 1 . 4 Debt to assets ( %/0) 28.0% Debt to equity ( %/0 ) 38.9% Times interest earned ( times ) 595 . 6 Current ratio ( times ) 2.0 Quick ratio ( times )I IIANNUAL BALANCE SHEET ($ MILLIONS) MENS WEARHOUSE INC Cash 3': Marketable securities 99.367 136.013 Accounts Receivables 24.372 16.745 Inventories 492 .423 . 43 1 .492 Prepaid Expenses . . 27.179 Other Current Assets Total Current Assets 729.612 630.329 . 631.615 703 .330 269.536 410.167 337.472 344.746 63.073 75.609 65.263 59.414 103.375 119.616 1 , 123.274 1,096.952 1,2 56.467 1,137.730 1,232 . l 06 Long Term Debt Due In One Year . 0.000 Accounts Payable 11 1.213 Taxes Payable 19.676 Accrued Expenses 75.453 Other Current Liabilities Total Current Liabilities 23 3.035 226.133 220.223 224.035 Long Term Debt Deferred Taxes Other Liabilities 495.741 343.130 . 345.532 329.762 EQUITY Oonunon Stock 0.671 0.691 0.700 0.705 Capital Surplus 255.214 236.120 305.209 315.404 327.742 Retained Earnings 641.553 775.357 923.713 933.530 936.523 Less: Treasury Stock 269.910 413.631 412.536 412.626 TOTAL EQUITY TOTAL LIABILITIES & EQUITY 1 , 123.274 . 1,256.467 1,137.730 ANNUAL INCOME STATEMENT (MILLIONS , EXCEPT PER SHARE ) Dec2014 Dec2015 Dec2016 Dec2017 DecZone Sales 1 , 724. 898 1 , 8.82.064 2 , 1 12.558 1, 972.418 1, 909. 575 Cost of Goods Sold 965. 889 1, 0:04.972 1, 062. 205 1 , 031. 241 1 , 025. 759 Gross Profit 759.0.09 877. 092 1 , 050.353 941. 177 883 .1 Selling , General , & Administrative Exp. 531. 839 591. 767 741.405 757. 073 732.722 Depreciation , Depletion , &Amortization* 61. 874 61. 387 80. 290 90. 605 86.090 Operating Profit 165. 296 223.938 228. 652 93.439 65.01:04 Other non- operating profit 0.0.00 0.0.00 0.0.00 0.0.00 0.0.00 Earnings before Interest and Taxes ( EBIT ) 165. 296 223. 938 228.652 93.439 65. 10:04 Interest Expense 5. 888 9.216 5. 046 1.300 0. 332 Non - Operating Income / Expense 3. 280 9. 786 5.987 2.592 0. 0.00 Special Items 0.000 0.0DO ( 2.968 ) 3. 200 Pretax Income 162. 688 224.508 229.593 88. 763 67. 872 Tax rate 1 /0 ) 36. 1%/0 33. 8%/' 33. 7%/} 33.01 %/} Total Income Taxes 58. 785 75.933 82.552 29.919 22.364 Income Before Extraordinary* Items & Discontinued Operations 103. 903 148.575 147. 0141 58. 8:44 45.508 savings Due to Common Stock Equiv* 0.0.00 0.0.00 ( 0. 8:34) Net Income 103. 903 148.575 147. 0141 58. 844 45. 508
