Question

In: Accounting

The contribution format income statement for Huerra Company for last year is given below: Total Unit...

The contribution format income statement for Huerra Company for last year is given below:

Total Unit
Sales $ 1,000,000 $ 50.00
Variable expenses 600,000 30.00
Contribution margin 400,000 20.00
Fixed expenses 322,000 16.10
Net operating income 78,000 3.90
Income taxes @ 40% 31,200 1.56
Net income $ 46,800 $ 2.34

The company had average operating assets of $491,000 during the year.

Required:

1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover.

For each of the following questions, indicate whether the margin and turnover will increase, decrease, or remain unchanged as a result of the events described, and then compute the new ROI figure. Consider each question separately, starting in each case from the data used to compute the original ROI in (1) above.

2. Using Lean Production, the company is able to reduce the average level of inventory by $109,000. (The released funds are used to pay off short-term creditors.)

3. The company achieves a cost savings of $11,000 per year by using less costly materials.

4. The company issues bonds and uses the proceeds to purchase machinery and equipment that increases average operating assets by $122,000. Interest on the bonds is $18,000 per year. Sales remain unchanged. The new, more efficient equipment reduces production costs by $5,000 per year.

5. As a result of a more intense effort by sales people, sales are increased by 10%; operating assets remain unchanged.

6. At the beginning of the year, obsolete inventory carried on the books at a cost of $20,000 is scrapped and written off as a loss.

7. At the beginning of the year, the company uses $177,000 of cash (received on accounts receivable) to repurchase and retire some of its common stock.

Solutions

Expert Solution

Solution:

Note 1. Operating Assets turnover ratio = Sales/average operating assets

Note 2. Margin = (Net income/sales)*100

Note 3. ROI(Return on Investment)= (Net income/Ttal operating assets)*100

Note 4. Operating Assets = $4,91,000

1. Operating Assets turnover ratio ($10,00,000/$4,91,000) = 2.04

Margin ($46,800/$10,00,000)*100 = 4.68%

ROI ($46,800/$4,91,000)*100 = 9.53%

2. Reduction in average inventory will reduce total opearting assets.

Total opearting assets ($4,91,000-$1,09,000) = $3,82,000

Operating Assets turnover ratio ($10,00,000/$3,82,000) = 2.62

Margin ($46,800/$10,00,000)*100 = 4.68%

ROI ($46,800/$3,82,000)*100 = 12.25%

3. Saving in cost will increase net income by $(46,800+$11,000) = $57,800

Operating Assets turnover ratio ($10,00,000/$4,91,000) = 2.04

Margin ($57,800/$10,00,000)*100 = 5.78%

ROI ($ 57,800/$4,91,000)*100 = 11.77%

4. Operating assets increase by ($4,91,000+$122,000) = $6,13,000

Saving in production cost pf $5000 will increase net income by ($46,800+5,000) = $51,800

Operating Assets turnover ratio ($10,00,000/$6,13,000) = 1.63

Margin ($51,800/$10,00,000)*100 = 5.18%

ROI ($51,800/$6,13,000)*100 = 8.45%

5. Sales increase by 10% is given in question.

So, No. of units at present ($10,00,000/$50,000) = 20,000unit

No. of units after 10% increase ($11,00,000/$50,000) = 22,000unit

Particular Per unit($) Value at 20,000 unit($) Value at 22,000 unit($)
Sales 50 10,00,000 11,00,000
Variable expense 30 6,00,000 6,60,000
Contribution margin 20 4,00,000 4,40,000
Fixed expense 16.10 3,22,000 5,18,000
Net operating income 3.90 78,000 85,800
Income tax@ 40% 1.56 31,200 34,320
Net Income 2.34 46,800 51,480

Operating Assets turnover ratio ($11,00,000/$4,91,000) = 2.24

Margin ($51,480/11,00,000)*100 = 4.68%

ROI ($51,480/11,00,000)*100 = 10.48%

6. Obsolete inventory reduces by 20,000 will affect both Net income & operating Assets.

So, Net income($46,800-$20,000) = $26,800

Operating assets ($4,91,000-$20,000) = $4,71,000

Operating Assets turnover ratio ($10,00,000/$4,71,000) = 2.12

Margin ($26,800/$10,00,000)*100 = 2.68%

ROI ($26,800/$4,71,000)*100 = 5.69%

7. Operating assets decrease by $177,000 for using of cash by company.

So, operating assets ($4,91,000-$1,77,000) = $3,14,000

Operating Assets turnover ratio ($10,00,000/$3,14,000) = 3.18

Margin ($46,800/$10,00,000)*100 = 4.68%

ROI ($46,800/$3,14,000)*100 = 14.90%


Related Solutions

The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 996,000 $ 49.80 Variable expenses 597,600 29.88 Contribution margin 398,400 19.92 Fixed expenses 316,400 15.82 Net operating income 82,000 4.10 Income taxes @ 40% 32,800 1.64 Net income $ 49,200 $ 2.46 The company had average operating assets of $502,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 4,000,000 $ 80.00 Variable expenses 2,800,000 56.00 Contribution margin 1,200,000 24.00 Fixed expenses 840,000 16.80 Net operating income 360,000 7.20 Income taxes @ 30% 108,000 2.16 Net income $ 252,000 $ 5.04 The company had average operating assets of $2,000,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 1,002,000 $ 50.10 Variable expenses 601,200 30.06 Contribution margin 400,800 20.04 Fixed expenses 320,800 16.04 Net operating income 80,000 4.00 Income taxes @ 40% 32,000 1.60 Net income $ 48,000 $ 2.40 The company had average operating assets of $502,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 998,000 $ 49.90 Variable expenses 598,800 29.94 Contribution margin 399,200 19.96 Fixed expenses 321,200 16.06 Net operating income 78,000 3.90 Income taxes @ 40% 31,200 1.56 Net income $ 46,800 $ 2.34 The company had average operating assets of $493,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 998,000 $ 49.90 Variable expenses 598,800 29.94 Contribution margin 399,200 19.96 Fixed expenses 321,200 16.06 Net operating income 78,000 3.90 Income taxes @ 40% 31,200 1.56 Net income $ 46,800 $ 2.34 The company had average operating assets of $507,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 998,000 $ 49.90 Variable expenses 598,800 29.94 Contribution margin 399,200 19.96 Fixed expenses 321,200 16.06 Net operating income 78,000 3.90 Income taxes @ 40% 31,200 1.56 Net income $ 46,800 $ 2.34 The company had average operating assets of $499,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 1,008,000 $ 50.40 Variable expenses 604,800 30.24 Contribution margin 403,200 20.16 Fixed expenses 323,200 16.16 Net operating income 80,000 4.00 Income taxes @ 40% 32,000 1.60 Net income $ 48,000 $ 2.40 The company had average operating assets of $495,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 1,008,000 $ 50.40 Variable expenses 604,800 30.24 Contribution margin 403,200 20.16 Fixed expenses 327,200 16.36 Net operating income 76,000 3.80 Income taxes @ 40% 30,400 1.52 Net income $ 45,600 $ 2.28 The company had average operating assets of $504,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 1,000,000 $ 50.00 Variable expenses 600,000 30.00 Contribution margin 400,000 20.00 Fixed expenses 320,000 16.00 Net operating income 80,000 4.00 Income taxes @ 40% 32,000 1.60 Net income $ 48,000 $ 2.40 The company had average operating assets of $495,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
The contribution format income statement for Huerra Company for last year is given below: Total Unit...
The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 1,000,000 $ 50.00 Variable expenses 600,000 30.00 Contribution margin 400,000 20.00 Fixed expenses 324,000 16.20 Net operating income 76,000 3.80 Income taxes @ 40% 30,400 1.52 Net income $ 45,600 $ 2.28 The company had average operating assets of $505,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT