Answer 1.
Sales Margin = Operating Income / Sales
Capital Turnover = Sales / Total Assets
Return on Investment = Operating Income / Total Assets
Residual Income = Operating Income - Target Rate of Return * Total Assets
Answer 2.
Cole Company:
Sales Margin = Operating Income / Sales
Sales Margin = $43,200 / $108,000
Sales Margin = 40%
Capital Turnover = Sales / Total Assets
Capital Turnover = $108,000 / $72,000
Capital Turnover = 1.50
Return on Investment = Operating Income / Total Assets
Return on Investment = $43,200 / $72,000
Return on Investment = 60%
Residual Income = Operating Income - Target Rate of Return *
Total Assets
Residual Income = $43,200 - 9% * $72,000
Residual Income = $36,720
LaChut Industries:
Sales Margin = Operating Income / Sales
0.14 = $110,600 / Sales
Sales = $790,000
Capital Turnover = Sales / Total Assets
4.00 = $790,000 / Total Assets
Total Assets = $197,500
Return on Investment = Operating Income / Total Assets
Return on Investment = $110,600 / $197,500
Return on Investment = 56%
Residual Income = Operating Income - Target Rate of Return *
Total Assets
$69,125 = $110,600 - Target Rate of Return * $197,500
Target Rate of Return * $197,500 = $41,475
Target Rate of Return = 21%
Gable, Inc.:
Sales Margin = Operating Income / Sales
0.10 = Operating Income / $522,000
Operating Income = $52,200
Capital Turnover = Sales / Total Assets
Capital Turnover = $522,000 / $180,000
Capital Turnover = 2.90
Residual Income = Operating Income - Target Rate of Return *
Total Assets
$21,600 = $52,200 - Target Rate of Return * $180,000
Target Rate of Return * $180,000 = $30,600
Target Rate of Return = 17%
s. There are three unrelated companies, Cole Company, LaChut Industries, and Gable, Inc. (1) (4 points) Write down...
Data on three unrelated companies are given in the.following table. EEB (Click the icon to view the table.) Fill in the missing information in the preceding table. (Enter the capital turnover to two decimal places X.XX) Austen Company Plumb Industries 100,000 Sales 40,000 $ 110,600 Operating income $ 80,000 Total assets 40 % Sales margin 14 % 125 4.00 Capital turnover. 50% % Return on investment (ROI) 10% 21 % Target rate of return. 32,000 Residual income 69 Austen Company...
Data on three unrelated companies are given in the following table. E: (Click the icon to view the table.) Fill in the missing information in the preceding table. (Enter the capital turnover to two decimal places X.XX.) Preston, Inc. Sales .......................$ Operating income ............ $ Total assets ............... .......$ 114,000 39,900 71,250 Sales margin ................. Capital turnover.......... Return on investment (ROI) .... Target rate of return... 10 % Residual income .............. Hoffman Industries $ 525,000 Sales ..................... $ Operating income...
I can't get to the numbers I'm suppose to be getting.. Can
Someone help me out?
Data on three unrelated companies are given in the following table. (Click the icon to view the table.) Fill in the missing information in the preceding table. (Enter the capital turnover to two decimal places X.XX.) i Data Table Cole, Inc. Sales ....................$ 120,000 Operating income .......... $ 36,000 Total assets ................$ 75,000 Sales margin ............. Return on investment (ROI) ... Target rate of...
Data on three unrelated companies are given in the following table.... (Click the icon to view the table.) Sales . . . . . . . . . . . . . . . . . . $ 105,000 ? $ 525,000 Operating income . . . . . . . . . . $ 37,800 $ 129,600 ? Total assets . . . . . . . . . . . . . . $ 84,000 ? ? Sales...
Required: The following data pertain to three divisions of Nevada Aggregates, Inc. The company's required rate of return on invested capital is 8 percent. (Round "Capital turnover" answers to 2 decimal place.) Division A Division B Division C Sales revenue Income S 1,740,000 8,280,000 Average investment 20 % 25 % Sales margin 20 % Capital turnover 1.00 4.00 20 % ROI Residual income 507,000 $
Evaluating New Investments Using Return on Investment (ROI) and Residual Income Three divisions of Watcore Inc. report the following sales and operating data: Division A Division B Division C Sales . . .... . . . . . .. . .. .. $6,000,000 $10,000,000 $8,000,000 Average operating assets . . . $1,500,000 $5,000,000 $2,000,000 Operating income ... .... . . $300,000 $900,000 $180,000 Minimum required rate of return. 15% 18% 12% Required: 1. Compute the return...
Question 4 (Marks: 27) South African companies measure their results by certain ratios. The following mining companies returned the following ratios and margins: Extract A Anglos Jarmony Afro Minerals Return on Assets 9% 6% 10% Profit Margin 2.6% 3.3% 8% Asset Turnover 3.4 times 1.9 times 1.3 times Diggin' X has been making waves in the mining industry and shows potential. Its 2019 results returned the following information: Extract B ZAR Capital Invested in Assets 250,000 Sales Revenue (Net sales)...
please provide formulas for excel.
lentz hma0 1 21a start erl Insert ρ Tell me what you want to do Page layout alibr B lu- 田, 오ア송, Fnrmulas Data Rrview View Help t=흐. F Merge & Centr. $. %, з , Conditional Format as vQvICTFy3pil WOBeiQY Mx wZkYYoRC L. Insert Delete Format ClearFiltr Seloct 50rt & Find & Cle Format Painter Formatting Table 03 Always use cell references and formulas where appropriate to receive full credit. If you 1 cupy/paste...
On January 1, 2012, two companies, Polland Ltd. and Turkey Inc. were incorporated. Each company operates a restaurant and had identical revenues during the year of $3 million but Polland bought its building for $1.7 million and the related land for $800,000. The company estimated that the building would have a useful life of 20 years with no residual value. Polland uses the straight-line method of depreciation. Because of the building purchase, Polland had an outstanding 4% bank loan during...
Problem 3-15 Journal Entries; T-Accounts; Financial Statements [LO3-1, LO3-2, LO3-3, LO3-4] points Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy equipment for use in North Sea oil fields. The company uses a job-order costing system that applies manufacturing overhead cost to jobs on the basis of direct labor- hours. Its predetermined overhead rate was based on a cost formula that estimated $395,600 of manufacturing overhead for an estimated allocation base of 920 direct labor-hours....