The following 2007 information is available for the Payne Company:

Partial additional information: The net income for 2007 totaled $1,600. During 2007 the company sold for $390, equipment that cost $390 and had a book value of $300. The company sold land for $200, resulting in a loss of $40. The remaining change in the Land account resulted from the purchase of land through the issuance of common stock.
Required
Making whatever additional assumptions that are necessary, prepare a worksheet (spreadsheet) to support the 2007 statement of cash flows for the PayneCompany.

Transcribed Image Text:

Comparative Balance Sheets January 1, 2007 December 31, 2007 $ 400 220 370 250 2,070 (310) $3,000 S 800 900 600 700 Total Liabilities and Stockholders' EqyS3,000 Cash Accounts receivable Inventory Land Equipment Less: Accumulated depreciation Total Assets S 600 200 610 410 2,200 400) $3,620 S 500 720 1,000 1,400 S3,620 Accounts payable Notes payable (long-term) Common stock, no par Retained earnings