Question: please answer in excel and show work M3-18. Compute ROE Selected balance sheet and income statement information for Home Depot follows. Compute the return on

please answer in excel and show workplease answer in excel and show work M3-18. Compute ROE Selected balance

M3-18. Compute ROE Selected balance sheet and income statement information for Home Depot follows. Compute the return on equity for the year ended January 31, 2016. Jan. 31, 2016 Feb. 01, 2015 $38,223 1,723 39,946 $ millions Operating assets Nonoperating assets Total assets. Operating liabilities. Nonoperating liabilities. Total liabilities.. Total stockholders' equity Sales..... Net operating profit before tax (NOPBT) Nonoperating expense before tax. Tax expense ... Net income. $40,333 2,216 42,549 14,918 21,315 36,233 6,316 13,427 17,197 30,624 9,322 88,519 11,774 753 4,012 7,009 M3-19. Apply DuPont Disaggregation of ROE Refer to the balance sheet and income statement information for Home Depot, from M3-18. a. Compute ROE and disaggregate the ratio into its DuPont components of ROA and financial leverage (FL). b. Disaggregate ROA into profitability and productivity components

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!