X 5. ? FILE HOME INSERT Sign In Calibri 11 Calculating the DuPont identity - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW A % A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Paste BIU. Cells Editing Clipboard Font A1 A B D E F G H K 1 2 3 If Roten Rooters, Inc., has an equity multiplier of 1.15, total asset turnover of 2.10, and a profit margin of 6.1 percent, what is its ROE? 4 5 6 7 8 9 10 Equity multiplier Total asset turnover Profit margin 1.15 2.10 6.10% 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 Return on equity 15 16 17 Sheet1 . X 5 Using the DuPont identity - Excel ? CC FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X6 Calibri 11 % M Paste BIU. Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 X > A B D E F G H 1 I J K > 2 3 Y3K, Inc., has sales of $5,783, total assets of $2,604, and a debt-equity ratio of .75. If its return on equity is 11 percent, what is its net income? 4 5 6 $ $ 7 8 9 Total assets Sales Debt-equity ratio Return on equity 2,604 5,783 0.75 11% 10 11 12 Complete the following analysis. Do not hard code values in your calculations. 13 14 15 Profit margin 16 Net income 17 18