Question

Data on three unrelated companies are given in the following table Fill in the missing information...

Data on three unrelated companies are given in the following table

Fill in the missing information in the preceding table. ​(Enter the capital turnover to two decimal places​ X.XX.)

Preston, Inc.

Sales. . . . . . . . . . . . . . . . . . . . . . .

$116,000

Operating income. . . . . . . . . . . . .

$46,400

Total assets. . . . . . . . . . . . . . . . . .

$80,000

Sales margin. . . . . . . . . . . . . . . . .

%

Capital turnover. . . . . . . . . . . . . . .

Return on investment (ROI). . . . .

%

Target rate of return. . . . . . . . . . . .

12

%

Residual income. . . . . . . . . . . . . .

Data Table

Preston, Inc.

Gammaro Company

Johnson Industries

Sales. . . . . . . . . . . . . . . . . . . . . . . . .

$116,000

?

$484,000

Operating income. . . . . . . . . . . . . .

$46,400

$110,600

?

Total assets. . . . . . . . . . . . . . . . . . .

$80,000

?

?

Sales margin. . . . . . . . . . . . . . . . . .

?

14%

10%

Capital turnover. . . . . . . . . . . . . . .

?

4.00

?

Return on investment (ROI). . . . .

?

?

22%

Target rate of return. . . . . . . . . .

12%

21%

?

Residual income (RI). . . . . . . . . . .

?

?

$4,400

Homework Answers

Answer #1
  • Requirements asked

Preston, Inc.

Gammaro Company

Johnson Industries

Sales. . . . . . . . . . . . . . . . . . . . . . . . .

$116,000

$790,000

$484,000

Operating income. . . . . . . . . . . . . .

$46,400

$110,600

$48,400

Total assets. . . . . . . . . . . . . . . . . . .

$80,000

$197,500

$220,000

Sales margin. . . . . . . . . . . . . . . . . .

40%

14%

10%

Capital turnover. . . . . . . . . . . . . . .

1.45

4

2.2

Return on investment (ROI). . . . .

58%

56%

22%

Target rate of return. . . . . . . . . .

12%

21%

20%

Residual income (RI). . . . . . . . . . .

$36,800

$69,125

$4,400

--working

Preston, Inc.

Gammaro Company

Johnson Industries

Sales. . . . . . . . . . . . . . . . . . . . . . . . .

116000

=110600/14%

484000

Operating income. . . . . . . . . . . . . .

46400

110600

=484000*10%

Total assets. . . . . . . . . . . . . . . . . . .

80000

=790000/4

=48400/22%

Sales margin. . . . . . . . . . . . . . . . . .

=46400/116000

0.14

0.1

Capital turnover. . . . . . . . . . . . . . .

=116000/80000

4

=484000/220000

Return on investment (ROI). . . . .

=46400/80000

=110600/197500

0.22

Target rate of return. . . . . . . . . .

0.12

0.21

=+(48400-4400)/220000

Residual income (RI). . . . . . . . . . .

=46400-(80000*12%)

=110600-(197500*21%)

4400

Know the answer?
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
Similar Questions
Provide the missing data in the following table for a distributor of martial arts products: (Enter...
Provide the missing data in the following table for a distributor of martial arts products: (Enter "Turnover" and "ROI" answers to 1 decimal place.) Division Alpha Bravo Charlie Sales $335,000 Net operating income $40,200 $59,180 Average operating assets $370,000 Margin 6 % % 11 % Turnover 5.0 Return on investment (ROI) % 30.0 % 22.0 %
Provide the missing data in the following table for a distributor of martial arts products: (Round...
Provide the missing data in the following table for a distributor of martial arts products: (Round "Turnover" and "ROI" answers to 1 decimal place.) Division Alpha Bravo Charlie Sales $342,500 Net operating income $27,400 $32,900 Average operating assets $390,000 Margin 4 % % 7 % Turnover 5.0 Return on investment (ROI) % 20.0 % 14.0 %
Provide the missing data in the following table for a distributor of martial arts products: (Enter...
Provide the missing data in the following table for a distributor of martial arts products: (Enter "Turnover" and "ROI" answers to 1 decimal place.) Division Alpha Bravo Charlie Sales $276,000 Net operating income $22,080 $30,240 Average operating assets $497,000 Margin 4 % 8 % 7 % Turnover 4.0 Return on investment (ROI) % 16.0 % 10.5 %
Comparative data on three companies in the same service industry are given below: Required: 2. Fill...
Comparative data on three companies in the same service industry are given below: Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal places.) Company A B C Sales $4,464,000 $975,000 Net operating income $624,960 $165,750 Average operating assets $1,860,000 $2,730,000 Margin % % 4 % Turnover 1.90 Return on investment (ROI) % 5.10 % %
Comparative data on three companies in the same service industry are given below. Required: 2. Fill...
Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal places.) Company A B C Sales $4,906,000 $2,744,000 Net operating income $735,900 $548,800 Average operating assets $2,230,000 $2,580,000 Margin % % 6 % Turnover 1.60 Return on investment (ROI) % 16.00 % %
Comparative data on three companies in the same service industry are given below. Required: 2. Fill...
Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal places.) Company A B C Sales $3,060,000 $975,000 Net operating income $336,600 $126,750 Average operating assets $1,530,000 $2,560,000 Margin % % 7 % Turnover 2.30 Return on investment (ROI) % 3.90 % %
Comparative data on three companies in the same service industry are given below. Required: 2. Fill...
Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information. (Do not round intermediate calculations. Round the "Turnover" and "ROI" answers to 2 decimal places.) Companies in the Same Industry A B C Sales $4,020,000 $1,620,000 Net operating income $562,800 $194,400 Average operating assets $2,010,000 $2,900,000 Margin % % 4 % Turnover times times 1.50 times Return on investment (ROI) % 7.20 % %
Provide the missing data in the following table for a distributor of martial arts products: (Enter...
Provide the missing data in the following table for a distributor of martial arts products: (Enter "ROI" answers to one decimal place.) Division    Alpha Bravo Charlie Sales    ? $342,500    ? Net Operating Income    ? $34,250 $37,980 Average Operating Assets $482,000    ?    ? Margin 5% ?    9% Turnover    5.0 times    ? times    ? times Return on Investment    ?% 25%    18.0%
Given the following information, calculate the ROI and the RI for the Cub Division of Bear,...
Given the following information, calculate the ROI and the RI for the Cub Division of Bear, Inc. Break ROI into profit margin and asset turnover components. Sales $1,000,000 Cost of Goods Sold $ 700,000 SG&A Expenses 200,000   Operating Assets (January 1). $1,250,000 Operating Assets (December 31). .$1,750,000 Required Rate of Return 8%
The following information for companies X, Y, and Z is incomplete. Supply the missing data. (Negative...
The following information for companies X, Y, and Z is incomplete. Supply the missing data. (Negative amounts should be indicated by a minus sign. Round your return on investment to 1 decimal place. Omit the "$" and "%" signs in your response).           Company X Company Y Company Z    Operating income $ 220,000 $ $    Sales $ $ $    Invested capital $ $ 6,000,000 $ 32,000,000    Return on sales 32 % 40 % %    Capital turnover 20 % % 30...