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 work
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
Get step-by-step solutions from verified subject matter experts
