Question

In: Finance

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 income (expense)
Interest expense (133) (124) (113)
Interest income and other, net 80 104 90
Income before income taxes 3,619 3,604 3,197
Provision for income taxes 1,243 1,195 1,109
Net income including noncontrolling interests 2,376 2,409 2,088
Net income attributable to noncontrolling interests (26) (32) (30)
Net income attributable to Costco $2,350 $2,377 $2,058
Costco Wholesale Corporation
Consolidated Balance Sheets
($ millions, except par value and share data) August 28, 2016 August 30, 2015
Assets
Current assets
Cash and cash equivalents $3,379 $4,801
Short-term investments 1,350 1,618
Receivables, net 1,252 1,224
Merchandise inventories 8,969 8,908
Deferred income taxes and other current assets 268 228
Total current assets 15,218 16,779
Property and equipment
Land 5,395 4,961
Buildings and improvements 13,994 12,618
Equipment and fixtures 6,077 5,274
Construction in progress 701 811
Gross property and equipment 26,167 23,664
Less accumulated depreciation and amortization (9,124) (8,263)
Net property and equipment 17,043 15,401
Other assets 902 837
Total assets $33,163 $33,017
Liabilities and equity
Current liabilities
Accounts payable $7,612 $9,011
Current portion long-term debt $1,100 $1,283
Accrued salaries and benefits 2,629 2,468
Accrued member rewards 869 813
Deferred membership fees 1,362 1,269
Other current liabilities 2,003 1,695
Total current liabilities 15,575 16,539
Long-term debt, excluding current portion 4,061 4,852
Other liabilities 1,195 783
Total liabilities 20,831 22,174
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;
437,524,000 and 437,952,000 shares issued and outstanding 2 2
Additional paid-in-capital 5,490 5,218
Accumulated other comprehensive loss (1,099) (1,121)
Retained earnings 7,686 6,518
Total Costco stockholders’ equity 12,079 10,617
Noncontrolling interests 253 226
Total equity 12,332 10,843
Total liabilities and equity $33,163 $33,017


(a) Compute Costco's financial leverage (FLEV), Spread, and noncontrolling interest (NCI) ratio for 2016; recall, NNE = NOPAT-Net income.

Remember to use negative signs with answers, when appropriate.  

2016 NNO =$Answer

million
2015 NNO =$Answer million  


2016 NNE =$Answer

million
2016 NNEP =Answer% Round NNEP to two decimal places.   

2016 FLEV        = Answer  Round FLEV to four decimal places.   
2016 Spread    = Answer% Round Spread to two decimal places.
2016 NCI ratio = Answer Round NCI ratio to four decimal places.



(b) Assume that Costco's return on equity (ROE) for 2016 is 20.71% and its return on net operating assets (RNOA) is 20.66%. Confirm computations to yield the relation: ROE = [RNOA + (FLEV X Spread)] X NCI ratio.

2016 ROE =Answer

% = [Answer%+(Answer X Answer%)] X Answer


(c) What do your computations of the nonoperating return in parts (a) and (b) imply about the company's use of borrowed funds?

Costco's FLEV is negative - meaning its non-operating assets exceed its non-operating liabilities. Costco has a high level of short term investments to use for new opportunities.

Costco's FLEV is negative - meaning its non-operating liabilities exceed its non operating assets. Costco will need to rely on debt to finance new opportunities.

Costco's FLEV is positive - meaning its non-operating assets exceed its non-operating liabilities. Costco has a high level of cash and short term investments to use for new opportunities.

Costco's FLEV is positive - meaning its non-operating liabilities exceed its non-operating assets. Costco has a high level of cash and short term investments to use for new opportunties.

Solutions

Expert Solution

Solution:

a. 2016 NNO= ($4,061 + $1,100) – ($3,379 + $1,350) = $432

2015 NNO= ($4,852 + $1,283) – ($4,801 + $1,618) = $(284)

2016 NOPAT = $3,672 – [$1,243 + ($133 - $80) × 0.37)] = $2,4092016

NNE = NOPAT – Net income= $2,409 – $2,376 = $33

2016 NNEP = $33 / [($432 + $(284)) / 2] = 45.12%

2016 FLEV = [($432 + $(284)) / 2] / ([$12,332 + $10,843] / 2) = 0.0064

2016 Spread = RNOA – NNEP = 20.66% – (45.12)% = -24.46%

NCI ratio = ($2,350 / $2,376) divided by [($12,079 + $10,617 / 2) / ($12,332 + $10,843 / 2)]= 1.0099

b.

ROE = [20.66% + (0.0064 × -24.46%)] × 1.0099 = 20.71%

c. Costco's FLEV is negative - meaning its non-operating assets exceed its non-operating liabilities. Costco has a high level of short term investments to use for new opportunities.

Costco’s non-operating assets exceed its non-operating liabilities in 2014 resulting in avery small NNO and a large NNEP. Because NNEP is so large, the spread is negative.The effect on ROE is minimal because FLEV is close to zero. Costco is holding a lot ofcash that may be easily liquidated to respond quickly to new opportunities or react to competition


Related Solutions

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...
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)...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2008 2007 2006 Sales $ 61,471 $ 57,878 $ 51,271 Credit card revenues 1,896 1,612 1,349 Total revenues 63,367 59,490 52,620 Cost of sales 41,895 39,399 34,927 Selling, general and administrative expenses 13,704 12,819 11,185 Credit card expenses 837 707 776 Depreciation and amortization 1,659 1,496 1,409 Earnings before interest and income taxes 5,272 5,069 4,323 Net interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2006 2005 2004 Sales $ 51,271 $ 45,682 $ 40,928 Credit card revenues 1,349 1,157 1,097 Total revenues 52,620 46,839 42,025 Cost of sales 34,927 31,445 28,389 Selling, general and administrative expenses 11,185 9,797 8,657 Credit card expenses 776 737 722 Depreciation and amortization 1,409 1,259 1,098 Earnings before interest and income taxes 4,323 3,601 3,159 Net interest...
Question text Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow....
Question text Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2008 2007 2006 Sales $ 61,471 $ 57,878 $ 51,271 Credit card revenues 1,896 1,612 1,349 Total revenues 63,367 59,490 52,620 Cost of sales 41,895 39,399 34,927 Selling, general and administrative expenses 13,704 12,819 11,185 Credit card expenses 837 707 776 Depreciation and amortization 1,659 1,496 1,409 Earnings before interest and income taxes 5,272 5,069 4,323...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Consolidated Statements of Earnings Year Ended December 31 (In millions) 2016 2015 Net sales Products $ 40,365 $ 34,868 Services 6,883 5,668 Total net sales 47,248 40,536 Cost of sales Products (36,616) (31,091) Services (6,040) (4,824) Severance and other charges (80) (82) Other unallocated costs 550 (47) Total cost of sales (42,186) (36,044)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 27,882 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,758 33,316 29,848 3,455 2,210 1,976 Other income (expenses),...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 28,800 27,879 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 34,676 33,558 29,848 2,537 1,968 1,976 Other income (expenses),...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 27,882 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,758 33,316 29,848 3,455 2,210 1,976 Other income (expenses),...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 27,882 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,758 33,316 29,848 3,455 2,210 1,976 Other income (expenses),...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT