The post-closing trial balance as of December 31, 2006 and the adjusted trial balance as of December 31, 2007 are shown here for the Heinz Company:

A review of the accounting records reveals the following additional information:
(a) Bonds payable with a face value, book value, and market value of $14,000 were retired on June 30, 2007.
(b) Bonds payable with a face value of $8,000 were issued at 90.25 on August 1, 2007. They mature on August 1, 2012. The company uses the straight-line method to amortize bond discount.
(c) A tornado completely destroyed a small building that had an original cost of $8,000 and a book value of $4,800. Settlement with the insurance company resulted in after-tax proceeds of $2,200 and an extraordinary loss (net of income taxes) of $2,600.
(d) Equipment with a cost of $4,000 and a book value of $1,400 was exchanged for an acre of land valued at $2,700. No cash was exchanged.
(e) Long-term investments in bonds being held to maturity with a cost of $1,000 were sold for $800.
(f) Sixty-five shares of common stock were exchanged for a patent. The common stock was selling for $20 per share at the time of the exchange.
Required
Prepare a worksheet (spreadsheet) to support a statement of cash flows for2007.

Transcribed Image Text:

December 31, 2006 Post-closing Trial Balance December 31, 2007 Adjusted Trial Balance S 2,700 5,900 15,300 1,400 8,300 16,300 68,700 S 3,520 6,215 15,530 Accounts receivable Prepaid items Investments in bonds (long-term) 7,300 19,000 60,700 Accumulated depreciation: buildings Equipment Accumulated depreciation: equipment Patents (net) Accounts payable Interest payable Wages payable Bonds payable Discount on bonds payable Common stock, $10 par Additional paid-in capital Retained earnings S 35,000 34,500 29,600 25,600 14,200 14,700 8,700 9,185 8,900 9,195 2,500 23,000 2,600 17,000 0 715 22,650 15,970 35,350 15,320 $156,900 $156,900 Sales (net) Cost of goods sold Wages expense Other operating expenses Depreciation expense: Depreciation expense: equipment Patent amortization Interest expense Loss (ordinary) on sale of investments Interest revenue Gain (ordinary) on exchange of assets Income tax expense Extraordinary loss (net of income taxes) Dividends declared 49,550 23,800 16,510 1,100 buildings 3,100 815 200 790 1,300 2,600 2,100 $203,905 Totals $203,905