Information: Questions: DuPont Model – Analysis of ROA Calculations: < >: Return
ID: 2421665 • Letter: I
Question
Information:
Questions:
DuPont Model – Analysis of ROA
Calculations:
< >: Return on sales x asset turnover
Fiscal Year Ended
2/1/2015
2/2/2014
2/3/2013
1/29/2012
Return on assets (calculated)
8.39%
8.15%
8.74%
8.47%
Return on sales
5.63%
?
?
?
Asset turnover
2.38%
2.33%
2.31
2.31
Product
13.40%
?
?
?
Profitability Performance
Calculations:
Asset turnover: total net revenues / average total assets = 485,661 / 203,706 = 2.38
Return on sales: adjusted net income / total net revenues = Step by step for 2015 =
Gross margin %: (total revenue – cost of sales) / total revenue = (485,651 – 365,086) / 485,651 = 0.2483 = 24.83%
Return on assets: adjusted net income / average total assets = 17,099 / 203,706 = 8.39%
Return on equity: net earnings / average equity = Step by step for 2015 ?
Average interest rate: interest expense / average total liabilities = 2,461 / 65,272 = 0.0377 = 3.77%
Average total assets: (total assets 2015 + total assets 2014)/2 = (203,706 + 204,751) / 2 = 204,228.50
Income tax rate: Provision for income taxes / earnings before income taxes = Step by step for 2015 ?
Net of tax interest expense: income tax rate x interest expense = Step by step for 2015 ?
Adjusted net income: net earning + net of tax interest expense = Step by step for 2015 ?
Average equity: (total shareholders’ equity 2015 + total shareholders’ equity 2014)/2 = Step by step for 201
Average total liabilities: (total liabilities 2015 + total liabilities 2014)/2 = Step by step for 2015 ?
Profitability Ratios
Fiscal Year Ended
2/1/2015
2/2/2014
2/3/2013
1/29/2012
Asset turnover
2.38
2.33
2.31
2.31
Return on sales
5.63%
?
?
?
Gross margin %
24.83%
24.82%
24.83%
24.98%
Return on assets
8.39%
8.15%
8.74%
8.47%
Return on equity
21.01%
?
?
?
Average interest rate
3.77%
3.37
3.13%
3.72%
Average total assets
204,228.50
203,928
198,255.50
2011 data needed
Income tax rate
32.20%
?
?
?
Net of tax interest expense
2,348
2,216
2,063
2,159
Adjusted net income
16,363
?
?
?
Average equity
78,824.50
?
?
?
Average total liabilities
120,590.50
?
?
?
WAL MART STORES INC 10-K Income Statement (Amounts in millions except per share data) Fiscal Year Ended January 31, 2015 2014 2013 2012 Revenues: Net sales $482,229 $473,076 ####### $443,416 Membership and other income 3,422 3,218 3,047 3,093 485,651 476,294 468,651 446,509 Costs and expenses: Cost of sales 365,086 358,069 352,297 334,993 Operating, selling, general and administrative expenses 93,418 91,353 88,629 85,025 Operating income 27,147 26,872 27,725 26,491 Interest: Debt 2,161 2,072 1,977 2,034 Capital leases 300 263 272 286 Interest expense 2,461 2,335 2,249 2,320 Interest income (113) (119) (186) (161) Interest, net 2,348 2,216 2,063 2,159 Income from continuing operations before income taxes 24,799 24,656 25,662 24,332 Provision for income taxes: Current 8,504 8,619 7,976 6,722 Deferred (519) (514) (18) 1,202 Total provision for income taxes 7,985 8,105 7,958 7,924 Income from continuing operations 16,814 16,551 17,704 16,408 Income (Loss) from discontinued operations, net of tax 285 144 52 (21) Consolidated net income 17,099 16,695 17,756 16,387 Consolidated net income attributable to noncontrolling interest (736) (673) (757) (688) Consolidated net income attributable to Walmart $16,363 $16,022 $16,999 $15,699 Net income per common share: Basic income per common share from continuing operations to Walmart $5.01 $4.87 $5.03 $4.55 Basic income (loss) per common share from discontinued operations $0.06 $0.03 $0.01 ($0.01) Basic net income per common share attributable to Walmart $5.07 $4.90 $5.04 $4.54 Diluted income per common share from continuing operations to Walmart $4.99 $4.85 $5.01 $4.53 Diluted income (loss) per common share from discontinued operations $0.06 $0.03 $0.01 ($0.01) Diluted net income per common share $5.05 $4.88 $5.02 $4.52 Weighted-average number of common shares: Basic 3,230 3,269 3,374 3,460 Diluted 3,243 3,283 3,389 3,474 Dividends declared per common share $1.92 $1.88 $1.59 $1.46Explanation / Answer
1
Calculation of Return on sales:
For 2015:
Amounts in millions
Operating income (A)
27147
Net sales (B)
482229
Return on sales = A/B
5.63%
2
Calculation of Return on sales:
For 2014:
Amounts in millions
Operating income (A)
26872
Net sales (B)
473076
Return on sales = A/B
5.68%
3
Calculation of Return on equity:
For 2015:
Consolidated net income (A)
17099
Total equity (B)
85937
Return on equity =A/B
19.90%
4
Calculation of Return on equity:
For 2014:
Consolidated net income (A)
16695
Total equity (B)
81339
Return on equity =A/B
20.53%
1
Calculation of Return on sales:
For 2015:
Amounts in millions
Operating income (A)
27147
Net sales (B)
482229
Return on sales = A/B
5.63%
2
Calculation of Return on sales:
For 2014:
Amounts in millions
Operating income (A)
26872
Net sales (B)
473076
Return on sales = A/B
5.68%
3
Calculation of Return on equity:
For 2015:
Consolidated net income (A)
17099
Total equity (B)
85937
Return on equity =A/B
19.90%
4
Calculation of Return on equity:
For 2014:
Consolidated net income (A)
16695
Total equity (B)
81339
Return on equity =A/B
20.53%