Using the information provided, complete the cash flow statement using the indirect method. MAKE USE OF EXCEL CAPABILITIES BY USING AS MANY FORMULAS AND FUNCTIONS AS POSSIBLE.

Reference or given data section. 12/31/2015 Change STATEMENT OF CASH FLOWS (INDIRECT METHOD) The Group, Inc. Consolidated Balance Sheets (in thousands) 3/31/2016 ASSETS Current Assets: Cash and Cash Equivalents $92,069 Accounts Receivables, Net 55,947 Inventories 50,784 Prepaid Expenses 12,112 Total Current Assets 210,912 Equipment 145,444 Less: Accumulated Depreciation -50,515 Total Assets $305,841 $72,634 75,492 53,129 13,057 214,312 134,312 -36,689 $311,935 Answer section is on the second tab titled "Cash Flow" LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Accounts Payable Accrued Liabilities Total Current Liabilities Long-Term Debt Stockholders' Equity: Contributed Capital Retained Earnings Total Stockholders' Equity Total Liabilities And Stockholders' $25,466 40,574 66,040 10,422 $34,879 40,722 75,601 10,206 1,662 227,717 229,379 $305,841 1,284 224,844 226,128 $311,935 Consolidated Statement of Income (in thousands) Info cash flow G H MN o Consolidated Statement of Income (in thousands) Quarter ended 3/31/16 Net Sales $130,896 Cost of Sales 74,040 Gross Profit 56,856 Operating Expenses: Selling, General & Administrative 33,211 Depreciation Expense 13,826 Total Operating Expenses 47,037 Operating Income 9,819 Interest Income 239 Income Before Income Taxes 10,058 Income Tax Expense 3,621 Net Income $6,437 The company declared and paid the following dividends during the quarter ended 3/31/16. The Group, Inc. did not sell any equipment or repay any borrowings during the quarter ended 3/31/16. A B C D E K L M N O P e R S T U V Using the information provided, complete the cash flow statement using the indirect method. Make use of Excel capabilities by using as many formulas and functions as possible