Westerville Company reported the following results from last year’s operations: Sales $1,800,000
Variable expenses 435,000
Contribution margin 1,365,000
Fixed expenses 1,005,000
Net operating income $360,000
Average operating assets $1,200,000

At the beginning of this year, the company has a $300,000 investment opportunity with the following cost and revenue characteristics:

Sales $360,000
Contribution margin ratio 70% of sales
Fixed expenses $216,000

The company’s minimum required rate of return is 10%.

1. What is last year's margin?
2. What is last year's turnover?
3. What is last year's ROI?
4. What is the margin related to this year's investment opportunity?
5. What is the turnover related to this year's investment opportunity?
6. What is the ROI related to this year's investment opportunity?
7. If the company pursues the investment opportunity and otherwise performs the same as last year, what margin will it earn this year?
8. If the company pursues the investment opportunity and otherwise performs the same as last year, what turnover will it earn this year?
9. If the company pursues the investment opportunity and otherwise performs the same as last year, what ROI will it earn this year?

Westerville Company

1. Last year's margin is:

= 20%

2. Last year's turnover is:

= $1,800,000

3. Last year's ROI is:

= 30%

4. The margin related to this year's investment opportunity is:

= 10%

5. The turnover related to this year's investment opportunity is:

= $360,000.

6. The ROI related to this year's investment opportunity is:

= 12%

7. The margin this year is:

= 18.33%

8. The turnover that it will earn this year is:

= $2,160,000

9. The ROI that it will earn this year is:

= 26.4%

Explanation:

a) Data and Calculations:

                                             Last Year's          This Year's          Total

Sales                                    $1,800,000           $360,000     $2,160,000

Variable expenses                  435,000              108,000          543,000

Contribution margin             1,365,000             252,000      $1,617,000

Fixed expenses                    1,005,000              216,000        1,221,000

Net operating income          $360,000             $36,000       $396,000

Average operating assets $1,200,000           $300,000    $1,500,000

Minimum Required Rate of Return = 10%

=                                             $120,000             $30,000       $150,000

1. Last year's margin = 20% ($360,000/$1,800,000) * 100

2. Last year's turnover = $1,800,000

3. Last year's ROI = 30% ($360,000/$1,200,000) * 100

4. The margin related to this year's investment opportunity is:

= 10% ($36,000/$360,000) * 100

5. The turnover related to this year's investment opportunity is $360,000.

6. The ROI related to this year's investment opportunity is:

12% ($36,000/$300,000)

7. The margin = 18.33% ($396,000/$2,160,000) * 100

8. The turnover that it will earn this year = $2,160,000

9. The ROI that it will earn this year = 26.4% ($396,000/$1,500,000) * 100