Please see prompt below. I need help with the consolidating entries and statement of cash flows. There are several other similar questions answered on this site but none of them show the calculations as to how to get to the answer. I tried attaching additional information and keep getting a message that file is too big. Please let me know how I can upload the rest of the information needed to answer the question. EDIT: I was able to take pictures of the assignment through the APP but they are posted as separate question.

Protecto Corporation purchased 80 percent of Strand Companys outstanding shares on January 1, 20X1, for $27,200 more than book value. At that date, the fair value of the noncontrolling interest was $16,800 more than 20 percent of Strands 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 $52,000 and later in the year sold it to Protecto for $74,000. Protecto is still holding the land as an investment. During 20X3, Protecto bonds with a value of $145,000 were exchanged for equipment valued at $145,000. On January 1, 20X3, Protecto held inventory purchased previously from Strand for $47,000. During 20X3, Protecto purchased an additional $100,000 of goods from Strand and held $55,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 $14,400, and on December 31, 20X3, it held goods it had purchased from Protecto for $6,900 during 20X3. Strands total purchases from Protecto in 20X3 were $32,000. Protecto sells inventory to Strand at cost plus a 50 percent markup. The consolidated balance sheet at December 31, 20X2, contained the following amounts:

The consolidated balance sheet at December 31, 20X2, contained the following amounts:

Debit

Cash $ 93,000

Accounts Receivable 155,000

Inventory 152,500

Land 74,000

Buildings and Equipment 440,000

Patents 33,000

Credit

Accumulated Depreciation $204,000

Accounts Payable 170,980

Bonds Payable 96,000

Noncontrolling Interest 40,520

Common Stock 160,000

Retained Earnings 276,000

Totals $947,500 $947,500

Thanks!

2 yo 120.000 43 PURECTO DOUTION AND STAY COMPANY December 2010 Canon DH Com 50000 DO DOOR 59-400 12.00 2000 16 2391 2.000 5.500 45220 162730 Cordwainer Nonwo SIS 1130 5136.409 5 216.00 5155.00 55 DE $15.00 S6400 $ 200 56.220 DOO Balance Sheet $ 29 000 85.000 124.000 5.00 4100 100 SG 300 126 136 Ivory 202.500 $11.00 2.300 27500 175,00 $ 27.800 17.500 7.520 22.000 4.800 22,000 83,000 Land Buildings and Equipment Lass: Accumulated Depreciation 79,000 416,000 (174,000) 21,600 225,000 (86,000) 78,600 578,000 (197,000) 0 S 884,700 63.000 $303 920 3 734,700 $120,420 Total Assets $ 330 500 Liabilities & Equity Accounts Payable Bonds Payable Common Stock Rotained Earnings NCI in NA of Strand $ 131,400 164.000, 180,000 279,220 $ 28,500 77,000 46,000 182.000 $ 159,980 241,000 160.000 279,220 44,500 $ 46,000 348,400 4,400 1,880 $400.680 $166,400 45,280 5,500 3217,180 S 884, 700 Total Liabilities & Equity S 734,700 3 333,500 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.) PROTECTORATION AND SOLARY Gesche Year Enter Contents De G 1103 12.31 1 5 DE 155.000 13 152.500 MC T4000 1204.0061 13 204 DOO 33.000 743500 1 5 Corrson each TOODE 6.000 165 g 20 TO,000 90.000 150 000 275.000 1 2.000 Os TOE.000 Charon Donald Amor Despre Order Purchase of und Audinys and proband Cash Prontong Dvd Paid Ta Proiecto Carpas Torres Din cat $ 05 Pra consided to chto 2013 Amounts to be deducted should be indicated with an 100% Pace, as income PROTECTO CORPORATION AND SUBSIDARY Candidedans of how Yaar Bed December 31, 203 Cathostro per Degeneng asus ar 0 Cash Flows from Asie Cash Rows from Francig Acties Dwide Pud 3 Canhance al beginning of yer Cash balance word of your 5 0 References Financial Statements Officulty 3 Hard Learning Objective: 10-01 Prepare a consolidated team of cash flows 2 yo 120.000 43 PURECTO DOUTION AND STAY COMPANY December 2010 Canon DH Com 50000 DO DOOR 59-400 12.00 2000 16 2391 2.000 5.500 45220 162730 Cordwainer Nonwo SIS 1130 5136.409 5 216.00 5155.00 55 DE $15.00 S6400 $ 200 56.220 DOO Balance Sheet $ 29 000 85.000 124.000 5.00 4100 100 SG 300 126 136 Ivory 202.500 $11.00 2.300 27500 175,00 $ 27.800 17.500 7.520 22.000 4.800 22,000 83,000 Land Buildings and Equipment Lass: Accumulated Depreciation 79,000 416,000 (174,000) 21,600 225,000 (86,000) 78,600 578,000 (197,000) 0 S 884,700 63.000 $303 920 3 734,700 $120,420 Total Assets $ 330 500 Liabilities & Equity Accounts Payable Bonds Payable Common Stock Rotained Earnings NCI in NA of Strand $ 131,400 164.000, 180,000 279,220 $ 28,500 77,000 46,000 182.000 $ 159,980 241,000 160.000 279,220 44,500 $ 46,000 348,400 4,400 1,880 $400.680 $166,400 45,280 5,500 3217,180 S 884, 700 Total Liabilities & Equity S 734,700 3 333,500 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.) PROTECTORATION AND SOLARY Gesche Year Enter Contents De G 1103 12.31 1 5 DE 155.000 13 152.500 MC T4000 1204.0061 13 204 DOO 33.000 743500 1 5 Corrson each TOODE 6.000 165 g 20 TO,000 90.000 150 000 275.000 1 2.000 Os TOE.000 Charon Donald Amor Despre Order Purchase of und Audinys and proband Cash Prontong Dvd Paid Ta Proiecto Carpas Torres Din cat $ 05 Pra consided to chto 2013 Amounts to be deducted should be indicated with an 100% Pace, as income PROTECTO CORPORATION AND SUBSIDARY Candidedans of how Yaar Bed December 31, 203 Cathostro per Degeneng asus ar 0 Cash Flows from Asie Cash Rows from Francig Acties Dwide Pud 3 Canhance al beginning of yer Cash balance word of your 5 0 References Financial Statements Officulty 3 Hard Learning Objective: 10-01 Prepare a consolidated team of cash flows