Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the provided income statement and balance sheet statement to calculate a list of accounting ratios. Then use the ratios you calculated to evaluate the
Use the provided income statement and balance sheet statement to calculate a list of accounting ratios. Then use the ratios you calculated to evaluate the companys performance over the given time period. See Excel file for details.
Question 2 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 output area for a list of ratios) b. What do these ratios suggest about the company's performance over this period? area area ANNUAL BALANLE SHEL $ MILLIONS MENS WEARHOUSE INC 2009 2008 99.367 492.423 2006 2010 2009 2008 200Z 2006 ASSETS Cash & Short-Term Investments Net Receivables Inventories Prepaid Expenses Other Current Assets Profitability Ratios (in %) 179.694 on 40.662 440.099 26.603 Return on assets 431.492 448.586 Profit margin Gross margin Turnover-Control Ratios Fixed-asset turnover Total Current Assets 708.330631.615 670.995680.829729.612 Gross Plant, Property & Equipment Accumulated Depreciation 866.005 521.259 885.981 498.509 865.084 454.917 669.340 379.700 611.957 Inventory turnover 342.371 269.586 61.003 ollectin peri Days' sales in cash Payables period Net Plant, Property & Equipment Intangibles 410.167 75.609 289.640 61.765 65.268 Leverage and Liquidity Ratios Assets to equity Debt to assets Debt to equity Times interest earned Current ratio Quick ratio (aka acid test) TOTAL ASSETS 1,232.106 1,187.730 1256.467 1096.952 1,123.274 LIABILITIES Long Term Debt Duel Accounts Payable Taxes Fayable Accrued Expenses Other Current Liabilities 108.800 19.676 75.458 21.086 66.542 117.047 035 220.223 277.255 92.399 66.876 440.530 Total Current Liabilities 238.085 Long Term Debt Deferred Taxes Other Liabilities 72.967 12.200 62.236 TOTAL LIABILITIES 329.762 345.582 495.741 EQUITY Common Stock Capital Surplus Retained Earnings Less: Treasury Stock 327.742 986.523 412.626 315.404 938.580 412.536 305.209 775.857 641.558 269.910 627.533 1,232.106 1,187.730 1256.467 1096.952 1,123.274 53.069 842.148 753.772 TOTAL EQUITY TOTAL LIABILITIES &EQUITY Common Shares Outstanding 902.344 815.937 52.288Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started