Use the spreadsheet to calculate as many of the company

Use the spreadsheet to calculate as many of the company

a. 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 INCJan10Jan09Jan08Jan07Jan06ASSETSCash & Short-Term Investments186.018104.53399.367179.694263.001Net Receivables16.74540.66224.87217.01819.276Inventories431.492440.099492.423448.586416.603Prepaid Expenses26.60327.1790.0000.000Other Current Assets74.07519.71827.15435.53130.732————————————————————————————–Total Current Assets708.330631.615670.995680.829729.612Gross Plant, Property & Equipment885.981865.084669.340611.957Accumulated Depreciation498.509454.917379.700342.371————————————————————————————–Net Plant, Property & Equipment344.746387.472410.167289.640269.586Intangibles59.41465.26875.60961.76563.073Other Assets119.616103.37599.69664.71861.003————————————————————————————–TOTAL ASSETS1,232.1061,187.7301,256.4671,096.9521,123.274LIABILITIESLong Term Debt Due In One Year0.0000.0000.0000.0000.000Accounts Payable83.052108.800146.713111.213125.064Taxes Payable23.9360.0195.59019.67621.086Accrued Expenses66.54270.22275.45872.531Other Current Liabilities117.04744.86254.73019.79119.404————————————————————————————–Total Current Liabilities224.035220.223277.255226.138238.085Long Term Debt43.49162.91692.39972.967207.750Deferred Taxes2.7004.00012.20024.400Other Liabilities62.23659.74366.87631.87525.506————————————————————————————–TOTAL LIABILITIES329.762345.582440.530343.180495.741EQUITYCommon Stock0.7050.7000.6960.6910.671Capital Surplus327.742315.404305.209286.120255.214Retained Earnings986.523938.580923.713775.857641.558Less: Treasury Stock412.626412.536413.681308.896269.910————————————————————————————–TOTAL EQUITY902.344842.148815.937753.772627.533————————————————————————————–TOTAL LIABILITIES & EQUITY1,232.1061,187.7301,256.4671,096.9521,123.274Common Shares Outstanding52.28851.91851.47953.91953.069ANNUAL INCOME STATEMENT(MILLIONS, EXCEPT PER SHARE)Jan10Jan09Jan08Jan07Jan06Sales1,909.5751,972.4182,112.5581,882.0641,724.898Cost of Goods Sold1,025.7591,031.2411,062.2051,004.972965.889—————————————————————————————-Gross Profit883.816941.1771,050.353877.092759.009Selling, General, & Administrative Exp.732.722757.073741.405591.767531.839—————————————————————————————-Operating Income Before Deprec.151.094184.104308.948285.325227.170Depreciation,Depletion,&Amortization86.09090.66580.29661.38761.874—————————————————————————————-Operating Profit65.00493.439228.652223.938165.296Interest Expense0.3324.3005.0469.2165.888Non-Operating Income/Expense0.0002.5925.9879.7863.280Special Items3.200(2.968)0.0000.0000.000—————————————————————————————-Pretax Income67.87288.763229.593224.508162.688Total Income Taxes22.36429.91982.55275.93358.785—————————————————————————————-Income Before ExtraordinaryItems & Discontinued Operations45.50858.844147.041148.575103.903—————————————————————————————-Savings Due to Common Stock Equiv.(0.834)0.0000.0000.0000.000—————————————————————————————-Adjusted Net Income44.67458.844147.041148.575103.903EPS Basic from Operations0.8201.1802.7602.7102.010EPS Diluted from Operations0.8201.1702.7302.6201.950Dividends Per Share0.2800.2800.2300.2000.000Com Shares for Basic EPS52.28051.64553.25853.11153.753Com Shares for Diluted EPS52.28051.94453.89054.74955.365


Price: £ 59

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh