please see attached file

question 1 cash flow statement in excel attached file

Cash account receivable inventory investment long term building equipment patent Total 2016 $ 38,500.00 $ 12,250.00 $ 12,000.00 $ $ $ 40,000.00 $ 5,000.00 $ 107,750.00 $ $ $ $ $ $ $ $ 2015 13,000.00 10,000.00 9,000.00 3,000.00 29,750.00 20,000.00 6,250.00 91,000.00 Allowance for doubtgul account Accumulated depreciation-equipment Accumulated depreciation-building Accounts payable Dividends payable Note payable short term Long term Note payable Common shares Retained earnings Totals $ 3,000.00 $ 2,000.00 $ $ 5,000.00 $ $ 3,000.00 $ 31,000.00 $ 43,000.00 $ 20,750.00 $ 107,750.00 $ $ $ $ $ $ $ $ $ $ 4,500.00 4,500.00 6,000.00 3,000.00 6,000.00 4,000.00 25,000.00 33,000.00 5,000.00 91,000.00 Additional data relating to 2016 are as follows: 1. Equipment that had cost $11,000 and was 40% depreciated at the time of disposal was sold for $2,500. 2. $10,000 of the long-term note payable was paid by issuing common shares. 3. Cash dividends paid were $6,000. 4. In early 2015, an unused building was expropriated by the federal government. Proceeds received were $33,000. 5. Investments (long-term) were sold for $2,500 above their cost. 6. Cash of $15,000 was paid for the acquisition of equipment. 7. A long-term note for $16,000 was issued for the acquisition of equipment. 8. Interest of 2000$ and income taxes of 5000$ were paid in cash. Required Prepare a properly formatted Cash Flow Statement for the year ended December 31, 2016 using the indirect method. Gel eived were $33,000. g the indirect method. Gelinas elected to report the government expropriation as an unusual item. Gelinas follows ASPE