On January 1, 2016, Pichai Corporation acquired 80 percent of the outstanding voting stock of Sundar Company in exchange for $1,200,000 cash. At that time, although Sundar’s book value was $925,000, Pichai assessed Sundar’s total fair value at $1,500,000.
The book values of Sundar’s individual assets and liabilities approximated their acquisition date fair values except for the Patent account, which was undervalued by $350,000. The undervalued Patents had a five-year remaining useful life at the acquisition date. Any remaining excess fair value was attributed to Goodwill.
Sundar regularly sells inventory to Pichai. Below are details of the intra-entity inventory sales for the past three years:
| Year | Intra-Entity Sales | Intra-Entity Ending Inventory at Transfer Price | Gross Profit Rate on Intra-Entity Inventory Transfers |
| 2016 | $125,000 | $80,000 | 25% |
| 2017 | $220,000 | $125,000 | 28% |
| 2018 | $300,000 | $160,000 | 25% |
Separate financial statements for these two companies as of December 31, 2018 follow: (to be consistent with the book, credit balances are in parentheses):
| Income Statement | Pichai | Sundar |
| Revenues | ($1,740,000) | ($950,000) |
| Cost of Goods Sold | 820,000 | 500,000 |
| Depreciation Expense | 104,000 | 85,000 |
| Amortization Expense | 220,000 | 120,000 |
| Interest Expense | 20,000 | 15,000 |
| Equity in Earnings of Sundar | ($124,000) | 0 |
| Net Income | ($700,000) | ($230,000) |
| Statement of Retained Earnings | ||
| Retained Earnings, 1/1/2018 | ($2,800,000) | ($345,000) |
| Net Income (above) | ($700,000) | ($230,000) |
| Dividends Declared | 200,000 | 25,000 |
| Retained Earnings (12/31/2018) | ($3,300,000) | ($550,000) |
| Balance Sheet | ||
| Cash | 535,000 | 115,000 |
| Accounts Receivable | 575,000 | 215,000 |
| Inventory | 990,000 | 800,000 |
| Investment in Sundar | 1,420,000 | 0 |
| Buildings and Equipment (net) | 1,025,000 | 863,000 |
| Patents | 950,000 | 107,000 |
| Total Assets | 5,495,000 | 2,100,000 |
| Accounts Payable | ($450,000) | ($200,000) |
| Notes Payable | ($545,000) | ($450,000) |
| Common Stock | ($900,000) | ($800,000) |
| Additional Paid-in Capital | ($300,000) | ($100,000) |
| Retained Earnings (12/31/2018) | ($3,300,000) | ($550,000) |
| Total Liabilities and Equity | ($5,495,000) | ($2,100,000) |
Questions
Part A (use a separate tab in the Excel spreadsheet for this section and label it as Part A)
Make sure the A1 cell in this tab has your full name.
- Calculate the total Goodwill of Sundar Company and allocate it between the Controlling Interest and the Non-Controlling Interest.
- Calculate the balance in Investment in Sundar account on 12/31/2017.
- Prepare the Equity Method journal entries for 2018.
- Based on your answer in (2), and the Equity Method journal entries in (3), prepare the T-account for Investment in Sundar and calculate the balance in this account on 12/31/2018. Your answer should match the number shown on Pichai Company’s Balance Sheet ($1,420,000)
- Based on the Equity Method journal entries in (3) above, calculate the balance in Equity in Earnings of Sundar. You answer should match what is shown in the Income Statement of Pichai Company ($124,000)
- Calculate the Net Income Attributable to Noncontrolling Interest for 2018. You need this number to do the worksheet in Part B.
- Calculate the balance in Non-Controlling Interest on 12/312018.
Part B: (do this section in a separate tab and label it as Part B).
Using Excel, prepare a worksheet to consolidate the separate financial statements of Pichai and Sundar. The worksheet should be in proper format and all consolidation journal entries should be labelled properly in the worksheet (*G, TI, G, S, A, I, D, E). You can use Exhibit 5.4 or Exhibit 5.5 in the text as a guide.
After completing the worksheet, make sure the balance in Investment in Sundar account is equal to zero in the Consolidated Balance Sheet. Program the Investment in Sundar cell in the Consolidated Balance Sheet (last column) so that it keeps a running total of the balance in that account as you are doing the worksheet journal entries. After you have completed all the worksheet journal entries, the cell should show a value of zero, if you did everything correctly. If it does not show zero, go back and check where you made a mistake.
Also, after you have completed the worksheet, the balance in the Non-Controlling Interest account shown on the Consolidated Balance Sheet should match the answer you got in Part A, # 7.