Please confirm my financial analysis with regard to both the income statement and the balance sheet is

correct, and if it is not; provide a formula or solution (preferably using Excel). Thanks!

Fiscal Years Ending on Sunday Closest to August 31 Selected Income Statement Data 2016 2015 2014 2013 2011 2005 2000 8,969 15,218 15,575 17,043 33,163 4,061 8,908 17,299 16,540 15,401 33.440 4,864 10.843 8.456 17,588 14.412 14,830 33,024 5,093 12,515 7,894 15,840 13,257 13,881 30,283 4,998 11,012 6,638 13,706 12,050 12,432 26,761 2.153 12,573 4,015 8.238 6,761 6,761 7.790 16,514 711 8,881 2.490 3,470 3,404 4,834 8,634 790 4.240 12.079 $3,292 $4,285 $3,984 $3,437 $3,198 686 663 634 608 $1,773 417 21 $1,070 292 25 33 26 30 26 24 Merchandise inventories Current assets Current liabilities Net property and equipment Total assets Long-term debt Stockholders' equity Cash Flow Data Net cash provided by operating activities Warehouse Operations Warehouses at beginning of year New Warehouses opened (including relocations) Existing warehouses closed (including relocations) Warehouses at end of year Net sales per warehouse open at year- end (in millions) Average annual growth at warehouses open more than a year Members at year-end Businesses (000s) Gold Star members (000s) Add-on cardholders (employees of busi- ness members, spouses of Gold Star members) Total cardholders (3) (5) 0 634 (4 313 715 686 663 592 $147.1 433 $1198 $161.0 $165.7 $164,0 $162.0 $101.0 4% 7% 6% 10% 7% 11% 7,300 36,800 7.100 34,000 6,900 31,600 6,600 28,900 6,300 25,000 5,000 16,200 4,200 10,500 na. na. 42,600 86,700 40,200 81,300 37.900 76,400 35,700 71.200 32,700 64.000 Prior to 2011, the company's warehouses-30 of which were opened in 2007 and two others in 2008-2009-were consolidated and reported as part of Cosico's total operations at the beginning of fiscal 2011 Sales for new warehouses opened during the year are annualized. Note: Some totals may not add due to rounding and the fact that some line items in the company's statement of income were not included in this summary, for reasons of simplicity Sources: Company 10-K reports for fiscal years 2000, 2005, 2011, 2013, 2015 and 2016. 544 53 EXHIBIT 1 Selected Financial and Operating Data for Costco Wholesale Corp., Fiscal Years 2000, 2005, 2011, and 2013-2016 ($ in millions, except for per share data) Fiscal Years Ending on Sunday Closest to August 31 Selected Income Statement Data 2016 2015 2014 2013 2011 2005 2000 Net sales $116,073 $113,666 $110,212 $102,870 $87,048 $51,862 $31,621 Membership fees 2.646 2,533 2,428 2 ,286 1.867 1,073 Total revenue 118.719 116,199 112,640 105,156 88,915 52,935 32,164 Operating expenses Merchandise costs 102,901 101,065 98,458 91,948 77,739 46,347 28,322 Selling, general, and administrative 12,068 11,445 10,899 1 0,104 8,682 5,044 2.755 Preopening expenses 78 65 63 51 46 - 42 Provision for impaired assets and store closing costs 7 3,624 Operating income 3,220 2439 3,053 Other income (expense) Interest expense (133) (124) (113) (99) (116) (34) (39 Interest income and other 80 97 54 Income before income taxes 3,619 3,604 3,197 3,051 2.383 1,549 1.052 1,243 1,109 1,195 990 Provision for income taxes 841 486 $ 2,350 $ Net income 2,377 $ 2,058 $ 2,039 $ 1.462 $ 1.063 $ 5,33 $ 5.37 $ 4.65 $ Diluted net income per share 4.63 $ 3.30 $ 2.18 $ 1.35 Dividends per share (not including spe- cial dividend of $5.00 in 2015 and $ 1.70 $ $7.00 in 2013) 1.51 $ 1.33 $ 1.17 $ 0.89 $ 0.43 0.00 Millions of shares used in per share 441.3 442.7 4425 calculations 440. 5 4 43.1 492.0 475.7 Balance Sheet Data $ 3,379 $ 4,801 $5,738 $ 4,644 Cash and cash equivalents $4,009 $ 2.063 3,672 1,037 104 60 109 421 x & fel COSTCO WHOLESALE FINANCIAL ANALYSIS 2013-2016 $ US Numbers in Millions, except EPS and where indicated 2013 2014 2015 2016 7 INCOME STATEMENT 9 Total Revenue (actual) 10 Total Revenue (in millions) 11 Total Revenue (in billions) $105, 156,000,000.00 $105,156.00 $105.16 $112,640,000,000.00 $112,640.00 $112.64 $116,199,000,000.00 $116,199.00 $116.20 $118,719,000,000.00 $118,719.00 $118.72 13 Revenue CAGR 2013-2016 4.13% 7.12% 3.16% 2.17% 15 Revenue 1 Year Growth Rate 16 17 Merchandise Costs 18 Gross Profit 19 Gross Margin $91,948.00 $13,208.00 12.56% $98,458.00 $14,182.00 12.59% $101,065.00 $15,134.00 13.02% $102,901.00 $15,818.00 13.32% 20 21 Operating Income 22 Operating Margin $3,053.00 2.90% $3,220.00 $3,624.00 $3,672.00 3.09% 2.86% 312 24 Net Income (NI) 25 NI 1 Year Growth Rate $2,039.00 $2,058.00 0.93% $2,377.00 15. SOX $2,350.00 -1.14% 27 Return on Sales (ROS) 1.94% 1.83 2.05 1985 29 Total Assets 30 Total Shareholder Equity $30,283.00 $11,012.00 $33,024.00 $12,515.00 $33,440.00 $10,843.00 $33,163.00 $12,079.00 32 Return on Assets (ROA) 6.73% 6.23 17.11% 7.09% 34 Return on Equity (ROE) 18.52% 21.92% 19.46% 36 Earnings per Share (EPS) $4.63 $5.37 $5.33 2013 2016 Sheet1 1 x fc 4 Return on Equity (ROE) 18.52% 16.44N 21929 19.46% 16 Earnings per Share (EPS) $4.63 $4.65 $5.37 $5.33 2013 2014 2015 2016 40 BALANCE SHEET 42 Current Assets 43 Inventories 44 Current Labilities $15,840,00 $7,894.00 $13,257,00 $17,588.00 $8,456.00 $14,412.00 $17,299.00 $8,908.00 $16,540.00 $15,218.00 $8,969.00 $15,575.00 1.19 46 Current Ratio 47 Quick Ratio 0.6 1.22 0.63 1.05 0.51 0.98 0.40 49 Total Assets 50 Total Shareholder Equity 51 Total Debt 52 Long Term Debt $30,283.00 $11,012.00 $19,271.00 $4,998.00 $33,024.00 $12,515.00 $20,509.00 $5,093.00 $33,440.00 $10,843.00 $22,597.00 $4,864.00 $33,163.00 $12,079.00 $21,084.00 $4,061.00 54 Debt to Asset Ratio (D/A) 55 Long Term Debt to Asset (LTD/A) 56 Debt to Equity Ratio (D/E) 63.64% 16 SOX 175.00% 62.10% 15.42% 163.88% 67.57% 14.55 208.40% 63.58% 12.25% 174.55% 58 Property & Equipment, Net $13,881.00 $14,830.00 $15,401.00 $17,043.00 7.58 3.47 7.60 6.97 60 Fixed Asset Turnover (FAT) 61 Total Asset Turnover (TAT) 62 63 Merchandise Costs 64 Inventory $91,948.00 $7,894.00 $98,458.00 $8,456.00 $101,065.00 $8,908.00 $102,901.00 $8,969.00 66 Inventory Turnover 11.65 113 11.47 - PINANGAL ANAL Sus Numb e r INCOME STATEMENT Total Mercedes Og Origin mon S OS To mon ROA Bertunan Wowowfully Current Current * Current Ratio Ratio 4 TA Total Wareholder 11 Tot Long Term Debt ty Debt Ratio Long Term Debt to LTDA Debiya) Peter Total TAT)