Please answer all questions on a Microsoft Excel spreadsheet ONLY and show calculations.

Prepare the corresponding consolidating worksheets based on the following facts. 75% $ 5,700,000 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 Price paid by P At the time of acquisition these were some values concerning S: Common stock Aditional paid-in capital Retained earnings Years Inventories Other current assets Plant & equipment, remaining life: Land Long term liabilities, remaining life: 5 Intangibles amortization: $ 950,000 $ 950,000 $ 627,000 FMV-BV $ 760,000 $ 285,000 $ 1,900,000 $ 1,330,000 $ 285,000 st 8 6 Intercompany transactions: 20X3 $ Upstream inventory sales % in ending inventory Gross profit rate on sales. 20X4 142,500 $ 7.50% 37.50%; 20X5 121,125 $ 9.00% 45.00%; 20X6 129,604 10.80% 54.00%; Upstream building sale, Dec. 31 Sold for Book value at time of sale Remaining life: $ 1,900,000 760,000 10 % of S bonds purchased by P, Jan. Price paid BV at that date Remaining life: Maturity value of acquired bonds 55% $ 1,551,104 $ 1,534,930 $ 1,567,500 Required: 1. Complete the worksheets for 20X4-6 Reconciliation: Investment to S's Equity 20X3 5,607,683 Investment, 12/31 Removal of unamortized differential: Initial (570,000) (213,750) (1,425,000) (997,500) (213,750) (384,750) Amortiz. 570,000 213,750 178,125 Inventories Other current assets Plant & equipment Land L. T. liabilities Intangibles Unamortized differential 42,750 64,125 (1,246,875) (997,500) (171,000) (320,625) (2,736,000 2,871,683 S's stockholders' equity P's ownership interest Difference 3,828,911 75% 2,871,683 Reconciliation: Non-contr. Interest to S's Equity: 957,228 S's stockholders' equity X Non-contr. interest percentage Unrealized intercompany balances in RE-S Non-contr. interest balance at year end Unamortized differential Excess Difference 1,869,228 (912,000) 957,228 957,228 Issuer's Facts: Face value Stated Rate Effective Rate Interest Pmts. Bonds Life 2,850,000 6.00% 6.50% 171,000 10 Acquirer's Facts: Acquired Jan. % acquired Face value Stated Rate Effective Rate Interest Pmts. Bonds Life 20X5 55% 1,567,500 6.002 6.25% 94,050 5 At issuance: PV of Principal PV of Interest Bond price $1,518,269 $1,229,290 $2,747,559 At bond purchase PV of Principal PV of Interest Bond price $1,157,612 $393,493 $1,551,104 Issuing Company 6.50%. Payment Interest Exp. Purchasing Company 6.25% Collections Interest Rev. Date 1/1/20XO 12/31/X0 12/31/X1 12/31/X2 12/31/X3 12/31/X4 12/31/35 12/31/X6 12/31/X7 12/31/X8 12/31/X9 171,000 171,000 171,000 171,000 171,000 171,000 171,000 171,000 171,000 171,000 178,591 179,085 179,610 180,170 180,766 181,401 182,077 182,797 183,564 184,380 Carrying Value $2,747,559 2.755,151 2,763,235 2,771,846 2,781,016 2,790,782 2,801,182 2,812,259 2,824,056 2,836,620 2,850,000 Date 1/1985 12/31/35 12/31/X6 12/31/X7 12/31/X8 12/31/X9 94,050 94,050 94,050 94,050 94,050 96,944 97,125 97,317 97,521 97,738 Carrying Value $1,551,104 1,553,998 1,557,073 1,560,340 1,563,812 1,567,500 Parent Subsidiary Adjusts, and Elims. Cons. 8,075,000 27,882,500 hrome tamenn Sales Income from S Cost of goods sold Operating expenses Interest Expense Gain on building sale Non-contr. interest income Net income 19,950,000 1,211,607 (13,965,000) (2.992,500) (142,500) (1,211,607) 142,500 (4,683,500) (1,211,250) (180,766) 1,140,000 (18,506,000) (4,203,750) (180,766) (1,140,000) (957,228) (957,228) 4,034,756 4,204,107 3,139,484 8,561,589 8,561,589 (1,928,911) AstavEawings Retained earnings--P, 1/1/X4 Retained earnings--S, 1/1/X4 Net income Dividends Retaind earnings--12/31/X4 4,204,107 (1,996,951) 10,768,746 1,928,911 3,139,484 (1,491,255) 3,577,140 1,491,255 7,343,591 (1,996,951) 13,908,230 1,496,250 1.995,000 2,194,500 8,126,647 5,700,849 4,750,000 100,000 457,809 1,098,741 1,007,179 915,617 Balance Test Cash Accounts receivable Inventories Other current assets Investment in S Plant and equipment--net Land Intangibles Total assets 1,954,059 3,093,741 2,631,679 7,902,264 3,479,345 2,197,481 (570,000) (1,140,000) (5,700,849) 1,662,500 1,330,000 (272,563) 9,891,845 3,627,481 (272,563) 28,828,505 24,363,246 9,156,171 1.995,000 199,500 (171,000) Accounts payable Notes Payable Bonds Payable, 10% Capital stock Additional paid in capital Retained earnings Non-contr. interest, 12/31/X4 Total liabilities and equity 807,500 80,750 2,790,782 950,000 950,000 3,577,140 9,500,000 1,900,000 10,768,746 (950,000) (950,000) (3,577,140) 957,228 2,802,500 109,250 2,790,782 9,500,000 1,900,000 10,768,746 957,228 28,828,505 24,363,246 9,156,171 Proofs of balance 0 0 Prepare the corresponding consolidating worksheets based on the following facts. 75% $ 5,700,000 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 Price paid by P At the time of acquisition these were some values concerning S: Common stock Aditional paid-in capital Retained earnings Years Inventories Other current assets Plant & equipment, remaining life: Land Long term liabilities, remaining life: 5 Intangibles amortization: $ 950,000 $ 950,000 $ 627,000 FMV-BV $ 760,000 $ 285,000 $ 1,900,000 $ 1,330,000 $ 285,000 st 8 6 Intercompany transactions: 20X3 $ Upstream inventory sales % in ending inventory Gross profit rate on sales. 20X4 142,500 $ 7.50% 37.50%; 20X5 121,125 $ 9.00% 45.00%; 20X6 129,604 10.80% 54.00%; Upstream building sale, Dec. 31 Sold for Book value at time of sale Remaining life: $ 1,900,000 760,000 10 % of S bonds purchased by P, Jan. Price paid BV at that date Remaining life: Maturity value of acquired bonds 55% $ 1,551,104 $ 1,534,930 $ 1,567,500 Required: 1. Complete the worksheets for 20X4-6 Reconciliation: Investment to S's Equity 20X3 5,607,683 Investment, 12/31 Removal of unamortized differential: Initial (570,000) (213,750) (1,425,000) (997,500) (213,750) (384,750) Amortiz. 570,000 213,750 178,125 Inventories Other current assets Plant & equipment Land L. T. liabilities Intangibles Unamortized differential 42,750 64,125 (1,246,875) (997,500) (171,000) (320,625) (2,736,000 2,871,683 S's stockholders' equity P's ownership interest Difference 3,828,911 75% 2,871,683 Reconciliation: Non-contr. Interest to S's Equity: 957,228 S's stockholders' equity X Non-contr. interest percentage Unrealized intercompany balances in RE-S Non-contr. interest balance at year end Unamortized differential Excess Difference 1,869,228 (912,000) 957,228 957,228 Issuer's Facts: Face value Stated Rate Effective Rate Interest Pmts. Bonds Life 2,850,000 6.00% 6.50% 171,000 10 Acquirer's Facts: Acquired Jan. % acquired Face value Stated Rate Effective Rate Interest Pmts. Bonds Life 20X5 55% 1,567,500 6.002 6.25% 94,050 5 At issuance: PV of Principal PV of Interest Bond price $1,518,269 $1,229,290 $2,747,559 At bond purchase PV of Principal PV of Interest Bond price $1,157,612 $393,493 $1,551,104 Issuing Company 6.50%. Payment Interest Exp. Purchasing Company 6.25% Collections Interest Rev. Date 1/1/20XO 12/31/X0 12/31/X1 12/31/X2 12/31/X3 12/31/X4 12/31/35 12/31/X6 12/31/X7 12/31/X8 12/31/X9 171,000 171,000 171,000 171,000 171,000 171,000 171,000 171,000 171,000 171,000 178,591 179,085 179,610 180,170 180,766 181,401 182,077 182,797 183,564 184,380 Carrying Value $2,747,559 2.755,151 2,763,235 2,771,846 2,781,016 2,790,782 2,801,182 2,812,259 2,824,056 2,836,620 2,850,000 Date 1/1985 12/31/35 12/31/X6 12/31/X7 12/31/X8 12/31/X9 94,050 94,050 94,050 94,050 94,050 96,944 97,125 97,317 97,521 97,738 Carrying Value $1,551,104 1,553,998 1,557,073 1,560,340 1,563,812 1,567,500 Parent Subsidiary Adjusts, and Elims. Cons. 8,075,000 27,882,500 hrome tamenn Sales Income from S Cost of goods sold Operating expenses Interest Expense Gain on building sale Non-contr. interest income Net income 19,950,000 1,211,607 (13,965,000) (2.992,500) (142,500) (1,211,607) 142,500 (4,683,500) (1,211,250) (180,766) 1,140,000 (18,506,000) (4,203,750) (180,766) (1,140,000) (957,228) (957,228) 4,034,756 4,204,107 3,139,484 8,561,589 8,561,589 (1,928,911) AstavEawings Retained earnings--P, 1/1/X4 Retained earnings--S, 1/1/X4 Net income Dividends Retaind earnings--12/31/X4 4,204,107 (1,996,951) 10,768,746 1,928,911 3,139,484 (1,491,255) 3,577,140 1,491,255 7,343,591 (1,996,951) 13,908,230 1,496,250 1.995,000 2,194,500 8,126,647 5,700,849 4,750,000 100,000 457,809 1,098,741 1,007,179 915,617 Balance Test Cash Accounts receivable Inventories Other current assets Investment in S Plant and equipment--net Land Intangibles Total assets 1,954,059 3,093,741 2,631,679 7,902,264 3,479,345 2,197,481 (570,000) (1,140,000) (5,700,849) 1,662,500 1,330,000 (272,563) 9,891,845 3,627,481 (272,563) 28,828,505 24,363,246 9,156,171 1.995,000 199,500 (171,000) Accounts payable Notes Payable Bonds Payable, 10% Capital stock Additional paid in capital Retained earnings Non-contr. interest, 12/31/X4 Total liabilities and equity 807,500 80,750 2,790,782 950,000 950,000 3,577,140 9,500,000 1,900,000 10,768,746 (950,000) (950,000) (3,577,140) 957,228 2,802,500 109,250 2,790,782 9,500,000 1,900,000 10,768,746 957,228 28,828,505 24,363,246 9,156,171 Proofs of balance 0 0