Question

In: Accounting

Profit Margin, investment turnover, and return on investment The condensed income statement for the Consumer Products...

Profit Margin, investment turnover, and return on investment The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $82,500,000 Cost of goods sold 53,625,000 Gross profit $28,875,000 Administrative expenses 15,675,000 Income from operations $13,200,000 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that $55,000,000 of assets have been invested in the Consumer Products Division. If required, round the investment turnover to one decimal place. Profit margin 16 % Investment turnover 1.5 Return on investment 24 % b. If expenses could be reduced by $1,650,000 without decreasing sales, what would be the impact on the profit margin, investment turnover, and return on investment for the Consumer Products Division? If required, round the investment turnover to one decimal place. Profit margin % Investment turnover Return on investment %

Solutions

Expert Solution

Solution:

a. Using the DuPont formula for return on investment

Rate of return on investment

= Income from operations / Invested assets X 100

= $13,200,000 / $55,000,000 X 100

=24%

Rate of return on investment = profit margin x investment turnover

a. Profit margin

=Income from operations / sales X 100

=$13,200,000 / $82,500,000 X 100

= 16%

b. Investment turnover

=Sales / invested assets

=$82,500,000 / $55,000,000

= 1.5

c. Rate of return on investment

= Profit margin x investment turnover

= 16% X 1.5

=24%

b. If expenses could be reduced by $1,650,000 without decreasing sales, what would be the impact on the profit margin, investment turnover, and return on investment for the Consumer Products Division?

Particulars

Amount ($)

Sales

82,500,000

Cost of goods sold

53,625,000

Gross profit

28,875,000

Administrative expenses($15,675,000-$ 1,650,000)

14,025,000

Income from operations

$ 14,850,000

a. Profit margin

=Income from operations / sales X 100

=$ 14,850,000/ $82,500,000 X 100

= 18%

b. Investment turnover

=Sales / invested assets

=$82,500,000 / $55,000,000

= 1.5

c. Rate of return on investment

= Profit margin x investment turnover

= 18% X 1.5

=27%

OR

Rate of return on investment

= Income from operations / Invested assets X 100

= $ 14,850,000/ $55,000,000 X 100

=27%

Analysis of Result

Because of reduction in expenses profit margin increased by 2% (from 16% to 18%), while investment turnover is unaffected at 1.5. Rate of return increased by 3% (from 24% to 27%).

Before reduction in expenses

After reduction in expenses

Increase or Decrease

Profit margin

16%

18%

2 % Increase

Investment turnover

1.5

1.5

No effect

Rate of return on investment

24%

27%

3 % Increase


Related Solutions

Profit Margin, Investment Turnover, and return on investment The condensed income statement for the Consumer Products...
Profit Margin, Investment Turnover, and return on investment The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $912,000 Cost of goods sold 410,400 Gross profit $501,600 Administrative expenses 228,000 Income from operations $273,600 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on...
22. How is return on investment calculated and how it is used? Investment turnover? Profit Margin?...
22. How is return on investment calculated and how it is used? Investment turnover? Profit Margin? Residual income? 23. What is meant by centralized vs. decentralized organization? 24. What is the difference between controllable and uncontrollable costs?
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for...
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $749,320,000 Less: Variable expenses 551,128,000 Contribution margin $198,192,000 Less: Fixed expenses 198,192,000 Operating income $0 At the beginning of last year, Elway had $38,624,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...
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for...
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $859,290,000 Less: Variable expenses 540,984,000 Contribution margin $318,306,000 Less: Fixed expenses 195,596,000 Operating income $122,710,000 At the beginning of last year, Elway had $38,662,000 in operating assets. At the end of the year, Elway had $41,354,000 in operating assets. Required: 1. Compute average operating assets. $ 2. Compute the margin (as a percent) and turnover ratios for last year. If...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
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...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
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...
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows...
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $1,008,000 Cost of goods sold 453,600 Gross profit $554,400 Administrative expenses 201,600 Income from operations $352,800 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that...
1.The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows...
1.The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows (assuming no support department allocations): Sales $1,232,000 Cost of goods sold (554,400) Gross profit $677,600 Administrative expenses (431,200) Operating income $246,400 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that $3,080,000...
E10-4 Finding Unknowns Using Return on Investment, Profit Margin, Investment Turnover [LO 10-4] Krall Company recently...
E10-4 Finding Unknowns Using Return on Investment, Profit Margin, Investment Turnover [LO 10-4] Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements including components of the return on investment calculations.    Required: Help Krall rebuild its information database by completing the following table: (Do not round your intermediate calculations. Round your final answers to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.))   Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return on assets, Return on equity, Earnings per Share, Price-earnings, Cash Dicidend payot, Debt Ratio, Debt-to-Equity, and Times Interest earned Orange Company Income Statement For the Years Ended December 31 2013 2012 Net sales (all on account) $            600,000 $                520,000 Expenses: Cost of Goods Sold $            415,000 $                354,000 Selling and administrative $            120,800 $                114,600 Interest Expense $                7,800 $                    6,000 Income Tax...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT