Question

Data on three unrelated companies are given in the.following table. EEB (Click the icon to view the table.) Fill in the missi
Austen Company Plumb Industries Cleary, Inc. Sales $ 100,000 ? $ 490,000 Operating income 40,000 110,600 ? Total assets $ 80,
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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%
Add a comment
Know the answer?
Add Answer to:
Data on three unrelated companies are given in the.following table. EEB (Click the icon to view...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Data on three unrelated companies are given in the following table. E: (Click the icon to...

    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...

    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...

    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 g...

    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...

    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...

    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...

    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...

    (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....

    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....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT