Thank you for your patience. Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Winston Company | ||||||||
Effect on Income | Scenario 1 | Note | Scenario 2 | Note | Scenario 3 | Note | Scenario 4 | Note |
Sales | 36,000,000.00 | No Change | 36,000,000.00 | No Change | 39,600,000.00 | Increase by 3,600,000. i.e. $ 36,000,000+3,600,000 | 36,360,000.00 | Increase by 360,000. i.e. $ 36,000,000+360,000 |
Less: Cost of goods sold | - | - | 2,700,000.00 | Increase by 2,700,000 | - | |||
Gross Margin | 36,000,000.00 | 36,000,000.00 | 36,900,000.00 | 36,360,000.00 | ||||
Less: Operating Expenses | 1,620,000.00 | Decrease by 180,000. i.e. $ 1,800,000-180,000 | 1,728,000.00 | Decrease by 72,000. i.e. $ 1,800,000-72,000 | 2,340,000.00 | Increase by 540,000. i.e. $ 1,800,000+540,000 | 1,854,000.00 | Increase by 54,000. i.e. $ 1,800,000+54,000 |
Operating Income | 34,380,000.00 | 34,272,000.00 | 34,560,000.00 | 34,506,000.00 | ||||
Effect on Investment | 22,500,000.00 | 21,600,000.00 | Decrease by 900,000. i.e. $ 22,500,000-900,000 | 22,500,000.00 | 23,400,000.00 | Increase by 900,000. i.e. $ 22,500,000+900,000 | ||
Margin | 95.50% | 95.20% | 87.27% | 94.90% | ||||
Income/ Sales | ||||||||
Turnover | 1.60 | 1.67 | 1.76 | 1.55 | ||||
Sales/ Investment | ||||||||
ROI | 152.80% | 158.67% | 153.60% | 147.46% | ||||
Income/ Investment | ||||||||
Note: You have not given cost of goods sold. Please put cost of goods sold on your own to arrive at the correct figure. Rest all is ok. |
Problem 3 (Testbook Reference 9-7)-Determine margin, turnaver, and return en isvestment for a segment and the...
Problem 3 (Textbook References P.) - Determine margin, turnerer, adreurs en lavestment for a segment the effect on each when the variables are changed The manager of the Winston Company faced the following data for the year 2015 Contribution to direct expenses Aswis directly wed by and wertified with the segment S $ $ .NO.000 22.500.000 16,000,000 Required: Determine the effect on margin, turnover, and return on investment of the segment in 2015 if each of the following changes were...
E10-5 Calculating Return on Investment, Residual Income, Determining Effect of Changes in Sales, Expenses, Invested Assets, Hurdle Rate on Each [LO 10-4, 10-5] Solano Company has sales of $900,000, cost of goods sold of $570,000, other operating expenses of $46,000, average invested assets of $2,600,000, and a hurdle rate of 12 percent. Required: 1. Determine Solano's return on investment (ROI), investment turnover, profit margin, and residual income. (Do mediate calculations. Enter your ROI and Profit Margin percentage answer to the...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment. One formula for calculating return on investment is: Operating income Invested Assets ROI is effective because it takes into consideration...
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $786,640,000 Less: Variable expenses 543,024,000 Contribution margin $243,616,000 195,036,000 Less: Fixed expenses Operating income $48,580,000 At the beginning of last year, Elway had $38,624,000 in operating assets. At the end of the year, Elway had $41,371,000 in operating assets. Required: 1. Compute average operating assets. 2. Compute the margin (as a percent) and turnover ratios for last year. If required,...
Required: Firm A has a margin of 11%, sales of $560,000, and ROI of 18%. Calculate the firm's average total assets. (Round "Turnover" to 1 decimal place.) Firm B has net income of $74,000, turnover of 1.20, and average total assets of $900,000. Calculate the firm's sales, margin, and ROI. (Round "Margin" and "ROI" answers to 1 decimal place.) Firm C has net income of $134,000, turnover of 2.01, and ROI of 23.40%. Calculate the firm's margin, sales, and average...
Margin, Turnover, Return on Investment Pelak Company had sales of $4,945,000, expenses of $4,320,000, and average operating assets of $3,230,000. Required: 1. Compute the operating income. 2. Compute the margin (as a percent) and turnover ratio. If required, round your answers to one decimal place. Margin % Turnover 3. Compute the ROI as a percent. Use the part 2 final answers in these calculations and round the final answer to two decimal places.
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $893,070,000 Less: Variable expenses 546,442,000 Contribution margin $346,628,000 Less: Fixed expenses 198,614,000 Operating income $148,014,000 At the beginning of last year, Elway had $38,632,000 in operating assets. At the end of the year, Elway had 541,363,000 in operating assets. Required: 1. Compute average operating assets. 2. Compute the margin (as a percent) and turnover ratios for last year. If required,...
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $899,720,000 Less: Variable expenses 543,801,000 Contribution margin $355,919,000 Less: Fixed expenses 198,570,000 Operating income $157,349,000 At the beginning of last year, Elway had $38,640,000 in operating assets. At the end of the year, Elway had $41,390,000 in operating assets. Required: 1. Compute average operating assets. 2. Compute the margin (as a percent) and turnover ratios for last year. If required,...
Solano Company has sales of $760,000, cost of goods sold of $500,000, other operating expenses of $40,000, average invested assets of $2,250,000, and a hurdle rate of 11 percent. Required: 1. Determine Solano's return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information for two of its divisions for last year: Small Appliances Cleaning Products Division Division Sales $34,670,000 $31,320,000 Operating income 2,773,600 1,252,800 Operating assets, January 1 6,394,000 5,600,000 Operating assets, December 31 7,474,000 6,000,000 Required: 1. For the Small Appliances Division, calculate: a. Average operating assets $ 6,934,000 b. Margin c. Turnover d. Return on investm nent (ROI) 2. For the Cleaning Products Division, calculate:...