(a)
Compute the missing terms.
(a)
Explanation of Solution
Profit margin: This ratio gauges the operating profitability by quantifying the amount of income earned from business operations from the sales generated.
Formula of profit margin:
Investment turnover: This ratio gauges the operating efficiency by quantifying the amount of sales generated from the assets invested.
Formula of investment turnover:
Formula of ROI according to Dupont formula:
Residual income: The remaining income from operations after deducting the desired acceptable income is referred to as residual income.
Formula of residual income:
Income from operations | XXX |
Less minimum acceptable income from operations as a percent of invested assets | XXX |
Residual income | XXX |
Table (1)
1)
Compute income from operations.
2)
Compute invested assets.
Note: Refer to missing amount (a) for value of income from operations.
3)
Compute investment turnover.
4)
Compute sales value.
5)
Compute sales value.
Note: Refer to missing amount (d) for value of sales.
6)
Compute ROI.
Note: Refer to missing amount (e) for value of invested assets.
7)
Compute income from operations.
8)
Compute profit margin.
Note: Refer to missing amount (g) for value of income from operations.
9)
Compute investment turnover.
10)
Compute ROI.
11)
Compute profit margin.
12)
Compute investment turnover.
(b)
Ascertain the residual income of for each division
(b)
Explanation of Solution
1)
Ascertain the residual income of N Division.
Step 1: Compute minimum acceptable income from operations as a percent of invested assets for N Division.
Note: Refer to missing amount (b) of part (a) for value of invested assets.
Step 2: Determine residual income of N Division.
Particulars | Amount ($) |
Income from operations | $60,200 |
Less minimum acceptable income from operations as a percent of invested assets | 41,280 |
Residual income | $18,920 |
Table (2)
Note: Refer to missing amount (a) of part (a) for value of income from operations, and Step 1 for value and computation of minimum acceptable income.
2)
Ascertain the residual income of S Division.
Step 1: Compute minimum acceptable income from operations as a percent of invested assets for S Division.
Note: Refer to missing amount (e) of part (a) for value of invested assets.
Step 2: Determine residual income of S Division.
Particulars | Amount ($) |
Income from operations | $51,300 |
Less minimum acceptable income from operations as a percent of invested assets | 36,000 |
Residual income | $15,300 |
Table (3)
Note: Refer to Step 1 for value and computation of minimum acceptable income.
3)
Ascertain the residual income of E Division.
Step 1: Compute minimum acceptable income from operations as a percent of invested assets for E Division.
Step 2: Determine residual income of E Division.
Particulars | Amount ($) |
Income from operations | $102,000 |
Less minimum acceptable income from operations as a percent of invested assets | 81,600 |
Residual income | $20,400 |
Table (4)
Note: Refer to missing amount (g) of part (a) for value of income from operations, and Step 1 for value and computation of minimum acceptable income.
4)
Ascertain the residual income of W Division.
Step 1: Compute minimum acceptable income from operations as a percent of invested assets for W Division.
Step 2: Determine residual income of W Division.
Particulars | Amount ($) |
Income from operations | $89,600 |
Less minimum acceptable income from operations as a percent of invested assets | 67,200 |
Residual income | $22,400 |
Table (5)
Note: Refer to missing amount (g) of part (a) for value of income from operations, and Step 1 for value and computation of minimum acceptable income.
(c) 1
Ascertain the profitable division in terms of ROI.
(c) 1
Explanation of Solution
The division with highest return on investment is considered as the most profitable division. Hence, N Division is the most profitable division with highest ROI of 17.5%.
(c) 2
Ascertain the division with highest residual income
(c) 2
Explanation of Solution
The division with highest residual income is considered as the most profitable division. Hence, W Division is the most profitable division with the highest residual income of $22,400.
Want to see more full solutions like this?
Chapter 24 Solutions
Financial and Managerial Accounting - Workingpapers
- Calculator Data for Divisions A, B, C, D, and E are as follows: a. Determine the missing items. Round rate of return on investment, profit margin, and investment turnover answers to one decimal place when required. Div. Sales Income from Operations Inv. Assets Rate of Return on Inv. Profit Margin Invest. Turnover A $ $35,000 $200,000 % % 1.6 B $455,000 $ $284,375 16% % C $525,000 $73,500 $ % % 1.2 D $800,000 $ $ % 13.0% 2.5 E $ $ $250,000 % 16.0% 2.0 b. Which division is most profitable in terms of income from operations? c. Which division is most profitable in terms of rate of return on investment?arrow_forwardThe sales, income from operations, and invested assets for each division of Frasier Company are as follows: Income from Invested Sales Operations Assets Division B $4,900,000 $530,000 $2,300,000 Division C 4,500,000 795,000 2,400,000 Division D 6,800,000 795,000 2,700,000 Required: (a) Using the DuPont formula, determine the following for each division: • Division B o Profit margin (rounded to two decimal places): o Investment turnover (rounded to four decimal places): o Rate of return on investment (rounded to one decimal place): Division C o Profit margin (rounded to two decimal places): o Investment turnover (rounded to four decimal places): o Rate of return on investment (rounded to one decimal place): • Division D o Profit margin (rounded to two decimal places):arrow_forwardReturn on investment is often expressed as follows: ROI = Controllable margin Average operating assets Controllable margin Sales Sales Average operating assets (b1) Comparative data on three companies operating in the same industry follow. The minimum required ROI is 10% for all three companies. Determine the missing amounts. (Round asset turnover of Company B and return on investment of Company C to 1 decimal place, e.g. 15.2 or 15.2% and all other answers to O decimal places. e.g. 152. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Sales Net operating income Average operating assets Profit margin Assets turnover Company A Company B $1,382,000 $700,400 $165.840 $133,076 (b) $ $691.000 (c) $ (d) % (e) % Return on investment (h) Residual income S k) $ () $ Company C $4,845,000 0.5 %arrow_forward
- Return on investment is often expressed as follows: ROI Controllable margin Average operating assets Controllable margin Sales X Sales Average operating assets (b1) Comparative data on three companies operating in the same industry follow. The minimum required ROI is 10% for all three companies. Determine the missing amounts. (Round asset turnover of Company B and return on investment of Company C to 1 decimal place, e.g. 15.2 or 15.2% and all other answers to 0 decimal places, e.g. 152. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Company A Company B Company C Sales $1,580,000 $725,800 (a) $ Net operating income $173,800 $152,418 (b) $ Average operating assets $790,000 (c) $ (d) % (e) % Profit margin (f) (g) Assets turnover Return on investment (h) % 2.1 % (1) $ (k) $ (1) $ Residual income $5,387,000 0.6 % 5 %arrow_forwardThe vice president of operations of Moab Bike Company is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past year ending October 31, 20Y9, for each division are as follows: (P14-5) Touring Bike Division Trail Bike Division Sales $1,500,000 $5,00 Cost of goods sold Operating expenses Invested assets 900,000 4,000,000 495,000 968,000 750,000 3,600,000 Instructions 1. Prepare condensed divisional income statements for the year ended October 31, 20Y9, assuming that there were no service department charges. Touting Bike Division Trial Bike Divisionarrow_forwardThe sales, income from operations, and invested assets for each division of Jackson Corporation are as follows: Sales Income from Operations Invested Assets Division E $4,000,000 $550,000 $2,400,000 Division F 4,800,000 760,000 2,500,000 Division G 7,000,000 860,000 2,800,000 (a) Using the expanded expression, determine the profit margin, investment turnover, and rate of return on investment for each division. Round answers to one decimal place. (b) Which Division is the most profitable per dollar invested? (a) (b)arrow_forward
- Determining missing items in return and residual income computations Data for Uberto Company are presented in the following table of returns on investment and residual incomes: Invested Assets Income from Operations Return on Investment Minimum Return Minimum Acceptable Income from Operations Residual Income $780,000 $187,200 (a) 13% (b) (c) $490,000 (d) (e) (f) $53,900 $24,500 $350,000 (g) 14% (h) $38,500 (i) $260,000 $52,000 (j) 12% (k) (l) Determine the missing values, identified by the letters above. For all amounts, round to the nearest whole number. a. fill in the blank 1% b. $fill in the blank 2 c. $fill in the blank 3 d. $fill in the blank 4 e. fill in the blank 5% f. fill in the blank 6% g. $fill in the blank 7 h. fill in the blank 8% i. $fill in the blank 9 j. fill in the blank 10% k.…arrow_forwarda. Compute the rate of return on investment for each division. b. Which division is the most profitable per dollar invested? Assume that management has established a 10% minimum acceptable rate of return for invested assets. c. Determine the residual income for each division. d. Which division has the most residual income?arrow_forwardThe sales, operating income, and invested assets for each division of Garner Company are as follows: Operating Invested Sales Income Assets Division E $3,000,000 $470,000 $2,500,000 Division F 3,600,000 430,000 2,400,000 Division G 6,000,000 560.000 3,000,000 a. Using the expanded expression, determine the profit margin, investment turnover, and rate of return on investment for each division. Round to one decimal place. Division E Division F Division G Profit margin X % X % X % Investment turnover Rate of return on investment X % X % X % b. Which division is the most profitable as per dollar invested? Division Earrow_forward
- Which of the following statements is true? Suppose a company evaluates divisional performance using both ROI and residual income. The company's minimum required rate of return for the purposes of residual income calculations is 12%. If a division has a residual income of $6,000, then its ROI is less than 12%. If a company contains a number of investment centers of differing sizes, return on investment (ROI) should be used rather than residual income to rank the financial performance of the divisions. ROI and residual income are tools used to evaluate managerial performance in investment centers.arrow_forwardDetermining missing items in return and residual income computations Data for Uberto Company are presented in the following table of rates of return on investment and residual incomes: Invested Assets Income from Operations Return on Investment Minimum Return Minimum Acceptable Income from Operations Residual Income $950,000 $228,000 (a) 13% (b) (c) $550,000 (d) (e) (f) $60,500 $27,500 $350,000 (g) 14% (h) $38,500 (i) $260,000 $52,000 (j) 12% (k) (l) Determine the missing values, identified by the letters above. For all amounts, round to the nearest whole number. a. fill in the blank 1% b. $fill in the blank 2 c. $fill in the blank 3 d. $fill in the blank 4 e. fill in the blank 5% f. fill in the blank 6% g. $fill in the blank 7 h. fill in the blank 8% i. $fill in the blank 9 j. fill in the blank 10% k. $fill in the…arrow_forwardDetermining missing items in return and residual income computations Data for Uberto Company are presented in the following table of rates of return on investment and residual incomes: Invested Assets Income from Operations Return on Investment Minimum Return Minimum Acceptable Income from Operations Residual Income $980,000 $225,400 (a) 13% (b) (c) $600,000 (d) (e) (f) $72,000 $24,000 $320,000 (g) 14% (h) $35,200 (i) $240,000 $45,600 (j) 11% (k) (l) Determine the missing values, identified by the letters above. For all amounts, round to the nearest whole number.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning