Homework Help is Here – Start Your Trial Now!
Business
Accounting
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 $230,000,000 Cost of goods sold 109,500,000 Gross profit $120,500,000 Administrative expenses 65,600,000 Operating income $54,900,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 $101,170,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 23.87 x % Investment turnover Rate of return on investment % b. If expenses could be reduced by $3,890,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

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 $230,000,000 Cost of goods sold 109,500,000 Gross profit $120,500,000 Administrative expenses 65,600,000 Operating income $54,900,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 $101,170,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 23.87 x % Investment turnover Rate of return on investment % b. If expenses could be reduced by $3,890,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

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
Practice Pack
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 $230,000,000 Cost of goods sold 109,500,000 Gross profit $120,500,000 Administrative expenses 65,600,000 Operating income $54,900,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 $101,170,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 23.87 x % Investment turnover Rate of return on investment % b. If expenses could be reduced by $3,890,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 %
Transcribed Image Text: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 $230,000,000 Cost of goods sold 109,500,000 Gross profit $120,500,000 Administrative expenses 65,600,000 Operating income $54,900,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 $101,170,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 23.87 x % Investment turnover Rate of return on investment % b. If expenses could be reduced by $3,890,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 %
Expert Solution
trending now

Trending now

This is a popular solution!

video

Learn your way

Includes step-by-step video

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
New Line profitability analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS