help me with worksheet entries on first photo

*Debit *other operating payments *payments of interest

COMP PROBLEM 17 eBook LUCILLUMUY LCO LULO Other operating payments 1,100 Payments of interest 2,045 Payments of income taxes 500 Cash Flows from Investing Activities: 2,200 Proceeds from building destroyed by tornado 800 Proceeds from sale of long-term investments Cash Flows from Financing Activities: Payment to retire bonds payable 14,000 Proceeds from issuance of bonds payable v 7,220 Payment of dividends 2,100 Investing and Financing Activities Not Affecting Cash: Exchange of equipment for land 2,700 2,700 Acquisition of land by exchanging equipment Issuance of common stock for patent 1,300 1,300 Acquisition of patent by issuing common stock Net increase in cash 820 Totals 65,420 Depreciation Expenses: Equipment 3,100 3,100 3,100 Patent Amortization Expense 1 815 815 815 interest Expense 1,715 1,715 1,715 Loss on Sale of Investments 200 2007 200 Interest Revenue 790 790 V 790 1,300 Gain on Exchange 1,300 1,300 Income Tax Expense 500 500 500 2,600 Extraordinary Loss (net) 2,600 2,600 2,100 2,100 Dividends Declared 2,100 Totals 156,900 156,900 203,905 203,905 67,235 67,2357 81,415 81,415 Worksheet Entries Debit Credit Cash Flows from Operating Activities: Collections from customers 49,550 7 315 790 Interest and dividends collected 295 24,030 Payments to suppliers Payments to employees 100 16,510 Buildings 8,000 68,700 8,000 60,700 Accumulated Depreciation: Buildings 2,700 3,200 7 35,000 34,500 500 Equipment 4,000 29,600 25,600 4,000 500 2,600 3,100 14,200 14,700 Accumulated Depreciation: Equipment Patents (net) 815 1,300 485 9,185 8,700 295 V 295 Accounts Payable 8,900 9,195 330 330 Interest Payable 630 300 100 2,500 2,600 100 Wages Payable 14,000 8,000 Bonds Payable 23,000 17,000 6,000 780 0 65 715 715 Discount on Bonds Payable 650 650 Common Stock, $10 par 22,000 22,650 650 650 15,970 15,320 Additional Paid-in Capital 35,350 35,850 Retained Earnings 49,550 49,550 49,550 Sales (net) 23,800 23,800 23,800 Cost of Goods Sold 16,510 16,510 16,510 Wages Expense 1,100 1,100 1,100 Other Operating Expenses 2,700 2,700 2,700 Depreciation Expenses: Buldings Check My Work 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, 2019. 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. 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. 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: Using the direct method for operating cash flows, prepare a spreadsheet to support a 2019 statement of cash flows. HEINZ COMPANY Cash Flows Worksheet For the Year Ended December 31, 2019 12/31/18 Post-Closing Trial Balance 12/31/19 Adjusted Trial Balance Change Worksheet Entries Debit Credit Debit Credit Debit Debit Account Titles Credit Credit 820 820 3,520 Cash 2,700 315 315 6,215 5,900 Accounts Receivable 230 230 Inventories 15,300 15,530 400 400 1,400 1,000 Prepaid Items 1,000 1,000 8,300 7,300 Investments (long-term) 2,700 2,700 16,300 19,000 Land 8,000 8,000 68,700 60,700 Buildings tor Interest Payable 630 300 Wages Payable 2,500 2,600 Bonds Payable 23,000 17,000 Discount on Bonds Payable 0 715 Common Stock, $10 par 22,000 22,650 Additional Paid-in Capital 15,320 15,970 Retained Earnings 35,350 35,350 $156,900 $156,900 Sales (net) 49,550 Cost of Goods Sold 23,800 16,510 Wages Expense Other Operating Expenses 1,100 2,700 Depreciation Expense: Buildings Depreciation Expense: Equipment 3,100 Patent Amortization 815 Interest Expense 1,715 Loss (Ordinary) on Sale of Investments 200 Interest Revenue 790 1,300 Gain (Ordinary) on Exchange of Assets Income Tax Expense Ordinary Loss on sale of building 500 2,600 Dividends Declared 2,100 Totals $203,905 $203,905 (Appendix 21.1) Complex Spreadsheet 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: Cash Accounts Receivable Inventories Prepaid Items Investments in Bonds (long-term) Land December 31, 2018 December 31, 2019 Post-Closing Trial Balance Adjusted Trial Balance $ 2,700 $ 3,520 5,900 6,215 15,300 15,530 1,400 1,000 8,300 7,300 16,300 19,000 68,700 60,700 $ 35,000 $ 34,500 29,600 25,600 14,200 14,700 8,700 9,185 8,900 630 300 2,500 2,600 23,000 17,000 0 715 22,000 22,650 Buildings 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 9,195 15,320 15,970 35,350 35,350 COMP PROBLEM 17 eBook LUCILLUMUY LCO LULO Other operating payments 1,100 Payments of interest 2,045 Payments of income taxes 500 Cash Flows from Investing Activities: 2,200 Proceeds from building destroyed by tornado 800 Proceeds from sale of long-term investments Cash Flows from Financing Activities: Payment to retire bonds payable 14,000 Proceeds from issuance of bonds payable v 7,220 Payment of dividends 2,100 Investing and Financing Activities Not Affecting Cash: Exchange of equipment for land 2,700 2,700 Acquisition of land by exchanging equipment Issuance of common stock for patent 1,300 1,300 Acquisition of patent by issuing common stock Net increase in cash 820 Totals 65,420 Depreciation Expenses: Equipment 3,100 3,100 3,100 Patent Amortization Expense 1 815 815 815 interest Expense 1,715 1,715 1,715 Loss on Sale of Investments 200 2007 200 Interest Revenue 790 790 V 790 1,300 Gain on Exchange 1,300 1,300 Income Tax Expense 500 500 500 2,600 Extraordinary Loss (net) 2,600 2,600 2,100 2,100 Dividends Declared 2,100 Totals 156,900 156,900 203,905 203,905 67,235 67,2357 81,415 81,415 Worksheet Entries Debit Credit Cash Flows from Operating Activities: Collections from customers 49,550 7 315 790 Interest and dividends collected 295 24,030 Payments to suppliers Payments to employees 100 16,510 Buildings 8,000 68,700 8,000 60,700 Accumulated Depreciation: Buildings 2,700 3,200 7 35,000 34,500 500 Equipment 4,000 29,600 25,600 4,000 500 2,600 3,100 14,200 14,700 Accumulated Depreciation: Equipment Patents (net) 815 1,300 485 9,185 8,700 295 V 295 Accounts Payable 8,900 9,195 330 330 Interest Payable 630 300 100 2,500 2,600 100 Wages Payable 14,000 8,000 Bonds Payable 23,000 17,000 6,000 780 0 65 715 715 Discount on Bonds Payable 650 650 Common Stock, $10 par 22,000 22,650 650 650 15,970 15,320 Additional Paid-in Capital 35,350 35,850 Retained Earnings 49,550 49,550 49,550 Sales (net) 23,800 23,800 23,800 Cost of Goods Sold 16,510 16,510 16,510 Wages Expense 1,100 1,100 1,100 Other Operating Expenses 2,700 2,700 2,700 Depreciation Expenses: Buldings Check My Work 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, 2019. 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. 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. 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: Using the direct method for operating cash flows, prepare a spreadsheet to support a 2019 statement of cash flows. HEINZ COMPANY Cash Flows Worksheet For the Year Ended December 31, 2019 12/31/18 Post-Closing Trial Balance 12/31/19 Adjusted Trial Balance Change Worksheet Entries Debit Credit Debit Credit Debit Debit Account Titles Credit Credit 820 820 3,520 Cash 2,700 315 315 6,215 5,900 Accounts Receivable 230 230 Inventories 15,300 15,530 400 400 1,400 1,000 Prepaid Items 1,000 1,000 8,300 7,300 Investments (long-term) 2,700 2,700 16,300 19,000 Land 8,000 8,000 68,700 60,700 Buildings tor Interest Payable 630 300 Wages Payable 2,500 2,600 Bonds Payable 23,000 17,000 Discount on Bonds Payable 0 715 Common Stock, $10 par 22,000 22,650 Additional Paid-in Capital 15,320 15,970 Retained Earnings 35,350 35,350 $156,900 $156,900 Sales (net) 49,550 Cost of Goods Sold 23,800 16,510 Wages Expense Other Operating Expenses 1,100 2,700 Depreciation Expense: Buildings Depreciation Expense: Equipment 3,100 Patent Amortization 815 Interest Expense 1,715 Loss (Ordinary) on Sale of Investments 200 Interest Revenue 790 1,300 Gain (Ordinary) on Exchange of Assets Income Tax Expense Ordinary Loss on sale of building 500 2,600 Dividends Declared 2,100 Totals $203,905 $203,905 (Appendix 21.1) Complex Spreadsheet 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: Cash Accounts Receivable Inventories Prepaid Items Investments in Bonds (long-term) Land December 31, 2018 December 31, 2019 Post-Closing Trial Balance Adjusted Trial Balance $ 2,700 $ 3,520 5,900 6,215 15,300 15,530 1,400 1,000 8,300 7,300 16,300 19,000 68,700 60,700 $ 35,000 $ 34,500 29,600 25,600 14,200 14,700 8,700 9,185 8,900 630 300 2,500 2,600 23,000 17,000 0 715 22,000 22,650 Buildings 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 9,195 15,320 15,970 35,350 35,350