Feustel Company acquired 80% of Schmitt Company on January 1, 2016 for $1,500,000. The FV of the non-controlling interests at the acquisition date was 260,000. The book value of Schmitt's equity was $1,000,000 at the time. Feustel uses the equity method to account for its investment in Star. The excess investment cost over book value was allocated as follows: Building (10-year life) $150,000 Patent 7-year life) 112,000 Goodwill 498,000 Total $760,000 On December 31, 2017, Schmitt sold equipment to Feustel for $125,000. The equipment had a cost of 125,000 and accumulated depreciation of 75,000. The remaining life of the equipment was estimated at 5 years. Feustel regularly sells inventory to Schmitt. Schmitt includes that inventory in the products that it ultimately sells to customers outside of the consolidated group. The following table shows the inventory sales information for the years ending 2018 and 2019: 2018 2019 Transfer price for inventory sale $70,000 $100,000 Cost of goods sold (60.000) (70.000) Gross profit deferred $10,000 $30,000 EOY Receivable/Payable $45,000 $36,000 Any amounts unsold at the end of the year are sold in the following year. The following financial statements are reported at December 31, 2019: Income Statement Feustel Sales $4,160,000 Cost of goods sold (3.098.100 Gross Profit 1,061,900 Income (loss) from subsidiary 30,400 Operating expenses (711.200 Net income $ 381.100 Schmitt $401,600 (232.700) 168,900 (89.900 $ 79.000 Statement of Retained Earnings Feustel BOY Retained Earnings $3,010,720 Net income 381,100 Dividends (74.500 EOY Retained Earnings $3.317320 Schmitt $404,400 79,000 (8.900 $474.500 Balance Sheet Feustel Schmitt $ Assets: Cash Accounts receivable Inventory Equity Investment PPE, net 84,700 113,200 142,100 $ 212,020 433,600 641,900 1,167,600 4.063200 $6.518.320 800.500 S1.140.500 Liabilities and Stockholders' Equity: Current Liabilities Long-term Liabilities Common Stock APIC Retained Earnings $ 505,900 703,500 402.000 1,589,600 3.317.320 $6,518.320 $ 99,500 250,000 75,300 241,200 474,500 $1.140.500 a. How was the income from subsidiary calculated by Feustel Company? What is the income attributable to NCI and how was it calculated? b. Do a proof of the investment account and NCI account at 12/31/18 and 12/31/19.1 am looking for you to tell me what comprises the balance in these accounts (BV Sub Equity + ....). Note: You have all the information you would need to calculate both beginning and ending investment balances! Do not do a rollforward where you start with 12/31/18 and then put in current year activity to get the 12/31/19 balance. That is not what I mean by proof. c. Prepare the entries required under the equity method on Feustel's pre-consolidation books for 2019. d. Prepare the consolidation entries for 2019. Every CEADI entry is required to do this consolidation e. Prepare the consolidation spreadsheet. What is provided in the Excel document is the same as the information provided above. Add or delete rows if necessary to accommodate your solution/consolidation entries. Feustel Company acquired 80% of Schmitt Company on January 1, 2016 for $1,500,000. The FV of the non-controlling interests at the acquisition date was 260,000. The book value of Schmitt's equity was $1,000,000 at the time. Feustel uses the equity method to account for its investment in Star. The excess investment cost over book value was allocated as follows: Building (10-year life) $150,000 Patent 7-year life) 112,000 Goodwill 498,000 Total $760,000 On December 31, 2017, Schmitt sold equipment to Feustel for $125,000. The equipment had a cost of 125,000 and accumulated depreciation of 75,000. The remaining life of the equipment was estimated at 5 years. Feustel regularly sells inventory to Schmitt. Schmitt includes that inventory in the products that it ultimately sells to customers outside of the consolidated group. The following table shows the inventory sales information for the years ending 2018 and 2019: 2018 2019 Transfer price for inventory sale $70,000 $100,000 Cost of goods sold (60.000) (70.000) Gross profit deferred $10,000 $30,000 EOY Receivable/Payable $45,000 $36,000 Any amounts unsold at the end of the year are sold in the following year. The following financial statements are reported at December 31, 2019: Income Statement Feustel Sales $4,160,000 Cost of goods sold (3.098.100 Gross Profit 1,061,900 Income (loss) from subsidiary 30,400 Operating expenses (711.200 Net income $ 381.100 Schmitt $401,600 (232.700) 168,900 (89.900 $ 79.000 Statement of Retained Earnings Feustel BOY Retained Earnings $3,010,720 Net income 381,100 Dividends (74.500 EOY Retained Earnings $3.317320 Schmitt $404,400 79,000 (8.900 $474.500 Balance Sheet Feustel Schmitt $ Assets: Cash Accounts receivable Inventory Equity Investment PPE, net 84,700 113,200 142,100 $ 212,020 433,600 641,900 1,167,600 4.063200 $6.518.320 800.500 S1.140.500 Liabilities and Stockholders' Equity: Current Liabilities Long-term Liabilities Common Stock APIC Retained Earnings $ 505,900 703,500 402.000 1,589,600 3.317.320 $6,518.320 $ 99,500 250,000 75,300 241,200 474,500 $1.140.500 a. How was the income from subsidiary calculated by Feustel Company? What is the income attributable to NCI and how was it calculated? b. Do a proof of the investment account and NCI account at 12/31/18 and 12/31/19.1 am looking for you to tell me what comprises the balance in these accounts (BV Sub Equity + ....). Note: You have all the information you would need to calculate both beginning and ending investment balances! Do not do a rollforward where you start with 12/31/18 and then put in current year activity to get the 12/31/19 balance. That is not what I mean by proof. c. Prepare the entries required under the equity method on Feustel's pre-consolidation books for 2019. d. Prepare the consolidation entries for 2019. Every CEADI entry is required to do this consolidation e. Prepare the consolidation spreadsheet. What is provided in the Excel document is the same as the information provided above. Add or delete rows if necessary to accommodate your solution/consolidation entries