Ans. | ||||||
Austen Company | Plumb industries | Cleary, Inc. | ||||
Sales | $100,000 | $790,000 | $490,000 | |||
Operating income | $40,000 | $110,600 | $39,200 | |||
Total assets | $80,000 | $197,500 | $196,000 | |||
Sales margin | 40% | 14% | 8% | |||
Capital turnover | 1.25 | 4.00 | 2.50 | |||
Return on investment | 50% | 56% | 20% | |||
Target rate of return | 10% | 21% | 19% | |||
Residual income | $32,000 | $69,125 | $1,960 | |||
*Calculations for Austen Company: | ||||||
Sales margin = Operating income / Sales * 100 | ||||||
$40,000 / $100,000 * 100 | ||||||
40% | ||||||
Capital turnover = Sales / Total assets | ||||||
$100,000 / $80,000 | ||||||
1.25 times | ||||||
Return on investment = Operating income / Total assets * 100 | ||||||
$40,000 / $80,000 * 100 | ||||||
50% | ||||||
Residual income = Net operating income - (Total assets * Target rate of return) | ||||||
$40,000 - ($80,000 * 10%) | ||||||
$40,000 - $8,000 | ||||||
$32,000 | ||||||
*Calculations for Plumb industries: | ||||||
Sales = Operating income / Sales margin | ||||||
$110,600 / 14% | ||||||
$790,000 | ||||||
Total assets = Sales / Capital turnover | ||||||
$790,000 / 4.00 | ||||||
$197,500 | ||||||
Return on investment = Operating income / Total assets * 100 | ||||||
$110,600 / $197,500 * 100 | ||||||
56% | ||||||
Residual income = Net operating income - (Total assets * Target rate of return) | ||||||
$110,600 - ($197,500 * 21%) | ||||||
$110,600 - $41,475 | ||||||
$69,125 | ||||||
*Calculations for Cleary, Inc.: | ||||||
Net operating income = Sales * Sales margin | ||||||
$490,000 * 8% | ||||||
$39,200 | ||||||
Total assets = Operating income / Return on investment | ||||||
$39,200 / 20% | ||||||
$196,000 | ||||||
Capital turnover = Sales / Total assets | ||||||
$490,000 / $196,000 | ||||||
2.5 times | ||||||
Residual income = Operating income - (Total assets * Target rate of return) | ||||||
$1,960 = $39,200 - ($196,000 * Target rate of return) | ||||||
($196,000 * Target rate of return) = $39,200 - $1,960 | ||||||
$196,000 * Target rate of return = $37,240 | ||||||
Target rate of return = $37,240 / $196,000 | ||||||
19.00% | ||||||
Data on three unrelated companies are given in the.following table. EEB (Click the icon to view...
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...
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...
s. There are three unrelated companies, Cole Company, LaChut Industries, and Gable, Inc. (1) (4 points) Write down the formulae, respectively, for Sales margin, Capital turnover, RO, and Residual Income. Answer: (2) (11 points) Fill in the missing numbers in the preceding table. (Round your answers to two decimal places if needed) Cole Company LaChut Industries Gable, Inc. $ 522,000 $108,000 Sales $ 110,600 $ 43,200 Operating income 180,000 $ 72,000 Total assets 10% 14% Sales margin 4.001076 Capital turnover...
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...
Results from First Corporation's most recent year of operations are presented in the following table. Requirements 1. Calculate the sales margin, capital turnover, and return on investment (ROI). 2. Calculate the residual income (RI). turnover, and return on investment (ROI). Data Table nargin, the sa Operating income ................$ Total assets. ................. $ Current liabilities............... 9,100 14,000 4,200 35,000 16 % the ca Sales........................ ..........$ Target rate of return. .............. the RO Print Done Results from First Corporation's most recent year...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C $ 28,760,000 $ 7,190,000 373,880 $ 25,950,000 $ 5,190,000 Sales $15,950,000 Average operating assets Net operating income Minimum required rate of return $3,190,000 733,700 6.008 752,550 6.508 14.508 Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover. 2. Compute the residual income (loss) for each...
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 $
(Just need Req 2 for both questions) Comparative data on three companies in the same service industry are given below: Required: 2. Fill in the missing information. (Round the "Margin" answers to 1 decimal place and "Turnover" answers to 2 decimal places.) Company В C $ $ Sales 600,000 500,000 84,000 70,000 Net operating income $ $ 300,000 1,000,000 Average operating assets 3.5% Margin % % Turnover 2.00 % 7 % Return on investment (ROI) % Exercise 10-12 Evaluating New...
Margin, Turnover, ROI Required: 1. Consider the data for each of the following four independent companies. Calculate the missing values in the table below. For margin and ROI, enter your answers as percentages, rounded to two decimal places. For example, the decimal value .03827 would be entered as "3.83" percent. For turnover, enter your answer as a decimal value rounded to two decimal places. A B C D Revenue $10,000 $47,000 $96,000 $ Expenses $8,000 $ $90,240 $ Operating income...
Margin, Turnover, ROI Required: 1. Consider the data for each of the following four independent companies. Calculate the missing values in the table below. For margin and ROI, enter your answers as percentages, rounded to two decimal places. For example, the decimal value .03827 would be entered as "3.83" percent. For turnover, enter your answer as a decimal value rounded to two decimal places. A B C D Revenue $10,000 $49,000 $96,000 $ Expenses $8,000 $ $90,240 $ Operating income...