Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

23-17 Analysis of return on invested assets, comparison of two divisions. DuPont method. Global Data, Inc., has two divisions: Test Preparation and Language Arts.

image text in transcribed

23-17 Analysis of return on invested assets, comparison of two divisions. DuPont method. Global Data, Inc., has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here: ASSIGNMENT MATERIAL & Es Home Insert Page Layout Formulas Data Review View B C D Operating 1 Operating Operating Total Income Revenues Assets Income/ Operating Operating Revenues/ Revenues Total Assets Operating Income/ Total Assets 2 Test Preparation Division 3 4 2011 2012 $ 720 $9,000 $1,800 2 2 2 920 ? ? 11.5% ? 46% 5 2013 1,140 ? ? 9.5% 6 ? 6 Language Arts Division 7 2011 $ 660 $3,000 $2,000 ? ? ? 8 2012 3,525 2,350 20% ? ? 9 2013 ? ? 2,900 ? 1.6 20% 10 Global Data, c 11 2011 $1,380 $12,000 $3,800 ? ? ? 12 13 2012 2013 ? ? ? ? ? ? ? ? ? ? ? ? 1. Complete the table by filling in the blanks. 2. Use the DuPont method of profitability analysis to explain changes in the operating-income-to-total-assets ratios over the 2011-2013 period for each division and for Global Data se a whole. Comment on the results. Required

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To solve the problem and complete the table using the DuPont method we need to calculate the missing values based on the relationships between Operating Income Operating Revenues Total Assets and the ... 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_2

Step: 3

blur-text-image_3

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

Cost management a strategic approach

Authors: Edward J. Blocher, David E. Stout, Gary Cokins

5th edition

73526940, 978-0073526942

More Books

Students explore these related Accounting questions