USE FORMULA TO ANSWER THE QUESTION FOR EXAMPLE =B1+B2 THAN GIVE THE ASWER 32 SKIP FIRST TWO I NEED 25 - 33PLEASE SHOW ME FORMULA. DEF1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the2 company's Northern Division for last year are given below:34Sales27,000,00015Variable expenses16,200,0006Contribution margin10,800,000Fixed expenses8,805,000Net operating income1.995.00010Average divisional operating assets9.500.0001112 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows:1314Average required investment2,500,00015Net operating income400,0001617 Adams Corporation's minimum acceptable rate of return15%1819 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following:2021 Northern Division ROI for last year2223 Northern Division ROI if new product line is added24Sheet1+)READY100% E21ABDE14Average required investmentNet operating income2,500,00015400,0001617 Adams Corporation's minimum acceptable rate of return15%1819 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following:2021 Northern Division ROI for last year2223 Northern Division ROI if new product line is added2425 Write an IF statement to determine whether the Northern Division26 manager will ACCEPT or REJECT the new product line based on ROI.2728 Northern Division residual income for last year2930 Northern Division residual income if the new product line is added3132 Write an IF statement to determine whether the Northern Division manager33 will ACCEPT or REJECT the new product line based on residual income34353637Sheet1...READY100%

ROI stands for return on investment that shows the return earned by the company on the investment.

1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below: Sales 27,000,000 Variable expenses Contribution margin 16,200,000 10,800,000 7. Fixed expenses 8,805,000 Net operating income 1.995.000 Lo Average divisional operating assets 9,500,000 %24 %24

1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below: Sales 27,000,000 Variable expenses Contribution margin 16,200,000 10,800,000 7. Fixed expenses 8,805,000 Net operating income 1.995.000 Lo Average divisional operating assets 9,500,000 %24 %24

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter14: Decentralized Operations

Section: Chapter Questions

Problem 14.5.3P

See similar textbooks

Similar questions

Communication The Norse Division of Gridiron Concepts Inc. experienced significant revenue and profit growth from 20Y4 to 20Y6 as shown in the following divisional income statements: There are no support department allocations, and the division operates as an investment center that must maintain a 15% return on invested assets. Determine the profit margin, investment turnover, and return on investment for the Norse Division for 20Y420Y6. Based on your computations, write a brief memo to the president of Gridiron Concepts Inc., Knute Holz, evaluating the divisions performance.
Effect of proposals on divisional performance A condensed income statement for the Jet Ski Division of Amazing Rides Inc. for the year ended December 31. 20Y2, is as follows Assume that the Jet Ski Division received no charges from service departments. The president of Amazing Rides has indicated that the division's rate of return on a $15,000,000 investment must be increased to at least 12% by the end of the next year if operations are to continue. The division manager is considering the following three proposals Proposal 1: Transfer equipment with a book value of J3.000.000 to other divisions at no gain or loss and lease similar equipment. The annual lease payments would exceed the amount of depreciation expense on the old equipment by $264,000. This increase in expense would be included as part of the cost of goods sold. Sales would remain unchanged. Proposal 2: Purchase new and more efficient machining equipment and thereby reduce the cost of goods sold by $480,000. Sales would remain unchanged, and the old equipment, which has no remaining book value, would be scrapped at no gain or loss. The new equipment would increase invested assets by an additional $1,000,000 for the year. Proposal 5? Reduce invested assets by discontinuing the tandem jet ski line. This action would eliminate sales of $2,280,000, cost of goods sold of $1,400,000, and operating expenses of $463,600. Assets of $4,200,000 would be transferred to other divisions at no gain or loss. Instructions Which of the three proposals would meet the required 12% return on investment?'
Q7 Consider the following data from two divisions of a company, P and Q: Divisional P Q Sales $ 1,500,000 $ 1,000,000 Operating Income $ 600,000 $ 450,000 Investment $ 4,000,000 $ 2,750,000 If both divisions were presented with an opportunity to invest in a project that is estimated to achieve an ROI of 15%, what will the units likely decide? Multiple Choice Division P will not invest; Division Q will invest. Division P will invest; Division Q will not invest. Neither unit will invest in the projects. Division P will be indifferent; Division Q will not invest. Division P will invest; Division Q will be indifferent.
7. Jordan Company has two divisions, which reported the following results for the most recent year. Division I Division II Income ₱ 02,700,000 ₱ 00,600,000 Average invested capital ₱ 18,000,000 ₱ 03,000,000 ROI 15% 20% Imputed interest rate = 10% Under residual income, which division is considered to have a better performance? Show solution Group of answer choices Neither Division I nor II Cannot be determined Division I Division II
(J) Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division ADivision BDivision CSales$ 12,120,000$ 28,120,000$ 20,120,000Average operating assets$ 3,030,000$ 7,030,000$ 5,030,000Net operating income$ 496,920$ 449,920$ 503,000Minimum required rate of return7.00%7.50%10.00%Required: 1. Compute the margin, turnover, and return on investment (ROI) for each division. 2. Compute the residual income (loss) for each division. 3. Assume that each division is presented with an investment opportunity that would yield a 8% rate of return. a. If performance is being measured by ROI, which division or divisions will probably accept the opportunity? b. If performance is being measured by residual income, which division or divisions will probably accept the opportunity
Q35 Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z Sales $ 1,483,000 $ 805,000 $ 5,005,000 Operating Income 216,100 59,700 263,800 Investment in assets 625,600 292,500 3,179,600 The return on sales (ROS) for Division Z is: (Round your percentages to one decimal place.) Multiple Choice 7.4%. 8.3%. 5.3%. 14.6%. 20.4%.
Selected sales and operating data for three divisions of different structural engineering firms are given asfollows:Division A Division B Division CSales ........................................................... $12,000,000 $14,000,000 $25,000,000Average operating assets ............................ $3,000,000 $7,000,000 $5,000,000Net operating income .................................. $600,000 $560,000 $800,000Minimum required rate of return .................. 14% 10% 16%Required:1. Compute the return on investment (ROI) for each division using the formula stated in terms of marginand turnover.2. Compute the residual income for each division.
4. Searchlight, Inc. uses ROI to evaluate operations and requires the return on its operating units to be 9%. Operating data for the Western division is shown below: Sales $1,000,000 Controllable margin 120,000 Total average assets 600,000 Fixed costs 60,000 How much is ROI for the year? Group of answer choices 20% 17% 10% 30%
Consider the following 000’s omitted __ Division A Division B Operating assets P 5,000 P 12,500 Operating Income 1,000 2,250 ROI 20 % 18 % Which is a more successful division in terms of ROI ? Using 16 % as the minimum required of return , compute the residual income for each decision. Which division is more successful under this rate ?
Case 1: ROI You are comparing the performance of two (2) separate divisions, segments A and B, using ROI Analysis. A B Sales P100,000.00 P500,000.00 Operating Expenses 30,000.00 300,000.00 Net Operating income 70,000.00 200,000.00 Average Operating Assets 10,000.00 40,000.00 Required: Using ROI Analysis, which segment is performing better? To answer this question, you need to: Compute the ROI of each segment and Compute the components of ROI of each segment
Q1 Hope and Co. is a multi-divisional marketing firm. The performance of divisions is evaluated using financial metrics such as ROI, Residual Income and EVA. For the year ended June 30, 2020, Hope's CEO received the following information about the performance of the sports marketing division: Sales Revenues $950,000 Operating Income $275,000 Total Assets $1,750,000 Current Liabilities $325,000 Debt (interest rate: 4%) $450,000 Common equity (book value) $550,000 For divisional performance evaluation Hope defined investment as total assets and income as operating income i.e. income before interest and taxes. Hope pays a flat rate of 20% in taxes on income. (a) What was the Sports Marketing division's ROI for the year? (2 decimal places)
Q1 Hope and Co. is a multi-divisional marketing firm. The performance of divisions is evaluated using financial metrics such as ROI, Residual Income and EVA. For the year ended June 30, 2020, Hope's CEO received the following information about the performance of the sports marketing division: Sales Revenues $950,000 Operating Income $275,000 Total Assets $1,750,000 Current Liabilities $325,000 Debt (interest rate: 4%) $450,000 Common equity (book value) $550,000 For divisional performance evaluation Hope defined investment as total assets and income as operating income i.e. income before interest and taxes. Hope pays a flat rate of 20% in taxes on income. (a) What was the Sports Marketing division's ROI for the year? (2 decimal places) (b) Based on Hope's required rate of return of 6% what was the residual income for the 2020 year? (2 decimal places) (c) Hope's debt trades at book value while its equity has a market value…