Use the spreadsheet to calculate as many of the companyAc€?cs Pro

Home / Questions / Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont

Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont

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 INC
		Jan10	Jan09	Jan08	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	74.075	19.718	27.154	35.531	30.732
		------------------	------------------	------------------	------------------	--------------
	Total Current Assets	708.330	631.615	670.995	680.829	729.612

	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	344.746	387.472	410.167	289.640	269.586
	Intangibles	59.414	65.268	75.609	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	0.000	0.000	0.000	0.000	0.000
	Accounts Payable	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	43.491	62.916	92.399	72.967	207.750
	Deferred Taxes		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	327.742	315.404	305.209	286.120	255.214
	Retained Earnings	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


			ANNUAL INCOME STATEMENT
			(MILLIONS, EXCEPT PER SHARE)

		Jan10	Jan09	Jan08	Jan07	Jan06

	Sales	1,909.575	1,972.418	2,112.558	1,882.064	1,724.898
	Cost of Goods Sold	1,025.759	1,031.241	1,062.205	1,004.972	965.889
		-------------------	------------------	------------------	------------------	---------------
	Gross Profit	883.816	941.177	1,050.353	877.092	759.009
	Selling, General, & Administrative Exp.	732.722	757.073	741.405	591.767	531.839
		-------------------	------------------	------------------	------------------	---------------
	Operating Income Before Deprec.	151.094	184.104	308.948	285.325	227.170
	Depreciation,Depletion,&Amortization	86.090	90.665	80.296	61.387	61.874
		-------------------	------------------	------------------	------------------	---------------
	Operating Profit	65.004	93.439	228.652	223.938	165.296

	Interest Expense	0.332	4.300	5.046	9.216	5.888
	Non-Operating Income/Expense	0.000	2.592	5.987	9.786	3.280
	Special Items	3.200	(2.968)	0.000	0.000	0.000
		-------------------	------------------	------------------	------------------	---------------
	Pretax Income	67.872	88.763	229.593	224.508	162.688
	Total Income Taxes	22.364	29.919	82.552	75.933	58.785
		-------------------	------------------	------------------	------------------	---------------
	Income Before Extraordinary
	Items & Discontinued Operations	45.508	58.844	147.041	148.575	103.903
		-------------------	------------------	------------------	------------------	---------------
	Savings Due to Common Stock Equiv.	(0.834)	0.000	0.000	0.000	0.000
		-------------------	------------------	------------------	------------------	---------------
	Adjusted Net Income	44.674	58.844	147.041	148.575	103.903

	EPS Basic from Operations	0.820	1.180	2.760	2.710	2.010
	EPS Diluted from Operations	0.820	1.170	2.730	2.620	1.950

	Dividends Per Share	0.280	0.280	0.230	0.200	0.000

	Com Shares for Basic EPS	52.280	51.645	53.258	53.111	53.753
	Com Shares for Diluted EPS	52.280	51.944	53.890	54.749	55.365

View less »

Feb 13 2016 01:44 AM

Solutions:

Disha Khetan answered 3 years ago

4986 answers so far

3 Ratings, (9 Votes)

Next Previous

Abhinav 03-Dec-2019

Answer (UnSolved)

question Get solution

Students will select and critique a media article Students will select and critique a media article on a crime topic using the Toulmin framework. See the “Assessment 4 Article Options” document for the articles that you...
The class of Qantas frequent flyer membership The class of Qantas frequent flyer membership is based on flying more for higher-level class. The types of memberships are based on distance flown, with bonuses that vary...
Each flight maintains an inventory table for consumable products Each flight maintains an inventory table for consumable products. The inventory will be refilled at end of each trip. The management wants to analyze the high costs of pr...
Qantas Airways is the flag carrier airline of Australia Qantas Airways is the flag carrier airline of Australia. Qantas' headquarter is located at the Qantas Centre in the Mascot suburb of Sydney, New South Wales. The Qantas G...
To promote the better services to VIP members and award customers To promote the better services to VIP members and award customers’ loyalty, Qantas provide the airline lounge with airport locations around Australia and the world. Those...
All Qantas Line Maintenance Stations can communicate with inbound aircraft provides All Qantas Line Maintenance Stations can communicate with inbound aircraft provides 24 hours per day for advice on incoming defects, facilitating the preparation of appro...
Customers can pay their purchased tickets by cash Customers can pay their purchased tickets by cash, cheque, bank card, visa card, master cards and frequent flyer point. The payment by American express card will be charg...
Each service and the in charge engineer Each service and the in charge engineer, the parts used, the problem fixed and service log for an aircraft will be recorded in the database. The management must make sure...
In the initial lectures on the economic way of thinking In the initial lectures on the economic way of thinking we considered the description of cost-benefit analysis in macroeconomics offered by Henry Hazlitt. Some years bac...
Qantas management is to ensure the successful completion Qantas management is to ensure the successful completion of around 300,000 flights every year to 57 airports around Australia and to 86 destinations in 36 countries that ...

Service

Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont

Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont

Solutions:

Answer (UnSolved)

Ask Homework Question

Writing Help

Have a language expert improve your writing

Instant response from experts on your writing help queries

Find your question's answer instantly in our Q&A bank

Service

Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont

Use the spreadsheet to calculate as many of the companyAc€?cs Profitability, Turnover-Cont

Solutions:

Do you need an answer to a question different from the above? Ask your question!

Answer (UnSolved)

Ask Homework Question

Writing Help

Have a language expert improve your writing

Instant response from experts on your writing help queries

Find your question's answer instantly in our Q&A bank