# Use the spreadsheet to calculate as many of the company

24 / 01 / 2019 Assignments

This paper circulates around the core theme of Use the spreadsheet to calculate as many of the company together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 59. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.

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

### 100% Plagiarism Free & Custom Written

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

Company # 11483120

## STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

## Benefits You Get

• Free Turnitin Report
• Unlimited Revisions
• Installment Plan
• Plagiarism Free Guarantee
• 100% Confidentiality
• 100% Satisfaction Guarantee
• 100% Money-Back Guarantee
• On-Time Delivery Guarantee

+44 7340 9595 39
+44 20 3239 6980
[email protected]
AKOSZTEC “International House, 12 Constance Street, London, United Kingdom, E16 2DQ”

Hire Researcher
Rated 4.7/5 based on 8956 Reviews

## Supporting Pages

FLAT 25% OFF ON EVERY ORDER. Use "FLAT25" as your promo code during checkout