Prepare the corresponding consolidating worksheets based on the following facts

CONSOLIDATION WORKSHEET PROBLEM                  Prepare   the corresponding consolidating worksheets based on the following facts.              Companies   involved: Parent and Sub.       Date   of acquisition:  Jan. 1, 20X3       Date   of the worksheets you must prepare: December 31,  20X4          ” 20X5          ” 20X6     Percentage   of common shares of S owned by P   75%   Price   paid by P        $ 5,700,000               At   the time of acquisition these were some values concerning S:     Common   stock         $ 950,000    Aditional   paid-in capital       $ 950,000    Retained   earnings       $ 627,000        Years    FMV-BV   Inventories   <1     $ 760,000    Other   current assets  <1     $ 285,000    Plant   & equipment, remaining life:  8      $ 1,900,000    Land         $ 1,330,000    Long   term liabilities; remaining life: 5     $ 285,000    Intangibles   amortization:   6                  Intercompany   transactions:             20X3 20X4 20X5 20X6   Upstream inventory sales          –   $ 142,500   $ 121,125   $ 129,604    % in ending   inventory          –  7.50% 9.00% 10.80%   Gross profit   rate on sales          –  37.50% 45.00% 54.00%                       Upstream   building sale, Dec. 31                   Sold for             $ 1,900,000        Book value at   time of sale            $ 760,000        Remaining   life:        10                                % of S bonds   purchased by P, Jan. 1             55%     Price paid              $ 1,551,104      BV at that   date              $ 1,534,930      Remaining   life:       5           Maturity value   of acquired bonds              $ 1,567,500
=============
Required:
1. Complete the worksheets for 20X4-6.
2. Show how the Controlling and   Non-controlling shares of Income from S were arrived at in X5 and X6.
3. In separate schedules for year ends X5 and   X6, reconcile the Investment account with S’s stockholders’ equity.
4.   In separate schedules for year ends X5 and X6, reconcile the ending   Noncontrolling Interest with S’s stockholders’equity.     .