A 3 4 5 B C G H Cristal Clear, Inc. Income Statement For the Year Ended Dec. 31, 2017 2017 2016 4,330,000 3,240,000 3,005,089 2,466,000 1,324,911 774,000 988,411 207,000 115,000 371,000 86,429 20,000 135,071 176,000 73,833 54,000 61,238 122,000 24,495 48,800 36,743 73,200 40% The data and template for Questions 5 are located in three aus: "Q5-85", "Q5-IS" and "Q5-SCF". Q5: Create the Statement of Cash Flows (use "Q5-SCF" as template) based on the Income Statement and Balance Sheet. Format your answers using thousand separator with no decimal places. Use negative sign for cash outflows. -1 2 3 4 5 Sales 6 Cost of Goods Sold 7 Gross Profit 8 G&A Expenses Other Expenses 0 Depreciation EBIT 1 2 Interest Expense 3 Earnings Before Taxes 4 Taxes 5 Net Income 6 7 Notes: 8 Tax Rate 9 D 1 2 D E 1 2 3 4 Assets 5 6 Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2017 Cash and Equivalents Accounts Receivable 7 Inventory 8 Total Current Assets 9 Plant & Equipment 10 Accumulated Depreciation 11 Net Fixed Assets 12 Total Assets 13 Liabilities and Owners' Equity 14 Accounts Payable 15 Short-term Notes Payable 16 Other Current Liabilities 17 Total Current Liabilities Long-term Debt 18 19 Total Liabilities 20 Common Stock 21 Retained Earnings 22 Total Shareholder's Equity 23 Total Liabilities and Owners' Equity 24 2017 2016 46,000 50,000 309,286 360,000 772,714 704,571 1,128,000 1,114,571 434,667 435,000 146,000 59,571 288,667 375,429 1,416,667 1,490,000 158,000 131,000 201,000 264,500 121,000 117,000 480,000 512,500 370,000 167,500 850,000 680,000 367,667 408,000 199,000 402,000 566,667 810,000 1,416,667 1,490,000