The Excel file includes an"Analysis" tab.You are to complete the information in that tab for the company we're analyzing.Please see information on this tab and substantiate your conclusions (i.e. show calculations, provide commentary if appropriate).The tab will also have a place for you to put in general analytical comments about that company (i.e. what are they doing well, what are they doing poorly, what can you tell about the company based on the numbers, etc.).Approach this as if you were an external analyst brought in to advise the management team.

Here are a few other pointers:

• Complete the information for the most recent year (you don't need to do the analysis for every year).
• Ratios and rate of change data in the income statement should be represented as a percentage.
• Use 2 decimal points of precision
• When providing the narrative for the "Source of change in cash" talk through the changes for the most recent year, not changes from the previous year to the current year.
  

Complete Chow Inc. Balance Sheet Form Type: 10-K Period End: Sep 27, 2015 Consolidated Balance Sheets (In millions) September 27, Assets Current assets: Cash and cash equivalents Short-term investments - available-for-sale securities Restricted cash Accounts receivable Merchandise inventories Prepaid expenses and other current assets Deferred income taxes Total current assets Property and equipment, net of accumulated depreciation and amortization Long-term investments - available-for-sale securities Goodwill Intangible assets, net of accumulated amortization Deferred income taxes Other assets Total assets Liabilities and Shareholders' Equity Current liabilities: Current installments of capital lease obligations Accounts payable Accrued payroll, bonus and other benefits due team members Dividends payable Other current liabilities Total current liabilities Long-term capital lease obligations, less current installments Deferred lease liabilities Other long-term liabilities Total liabilities September 28, 2015 $ $ 2014 237 $ 155 127 218 500 108 199 1,544 190 553 109 198 441 97 168 1,756 3,163 63 710 79 144 38 5,741 $ 2,923 120 708 81 132 24 5,744 $3 $2 295 436 45 473 1,252 276 379 43 557 1,257 62 587 71 1,972 60 548 66 1,931 2,904 2,863 Commitments and contingencies Shareholders' equity: Common stock, no par value, 1,200 and 600 shares authorized; 377.1 shares issued; 348.9 and 360.4 shares outstanding at 2015 and 2014, respectively Common stock in treasury, at cost, 28.2 and 16.7 shares at 2015 and 2014, respectively Accumulated other comprehensive loss Retained earnings Total shareholders' equity Total liabilities and shareholders' equity $ (1,124) (28) 2,017 3,769 5,741 $ (711) (7) 1,668 3,813 5,744 Complete Chow Inc. Income Statement Form Type: 10-K Period End: Sep 27, 2015 Consolidated Statements of Operations Sales Cost of goods sold and occupancy costs Gross profit Selling, general and administrative expenses Pre-opening expenses Relocation, store closure and lease termination costs Operating income Investment and other income, net of interest expense Income before income taxes Provision for income taxes Net income $ $ 2015 15,389 $ 9,973 5,416 4,472 67 16 861 17 878 342 536 $ 2014 14,194 $ 9,150 5,044 4,032 67 11 934 12 946 367 579 $ 2013 12,917 8,288 4,629 3,682 52 12 883 11 894 343 551 Basic earnings per share Weighted average shares outstanding $ 1.49 $ 358.50 1.57 $ 367.80 1.48 371.20 Diluted earnings per share Weighted average shares outstanding, diluted basis $ 1.48 $ 360.80 1.56 $ 370.50 1.47 374.50 Dividends declared per common share $ 0.52 $ 0.48 $ 1.40 Complete Chow Inc. Cash Flow Form Type: 10-K Period End: Sep 27, 2015 Consolidated Statements of Cash Flows Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization Impairment of long-lived assets Share-based payment expense LIFO expense Deferred income tax benefit Excess tax benefit related to exercise of team member stock options Accretion of premium/discount on marketable securities Deferred lease liabilities Other Net change in current assets and liabilities: Accounts receivable Merchandise inventories Prepaid expenses and other current assets Accounts payable Accrued payroll, bonus and other benefits due team members Other current liabilities Net change in other long-term liabilities Net cash provided by operating activities Cash flows from investing activities Development costs of new locations Other property and equipment expenditures Purchases of available-for-sale securities Sales and maturities of available-for-sale securities Purchases of intangible assets Decrease (increase) in restricted cash Payment for purchase of acquired entities, net of cash acquired Other investing activities Net cash used in investing activities Cash flows from financing activities Purchases of treasury stock Common stock dividends paid Issuance of common stock Excess tax benefit related to exercise of team member stock options Other financing activities Net cash used in financing activities Effect of exchange rate changes on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental disclosure of cash flow information: Federal and state income taxes paid $ 2015 2014 2013 536 $ 579 $ 551 439 48 64 1 (43) 377 1 68 16 (78) 339 1 57 2 (51) (11) (9) (37) 17 32 5 27 36 11 31 51 8 (21) (61) (9) 20 (14) (41) (4) 30 9 (42) (17) - 58 47 7 1,129 12 54 23 1,088 60 51 (4) 1,009 (516) (335) (494) (447) (263) (720) (339) (198) (1,252) 928 (3) (19) 1,054 (20) 2 1,534 (1) (8) (4) (12) (455) (73) (17) (484) (22) (3) (289) (513) (184) 66 (578) (170) 42 (125) (508) 81 11 (2) (622) 9 (1) (698) 37 (2) (517) $ (5) 47 190 237 $ (6) (100) 290 190 $ (2) 201 89 290 $ 383 $ 429 $ 378 For all questions, answer for the most recent year Balance sheet Does it balance? (provide proof) Quick ratio Current ratio Change in cash (in $M) Supporting notes and comments Income Statement Revenue Net profit EBITDA RoS COGS ratio OpEx ratio Sales rate of change COGS rate of change OpEx rate of change (in $M) Cash Flow Statement OCF ICF FCF Change in cash Source of change in cash Is OCF positive Is OCF > net profit Is OCF > fixed asset investment Is OCF trending the same as net profit? (in $M) Other Receivable days Inventory days ROA General observations of Company