2008 2009 2010 Cash 600 350 300 Accounts Receivable 2 730 3 100 4 200 Inventories 2 800 3 200 4 300 Prepaid Expenses Net Fixed Assets 1 200 1 300 1 450 Total Assets 7 330 7 950 10 250 Short term Debt 300 500 1 900 Accounts Payable 1 400 1 600 2 050 Accrued Expenses 200 260 350 Long term Debt 1 300 1 200 1 100 Owners' Equity 4 130 4 390 4 850 Total Liabilities OE 7 330 7 950 10 250 Net Sales 22 100 24 300 31 600 COGS 17 600 19 300 25 100 SG A 3 750 4 000 5 000 Depreciation Expense 100 100 150 EBIT 650 900 1 350 Net Interest Expense 110 130 260 EBT 540 770 1 090 Tax Expense 220 310 430 EAT 320 460 660 Dividends 180 200 200 In 2010, firms in the same business sector as the company had an average collection period of thirty days, an average payment period of 33 days and an inventory turnover of eight Suppose the company operated its operating cycle like average firm in the sector On December 31, 2010, What would its WCR, managerial balance sheet, operating margin, IC turnover, ROCE, financial cost ratio, its tax effect and ROE be (Assume a ratio of interest expense to EBIT to 4 and an effective tax rate of 40 )

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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 09, 2024

2008 2009 2010 Cash 600 350 300 Accounts Receivable 2.730 3.100 4.200 Inventories 2.800 3.200 4.300 Prepaid Expenses - - - Net Fixed Assets 1.200

	2008	2009	2010
Cash	600	350	300
Accounts Receivable	2.730	3.100	4.200
Inventories	2.800	3.200	4.300
Prepaid Expenses	-	-	-
Net Fixed Assets	1.200	1.300	1.450
Total Assets	7.330	7.950	10.250

Short-term Debt	300	500	1.900
Accounts Payable	1.400	1.600	2.050
Accrued Expenses	200	260	350
Long-term Debt	1.300	1.200	1.100
Owners' Equity	4.130	4.390	4.850
Total Liabilities & OE	7.330	7.950	10.250

Net Sales	22.100	24.300	31.600
COGS	17.600	19.300	25.100
SG&A	3.750	4.000	5.000
Depreciation Expense	100	100	150
EBIT	650	900	1.350
Net Interest Expense	110	130	260
EBT	540	770	1.090
Tax Expense	220	310	430
EAT	320	460	660

Dividends	180	200	200

In 2010, firms in the same business sector as the company had an average collection period of thirty days, an average payment period of 33 days and an inventory turnover of eight. Suppose the company operated its operating cycle like average firm in the sector. On December 31, 2010, What would its WCR, managerial balance sheet, operating margin, IC turnover, ROCE, financial cost ratio, its tax effect and ROE be?(Assume a ratio of interest expense to EBIT to 4% and an effective tax rate of 40%)