use the income statement to create an excel cash flow statement.

Egils Inc. Comparative Income Statement For the Years Ended December 31, 2010 and 2009 2010 $126.200 $100,000 Sales returns and allowances 26 000 Net sales $123,774 98,000 Cost of goods sold 50,000 Gross profit 64,974 S 48,000 Selling expenses 17,310 15,000 Administrative expenses 13464 000 30,774 27,000 Total operating expenses 34.200 21,000 Income from operations 1,000 1 000 35,200 Income before income tax 22,000 12.000 6,000 Income tax expense Net income. 3200 16,000 Egils Inc. Comparative Income Statement For the Years Ended December 31, 2010 and 2009 2010 $126.200 $100,000 Sales returns and allowances 26 000 Net sales $123,774 98,000 Cost of goods sold 50,000 Gross profit 64,974 S 48,000 Selling expenses 17,310 15,000 Administrative expenses 13464 000 30,774 27,000 Total operating expenses 34.200 21,000 Income from operations 1,000 1 000 35,200 Income before income tax 22,000 12.000 6,000 Income tax expense Net income. 3200 16,000