a. Use the spreadsheet to calculate as many of the company's Profitability, Turnover-Control, and Leverage and Liquidity
Question:
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?
Transcribed Image Text:
ANNUAL BALANCE SHEET ($ MILLIONS) MENS WEARHOUSE INC Jan09 Jan08 Jan10 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 30.732 74.075 19.718 27.154 35.531 708.330 670.995 729.612 Total Current Assets 631.615 680.829 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 Intangibles 410.167 344.746 387.472 289.640 269.586 75.609 59.414 65.268 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 Accounts Payable 0.000 0.000 0.000 0.000 0.000 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 Deferred Taxes 43.491 62.916 92.399 72.967 207.750 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 Retained Earnings 327.742 315.404 305.209 286.120 255.214 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 invested capital 964.54 $ 821.95 $ 892.38 $ 796.08 $ 793.83
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 80% (10 reviews)
ANNUAL BALANCE SHEET MILLIONS MENS WEARHOUSE INC Jan10 Jan09 Jan08 Jan07 Jan06 ASSETS Cash ShortTerm Investments 186018 104533 99367 179694 263001 Net Receivables 16745 40662 24872 17018 19276 Invento...View the full answer
Answered By
Ann Wangechi
hey, there, paying attention to detail is one of my strong points, i do my very best combined with passion. i enjoy researching since the net is one of my favorite places to be and to learn. i am a proficient and versatile blog, article academic and research writing i possess excellent English writing skills, great proof-reading. i am a good communicator and always provide feedback in real time. i'm experienced in the writing field, competent in computing, essays, accounting and research work and also as a Database and Systems Administrator
4.90+
151+ Reviews
291+ Question Solved
Related Book For
Question Posted:
Students also viewed these Managerial Accounting questions
-
A spreadsheet containing financial statements for Mens Wearhouse, Inc., for fiscal years 20062010 is available for download from McGraw-Hills Connect or your course instructor. MEN'S WEARHOUSE INC....
-
A monopoly faces the demand function Q = 30 p. Its inverse demand function is therefore p = 30 Q, so its marginal revenue function is MR = 30 2Q. The firms cost function is C = 6Q + Q 2 , so its...
-
Develop a spreadsheet model for Classify each of the data elements in the Sales Transactions database (Figure 1.1) as categorical, ordinal, interval, or ratio data and explain why. Apply the...
-
n Write a program that finds how many zeros in the list and puts the result in cntr variable (Copy and paste a program that is not related to the requirements will get Ox0000) .data list1 .word...
-
In an oscillating circuit shown in Fig. 4.27 the coil inductance is equal to L = 2.5 mH and the capacitor have capacitances C1 = 2.0μF and C2 = 3.0μF. The capacitors were charged to a voltage V...
-
Find and read the article entitled "Demystifying the Law: Examining Cause and Effect Principles". Explain the difference between "but for" causation and proximate causation. ...
-
What competencies are required for global account management and do they differ from those required of the key account manager?
-
The following transactions pertain to 2012, the first-year operations of Hall Company. All inventory was started and completed during 2012. Assume that all transactions are cash transactions. 1....
-
Sandy Pears, Managing Director of Little Pear Juice Co, gives you feedback that $90.25 is the superannuation contribution amount paid for Daniella. Is the contribution amount paid to Daniella...
-
Ralph and Kathy Gump are married with one 20-year-old dependent child. Ralph earns a total of $98,000 and estimates their itemized deductions to be $28,500 for the year. Kathy is not employed. Use...
-
1-Two brothers each open IRAs in 2009 and plan to invest $3,000 per year for the next 30 years. John makes his first deposit on January 1, 2009, and will make all future deposits on the first day of...
-
The details can be worked out by preparing the respective accounts a. Determine the cost and accumulated depreciation of the equipment sold during 20X4. b. Determine the selling price of the...
-
In 1998, the people of Puerto Rico held a referendum in which there were five choices retain commonwealth status, become a state, become independent, free association ( a type of independence that...
-
Given the following matrices: 214 A= -3 p 2 -1-25 01 B= q 3 4 0 Given that the determinant of A is 3, find the value of p O A. p = 3 OB.p=-2 C p = -3 ODP=2 4
-
2:21. Activity 4 EVAL... Activity: Module 3 Lesson 2 Group yourselves into 5 members per group. Each group will choose/identify one multimodal text (print advertisement) and insert the photo in your...
-
Rachel and Tala are in their early 40s and have two boys together, Callum (8) and Leroy (5). Rachel also has an adult daughter Ruby from a previous relationship. Rachel works full time in the...
-
The ultimate goal of this section is to generate a Java based project or game application of your choice, using all the Java concepts discussed in this course. Part 2: Instructions Develop Java...
-
In the questions below, display formulas and the steps necessary to acquire a solution. 1. Find the minimum cost solution for the following transportation problem which has cost structure as: To/From...
-
Environmental Corporation specializes in the production and sale of ecofriendly packaging. In 2020, Environmental reported net income (earnings) in excess of analyst expectations. This included a...
-
According to a New York Times columnist, The estate tax affects a surprisingly small number of people. In 2003, . . . just 1.25 percent of all deaths resulted in taxable estates, with most of them...
-
Should firms require higher rates of return on foreign projects than on identical projects located at home? Explain.
-
What is a Eurodollar? If a French citizen deposits $10,000 in Chase Manhattan Bank in New York, have Eurodollars been created? What if the deposit is made in Barclays Bank in London Chase Manhattans...
-
What is a Eurodollar? If a French citizen deposits $10,000 in Chase Manhattan Bank in New York, have Eurodollars been created? What if the deposit is made in Barclays Bank in London Chase Manhattans...
-
The following partially complete T-accounts for the month of June along with additional information are from Renfrew & Company: Materials Inventory Work-in-Process Inventory Finished Goods Inventory...
-
The information that follows pertains to Julia Company: (a) Temporary differences for the year 2024 are summarized below. Expenses deducted in the tax return, but not included in the income...
-
Harwood Company uses a job-order costing system that applies overhead cost to jobs on the basis of machine-hours. The company's predetermined overhead rate of $2.60 per machine-hour was based on a...
Study smarter with the SolutionInn App