In: Finance
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
%
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!!