Complete the cash flow statement worksheet (using the indirect method) that is attached to the e-mail to which this document is also attached.

Also compute the amounts for the items listed in cells H6, H7 and H8. Enter the amounts in cells I6, I7 and I8. H7 and H8 are amounts that must be disclosed at the bottom of a formal cash flow statement when using the indirect method.

The comparative balance sheet information is found in cells A2-D26. The income statement and retained earnings statement are given in cells H2 to L26. Use cells C4 to C52 to complete the worksheet. Cells C1 and C56 are check cells. If these cells are not zero, there is an error. Cells A28 to D56 would be the information that would appear on the company's 2016 cash flow statement. You do not need to prepare a formal statement. I have entered the net income information to help get you started. Cell F3 shows the change in cash for the year.

Put your name in cell A1, print the document (The print area has been set) and bring it to class on the day of the final exam and turn it in at the beginning of the final exam.

Other information:

1) The total depreciation expense consists of $10,000 on buildings and $25,000 on equipment.

2) Equipment that had a cost of $54,000 and a book value of $25,000 was sold for $15,000.

3) Included in the other operating expenses is Patent amortization expense of $5,000.

4) All changes in long-term notes payable, mortgage payable, common stock and treasury stock are the result of cash transactions.

5) Equipment costing $128,000 was purchased for cash.