Question: D E 3 Chapter 2 Problem 14 Suggested Answers a. Use the spreadsheet to calculate as many of the company's profitability, turnover-control, and leverage

spreadsheet to calculate as many of the company's profitability, turnover-control, and leverage

and liquidity ratios as you can for these years 4 b. What

D E 3 Chapter 2 Problem 14 Suggested Answers 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 4 b. What do these ratios suggest about the company's performance over this period? 5 Review each category 6 7 MEN'S WEARHOUSE INC. BALANCE SHEET (S millions) 2006 2007 2008 2009 2010 8 9 ASSETS 10 Cash & Short-Term Investments 263.001 179.694 99.367 104.533 186.018 11 Net Receivables 19.276 17.018 24.872 40.662 16.745 12 Inventories 416.603 448.586 492.423 440.099 431.492 13 Prepaid Expenses 0.000 0.000 27.179 26.603 0.000 14 Other Current Assets 30.732 35.531 27.154 19.718 74.075 15 Total Current Assets 729.612 680.829 670.995 631.615 708.330 16 17 Gross Plant, Property & Equipment 611.957 669.340 865.084 885.981 866.005 18 Accumulated Depreciation 342.371 379.700 454.917 498.509 521.259 19 Net Plant, Property & Equipment 269.586 289.640 410.167 387.472 344.746 20 Intangibles 63.073 61.765 75.609 65.268 59.414 21 Other Assets 61.003 64.718 99.696 103.375 119.616 22 TOTAL ASSETS 1,123.274 1,096.952 1,256.467 1,187.730 1,232.106 23 24 LIABILITIES 25 Long Term Debt Due In One Year 0.000 0.000 0.000 0.000 0.000 26 Accounts Payable 125.064 111.213 146.713 108.800 83.052 27 Taxes Payable 21.086 19.676 5.590 0.019 23.936 28 Accrued Expenses 72.531 75.458 70.222 66.542 0.000 29 Other Current Liabilities 19.404 19.791 54.730 44.862 117.047 30 Total Current Liabilities 238.085 226.138 277.255 220.223 224.035 31 32 Long Term Debt 207.750 72.967 92.399 62.916 43.491 33 Deferred Taxes 24.400 12,200 4.000 2.700 0.000 34 Other Liabilities 25.506 31.875 66.876 59.743 62.236 35 TOTAL LIABILITIES 495.741 343.180 440.530 345.582 329.762 36 37 EQUITY 38 Common Stock 0.671 0.691 0.696 0.700 0.705 39 Capital Surplus 255.214 286.120 305.209 315.404 327.742 40 Retained Earnings 641.558 775.857 923.713 938.580 986.523 41 Less: Treasury Stock 269.910 308.896 413.681 412.536 412.626 42 TOTAL EQUITY 627.533 753.772 815.937 842.148 902.344 43 TOTAL LIABILITIES & EQUITY 1123 274 1006052 1.256.467 1187720 1.322 106

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

a. For the years 20052009, calculate Boeings: i. Total liabilities-to-equity ratio ii. Times interest earned ratio iii. Times burden covered ratio b. What percentage decline in earnings before...

14. A spreadsheet containing financial statements for Men's Wearhouse, Inc., for fiscal years 2006-2010 is available for download from McGraw-Hill's Connect or your course instructor (see the Preface...

capital budgeting question. I need help from a Finance expert. Question 1 Common size financial statements Input area: Assets 2013 Current assets Cash Accounts receivable Inventory Total $ $ 2014...

Chapter 2 Problem 13 All information in Excel attach file and pls explain the answer . a. Use the spreadsheet to calculate as many of the companys Profitability, Turnover-Control, and Leverage and...

N54 . E D G CL B H MEN'S WEARHOUSE INC. BALANCE SHEET (5 millions) 2006 2007 2008 2009 2010 1 2 3 4 5 6 7 8 ASSETS Cash & Short-Term Investments Net Receivables Inventories Prepaid Expenses Other...

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...

Show formulas for each step 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...

Chapter 2 Problem 13 a. Use the spreadsheet to calculate as many of the companys Profitability, Turnover-Control, and Leverage and Liquidity ratios as you can for these years (see Table 2.5 in text...

List four basic financial statement analysis procedures, describe how you would calculate each procedure and discuss why you would use each procedure. In your initial response, please do not use...

Use the Algebra of Limits and Standard Sequences to evaluate: 12n3 - 4n2 + n+ 2 lim (1) 5n3 + 10n + 5 n-00 10n3 5n2 + 4 (2) lim n4 + 5n3 + 10n n-00 2V5 nv5 lim (3) 5n2 5n n-00 lim (n-2n) (4)

ACME Company has 3,000,000 in current assets and 1,400,000 in current liabilities. The firm wants to raise dividends by issuing notes payable. How much can its short-term debt (notes payable)...

An increase in the consumer price index is commonly referred to as (A) economic growth. (B) inflation. (C) unemployment. (D) discouraged workers. (E) deflation.

The force constant of a massless spring is 2 5 . 0 N / m . A mass of 0 . 4 5 kg is oscillating in simple harmonic motion at the end of the spring

Bodily injury awards have increased at a significant rate during the past two decades. Towhat do you attribute this increase?Were previous awards inadequate, or are the current ones excessive?

Because of a rash of liability suits and high judgments, many municipalities and government subdivisions have had difficulty in obtaining liability insurance for a decade. This seems ironic...

At one time, it was felt that liability insurance would undermine the tort system, which has as its central theorem the concept that the individual responsible for injuring another should be made to...