really is one part only. Tired of excuses

Protecto Corporation purchased 60 percent of Strand Company's outstanding shares on January 1, 20X1, for $40,500 more than book value. At that date, the fair value of the noncontrolling interest was $15,500 more than 40 percent of Strand's book value. The full amount of the differential is considered related to patents and is being amortized over an eight-year period. In 20X1, Strand purchased a piece of land for $64,000 and later in the year sold it to Protecto for $75,000. Protecto is still holding the land as an investment. During 20X3, Protecto bonds with a value of $175,000 were exchanged for equipment valued at $175,000. On January 1, 20X3, Protecto held inventory purchased previously from Strand for $50,000. During 20X3, Protecto purchased an additional $106,000 of goods from Strand and held $64,000 of this inventory on December 31, 20X3. Strand sells merchandise to the parent at cost plus a 25 percent markup. Strand also purchases inventory items from Protecto. On January 1, 20X3, Strand held inventory it had previously purchased from Protecto for $18,900, and on December 31, 20X3, it held goods it had purchased from Protecto for $8,400 during 20X3. Strand's total purchases from Protecto in 20X3 were $23,000. Protecto sells inventory to Strand at cost plus a 40 percent markup. The consolidated balance sheet at December 31, 20X2, contained the following amounts: Credit $ Debit 99,000 185,000 150,000 80,000 500,000 42,000 Cash Accounts Receivable Inventory Land Buildings and Equipment Patents Accumulated Depreciation Accounts Payable Bonds Payable Noncontrolling Interest Common Stock Retained Earnings Totals $ 210,000 137,200 94,000 112,800 220,000 282,000 $1,056,000 $1,056,000 Required: a. Prepare a worksheet for a consolidated statement of cash flows for 20X3 using the indirect method. (Values in the first two columns (the "parent" and "subsidiary" balances) that are to be deducted should be indicated with a minus sign, while all values in the "Consolidation Entries" columns should be entered as positive values. For accounts where multiple adjusting entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet.) Balance 12/31/X3 PROTECTO CORPORATION AND SUBSIDIARY Consolidated Cash Flow Worksheet Year Ended December 31, 20X3 Consolidation Entries Balance Item Debit Credit 1/1/X3 Assets Cash Accounts receivable Inventory Land Buildings and equipment Less: Accumulated depreciation Patents Total Assets Liabilities & Equity Accounts payable Bonds payable Common stock Retained earnings Noncontrolling interest Total Liabilities & Equity Cash Flows from Operating Activities: Consolidated net income Amortization expense Depreciation expense Decrease in accounts receivable Increase in inventory Decrease in accounts payable Cash Flows from Investing Activities: Purchase of land Acquisition of buildings and equipment from bond issue Purchase of buildings and equipment Cash Flows from Financing Activities: Dividends Paid: To Protecto Corp. shareholders To noncontrolling shareholders Issuance of bonds for buildings and equipment Decrease in cash Protecto Corporation purchased 60 percent of Strand Company's outstanding shares on January 1, 20X1, for $40,500 more than book value. At that date, the fair value of the noncontrolling interest was $15,500 more than 40 percent of Strand's book value. The full amount of the differential is considered related to patents and is being amortized over an eight-year period. In 20X1, Strand purchased a piece of land for $64,000 and later in the year sold it to Protecto for $75,000. Protecto is still holding the land as an investment. During 20X3, Protecto bonds with a value of $175,000 were exchanged for equipment valued at $175,000. On January 1, 20X3, Protecto held inventory purchased previously from Strand for $50,000. During 20X3, Protecto purchased an additional $106,000 of goods from Strand and held $64,000 of this inventory on December 31, 20X3. Strand sells merchandise to the parent at cost plus a 25 percent markup. Strand also purchases inventory items from Protecto. On January 1, 20X3, Strand held inventory it had previously purchased from Protecto for $18,900, and on December 31, 20X3, it held goods it had purchased from Protecto for $8,400 during 20X3. Strand's total purchases from Protecto in 20X3 were $23,000. Protecto sells inventory to Strand at cost plus a 40 percent markup. The consolidated balance sheet at December 31, 20X2, contained the following amounts: Credit $ Debit 99,000 185,000 150,000 80,000 500,000 42,000 Cash Accounts Receivable Inventory Land Buildings and Equipment Patents Accumulated Depreciation Accounts Payable Bonds Payable Noncontrolling Interest Common Stock Retained Earnings Totals $ 210,000 137,200 94,000 112,800 220,000 282,000 $1,056,000 $1,056,000 Required: a. Prepare a worksheet for a consolidated statement of cash flows for 20X3 using the indirect method. (Values in the first two columns (the "parent" and "subsidiary" balances) that are to be deducted should be indicated with a minus sign, while all values in the "Consolidation Entries" columns should be entered as positive values. For accounts where multiple adjusting entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet.) Balance 12/31/X3 PROTECTO CORPORATION AND SUBSIDIARY Consolidated Cash Flow Worksheet Year Ended December 31, 20X3 Consolidation Entries Balance Item Debit Credit 1/1/X3 Assets Cash Accounts receivable Inventory Land Buildings and equipment Less: Accumulated depreciation Patents Total Assets Liabilities & Equity Accounts payable Bonds payable Common stock Retained earnings Noncontrolling interest Total Liabilities & Equity Cash Flows from Operating Activities: Consolidated net income Amortization expense Depreciation expense Decrease in accounts receivable Increase in inventory Decrease in accounts payable Cash Flows from Investing Activities: Purchase of land Acquisition of buildings and equipment from bond issue Purchase of buildings and equipment Cash Flows from Financing Activities: Dividends Paid: To Protecto Corp. shareholders To noncontrolling shareholders Issuance of bonds for buildings and equipment Decrease in cash