Textbook Problem

Spreadsheet from Trial Balance Heinz Company’s post closing trial balance as of December 31, 2018, and the adjusted trial balance as of December 31, 2019, are shown here:

A review of the accounting records reveals the following additional information:

1. a. Bomb payable with a face value, book value, and market value of $14,000 were retired on June 30, 2019.
2. b. Bonds payable with a face value of $8,000 were issued at 90.25 on August 1, 2019. They mature on August 1, 2024. The company uses the straight-line method to amortize the bond discount.
3. c. The company sold a building that had an original cost of $8,000 and a book value of $4,800. The company received $2,200 in cash for the building and recorded a loss of $2,600.
4. 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.
5. e. Long-term investments in bonds being held to maturity with a cost of $ 1,000 were sold for $800.
6. 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 spreadsheet to support a statement of cash flows for 2019.