Chapter 2 Problem 13 All information in Excel attach file and pls explain the answer a Use the spreadsheet to calculate as many of the companys 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 companys 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 Chapter 2 Problem 13 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 ANNUAL BALANCE SHEET ($ MILLIONS) MENS WEARHOUSE INC Jan10 ASSETS Cash Short Term Investments Net Receivables Inventories Prepaid Expenses Other Current Assets Total Current Assets TOTAL ASSETS LIABILITIES Long Term Debt Due In One Year Accounts Payable Taxes Payable Accrued Expenses Other Current Liabilities Total Current Liabilities Long Term Debt Deferred Taxes Other Liabilities TOTAL LIABILITIES EQUITY Common Stock Capital Surplus Retained Earnings Less Treasury Stock TOTAL EQUITY TOTAL LIABILITIES EQUITY Jan08 186 018 16 745 431 492 Jan07 104 533 99 367 40 662 24 872 440 099 492 423 26 603 27 179 74 075 19 718 27 154 708 330 631 615 670 995 179 694 17 018 448 586 0 000 35 531 680 829 885 981 865 084 498 509 454 917 387 472 410 167 65 268 75 609 103 375 99 696 1,187 730 1,256 467 669 340 379 700 289 640 61 765 64 718 1,096 952 0 000 83 052 23 936 0 000 0 000 108 800 146 713 0 019 5 590 66 542 70 222 117 047 44 862 54 730 224 035 220 223 277 255 0 000 111 213 19 676 75 458 19 791 226 138 43 491 62 916 92 399 2 700 4 000 62 236 59 743 66 876 329 762 345 582 440 530 72 967 12 200 31 875 343 180 0 705 0 700 0 696 327 742 315 404 305 209 986 523 938 580 923 713 412 626 412 536 413 681 902 344 842 148 815 937 1,232 106 1,187 730 1,256 467 0 691 286 120 775 857 308 896 753 772 1,096 952 Gross Plant, Property Equipment Accumulated Depreciation Net Plant, Property Equipment Intangibles Other Assets Jan09 344 746 59 414 119 616 1,232 106 Common Shares Outstanding 52 288 51 918 51 479 53 919 ANNUAL INCOME STATEMENT (MILLIONS, EXCEPT PER SHARE) Jan10 Sales Cost of Goods Sold Gross Profit Selling, General, Administrative Exp Operating Income Before Deprec Depreciation,Depletion, Amortization Operating Profit Interest Expense Non Operating Income Expense Special Items Pretax Income Total Income Taxes Income Before Extraordinary Items Discontinued Operations Savings Due to Common Stock Equiv Adjusted Net Income Jan09 Jan08 Jan07 1,909 575 1,972 418 2,112 558 1,025 759 1,031 241 1,062 205 883 816 941 177 1,050 353 732 722 757 073 741 405 151 094 184 104 308 948 86 090 90 665 80 296 65 004 93 439 228 652 1,882 064 1,004 972 877 092 591 767 285 325 61 387 223 938 0 332 4 300 5 046 0 000 2 592 5 987 3 200 (2 968) 0 000 67 872 88 763 229 593 22 364 29 919 82 552 9 216 9 786 0 000 224 508 75 933 45 508 58 844 147 041 (0 834) 0 000 0 000 44 674 58 844 147 041 148 575 0 000 148 575 EPS Basic from Operations EPS Diluted from Operations 0 820 0 820 1 180 1 170 2 760 2 730 2 710 2 620 Dividends Per Share 0 280 0 280 0 230 0 200 52 280 52 280 51 645 51 944 53 258 53 890 53 111 54 749 Com Shares for Basic EPS Com Shares for Diluted EPS rol, and Leverage and Jan06 263 001 19 276 416 603 0 000 30 732 729 612 611 957 342 371 269 586 63 073 61 003 1,123 274 0 000 125 064 21 086 72 531 19 404 238 085 207 750 24 400 25 506 495 741 0 671 255 214 641 558 269 910 627 533 1,123 274 53 069 Jan06 1,724 898 965 889 759 009 531 839 227 170 61 874 165 296 5 888 3 280 0 000 162 688 58 785 103 903 0 000 103 903 2 010 1 950 0 000 53 753 55 365

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 08, 2024

Chapter 2 Problem 13 All information in Excel attach file and pls explain the answer . a. Use the spreadsheet to calculate as many of

Chapter 2 Problem 13 All information in Excel attach file and pls explain the answer .
a. Use the spreadsheet to calculate as many of the companys 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 companys 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

Chapter 2 Problem 13 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? ANNUAL BALANCE SHEET ($ MILLIONS) MENS WEARHOUSE INC Jan10 ASSETS Cash & Short-Term Investments Net Receivables Inventories Prepaid Expenses Other Current Assets Total Current Assets TOTAL ASSETS LIABILITIES Long Term Debt Due In One Year Accounts Payable Taxes Payable Accrued Expenses Other Current Liabilities Total Current Liabilities Long Term Debt Deferred Taxes Other Liabilities TOTAL LIABILITIES EQUITY Common Stock Capital Surplus Retained Earnings Less: Treasury Stock TOTAL EQUITY TOTAL LIABILITIES & EQUITY Jan08 186.018 16.745 431.492 Jan07 104.533 99.367 40.662 24.872 440.099 492.423 26.603 27.179 74.075 19.718 27.154 ------------------ ------------------ -----------------708.330 631.615 670.995 179.694 17.018 448.586 0.000 35.531 -----------------680.829 885.981 865.084 498.509 454.917 ------------------ -----------------387.472 410.167 65.268 75.609 103.375 99.696 ------------------ -----------------1,187.730 1,256.467 669.340 379.700 -----------------289.640 61.765 64.718 -----------------1,096.952 0.000 83.052 23.936 0.000 0.000 108.800 146.713 0.019 5.590 66.542 70.222 117.047 44.862 54.730 ------------------ ------------------ -----------------224.035 220.223 277.255 0.000 111.213 19.676 75.458 19.791 -----------------226.138 43.491 62.916 92.399 2.700 4.000 62.236 59.743 66.876 ------------------ ------------------ -----------------329.762 345.582 440.530 72.967 12.200 31.875 -----------------343.180 0.705 0.700 0.696 327.742 315.404 305.209 986.523 938.580 923.713 412.626 412.536 413.681 ------------------ ------------------ -----------------902.344 842.148 815.937 ------------------ ------------------ -----------------1,232.106 1,187.730 1,256.467 0.691 286.120 775.857 308.896 -----------------753.772 -----------------1,096.952 Gross Plant, Property & Equipment Accumulated Depreciation Net Plant, Property & Equipment Intangibles Other Assets Jan09 -----------------344.746 59.414 119.616 -----------------1,232.106 Common Shares Outstanding 52.288 51.918 51.479 53.919 ANNUAL INCOME STATEMENT (MILLIONS, EXCEPT PER SHARE) Jan10 Sales Cost of Goods Sold Gross Profit Selling, General, & Administrative Exp. Operating Income Before Deprec. Depreciation,Depletion,&Amortization Operating Profit Interest Expense Non-Operating Income/Expense Special Items Pretax Income Total Income Taxes Income Before Extraordinary Items & Discontinued Operations Savings Due to Common Stock Equiv. Adjusted Net Income Jan09 Jan08 Jan07 1,909.575 1,972.418 2,112.558 1,025.759 1,031.241 1,062.205 ------------------- ------------------ -----------------883.816 941.177 1,050.353 732.722 757.073 741.405 ------------------- ------------------ -----------------151.094 184.104 308.948 86.090 90.665 80.296 ------------------- ------------------ -----------------65.004 93.439 228.652 1,882.064 1,004.972 -----------------877.092 591.767 -----------------285.325 61.387 -----------------223.938 0.332 4.300 5.046 0.000 2.592 5.987 3.200 (2.968) 0.000 ------------------- ------------------ -----------------67.872 88.763 229.593 22.364 29.919 82.552 ------------------- ------------------ ------------------ 9.216 9.786 0.000 -----------------224.508 75.933 ------------------ 45.508 58.844 147.041 ------------------- ------------------ -----------------(0.834) 0.000 0.000 ------------------- ------------------ -----------------44.674 58.844 147.041 148.575 -----------------0.000 -----------------148.575 EPS Basic from Operations EPS Diluted from Operations 0.820 0.820 1.180 1.170 2.760 2.730 2.710 2.620 Dividends Per Share 0.280 0.280 0.230 0.200 52.280 52.280 51.645 51.944 53.258 53.890 53.111 54.749 Com Shares for Basic EPS Com Shares for Diluted EPS rol, and Leverage and Jan06 263.001 19.276 416.603 0.000 30.732 -------------729.612 611.957 342.371 -------------269.586 63.073 61.003 -------------1,123.274 0.000 125.064 21.086 72.531 19.404 -------------238.085 207.750 24.400 25.506 -------------495.741 0.671 255.214 641.558 269.910 -------------627.533 -------------1,123.274 53.069 Jan06 1,724.898 965.889 --------------759.009 531.839 --------------227.170 61.874 --------------165.296 5.888 3.280 0.000 --------------162.688 58.785 --------------103.903 --------------0.000 --------------103.903 2.010 1.950 0.000 53.753 55.365