Question

In: Finance

Compute ROE and RNOA with Disaggregation Selected balance sheet and income statement information for Home Depot...

Compute ROE and RNOA with Disaggregation
Selected balance sheet and income statement information for Home Depot follows.

$ millions Jan. 31, 2016 Feb. 01, 2015
Operating assets $40,333 $38,223
Nonoperating assets 2,216 1,723
Total assets 42,549 39,946
Operating liabilities 14,918 13,427
Nonoperating liabilities 21,315 17,197
Total liabilities 36,233 30,624
Total stockholders' equity 6,316 9,322
Sales 88,519
Net operating profit before tax (NOPBT) 11,774
Nonoperting expense before tax 753
Tax expense 4,012
Net income 7,009


Round all answers to two decimal places (ex: 0.12345 = 12.35%)

a. Compute return on equity.
Answer%

b. Compute return on net operating assets (RNOA).
Answer%

c. Use ROE and RNOA to determine the nonoperating return for the year.
Answer%

d. Disaggregate RNOA into components of profitability and productivity and show that the product of the two components equals RNOA. Assume a statutory tax rate of 37%.
NOPM Answer%
NOAT Answer
RNOA Answer%

Most important, I can not figure out D

Solutions

Expert Solution

Question 1:

Return on Equity ROE = Net Income / (Average Equity)

ROE = 7,009 / ((6,316 + 9,322)/2)

ROE = 7,009/7,819

ROE = 0.8964

Question 2:

Return on Net Operating Assets = (Net Operating Profit After Tax) / (Average Operating Assets)

Return on Net Operating Assets = (NOPBT)(1 - Tax Rate) / (Average Operating Assets)

RNOA = (11,774)*(1-0.37)/((40,333 + 38,223)/2)

RNOA = 7,417.62/39,278

RNOA = 0.1888

Question 3:

ROE = RNOA + Nonoperating return

Nonoperating return = ROE - RNOA

Nonoperating return = 0.8964 - 0.1888

Nonoperating return = 0.7076

Question 4:

RNOA = NOPAT/(Average NOA)

RNOA = (NOPAT/Sales) * (Sales/Average NOA)

Net Income/Sales is the net profit margin, which is a profitability ratio and Sales/Average NOA is Operating Asset Turnover, which is a performance ratio

NOPM = NOPAT/Sales

NOPM = 7,417.62/88,519

NOPM = 0.0838

NOAT = Sales/Average NOA

NOAT = 88,519/39,278

NOAT = 2.2536

RNOA = NOPM*NOAT

RNOA = 0.0838*2.2536

RNOA = 0.1888


Related Solutions

Compute ROE and RNOA with Disaggregation Selected balance sheet and income statement information for Home Depot...
Compute ROE and RNOA with Disaggregation Selected balance sheet and income statement information for Home Depot follows. $ millions Jan. 31, 2016 Feb. 01, 2015 Operating assets $40,583 $38,473 Nonoperating assets 2,241 1,748 Total assets 42,824 40,221 Operating liabilities 15,018 13,527 Nonoperating liabilities 21,285 17,167 Total liabilities 36,303 30,694 Total stockholders' equity 6,521 9,527 Sales 88,999 Net operating profit before tax (NOPBT) 12,024 Nonoperting expense before tax 778 Tax expense 4,088 Net income 7,158 Round answers to two decimal places...
Apply DuPont Disaggregation of ROE Selected balance sheet and income statement information for Home Depot follows....
Apply DuPont Disaggregation of ROE Selected balance sheet and income statement information for Home Depot follows. $ millions Jan. 31, 2016 Feb. 01, 2015 Total assets $43,179 $40,576 Total liabilities 36,413 30,804 Sales 89,599 Net income 7,013 Round answers to two decimal places (ex: 0.12345 = 12.35%) a. Compute ROE and disaggregate the ratio into its DuPont components of ROA and financial leverage. ROE: Answer % ROA: Answer % Financial leverage: Answer b. Disaggregate ROA in to profitability and productivity...
Compute and Compare ROE, ROA, and RNOA Selected balance sheet and income statement information for Oracle...
Compute and Compare ROE, ROA, and RNOA Selected balance sheet and income statement information for Oracle Corporation follows. (Perform the required computations from the perspective of an Oracle shareholder. $ millions May 31, 2015 May 31, 2014 Operating assets $62,090 $57,002 Nonoperating assets 54,368 38,819 Total assets 116,458 95,821 Operating liabilities 20,180 19,055 Nonoperating liabilities 41,958 24,097 Total liabilities 62,138 43,152 Total Oracle stockholders' equity 54,320 52,669 Total revenues 38,559 Operating income before tax 13,993 Nonoperating expense before tax 1,037...
Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc. and...
Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc. and Lowe’s Companies Inc. Assume the statutory tax rate is 22%. Pretax Net Average Net Nonoperating Tax Operating Company ($ millions) Ticker Sales NOPBT Expense Expense Assets Home Depot HD $108,203 $15,219 $955 $3,366 $24,713 Lowe’s LOW 69,883 3,938 612 1,080 20,326 a. Compute the following measures for both companies. Measure Rounding Instructions Home Depot Lowe’s 1. Net operating profit (NOPAT) Round to nearest whole...
1. Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc....
1. Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc. and Lowe’s Companies Inc. Assume the statutory tax rate is 22%. Pretax Net Average Net Nonoperating Tax Operating Company ($ millions) Ticker Sales NOPBT Expense Expense Assets Home Depot HD $108,203 $16,151 $1,013 $3,572 $26,226 Lowe’s LOW 74,161 4,179 649 1,080 20,326 a. Compute the following measures for both companies. Measure Rounding Instructions Home Depot Lowe’s 1. Net operating profit (NOPAT) Round to nearest...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Calpine Corporation for 2004 and 2006 follows. ($ millions) 2004 2006 Cash $ 1,376.73 $ 1,503.36 Accounts receivable 1,097.16 735.30 Current assets 3,563.56 3,168.33 Current liabilities 3,285.39 6,057.95 Long-term debt 16,940.81 3,351.63 Short-term debt 1,033.96 4,568.83 Total liabilities 22,628.42 25,743.17 Interest expense 1,516.90 1,288.29 Capital expenditures 1,545.48 211.50 Equity 4,587.67 (7,152.90) Cash from operations 9.89 155.98 Earnings before interest and taxes 1,589.84 1,877.84 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Nordstrom, Inc. for 2016 and 2015 follows. ($ millions) 2016 2015 Cash $ 595 $ 827 Accounts receivable 196 2,306 Current assets 3,014 5,224 Current liabilities 2,911 2,800 Long-term debt 2,795 3,123 Short-term debt 10 8 Total liabilities 6,827 6,805 Interest expense 153 156 Capital expenditures 1,082 861 Equity 871 2,440 Cash from operations 2,451 1,220 Earnings before interest and taxes 1,101 1,323 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Nordstrom, Inc. for 2014 and 2013 follows. ($ millions) 2014 2013 Cash $ 1,194 $ 1,285 Accounts receivable 2,177 2,129 Current assets 5,228 5,081 Current liabilities 2,541 2,226 Long-term debt 3,113 3,131 Short-term debt 0 0 Total liabilities 6,494 6,176 Interest expense 161 160 Capital expenditures 803 513 Equity 2,080 1,913 Cash from operations 1,320 1,110 Earnings before interest and taxes 1,350 1,345 (a)...
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions). Total Current Assets Total Current Liabilities EBIT (Operating income) Interest Expense, Gross Total Liabilities Equity 2016 $31,042 $26,250 $10,338 $1,058 $57,628 $36,834 2015 29,158 23,169 9,454 838 55,234 37,203 2014 25,983 19,027 8,799 600 36,224 37,963 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from Verizon Communications follows. ($ millions) 2005 2004 Current assets $ 16,448 $ 19,479 Current liabilities 25,063 23,129 Total debt 39,010 39,267 Total liabilities 101,696 103,345 Equity 66,434 62,613 Earnings before interest and taxes 12,787 12,496 Interest expense 2,180 2,384 Net cash flow from operating activities $ 22,012 $ 21,820 (a) Compute the current ratio for each year and discuss any trend in liquidity. (Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT