Question

All answers must be entererd as formulas

CHAPTER 3 Saved Help Save & Exit Submit E F G 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? 1.15 Equity multiplier Total asset turnover Profit margin 2.10 6.10% Complete the following analysis. Do not hard code values in your calculations. Return on equity

two different questions

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ALL CELL REFERENCES ARE GIVEN

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) View Add-Ins File Home Insert Page Layout Formulas Data Review - 2x % Cut Dr General -11AA = = = D A E E E Wrap Text FMerce Merge & Center Center Σ AutoSum : A Fill Z Sort & U - s $ - % % 4.0 .00 8.9 Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Calibri E Copy Paste Format Painter B I Clipboard G4 - A A B Find & Select Filter Editing Font Alignment Number Cells fax C D E I J K L M EQUITY MULTIPLIER TOTAL ASSETS TURNOVER PROFIT MARGIN 1.15 2.1 6.10% 9 11 12 13 RETURN ON EQUITY 14.73% (=D8*D7*D6] [PROFIT MARGIN XASSETS TURNOVER X EQUITY MULTIPLIER ] 14 15 16 17 18 19 N d overhead ORDER BOOK COMMON INCOME Sheet1 Sheet2 Sheet3 Sheets Sheet4 Sheets Sheet7 Sheets Sheet upont DIFF ANALYSIS ferences Rea Sheet10 ] 20J 130% 0 + 9 . * *0 ENG 30-10-2019 . B

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) View Add-Ins Data Review - 2x Σ AutoSum : A A = = = V General Wrap Text FMerce Merge & Center - Center E E E s $ % % , 4.0 .00 :.: Insert Delete Format File Home Insert Page Layout Formulas % Cut Calibri 11 A Ea Copy Paste Format Painter BI U D- DA Clipboard Font D20 C for AA B C Conditional Format Formatting as Table Styles Cell Styles Fill 2 Clear Sort & Filter Editing Find & Select Alignment Number Cells D Formula Bar L M N 000 vouw 2604 5783 TOTAL ASSETS SALES DEBT-EQUITY RATIO RETURN ON EQUITY 0.75 11% 11 12 13 14 PROFIT MARGIN 2.83% (=D9/((07/06)*(1+D8))] 15 NET INCOME 163.68 (=D14*D7] 16 17 18 19 20 21 HIN Red overhead ORDER BOOK COMMON INCOME Sheet1 Sheet2 Sheet3 Sheets Sheet4 Sheeto Sheetz Sheets Sheets Sheet10 0 DIFF ANALYSIS ferences Sheet11 0 BOU 130% O DO 90 * 410 ENG 30-10-2019