Question

In: Accounting

Compute and Analyze Measures for DuPont Disaggregation Analysis Balance sheets and income statements for Costco Wholesale...

Compute and Analyze Measures for DuPont Disaggregation Analysis
Balance sheets and income statements for Costco Wholesale Corporation follow.

Consolidated Statements of Earnings
For Fiscal Years Ended ($ millions) September 1, 2013 September 2, 2012 August 28, 2011
Revenue
Net Sales $102,870 $97,062 $87,048
Membership fees 2,286 2,075 1,867
Total revenue 105,156 99,137 88,915
Operating expenses
Merchandise costs 91,948 86,823 77,739
Selling, general and administrative 10,104 9,518 8,691
Preopening expenses 51 37 46
Operating Income 3,053 2,759 2,439
Other income (expense)
Interest expense (99) (95) (116)
Interest income and other, net 97 103 60
Income before income taxes 3,051 2,767 2,383
Provision for income taxes 990 1,000 841
Net income including noncontrolling interests 2,061 1,767 1,542
Net income attributable to noncontrolling interests (22) (58) (80)
Net income attributable to Costco $ 2,039 $ 1,709 $ 1,462
Consolidated Balance Sheets
($ millions, except par value and share data) September 1, 2013 September 2, 2012
Assets
Current assets
Cash and cash equivalents $ 4,644 $ 3,528
Short-term investments 1,480 1,326
Receivables, net 1,201 1,026
Merchandise inventories 7,894 7,096
Deferred income taxes and other current assets 621 550
Total current assets 15,840 13,526
Property and equipment
Land 4,409 4,032
Buildings and improvements 11,556 10,879
Equipment and fixtures 4,472 4,261
Construction in progress 585 374
21,022 19,546
Less accumulated depreciation and amortization (7,141) (6,585)
Net property and equipment 13,881 12,961
Other assets 562 653
Total assets $ 30,283 $ 27,140
Liabilities and equity
Current liabilities
Accounts payable $ 7,872 $ 7,303
Accrued salaries and benefits 2,037 1,832
Accrued member rewards 710 661
Accrued sales and other taxes 382 397
Deferred membership fees 1,167 1,101
Other current liabilities 1,089 966
Total current liabilities 13,257 12,260
Long-term debt, excluding current portion 4,998 1,381
Deferred income taxes and other liabilities 1,016 981
Total liabilities 19,271 14,622
Equity
Preferred stock, $0.005 par value:
100,000,000 shares authorized; no shares issued and outstanding 0 0
Common stock, $0.005 par value:
900,000,000 shares authorized;
436,839,000 and 432,350,000 shares issued and outstanding 2 2
Additional paid-in-capital 4,670 4,369
Accumulated other comprehensive (loss) income (122) 156
Retained earnings 6,283 7,834
Total Costco stockholders’ equity 10,833 12,361
Noncontrolling interests 179 157
Total equity 11,012 12,518
Total liabilities and equity $ 30,283 $ 27,140


NOTE: Using net income attributable to controlling interests with your computations, when applicable.

a. Compute ROE for 2013.

Do not round until your final answer. Round answers two decimal places.

ROE =Answer%


b. Confirm that ROE equals ROE computed using the component measures for profit margin, asset turnover, and financial leverage using: ROE = PM * AT * FL.

Compute the components of ROE.

Do not round until your final answer. Round answers two decimal places.

PM = Answer%
AT = Answer
FL = Answer

c. Compute adjusted ROA (assume a tax rate of 37%).

Round answer to two decimal places.
  Adjusted ROA =Answer%

Solutions

Expert Solution

(a) NOPAT=Operating income*(1-Tax rate)=3053*(1-0.37)=$ 1923
c. RNOA=Income before income taxes/Average total assets
Average total assets=(Beginning total assets+Ending total assets)/2=(30283+27140)/2=28711.5
RNOA=3051/28711.5=0.10626=10.63%
NOPM=Net income/Total revenue=2061/105156=1.96 %
NOAT=Total revenue/Average current assets
Average current assets=(Beginning current assets+Ending current assets)/2=(15840+13526)/2=$ 14683
NOAT=105156/14683=7.16
(f) Non-operating return component of ROE=ROE-RNOA
ROE=Net income/Average shareholder's equity
Average shareholder's equity=(Beginning shareholder's equity+Ending shareholder's equity)/2=(11012+12518)/2=$ 11765
ROE=2061/11765=0.1751=17.52%
Non-operating return component of ROE=17.52-10.63=6.89%
(g) ROE > RNOA implies that Costco is able to borrow money to fund operating assets that yield a return greater than its cost of debt

Related Solutions

Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expense and income Interest expense 149...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($millions) 2015 2014 2013 Net sales $30,674 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 7,346 7,135 6,666 Interest expense and income Interest expense 149 142...
Analysis and Interpretation of Profitability Balance sheets and income statements for Costco Wholesale Corporation follow. Costco...
Analysis and Interpretation of Profitability Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) September 2, 2018 Total revenue $141,576 Operating expenses Merchandise costs 123,152 Selling, general and administrative 13,876 Preopening expenses 68 Operating Income 4,480 Other income (expense) Interest expense 159 Interest income and other, net (121) Income before income taxes 4,442 Provision for income taxes 1,263 Net income including noncontrolling interests 3,179 Net income...
Analysis and Interpretation of Liquidity and Solvency Balance sheets and income statements for Costco Wholesale Corporation...
Analysis and Interpretation of Liquidity and Solvency Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) August 28, 2016 August 30, 2015 August 31, 2014 Revenue Net Sales $116,073 $113,666 $110,212 Membership fees 2,646 2,533 2,428 Total revenue 118,719 116,199 112,640 Operating expenses Merchandise costs 102,901 101,065 98,458 Selling, general and administrative 12,068 11,445 10,899 Preopening expenses 78 65 63 Operating Income 3,672 3,624 3,220 Other...
Compute Measures for DuPont Disaggregation Analysis Use the information below for 3M Company to answer the...
Compute Measures for DuPont Disaggregation Analysis Use the information below for 3M Company to answer the requirements (perform these computations from the perspective of a 3M shareholder). ($ millions) 2015 2014 Sales $31,385 Net income, consolidated 5,554 Net income attributable to 3M shareholders 5,546 Assets 33,139 $31,630 Total equity 11,747 13,142 Equity attributable to 3M shareholders 11,708 13,109 a. Compute return on equity (ROE). Round answer to two decimal places (ex: 0.12345 = 12.35%) Answer % b. Compute the DuPont...
Income statements and balance sheets follow for E.I. DuPont de Nemours and Company. Refer to these...
Income statements and balance sheets follow for E.I. DuPont de Nemours and Company. Refer to these financial statements to answer the requirements. E. I. du Pont de Nemours and Company Consolidated Income Statements For The Year Ended December 31, ($ millions) 2016 2015 Net sales $ 24,594 $ 25,130 Cost of goods sold and other operating charges 15,155 15,571 Selling, general and administrative expenses 4,319 4,615 Research and development expense 1,641 1,898 Other (income) expense, net (non-operating) (708) (697) Interest...
Income statements and balance sheets follow for E.I. DuPont de Nemours and Company. Refer to these...
Income statements and balance sheets follow for E.I. DuPont de Nemours and Company. Refer to these financial statements to answer the requirements. E. I. du Pont de Nemours and Company Consolidated Income Statements For The Year Ended December 31, ($ millions) 2016 2015 Net sales $ 24,594 $ 25,130 Cost of goods sold and other operating charges 15,155 15,571 Selling, general and administrative expenses 4,319 4,615 Research and development expense 1,641 1,898 Other (income) expense, net (non-operating) (708) (697) Interest...
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 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...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2010 2009 2008 Net sales $26,662 $23,123 $25,269 Operating expenses Cost of sales 13,831 12,109 13,379 Selling, general and administrative expenses 5,479 4,907 5,245 Research, development and related expenses 1,434 1,293 1,404 Loss/(gain) from sale of business -- -- 23 Total operating expenses 20,744 18,309 20,051 Operating income 5,918 4,814 5,218 Interest expenses and income Interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT