Can you all show a very, very detailed step by step work as what was done to calculate and get the dollar amounts, which appear on the Consolidated Entries area of the Consolidation Worksheet, please? Can you type and/or write all the information in way in which I can actually read and understand the information, please?

Protecto Corporation purchased 80 percent of Strand Company's outstanding shares on January 1, 20x1, for $44.800 more than book value. At that date, the fair value of the noncontrolling interest was $11.200 more than 20 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 $40,000 and later in the year sold it to Protecto for $55,000. Protecto is still holding the land as an investment. During 20X3. Protecto bonds with a value of $115,000 were exchanged for equipment valued at $115.000. On January 1, 20X3, Protecto held inventory purchased previously from Strand for $42,500. During 20X3, Protecto purchased an additional $95.000 of goods from Strand and held $48,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 $15,750, and on December 31, 20X3, it held goods it had purchased from Protecto for $9.800 during 20X3. Strand's total purchases from Protecto in 2003 were $26,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 $ 96,000 150,000 130,000 73,000 450,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 $ 213,000 174,300 95,000 48,700 130,000 280,000 $941,000 $941,000 The consolidation worksheet below was prepared on December 31, 20X3. All consolidation entries and adjustments have been entered properly in the worksheet. Protecto accounts for its investment in Strand using the fully adjusted equity method. PROTECTO CORPORATION AND STRAND COMPANY Consolidation Worksheet December 31, 20x3 Consolidation Entries Protecto Corporation DR CR Consolidated Income Statement Sales Less: Cost of Goods sold Strand Company $ 250,000 (150,000) $ 430,000 (310,000) $ 559,000 $ 95,000 26,000 (338,400) $ 8,500 85,400 4,500 23, 200 (27,500) (33,000) 33,220 $ 92,720 (17,500) (35,000) 7 7,000 (45,000) (7,600 (68,000) $ 47,500 Less: Depreciation Expense Less: Amortization Expense Less: Other Expense Income from Strand Co. Consolidated Net Income NCI in Net Income of Strand Controlling Interest in Net Income Statement of Retained Earnings Beginning Balance Net Income Less: Dividends Declared Ending Balance 38,820 $166,820 9,280 $176,100 5,600 $127,200 1,400 $128,600 $ 100,600 (7.880) $ 92,720 $ 92,720 $ 47,500 $ 280,000 92,720 (55,000) $ 317,720 $170,000 176,100 $ 170,000 47,500 (22,000) $ 195,500 $128,680 22,000 $150, 680 $ 280,000 92,720 (55, eee) $317.720 5346,100 Balance Sheet Assets Cash Accounts Receivable Inventory Patent Investment in Subsidiary $ 27,500 80,600 120,300 $ 36,500 40,600 90,500 $ 64,000 121,200 198,400 $ 9,600 2,800 35,000 205,920 $ 35,000 12,000 6,800 4,500 201,220 28,000 Land Buildings and Equipment Less: Accumulated Depreciation 73,800 370,000 (168,000) 20,500 240,000 (90,000) 15,000 72,500 72,500 78,500 537,500 (185,500) 8 $ 849,100 Total Assets $ 789,320 $ 338,100 $130,800 $329,120 Liabilities & Equity Accounts Payable Bonds Payable Common Stock Retained Earnings NCI in NA of Strand $ 123,600 138,000 130,000 317, 720 $ 15,600 72,000 55,000 195,500 $ 55,000 346,100 3,000 1,700 $405,800 $ 139,200 210,000 130,000 317, 720 52,180 $150,680 49,880 7,000 $207,480 Total Liabilities & Equity $ 709, 320 $ 338,100 $ 849,100 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.) Answer is complete and correct. PROTECTO CORPORATION AND SUBSIDIARY Consolidated Cash Flow Worksheet Year Ended December 31, 20X3 Consolidation Entries Balance Debit 1/1/X3 Credit Item Balance 12/31/X3 $ 32,000 28.800 $ 96,000 150,000 130,000 73,000 450,000 (213.000) 42,000 $728.000 68,400 5,500 160,000 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 $ 64,000 121,200 198,400 78,500 610,000 (258,000) 35,000 $ 849,100 45.000 7,000 35.100 115,000 174,300 95,000 130,000 280,000 48,700 $ 728,000 139,200 210,000 130,000 317,720 52,180 $ 849,100 55,000 4.400 $ 328,400 92,720 7,880 $ 328,400 S 100,600 7,000 45,000 28,800 68.400 35,100 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 5,500 115,000 45,000 55.000 4,400 115,000 32,000 $ 328,400 $ 328,400