Sales Net operating income Average operating assets Margin mover turn on investment (ROI) Alpha 5 446,000 8% 5.0 % Division Bravo $ 315,000 S 31,500 % 25.0 % Charlie $ 41,040 D * 18.0%
Q: Requirement 2: Revise the data in your worksheet as follows: 1 Chapter 11: Applying Excel 2 3 4 A…
A: ROI is return on invested assets. This is one of the profitability measure which shows percentage of…
Q: Division Northeast Southeast West Sales $ ? $10,980,000 $ ? Net operating income $ ? $878,400…
A: Margin = Net Operating Income / Sales Turnover = Sales / Average Operating Assets Return on…
Q: Assume the Residential Division of Kappy Faucets had the following results last year: Net sales…
A: Ratio analysis is a method of measuring the financial position of the organization with different…
Q: BR Company has a contribution margin of 9%. Sales are $477,000, net operating income is $42,930, and…
A: Return on Investment - Return on Investment is the income earned on an investment made by the…
Q: A company's divislon has sales of $6,000,000, Income of $240,000, and average assets of $4,800.000.…
A: Financial ratios are used to check different aspects of a company - liquidity, solvency, etc. They…
Q: 3. Data $ 72,000,000 $ 3,600,000 $ 18,000,000 Sales Net operating income Average operating assets 6.…
A: a. ROI = $3,600,000$18,000,000=20% b. The minimum required rate of return =…
Q: Crawford Corp. has an ROI of 23% and a residual income of $10,400. If operating income equals…
A: RETURN ON INVESTMENT Return on Investment is the Ratio Between Net Operating Income & Average…
Q: Division A $ 12,280,000 $ 3,070,000 $ 601,720 10.00% Division B $35,350,000 $ 7,070,000 $ 600,950…
A: Return on investment (ROI) is a performance statistic used to evaluate the efficiency or…
Q: Assume the Residential Division of Kopper Faucets had the following results last year: $ 16,000,000…
A: Return on investment helps in measuring the performance by evaluating the profit and efficiency of…
Q: Fill in the blanks for each independent situation. A B $350,000 $ Sales Variable expense Fixed…
A: Cost volume profit analysis is the one which is prepared by the entity in order to determine the…
Q: Required Supply the missing information in the following table for Gibson Company. (Do not round…
A: Operating Income is one of the important measure of profitability of the business. Operating income…
Q: Johanssen Company reported the following information for 2014: $794,000 $382,000 Sales Average…
A: Operating Income:Operating Income is a measure of profitability that tells investors how much…
Q: The Millard Division's operating data for the past two years are provided below: Year 1 Year 2…
A: Return on investment is profitability ratio which shows operating income earned by investment…
Q: Q36 The following results pertain to an investment center. Sales $ 1,633,700 Variable costs…
A: Solution:- Return on Investment (ROI) means the percentage of net profit earned to the average…
Q: Provide the missing data for the following situations: Red Division White…
A: The ratio analysis helps to analyse the financial statements of the business on the basis of various…
Q: all Division mmercial Division za Analytics Division Operating Income Inve $74,000 70,400 75,000…
A: ROI is a flexible indicator that is used in a variety of fields such as finance, business, real…
Q: For its three investment centers, Gerrard Company accumulates the following data: I II…
A: Return on investment is compute by dividing the controllable margin with the average operating…
Q: The following information relates to the Quilt Division of TDS Corporation for last year: Sales…
A: Given, Net operating income = $60,000 Average operating assets = $500,000 Minimum required rate of…
Q: Sales Net operating income Average operating assets $17,958,000 51,005,200 5 4,898,000 The…
A: Formula: Division return on investment = ( Net operating income / Average operating Assets ) x 100
Q: The following information pertains to Splash Brothers’ Corporation: Sales margin 25%…
A: Sales margin = 25% Income = P80,000 Sales = Income/Sales margin = 80000/0.25 =…
Q: Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z…
A: Operating income for division Y (O) = $108200 Investment for division Y (I) = $764100
Q: Sales $ 400, eee Variable expenses 260,e00 140, eee Contribution margin Fixed expenses 96,eee Net…
A: Formula: Contribution margin ratio = ( Contribution margin / Sales ) x 100
Q: Nasser Incorporated reported the following results from last year's operations: Sales Variable…
A: The term return on investment (ROI) is used to assess how profitable or successful an investment is…
Q: The Electronics Division of Anton Company reports the following results for the current year:…
A: Return on investment is calculated by dividing net operating income by average operating assets.…
Q: Assume a company reported the following results: Sales $ 400,000 Variable expenses 260,000…
A: Formula: Margin = ( Contribution margin / Sales ) x 100
Q: The Millard Division's operating data for the past two years are provided below: Year 1 Year…
A: The objective of the question is to find the net operating income for Year 1 of the Millard…
Q: lowing data are for the Akron Division of Consolidated Rubber, Inc.: Sales Net operating income…
A: The return on investment (ROI) is to measure the profitability of the investment. It is computed by…
Q: Sales Net operating income Average operating assets Margin Turnover Return on investment (ROI) Alpha…
A: RATIO ANALYSISRatio analysis is a method of measuring the financial position of the organization…
Q: Q23 Selected data from Box Division's accounting records revealed the following: Sales $…
A: Ratio Analysis is the method of checking the company's operational efficiency, liquidity, and…
Q: Sales Net operating income Average operating assets Return on investment (ROI) Minimum required rate…
A: Return on investment (ROI) is a financial ratio used to calculate the benefit an investor will…
Q: Use the following information for the Problems below: The following data pertain to three divisions…
A: ROI means return on investment. It is the percentage return earned by the entity on the operating…
Q: The Millard Division's operating data for the past two years are provided below: Return on…
A: Lets understand the basics.Formula for calculating net operating income are,First we will need to…
Q: company with two divisions (X and Y) prepared the following segmented income statement: Y Total 2$ ?…
A: Solution: Segment margin is the margin of the segment which is based on costs directly related to…
Q: Dacker Products is a division of a major corporation. The following data are for the most recent…
A: We can calculate the division's margin that is use to compute ROI using the formula for margin, we…
Q: Accelerated Logistics provides the following information: Operating income $1,600,000 $15,000,000…
A: The profit margin ratio is calculated as the ratio of net profit and sales revenue
Q: $75,000,000 $80,000,000 2017 Total assets 2018 Total assets $ 1,875,000 $ 1,925,000 $ 4,525,000 $…
A: ROI stands for Return on investment that shows the percentage of return received from the invested…
Q: Division Y has generated sales revenue of $260,000 and achieved operating income of $18,500 using…
A: Sales and net income are related to each other and that gives the profit margin.Good profit margins…
Q: The following data pertain to Dakota Division's most recent year of operations.
A: Sales Margin: This ratio tells us how much profit is generated over a company's sales. It is…
Q: Sales 13,000,000 Variable expenses 8,600,000 Contribution margin 4,400,000 Fixed expenses 2,940,000…
A: Minimum required return = $8,000,000 x 15% = $1,200,000
Q: Assume a company reported the following information: Sales Minimum required rate of return on…
A: Residual income is the profit earned above the minimum expected return on invested capital,…
Q: Company A. Sales $ 10.900,000 $ 6,700,000 S 0.000,000 Net operating income 238.000 Average operating…
A: Lets understand the basics. For calculating the requirement, we will need to use below formulas.…
Q: Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal…
A: Return on Assets is one of the most important figure/ratio that determines Profitability of the…
Q: Assume a company reported the following results: Sales Variable expenses Contribution margin Fixed…
A: Residual income: Residulal income means excess of income earned over the desired income. Desired…
Q: Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z…
A: Introduction:- The following formula used to calculate return on sales as follows under:- Return on…
Q: The Millard Division's operating data for the past two years are provided below: Year 1 Year 2…
A: Return on investment = Margin * turnover Margin = Return on investment / turnover Margin in year 2 =…
Q: Required information Use the following information for the Problems below: The following data…
A: ROI (Return on investment) helps in measuring the performance by evaluating the profit and…
Step by step
Solved in 4 steps
- Year 1 Return on investment Net operating income Turnover Margin Sales Year 2 12 368 $ 384,000 3 $4,800,000 Del Luna Division's margin in Year 2 was 150% of the margin in Year 1. The turnover for Year 1 was: Oa, 1.2 ь, 1.5 Oc. 3.0 Od. 4.01 Saved Help Coolbrook Company has the following information available for the past year: River Division Stream Division $1,815,000 1,298,000 $517,000 Sales revenue $1,210,000 883,000 $ 327,000 $1,180,000 Cost of goods sold and operating expenses Net operating income Average invested assets $1,510,000 The company's hurdle rate is 6.76 percent. Required: 1. Calculate return on investment (ROI) and residual income for each division for last year. 2. Recalculate ROI and residual income for the division for each independent situation that follows: a. Operating income increases by 9 percent. b. Operating income decreases by 11 percent. c. The company invests $253,000 in each division, an amount that generates $101,000 additional income per division. d. Coolbrook changes its hurdle rate to 4.76 percent. Complete this auestion hy entering v ur answers in the tabs below. %24Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z Sales $ 1,470,000 $ 974,000 $ 4,861,000 Operating Income 173,200 172,300 180,500 Investment in assets 428,200 567,500 2,553,200 The return on sales (ROS) for Division Y is: Multiple Choice 3.7%. 30.4%. 17.7%. 11.8%.
- ume a company with two divisions (A and B) prepared the following segmented income statement: A Total 507,000 260,000 247,000 180,000 67,000 43,000 24,000 IB Sales Variable expenses Contribution margin Traceable fixed expenses Segment margin Common fixed expenses Net operating income 300,000 120,000 180,000 100,000 80,000 207,000 140,000 67,000 80,000 (13,000) The dollar sales required for the company to break even is closest to: O $455,102 $355,201 $300,000 O $400,000Supply the missing data for three service companies shown in the table below: Note: Loss amounts should be indicated by a minus sign. Round your percentage answers to nearest whole percent. Company B A C Sales Net operating income $ 9,120,000 $ 7,200,000 $ 4,680,000 $ 290,000 Average operating assets $ 3,040,000 $ 1,872,000 Return on investment (ROI) 11 % 20 % % Minimum required rate of return. Percentage Dollar amount Residual income 9% % 13 % $ 261,000 $ 93,600Required Supply the missing information in the following table for Vernon Company. (Do not round intermediate calculations. Round "ROI" answer to 2 decimal places. (i.e., 0.2345 should be entered as 23.45).) Sales $369,600 ROI % Operating assets Operating income Turnover 2.1 Residual income Operating profit margin 14 % Desired rate of return 17 %
- Assume a company with two divisions (A and B) prepared the following segmented income statement: A B Traceable fixed expenses Sales Variable expenses Contribution margin Segment margin Common fixed expenses Net operating income The dollar sales required for the company to break even is closest to: $ 300,000 $ 209,500 Total $ 509,500 120,000 180,000 140,000 260,000 69,500 249,500 100,000 80,000 180,000 $ 80,000 $ (10,500) 69,500 48,000 $ 21,500What is residual income on these facts? Return on investment (ROI) 20% Sales $400,000 Margin 4% Minimum required rate of return. 16% O $ 6,000 O $ 16,000 O $ 3,200 $12,800 O $10,000Assume a company with two divisions (A and B) prepared the following segmented income statement: A B Total Sales $ 300,000 $ 200,000 $ 500,000 Variable expenses 120,000 140,000 260,000 Contribution margin 180,000 60,000 240,000 Traceable fixed expenses 100,000 80,000 180,000 Segment margin $ 80,000 $ (20,000) 60,000 Common fixed expenses 50,000 Net operating income $ 10,000 The dollar sales required for the company to break even is closest to:
- dreams demstime dremstph %24 The co ired rate of is 15%. Requlred Information The following information applies to the questions displayed below.] Westerville Company reported the following results from last year's operations: $ 2,300,000 Sales Variable expenses Contribution margin Fixed expensesi 1,630,000 1,170,000 24 460,000 $ 1,437,500 Net operating income Average operating assets At the beginning of this year, the company has a $287,500 investment opportunity with the following cost and revenue characteristics: $ 460,000 Contribution margin ratio Fixed expenses 50% of sales $ 161,000 The company's minimum required rate of return is 15%. 9. If the company pursues the investment opportunity and otherwise performs the same as last year, what ROI will it earn this year? (Do not round Intermedlate calculations. Round your percentage answer to 1 declmal place (I.e., 0.1234 should be considered as 12.3).)Supply the missing data for three service companies shown in the table below: Note: Loss amounts should be indicated by a minus sign. Round your percentage answers to nearest whole percent. Sales Net operating income Average operating assets Return on investment (ROI) Minimum required rate of return: Percentage Dollar amount Residual income A Company B C $ 9,450,000 $ $ 7,750,000 329,000 $ 5,175,000 $ 3,150,000 $ 2,070,000 11 % 14 % % 9% $ 376,000 % 14 % $ 103,500Kyle Corporation provides the following information for the Product Division and Service Division for the year. Product Division Service Division 420,000 $ 650,000 195,000 245,000 640,000 610,000 14.0% 14.0% Net sales Operating income Average total assets Target rate of return $ Requirement 1. Calculate the return on investment for each division. (Enter answers as a percent rounded to the nearest hundredth percent, X.XX%) The return on investment for the Product Division is The return on investment for the Service Division is Requirement 2. Which division has the highest ROI? % % Requirement 3. Calculate the residual income for each division. (Round answers to the nearest whole dollar.) The residual income for the Product Division is The residual income for the Service Division is Requirement 4. Which division has the highest residual income?SEE MORE QUESTIONS