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

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%