I have this Consolidations sheet If you could help me with it, it is in an advanced accounting.

I have max 24 hours to submit it.

On January 1, 2012, the Brown Bag Group obtained control of Cinco Quatro through an 80% stock purchase that had an associated FV of $12,120,000. The FV of the NCI was $2,530,0000. At acquistion, Cinco Quatro has common stock valued at 590,000, APIC of 2,635,000 and Retained Earnings of 3,945,000. At the time of acquisition, Land was undervalued by 750,000, Equipment was undervalued by 445,000 with a remaining life of 5 years, a Building was undervalued by 990,000 with a remaining life of 20 years and Long-term Liabilities were over-valued by 450,000 with a remaining life of 7 years. The remaining value was attributed to Goodwill Cinco Quatro sold inventroy to Brown Bag in 2012, 2013 and 2014 as follows: Transfer Price 2012 $ 150,000 $ 2013 $ 190,000 $ 2014 $ 225,000 $ Remaining at Cost Year-End 120,000 $ 45,000 140,000 $ 60,000 160,000 $ 75,000 As of 12/31/2014, Brown Bag still owed Cinco Quatro $50,000 for the purchase inventory On July 1, 2012 Brown Bag sold Cinco Quatro a Building with an original cost of $250,000 and accumulated depreciation of 100,000 for 190,000. The Building had a remaining useful life of 12 years On January 1, 2013, Cinco Quatro sold Brown Bag Land with a historical cost of 93,000 for 164,000. 1. Prepare the elimination entries for the consolidated financial statements as of 12/31/14. 2. Prepare the consolidation worksheet, with the required NCI information included. 3. Show all of your work 4. Modify the worksheet based on the following: Inventory was sold from Brown Bag to Cinco Quatro The financial statements for both companies at 12/31/14 are listed below: Brown Bag Cinco Quatro Sales Cost of Goods Sold Operating Expenses Income from Cinco Net income $ $ $ $ $ (20,000,000) 11,000,000 8,700,000 (120,000) (420,000) $ $ $ $ $ (12,000,000) 8,750,000 2,750,000 (500,000) Retained Earnings 1/1 Net Income Dividends Retained Earnings 12/31 $ $ $ $ (5,640,000) (420,000) 100,000 (5,960,000) $ $ $ $ (4,490,000) (500,000) 150,000 (4,840,000) Cash Accounts Receivable Inventory Other current assets Investment in Brown Bag Land Depreciable assets Accumulated depreciation Total Assets $ $ $ $ $ $ $ $ $ 1,550,000 1,250,000 4,000,000 3,000,000 12,120,000 1,500,000 6,000,000 (1,000,000) 28,420,000 $ $ $ $ 1,380,000 750,000 5,095,000 1,900,000 $ $ $ $ 1,500,000 4,500,000 (1,060,000) 14,065,000 Current Liabilities Long-term liabilities Common Stock Additional paid-in capital Retained earnings Total liabilities and equity $ $ $ $ $ $ (4,250,000) (5,790,000) (2,050,000) (10,370,000) (5,960,000) (28,420,000) $ $ $ $ $ $ (2,750,000) (3,250,000) (590,000) (2,635,000) (4,840,000) (14,065,000)