Question

In: Accounting

Exercise 9-1 Compute the Return on Investment (ROI) [LO9-1] Alyeska Services Company, a division of a...

Exercise 9-1 Compute the Return on Investment (ROI) [LO9-1]

Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below:

  Sales $ 18,800,000  
  Net operating income $ 5,200,000
  Average operating assets $ 36,300,000  
Required:
1.

Compute the margin for Alyeska Services Company. (Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).)

Margin %
2.

Compute the turnover for Alyeska Services Company. (Round your answer to 2 decimal places.)

Turnover
3.

Compute the return on investment (ROI) for Alyeska Services Company. (Round your intermediate calculations to 2 decimal places. Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).

ROI %

Exercise 9-2 Residual Income [LO9-2]

Juniper Design Ltd. of Manchester, England, is a company specializing in providing design services to residential developers. Last year the company had net operating income of $450,000 on sales of $1,900,000. The company’s average operating assets for the year were $2,100,000 and its minimum required rate of return was 11%.

Required:

Compute the company’s residual income for the year.

Average operating assets
Net operating income
Minimum required return
Residual income

Exercise 9-5 Return on Investment (ROI) [LO9-1]

Provide the missing data in the following table for a distributor of martial arts products: (Enter your Margin and ROI answers to the nearest percentage (i.e., 0.123 should be entered as 12).)

Division
Alpha Bravo Charlie
Sales ? $280,000 ?
Net operating income ? $39,200 $38,870
Average operating assets $438,000 ? ?
Margin 7 % ? % 13 %
Turnover 4 ? ?
Return on investment (ROI) ? % 28 % 13 %

Solutions

Expert Solution

Exercise 9-1

1. Margin = Net Operating Income / Sales

  $5200000 / $ 18800000 = 27.66%

2. Turnover = Sales / Average Operating Assets

$18800000/ $ 36300000 = 0.52

3. ROI = Margin x Turnover

27.62% x 0.52 = 14.36%

Exercise 9-2

Residual Income = Net Operating Income - ( Minimum Return Required On Assets x Average Operating Assets)

Average Operating Assets $2100000
Net Operating Income $450000
Minimum Required Return 11%
Residual Income $450000-($ 2100000*11%)= $219000

Exercise 9-5

Division
Alpha Bravo Charlie
Sales $1752000 (Refer note 1) $280,000 $299000 ( Refer note 7)
Net operating income $12264000 ( Refer note 2) $39,200 $38,870
Average operating assets $438,000 $140000( Refer note 6) $299000 (Refer note 8)
Margin 7 % 14% ( Refer Note 4) % 13 %
Turnover 4 2 (Refer note 5) 1 (Refer note 8)
Return on investment (ROI) 28% ( Refer note 3) % 28 % 13 %
1 Turnover= Sales / Average Operating Assets 4. Margin = Net Operating Income / Sales 7. Margin = Net Operating Income / Sales
4= sales/438000 $39200/$280000= 14% 13= $38870 / Sales
Sales = $438000*4 = $1752000 Sales = $299000
5. ROI = Margin x Turnover
2 Margin= Net Operating Income / Sales 28 = 14* Turnover 8. ROI = Margin x Turnover
7% = NOI / 1752000 Turnover= 2 13 = 13* Turnover
NOI = $1752000 * 7 = $12264000 Turnover = 1
6. Turnover = Sales /Average Operating Assets
3 ROI = Margin x Turnover 2= $280000/ Avg OA 9. Turnover = Sales /Average Operating Assets
7*4 =28% Average operating assets = $140000 1= $299000 / Avg OA
Average Operating assets = $299000

Related Solutions

Exercise 12-1 Compute the Return on Investment (ROI) [LO12-1] Alyeska Services Company, a division of a...
Exercise 12-1 Compute the Return on Investment (ROI) [LO12-1] Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below: Sales $ 17,400,000 Net operating income $ 4,700,000 Average operating assets $ 35,900,000 Required: 1. Compute the margin for Alyeska Services Company. (Round your answer to 2 decimal places.) 2.Compute the turnover for Alyeska Services Company. (Round your answer...
Exercise 9-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO9-1] [The...
Exercise 9-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO9-1] [The following information applies to the questions displayed below.] Fitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as needed, are evaluated based largely on return on investment (ROI). The company's Springfield Club reported the following results for the past year: Sales $ 820,000 Net operating income $ 22,140 Average operating assets $ 100,000...
Exercise 9-6 Contrasting Return on Investment (ROI) and Residual Income [LO9-1, LO9-2] Meiji Isetan Corp. of...
Exercise 9-6 Contrasting Return on Investment (ROI) and Residual Income [LO9-1, LO9-2] Meiji Isetan Corp. of Japan has two regional divisions with headquarters in Osaka and Yokohama. Selected data on the two divisions follow: Division Osaka Yokohama   Sales $ 10,700,000    $ 37,000,000      Net operating income $ 749,000    $ 3,330,000      Average operating assets $ 2,675,000    $ 18,500,000    Required: 1. For each division, compute the return on investment (ROI) in terms of margin and turnover. (Do not round intermediate...
Exercise 12-9 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO12-1, LO12-2] Selected...
Exercise 12-9 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO12-1, LO12-2] Selected sales and operating data for three divisions of three different companies are given below: Division A Division B Division C   Sales $ 6,000,000 $ 10,000,000 $ 8,000,000   Average operating assets $ 1,500,000 $ 5,000,000 $ 2,000,000   Net operating income $ 300,000 $ 900,000 $ 180,000   Minimum required rate of return 15 % 18 % 12 % Required: 1. Compute the margin, turnover and return...
Exercise 10-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO10-1] [The...
Exercise 10-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO10-1] [The following information applies to the questions displayed below.] Fitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as needed, are evaluated based largely on return on investment (ROI). The company's Springfield Club reported the following results for the past year: Sales $ 1,400,000 Net operating income $ 70,000 Average operating assets $ 350,000...
Exercise 11-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO11-1] [The...
Exercise 11-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO11-1] [The following information applies to the questions displayed below.] Fitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as needed, are evaluated based largely on return on investment (ROI). The company's Springfield Club reported the following results for the past year: Sales $ 820,000 Net operating income $ 22,140 Average operating assets $ 100,000...
chapter 9 h 2 Exercise 9-16 Flexible Budgets in a Cost Center [LO9-1, LO9-2] Packaging Solutions...
chapter 9 h 2 Exercise 9-16 Flexible Budgets in a Cost Center [LO9-1, LO9-2] Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.40q Indirect labor $4,500 + $1.50q Utilities $5,700 + $0.60q Supplies $1,200 + $0.40q Equipment...
Exercise 9-1 Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides diving...
Exercise 9-1 Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company’s planning budget for May appears below: Puget Sound Divers Planning Budget For the Month Ended May 31 Budgeted diving-hours (q) 250 Revenue ($390.00q) $ 97,500 Expenses: Wages and salaries ($11,000 + $126.00q) 42,500 Supplies ($5.00q) 1,250 Equipment rental ($2,100 + $26.00q) 8,600 Insurance ($3,800) 3,800 Miscellaneous ($540 + $1.48q)...
Exercise 9-17 Flexible Budget Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] AirQual Test Corporation provides on-site air...
Exercise 9-17 Flexible Budget Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: Fixed Component per Month Variable Component per Job Actual Total for February Revenue $ 275 $ 38,500 Technician wages $ 8,100 $ 7,950 Mobile lab operating expenses $ 4,800 $ 33 $ 9,590 Office expenses $ 2,400 $ 2 $ 2,550 Advertising expenses $ 1,590...
Exercise 9-11 Flexible Budget [LO9-1] Lavage Rapide is a Canadian company that owns and operates a...
Exercise 9-11 Flexible Budget [LO9-1] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.70 Electricity $ 1,400 $ 0.07 Maintenance $ 0.10 Wages and salaries $ 4,000 $ 0.30 Depreciation $ 8,400 Rent $ 1,900 Administrative expenses $ 1,800 $ 0.04 For example, electricity costs are $1,400 per month plus...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT