The template for consolidation is provided.

Beast Corporation purchased 80% of Beauty Corporation on January 2, 2015, Beast paid $1,312,000 on that date and the remaining 2,000 NCI shares were valued at $164 per share. Below is Beauty's Balance Sheet as of the date of acquisition: Beauty Corporation Balance Sheet January 2, 2015 Assets Liabilities and Equity Accounts Receivable Inventory Land Buildings Accumulated Depreciation Equipment Accumulated Depreciation 295,200 164,000 196,800 28,000 56,915 328,000 8,685 32,800 (98,400)Paid-in capital in excess of par 295,200 328,000 Accounts Payable Bonds Payable Premium on bonds payable Common Stock ($1 par) 262,400 Retained Earnings 98 Total Assets Total Liabilities and Equity 1,049,600 Buildings, which have a 20-year life, are undervalued by $426,400. Equipment, which has a 5-year life, is undervalued by $164,000. Any remaining excess is considered to be goodwill. Beauty issued $328,000 of 8%, 10-year bonds for $339,257 on January 1, 2012, when the market rate was 7.5%, Annual interest is paid on December 31. Beast purchased the bonds for $313,286 on January 1, 2016, when the market rate was 9%. Both companies use the effective interest method to amortize the premium/discount on the bonds Beast uses the equity method to account for its investment in Beauty. On January 1, 2017, Beast held merchandise acquired from Beauty for $39,360. During 2017, Beauty sold $82,000 worth of merchandise to Beast. Beast held $32,800 of this merchandise at December 31, 2017. Beast owed Beauty $8,900 on December 31 a intercompany sales. Beauty has a gross profit rate of 25% sult of these Required ) Prepare all necessary schedules and calculations in preparation for a consolidation (i.e. excess and allocation schedule, depreciation schedule, goodwill allocation schedule