Home / Questions / Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont
| Use the spreadsheet to calculate as many of the companyAc€?cs 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 companyAc€?cs performance over this period? | ||||||||
| ANNUAL BALANCE SHEET | ||||||||
| ($ MILLIONS) | ||||||||
| MENS WEARHOUSE INC | ||||||||
| Jan10 | Jan09 | Jan08 | Jan07 | Jan06 | ||||
| ASSETS | ||||||||
| Cash & Short-Term Investments | 186.018 | 104.533 | 99.367 | 179.694 | 263.001 | |||
| Net Receivables | 16.745 | 40.662 | 24.872 | 17.018 | 19.276 | |||
| Inventories | 431.492 | 440.099 | 492.423 | 448.586 | 416.603 | |||
| Prepaid Expenses | 26.603 | 27.179 | 0.000 | 0.000 | ||||
| Other Current Assets | 74.075 | 19.718 | 27.154 | 35.531 | 30.732 | |||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| Total Current Assets | 708.330 | 631.615 | 670.995 | 680.829 | 729.612 | |||
| Gross Plant, Property & Equipment | 885.981 | 865.084 | 669.340 | 611.957 | ||||
| Accumulated Depreciation | 498.509 | 454.917 | 379.700 | 342.371 | ||||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| Net Plant, Property & Equipment | 344.746 | 387.472 | 410.167 | 289.640 | 269.586 | |||
| Intangibles | 59.414 | 65.268 | 75.609 | 61.765 | 63.073 | |||
| Other Assets | 119.616 | 103.375 | 99.696 | 64.718 | 61.003 | |||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| TOTAL ASSETS | 1,232.106 | 1,187.730 | 1,256.467 | 1,096.952 | 1,123.274 | |||
| LIABILITIES | ||||||||
| Long Term Debt Due In One Year | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | |||
| Accounts Payable | 83.052 | 108.800 | 146.713 | 111.213 | 125.064 | |||
| Taxes Payable | 23.936 | 0.019 | 5.590 | 19.676 | 21.086 | |||
| Accrued Expenses | 66.542 | 70.222 | 75.458 | 72.531 | ||||
| Other Current Liabilities | 117.047 | 44.862 | 54.730 | 19.791 | 19.404 | |||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| Total Current Liabilities | 224.035 | 220.223 | 277.255 | 226.138 | 238.085 | |||
| Long Term Debt | 43.491 | 62.916 | 92.399 | 72.967 | 207.750 | |||
| Deferred Taxes | 2.700 | 4.000 | 12.200 | 24.400 | ||||
| Other Liabilities | 62.236 | 59.743 | 66.876 | 31.875 | 25.506 | |||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| TOTAL LIABILITIES | 329.762 | 345.582 | 440.530 | 343.180 | 495.741 | |||
| EQUITY | ||||||||
| Common Stock | 0.705 | 0.700 | 0.696 | 0.691 | 0.671 | |||
| Capital Surplus | 327.742 | 315.404 | 305.209 | 286.120 | 255.214 | |||
| Retained Earnings | 986.523 | 938.580 | 923.713 | 775.857 | 641.558 | |||
| Less: Treasury Stock | 412.626 | 412.536 | 413.681 | 308.896 | 269.910 | |||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| TOTAL EQUITY | 902.344 | 842.148 | 815.937 | 753.772 | 627.533 | |||
| ------------------ | ------------------ | ------------------ | ------------------ | -------------- | ||||
| TOTAL LIABILITIES & EQUITY | 1,232.106 | 1,187.730 | 1,256.467 | 1,096.952 | 1,123.274 | |||
| Common Shares Outstanding | 52.288 | 51.918 | 51.479 | 53.919 | 53.069 | |||
| ANNUAL INCOME STATEMENT | ||||||||
| (MILLIONS, EXCEPT PER SHARE) | ||||||||
| Jan10 | Jan09 | Jan08 | Jan07 | Jan06 | ||||
| Sales | 1,909.575 | 1,972.418 | 2,112.558 | 1,882.064 | 1,724.898 | |||
| Cost of Goods Sold | 1,025.759 | 1,031.241 | 1,062.205 | 1,004.972 | 965.889 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Gross Profit | 883.816 | 941.177 | 1,050.353 | 877.092 | 759.009 | |||
| Selling, General, & Administrative Exp. | 732.722 | 757.073 | 741.405 | 591.767 | 531.839 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Operating Income Before Deprec. | 151.094 | 184.104 | 308.948 | 285.325 | 227.170 | |||
| Depreciation,Depletion,&Amortization | 86.090 | 90.665 | 80.296 | 61.387 | 61.874 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Operating Profit | 65.004 | 93.439 | 228.652 | 223.938 | 165.296 | |||
| Interest Expense | 0.332 | 4.300 | 5.046 | 9.216 | 5.888 | |||
| Non-Operating Income/Expense | 0.000 | 2.592 | 5.987 | 9.786 | 3.280 | |||
| Special Items | 3.200 | (2.968) | 0.000 | 0.000 | 0.000 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Pretax Income | 67.872 | 88.763 | 229.593 | 224.508 | 162.688 | |||
| Total Income Taxes | 22.364 | 29.919 | 82.552 | 75.933 | 58.785 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Income Before Extraordinary | ||||||||
| Items & Discontinued Operations | 45.508 | 58.844 | 147.041 | 148.575 | 103.903 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Savings Due to Common Stock Equiv. | (0.834) | 0.000 | 0.000 | 0.000 | 0.000 | |||
| ------------------- | ------------------ | ------------------ | ------------------ | --------------- | ||||
| Adjusted Net Income | 44.674 | 58.844 | 147.041 | 148.575 | 103.903 | |||
| EPS Basic from Operations | 0.820 | 1.180 | 2.760 | 2.710 | 2.010 | |||
| EPS Diluted from Operations | 0.820 | 1.170 | 2.730 | 2.620 | 1.950 | |||
| Dividends Per Share | 0.280 | 0.280 | 0.230 | 0.200 | 0.000 | |||
| Com Shares for Basic EPS | 52.280 | 51.645 | 53.258 | 53.111 | 53.753 | |||
| Com Shares for Diluted EPS | 52.280 | 51.944 | 53.890 | 54.749 | 55.365 | |||
Dec 03 2019 View more View Less
Determine the rms voltage across R3 in Figure 82.
Aug 06 2020Please write an essay in IRAC format for the following: Corporation Pearl, who is President of Oilco Corporation, enters into negotiations with Wood Corps President, Ve...
Feb 15 2020An economy begins in long-run equilibrium, and then a change in government regulations allows banks to start paying interest on checking accounts. Recall that the money s...
May 27 2020Derive an equation for the work of mechanically reversible, isothermal compression of 1 mol of a gas from an initial volume V1 to a final volume V2 when theequation of th...
Jul 31 2020Harmony Corporation plans to set aside $60,000 per year beginning 1 year from now for replacing equipment 5 years from now. What will be the buying power of the amount ac...
May 11 2020The Navy uses a certain type of vacuum tube in a sonar scanning device. Based on past experience, the vacuum tube exhibits the following failure pattern:Failures during...
Jul 27 2020Blake and Mouton’s Managerial Grid is an approach to defining leadership styles based on a manager’s concern for people and concern for production. Which of the following...
Nov 27 2017Develop a logic diagram that shows the common and unique outcomes that employee satisfaction, commitment, and engagement might be related to.
May 30 2020Suppose the Holiday Inn Hotel has annual fixed costs applicable to its rooms of $1.2 million for its 300-room hotel, average daily room rents of $50, and average variable...
Jun 10 2021An advance in technology lowers the price of a laptop. If the demand for laptops is price inelastic, the quantity of laptops sold will_and total revenue will a) increase:...
Apr 19 2021