How do I complete the below worksheets for 20x4-20x6 based on the data from the consolidated worksheet in 20x3?Above is all the relevant information.

CONSOLIDATION WORKSHEET PROBLEM Prepare the corresponding consolidating worksheets based on the following facts Companies involved: Parent and Sub Date of acquisition Date of the worksheets you must prepare: December 31 Jan. 1, 20X3 20X4 20X5 20X6 80% $ 1,800,000 Percentage of common shares of S owned bV P Price paid by P At the time of acquisition these were some values concerning S Common stock Aditional paid-in capital Retained earnings $ 300,000 $ 300,000 $ 198,000 FMV-BY $ 240,000 $ 90,000 $ 600,000 Years Inventories Other current assets Plant & equipment, remaining lire Land Long term liabilities, remaining life Intangibles amortization: 420,000 $ 90,000 10 10 Intercompany transactions 20X3 20X4 20X5 20X6 Upstream inventory sales % in ending inventory Gross profit rate on sales S 45,000 S38 250 S 40928 11.52% 57.60% 8.00% 40.00% 9.60% 48.00% Upstream building sale, Dec. 31 Sold for Book value at time of sale Remaining life $ 600,000 216,000 10 % of S bonds purchased by P. Jan. 1 Price paid BV at that date Remaining life Maturity value of acquired bonds 30% $ 272,768 S 278 415 5 $ 270,000 CONSOLIDATION WORKSHEET PROBLEM Prepare the corresponding consolidating worksheets based on the following facts Companies involved: Parent and Sub Date of acquisition Date of the worksheets you must prepare: December 31 Jan. 1, 20X3 20X4 20X5 20X6 80% $ 1,800,000 Percentage of common shares of S owned bV P Price paid by P At the time of acquisition these were some values concerning S Common stock Aditional paid-in capital Retained earnings $ 300,000 $ 300,000 $ 198,000 FMV-BY $ 240,000 $ 90,000 $ 600,000 Years Inventories Other current assets Plant & equipment, remaining lire Land Long term liabilities, remaining life Intangibles amortization: 420,000 $ 90,000 10 10 Intercompany transactions 20X3 20X4 20X5 20X6 Upstream inventory sales % in ending inventory Gross profit rate on sales S 45,000 S38 250 S 40928 11.52% 57.60% 8.00% 40.00% 9.60% 48.00% Upstream building sale, Dec. 31 Sold for Book value at time of sale Remaining life $ 600,000 216,000 10 % of S bonds purchased by P. Jan. 1 Price paid BV at that date Remaining life Maturity value of acquired bonds 30% $ 272,768 S 278 415 5 $ 270,000