Global Data, Inc, has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here:

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 2012-2014 periods for each division and for Global Data as a whole. Comment on the results.

Transcribed Image Text:

HomeInsert Page Layout Formulas Data Review View Operating Incomel Operating Operating Operating Total Operating Revenues/Total Income Revenues Assets Revenues Total Assets Assets 2 Test S 7209,000 $1,800 2012 2014 2012 2014 11.5% 9.5% 3 3 46% 2 2 1,140 6 Language Arts Division $ 3,000 $2,000 2,900 $1,380$12,000 $3,800 2 3.525| 2.350| 2096 2 1.6 20% 10 Global Data, Inc. 2013 12 13 2 2 2014