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,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 (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.
NOPM Answer

%
NOAT Answer


RNOA Answer

%

Solutions

Expert Solution

Particulars Jan 31,2016 Feb 01,2015
Operating Assets A                                   40,583            38,473
Non Operating Assets B                                     2,241              1,748
Net Operating Assets A-B                                   38,342            36,725
Total Assets C                                   42,824            40,221
Operating Liabilities D                                   15,018            13,527
Non Operating Liabilities E                                   21,285            17,167
Total Liabilities F                                   36,303            30,694
Total Equity G                                     6,561              9,527
Sales H                                   88,999
NOPBT I                                   12,024
Non Operating expense before tax J                                        778            11,246
Profit before tax K=I-J                                   11,246
Tax L                                     4,088 36.35%
Net Income M                                     7,158
Tax Rate N=L/K 36.35%
NOPAT O=I*(1-N)                                     7,653
              1 Return on Equity, ROE (Net Income/ Avg Equity) L/Avg Equity 7158/{(6561+9527)/2} 88.99%
              2 RNOA (NOPAT/ Avg Net Op. Assets) O/Avg Net Op. Asset 7653/{(38342+36725)/2} 20.39%
              3 Return on Non Operating Asset (ROE - RNOA) 68.60%
              4 NOPM (NOPAT/Sales) O/H 8.60%
NOAT (Sales/Average NOA) H/Average Net Op. Assets 88999/{(38342+36725)/2}                2.37
RNOA= NOPM*NOAT 20.39%

Please Upvote and Support!!


Related Solutions

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...
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 $33,930 $26,250 $10,504 $1,058 $57,628 $39,722 2015 32,046 23,169 9,620 838 55,234 40,091 2014 28,871 19,027 8,965 600 36,224 40,851 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT