Sun Corporation was created on January 1,20X2, and quickly became successful. On January 1,20X6, its owner sold 80 percent of the stock to Planet Company at underlying book value. At the date of that sale, the fair value of the remaining shares was equal to 20 percent of the book value of Sun. Planet continued to operate the subsidiary as a separate legal entity and used the equity method in accounting for its investment in Sun. The following consolidated financial statements have been prepared: \begin{tabular}{|c|c|c|c|c|} \hline Cash & $54,000 & $21,000 & & 75,000 \\ \hline Accounts receivable & 121,0000 & & 10,000 & 111,000 \\ \hline Inventory & 230,000 & 130,000 & & 360,000 \\ \hline Land & 95,000 & 5,000 & & 100,000 \\ \hline Buildings and equipment & 800,000 & & 150,000 & 650,000 \\ \hline Less: Accumulated depreciation & 29,000 & 100,0000 & & 129,000 \\ \hline Total Assets & $1,329,000 & & & $1,425,000 \\ \hline \multicolumn{5}{|l|}{ Liabilities and Equity } \\ \hline Accounts payable & $90,000 & & $15,000 & $105,000 \\ \hline Bonds payable & 90,000 & 50,000 & 4 & 40,000 \\ \hline Common stock & 300,000 & & & 300,000 \\ \hline Retained earnings & 290,000 & 65,000 & 148,000 & 373,000 \\ \hline Noncontrolling interest & 30,000 & 4,000 & 12,000 & 38,000 \\ \hline Total Liabilities and Equity & $800,000 & $375,000 & $335,000 & $856,000 \\ \hline \multicolumn{5}{|l|}{ Cash Flows from Operating Activities: } \\ \hline Consolidated net income & & $150,000 & & \\ \hline Depreciation expense & & 40,000 & & \\ \hline Gain on sale of equipment & & & 30,000 & \\ \hline Decrease in accounts receivable & & 80,000 & & \\ \hline Increase in inventory & & & 130,000 & \\ \hline Increase in accounts payable & & 15,000 & & \\ \hline \multicolumn{5}{|l|}{ Cash Flows from Investing Activities: } \\ \hline Sale of buildings and equipment & & & & \\ \hline Purchase of land & & & & \\ \hline \multicolumn{5}{|l|}{ Cash Flows from Financing Activities: } \\ \hline Bond retirement & & & 50,000 & \\ \hline nividende Daid. & & & & \\ \hline \end{tabular} During 206, Sun reported net income of $60,000 and paid dividends of $20,000; Planet reported net income of $148,000 and paid dividends of $65,000. There were no intercompany transfers during the period. Required: Prepare a worksheet for a consolidated statement of cash flows for 206 using the indirect method of computing cash fiows from operations. Note: 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
