Please help me answer questions on attached excel sheet. Thanks.

Chapter 2 Problem 13 a. Use the spreadsheet to calculate as many of the company's Profitability, Turnover-Control, and Leverage and Liquidity ratios as you can for these years (see Table 2.5 in text for a list of possible ratios). b. What do these ratios suggest about the company's performance over this period? ANNUAL BALANCE SHEET ($ MILLIONS) MENS WEARHOUSE INC Jan10 Jan09 ASSETS Cash & Short-Term Investments Net Receivables Inventories 186.018 104.533 16.745 40.662 431.492 440.099 Prepaid Expenses Other Current Assets 26.603 74.075 19.718 ------------------ -----------------Total Current Assets 708.330 631.615 Gross Plant, Property & Equipment 885.981 Accumulated Depreciation 498.509 ------------------ ------------------ Net Plant, Property & Equipment Intangibles Other Assets 344.746 387.472 59.414 65.268 119.616 103.375 ------------------ -----------------TOTAL ASSETS 1,232.106 1,187.730 0.000 0.000 Accounts Payable 83.052 108.800 Taxes Payable 23.936 0.019 LIABILITIES Long Term Debt Due In One Year Accrued Expenses Other Current Liabilities 66.542 117.047 44.862 ------------------ -----------------Total Current Liabilities Long Term Debt 224.035 220.223 43.491 62.916 Deferred Taxes Other Liabilities 2.700 62.236 59.743 ------------------ -----------------TOTAL LIABILITIES 329.762 345.582 0.705 0.700 EQUITY Common Stock Capital Surplus 327.742 315.404 Retained Earnings 986.523 938.580 Less: Treasury Stock 412.626 412.536 ------------------ -----------------TOTAL EQUITY 902.344 842.148 ------------------ -----------------TOTAL LIABILITIES & EQUITY Common Shares Outstanding 1,232.106 1,187.730 52.288 51.918 ANNUAL INCOME STATEMENT (MILLIONS, EXCEPT PER SHARE) Jan10 Jan09 Sales 1,909.575 1,972.418 Cost of Goods Sold 1,025.759 1,031.241 ------------------- -----------------Gross Profit 883.816 941.177 Selling, General, & Administrative Exp. 732.722 757.073 ------------------- -----------------Operating Income Before Deprec. Depreciation,Depletion,&Amortization 151.094 184.104 86.090 90.665 ------------------- -----------------Operating Profit 65.004 93.439 Interest Expense 0.332 4.300 Non-Operating Income/Expense 0.000 2.592 Special Items 3.200 (2.968) ------------------- -----------------Pretax Income 67.872 88.763 Total Income Taxes 22.364 29.919 ------------------- -----------------Income Before Extraordinary Items & Discontinued Operations 45.508 58.844 ------------------- -----------------Savings Due to Common Stock Equiv. (0.834) 0.000 ------------------- -----------------Adjusted Net Income 44.674 58.844 EPS Basic from Operations 0.820 1.180 EPS Diluted from Operations 0.820 1.170 Dividends Per Share 0.280 0.280 Com Shares for Basic EPS 52.280 51.645 Com Shares for Diluted EPS 52.280 51.944 urnover-Control, and Leverage and HEET Jan08 Jan07 Jan06 99.367 179.694 263.001 24.872 17.018 19.276 492.423 448.586 416.603 27.179 0.000 0.000 27.154 35.531 30.732 ------------------ ------------------ -------------- 670.995 680.829 729.612 865.084 669.340 611.957 454.917 379.700 342.371 ------------------ ------------------ -------------- 410.167 289.640 269.586 75.609 61.765 63.073 99.696 64.718 61.003 ------------------ ------------------ -------------- 1,256.467 1,096.952 1,123.274 0.000 0.000 0.000 146.713 111.213 125.064 5.590 19.676 21.086 70.222 75.458 72.531 54.730 19.791 19.404 ------------------ ------------------ -------------- 277.255 226.138 238.085 92.399 72.967 207.750 4.000 12.200 24.400 66.876 31.875 25.506 ------------------ ------------------ -------------- 440.530 343.180 495.741 0.696 0.691 0.671 305.209 286.120 255.214 923.713 775.857 641.558 413.681 308.896 269.910 ------------------ ------------------ -------------- 815.937 753.772 627.533 ------------------ ------------------ -------------- 1,256.467 1,096.952 1,123.274 51.479 53.919 53.069 COME STATEMENT EXCEPT PER SHARE) Jan08 Jan07 Jan06 2,112.558 1,882.064 1,724.898 1,062.205 1,004.972 965.889 ------------------ ------------------ --------------1,050.353 877.092 759.009 741.405 591.767 531.839 ------------------ ------------------ --------------308.948 285.325 227.170 80.296 61.387 61.874 ------------------ ------------------ --------------228.652 223.938 165.296 5.046 9.216 5.888 5.987 9.786 3.280 0.000 0.000 0.000 ------------------ ------------------ --------------229.593 224.508 162.688 82.552 75.933 58.785 ------------------ ------------------ --------------147.041 148.575 103.903 ------------------ ------------------ --------------0.000 0.000 0.000 ------------------ ------------------ --------------147.041 148.575 103.903 2.760 2.710 2.010 2.730 2.620 1.950 0.230 0.200 0.000 53.258 53.111 53.753 53.890 54.749 55.365