Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Profit margin, investment turnover, and return on investment The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows

image text in transcribed

Profit margin, investment turnover, and return on investment The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows (assuming no support department charges): Sales $200,000,000 Cost of goods sold Gross profit 127,300,000 $72,700,000 Administrative expenses Operating income 61,600,000 $11,100,000 The manager of the Consumer Products Division is considering ways to increase the return on investment. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet 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 $108,510,000 of assets have been invested in the Consumer Products Division. Round your answers for the profit margin and the rate of return on investment to the nearest whole number, round your answer for the investment turnover to two decimal places. Profit margin Investment turnover Rate of return on investment % b. If expenses could be reduced by $3,880,000 without decreasing sales, what would be the impact on the profit margin, investment turnover, and return on investment for the Consumer Products Division? Round your answers for the profit margin and the rate of return on investment to the nearest whole number, round your answer for the investment turnover to two decimal places. Profit margin Investment turnover % Rate of return on investment %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Excel & Access for Accounting 2010

Authors: Glenn Owen

3rd edition

1111532672, 978-1111532673

More Books

Students also viewed these Accounting questions