69.9k views
0 votes
ROI: Fill in the Unknowns Provide the missing data in the following situations: North American Division Asian Division European Division Sales Answer $5,000,000 Answer Net operating income $80,000 $200,000 $168,000 Operating assets Answer Answer $700,000 Return on investment 16% 10% Answer Return on sales 0.04 Answer 0.16 Investment turnover Answer Answer 1.5

1 Answer

2 votes

Answer and Explanation:

The computation of the missing data is shown below:

Particulars North American Asian European

division Division Division

Sales $2,000,000 $5,000,000 $1,050,000

Net Operating

Income $80,000 $200,000 $168,000

Operating

assets $500,000 $2,000,000 $700,000

Return on

Investment 16% 10% 24%

Return on sales 0.04 0.04 0.16

Investment

turnover 4 2.5 1.5

Working notes :

1. For North American division

Sales is

= Net operating income ÷ return on sales

= $80,000 ÷ 0.04

= $2,000,000

Operating assets is

= Net Operating income ÷ return on investment

= $80,000 ÷ 16%

= $500,000

Investment turnover is

= Sales ÷ operating assets

= $2,000,000 ÷ $500,000

= 4

For Asian Division

Operating assets is

= Net operating income ÷ return on investment

= $200,000 ÷ 10%

= $2,000,000

Return on sales is

= Net Operating income ÷ sales

= $200,000 ÷ $5,000,000

= 0.04

Investment turnover is

= Sales ÷ operating assets

= $5,000,000 ÷ $2,000,000

= 2.5

For European division:

Sales is

= Operating assets × investment turnover

= $700,000 × 1.5

= $1,050,000

Return on investment is

= Net operating income ÷ operating assets × 100

= $168,000 ÷ $700,000

= 24%

User Hagen
by
4.4k points