Consolidated Worksheet:
Consolidated worksheet is a tool used to prepare consolidated financial statement of a parent company and its subsidiaries. It shows the individual book values of both companies, the necessary adjustment and eliminations and the final consolidated values.
:Preparation of Consolidated worksheet.
Answer to Problem 11.3P
Combined net income is equal to -7,919,550.
Explanation of Solution
Following is thepreparation of consolidated worksheet.
Consolidated Worksheet
S Company
Trail balance translation-December 31, 2018
Account | Balance (FC) | Relevant Exchange rate (in $) | Balance ($) |
Cash | 2,840,000 | 1.31 | 3,720,000 |
3,990,000 | 1.31 | 5,226,900 | |
Inventory | 5,800,000 | 1.31 | 7,598,000 |
Fixed Assets | 15,000,000 | 1.31 | 19,650,000 |
(6,800,000) | 1.31 | (8,908,000) | |
Account Payable | (1,580,000) | 1.31 | (2,069,800) |
Long-term debt | (5,000,000) | 1.31 | (6,550,000) |
Common Stock | (3,000,000) | 1.20 | (3,600,000) |
Paid-in capital in excess of par | (2,000,000) | 1.20 | (2,400,000) |
(7,950,000) | (refer note: 1) | (9,880,000) | |
Sales | (10,000,000) | 1.33 | (13,300,000) |
Cost of goods sold | 7,500,000 | 1.33 | 9,975,000 |
Operating expenses | 1,200,000 | 1.33 | 1,596,000 |
Cumulative translation adjustment | (1,058,500) | ||
Total | 0 | 0 |
Note: 1
Calculation of retained earnings balance:
Particulars | Amount (in $) |
Balance as on January 1, 2016 | 5,040,000 |
Income − 2016 | 2,240,000 |
Income − 2017 | 2,600,000 |
Total | 9880,000 |
Following is the P’s & S’s corporation consolidated financial statement:
P’s & S’s corporation consolidated financial statement
For the year ended December 31, 2018
Particulars | Trail Balance | Elimination and Adjustment | Consolidated Income statement (in $) | Consolidated Balance Sheet (in $) | ||
P(in $) | S(in $) | Dr. (in $) | Cr. (in $) | |||
Cash | 4,050,000 | 3,720,000 | 7,770,400 | |||
Account Receivable | 5,270,000 | 5,226,900 | 10,496,000 | |||
Inventory | 5,540,000 | 7,598,000 | 13,138,000 | |||
Investment in S | 20,969,000 | 1,729,000 (refer note A) | ||||
15,880,000 (refer note B) | ||||||
3,360,000 (refer note C) | ||||||
Fixed assets | 21,000,000 | 19,650,000 | 655,000 (refer note C) | 41,305,000 | ||
Accumulated Depreciation | -12,560,000 | -8,908,000 | 196,500 (refer note D) | -21,664,500 | ||
Additional Equipment | 3,013,000 (refer note C) | 451,950 (refer note D) | 2,561,050 | |||
Account Payable | -3,450,000 | -2,069,800 | -5,519,800 | |||
long-term Debt | -10,000,000 | -6,550,000 | -16,550,000 | |||
Common stock- Parent Company | -4,000,000 | -4,000,000 | ||||
Common Stock- Subsidiary company | -3,600,000 | 3,600,000 (refer note B) | ||||
Paid-in capital in excess of par- Parent | -6,500,000 | -6,500,000 | ||||
Paid-in capital in excess of par- Subsidiary | -2,400,000 | 2,400,000 (refer note B) | ||||
Retained Earnings Jan 1, 2018- Parent | -12,180,000 | 425,700 (refer note D) | -11,754,300 | |||
Retained Earnings Jan 1, 2018- Subsidiary | -9,880,000 | 9,880,000 (refer note B) | ||||
Sales | -26,000,000 | -13,300,000 | -39,300,000 | |||
Cost of goods sold | 16,380,000 | 9,975,000 | 26,355,000 | |||
Operating Expense | 3,210,000 | 1,596,000 | 219,450 (refer note D) | 5,025,450 | ||
Subsidiary Income | -1,729,000 | 1,729,000 (refer note A) | ||||
Cumulative translation adjustment | -1,058,500 | 3,300 (refer note D) | 308,000 (refer note C) | -1,363,200 | ||
Total | 0 | 0 | 21,925,450 | 21,925,450 | ||
Combined Net Income | -7,919,550 | -7,919,550 |
Elimination and adjustment:
Note: A
Subsidiary income account ($1,729,000) should be eliminated against the investment account.
Note: B Eliminate the equity balance of the subsidiary on January 1, 2018, against the investment account.
Note: C Distribution of Excess of cost over book value:
Particulars | Amount in FC |
Cost to acquire subsidiary | 12,000,000 |
Book Value of Subsidiary | 9,200,000 |
Excess of cost over book value | 2,800,000 |
Less: Adjustment to equipment | 500,000 |
Additional Equipment | 2,300,000 |
Cumulative translation adjustment:
Particulars | Amount in $ |
Excess of cost over book value in dollars: | |
January 1, 2016 | 3,360,000 |
December 31, 2018: | |
Equipment | 655,000 |
Additional Equipment < | 3,013,000 |
Cumulative translation adjustment | 308,000 |
Note: D Record Excess Appropriate Depreciation:
Particulars | Amount (in $) |
Excess annual depreciation: | |
Equipment | 50,000 |
Additional Equipment | 115,000 |
Total | 165,000 |
Particulars | Amount (in $) |
Accumulated Depreciation in dollars: | |
December 31,2018: | |
Equipment | 196,500 |
Additional Equipment | 451,950 |
Total | 648,450 |
Particulars | Amount (in $) |
Current-year depreciation at December 31, 2018, in dollars: | 219,450 |
Prior year- Depreciation expense in dollars: | |
2016 - | 211,200 |
2017 - | 214,500 |
Total | 425,700 |
Calculation of Cumulative translation adjustment:
Hence, cumulative translation adjustment is $3,300.
Want to see more full solutions like this?
Chapter 11 Solutions
ADVANCED ACCOUNTING CHAPTERS 15-19
- On May 1, 2015, Zoe Inc. purchased Branta Corp. for $15,000,000 in cash. They only received $12,000,000 in net assets. In 2016, the market value of the goodwill obtained from Branta Corp. was valued at $4,000,000, but in 2017 it dropped to $2,000,000. Prepare the journal entry for the creation of goodwill and the entry to record any impairments to it in subsequent years.arrow_forwardOn August 27, 2015, Celgene Corporation acquired all of the outstanding stock of Receptos, Inc., in exchange for $7.6 billion in cash. Referring to Celgene's 2015 financial statements and its July 14, 2015, press release announcing the acquisition, answer the following questions regarding the Receptos acquisition. How will Celgene account for the in-process research and development product rights acquired in the Receptos combination?arrow_forwardDontelli Enterprises began operations on July 1, 2012, as a manufacturer of heat sensitive valves used in the plumbing industry. Effective at the beginning of 2014, Platco, an American company, acquired an 80% interest in Dontelli paying 400,000 FC. Of the purchase price in excess of book value, 42,000 FC was allocated to patents having a remaining useful life of 10 years and the balance was allocated to goodwill. It has been determined that the functional currency is the FC.Dontelli’s condensed trial balances, expressed in FC, at selected rates are as follows:(attached)Additional equipment was purchased on April 1, 2015. Dividends were paid on June 30 of 2014 and 2015. At the end of 2015, goodwill traceable to the acquisition of Dontelli was tested for impairment, and accordingly, the goodwill was written down by 20%. Calculate the balance of the cumulative translation adjustment as of year-end 2014 and 2015. Given the consolidated income statement for years 2014 and 2015, determine…arrow_forward
- The following are several figures reported for Allister and Barone as of December 31, 2021: Allister Barone Inventory $ 600,000 $ 400,000 Sales 1,200,000 1,000,000 Investment income not given Cost of goods sold 600,000 500,000 Operating expenses 280,000 350,000 Allister acquired 90 percent of Barone in January 2020. In allocating the newly acquired subsidiary's fair value at the acquisition date, Allister noted that Barone had developed a customer list worth $76,000 that was unrecorded on its accounting records and had a five-year remaining life. Any remaining excess fair value over Barone's book value was attributed to goodwill. During 2021, Barone sells inventory costing $140,000 to Allister for $200,000. Of this amount, 15 percent remains unsold in Allister's warehouse at year-end. Determine balances for the following items that would appear on Allister's consolidated financial statements for 2021: Inventory Sales Cost of Goods Sold…arrow_forwardACME Incorporate acquired 100% of Petunia Ltd. in 2011 and recognized $1-million in goodwill. Due to a series of operating losses the investment was found to be impaired and goodwill was written down to $500,000 in 2017. Due to a restructuring in early 2019, the investment in Petunia has increased in value and management believes that significant goodwill has been generated. Management estimates that the value of goodwill is 900,000 at the end of 2020. Required: Prepare any necessary journal entries for 2020 and provide an explanation to support your work assuming that ACME reports under ASPE.arrow_forwardfollowing are several figures reported for Allister and Barone as of December 31, 2018: Allister Barone Inventory $ 400,000 $ 200,000 Sales 800,000 600,000 Investment income not given Cost of goods sold 400,000 300,000 Operating expenses 180,000 250,000 Allister acquired 70 percent of Barone in January 2017. In allocating the newly acquired subsidiary's fair value at the acquisition date, Allister noted that Barone had developed a customer list worth $65,000 that was unrecorded on its accounting records and had a 5-year remaining life. Any remaining excess fair value over Barone's book value was attributed to goodwill. During 2018, Barone sells inventory costing $120,000 to Allister for $160,000. Of this amount, 20 percent remains unsold in Allister's warehouse at year-end. Determine balances for the following items that would appear on Allister's consolidated financial statements for 2018: Inventory____$_____________________…arrow_forward
- Python acquired 75% of Slither’s stock for $316 million in cash on January 2, 2015. The fair value of the noncontrolling interest in Slither was $89 million. Slither’s book value at that time was $120 million. The assets and liabilities reported on Slither’s balance sheet had balances that approximated fair value at the date of acquisition. However, Slither had previously unreported developed technology (10 year life, straight-line), valued at $40 million. There has been no impairment loss on the developed technology since acquisition. Goodwill was impaired $6 million in 2015, and a $3 million impairment loss should be recorded for 2016. It is now December 31, 2016. The trial balances of Python and Slither appear below. (in thousands) Python Dr (Cr) Slither Dr (Cr) Current assets $ 113,500 $ 35,000 Plant assets, net 1,200,000 500,000 Investment in Slither 323,800 – Liabilities (1,342,950) (387,000) Capital stock (40,000) (20,000) Retained earnings, Jan. 1 (215,000) (110,000)…arrow_forwardPam Company acquires the net assets of Jam Company for an agreed-upon price of $900,000 on July 1, 2015. The value is tentatively assigned as follows:Current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 100,000Land. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50,000Equipment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200,000 (5-year life)Building . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 500,000 (20-year life)Current liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . (150,000)Goodwill . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200,000Values are subject to change during the measurement period. Depreciation is taken to the nearest month. The measurement period expires on July 1, 2016, at which time the fair values of the equipment and building as of the acquisition date…arrow_forwardAbra Ltd sold an item of plant to its subsidiary Cadabra Ltd on 1 January 2017 for $50 000. The asset had cost Abra Ltd $60 000 when acquired on 1 January 2015. At that time the useful life of the plant was assessed at 6 years. Rounded to the nearest dollar, the consolidation elimination entries at 30 June 2017 in relation to the sale of plant are which of the following? a. Plant Dr 10 000 Gain on sale Dr 10 000 Accumulated depreciation Cr 20 000 Deferred tax asset Dr 3 000 Income tax expense Cr 3 000 Accumulated depreciation Dr 1 250 Depreciation expense Cr 1 250 Income tax expense Dr 375 Deferred tax asset Cr 375 b. Accumulated depreciation Dr 10 000 Gain on sale Dr 10 000 Plant Cr 20 000 Deferred tax asset Dr 3 000 Income tax expense Cr 3…arrow_forward
- Wember Company acquired a subsidiary company on December 31, 2015, and recorded the cost of the intangible assets it acquired as follows: Patent $80,000 Trade name 100,000 Goodwill 250,000 The patent is being amortized by the straight-line method over an expected life of 10 years with no residual value. Amortization has been recorded for the current year. The trade name was considered to have an indefinite life. Because of the success of the subsidiary in the past, Wember has not previously considered any of the intangible assets to be impaired. However, in 2019, because of a current recession and technological changes in the subsidiary’s industry, Wember decides to review all of its intangible assets for impairment and record any adjustments at December 31, 2019. Wember estimates that the fair value of the patent is $42,000. The company estimates the fair value of the trade name to be $120,000 but decides that it now has a limited life of 6 years. The subsidiary…arrow_forwardWember Company acquired a subsidiary company on December 31, 2015, and recorded the cost of the intangible assets it acquired as follows: Patent $80,000 Trade name 100,000 Goodwill 250,000 The patent is being amortized by the straight-line method over an expected life of 10 years with no residual value. Amortization has been recorded for the current year. The trade name was considered to have an indefinite life. Because of the success of the subsidiary in the past, Wember has not previously considered any of the intangible assets to be impaired. However, in 2019, because of a current recession and technological changes in the subsidiary’s industry, Wember decides to review all of its intangible assets for impairment and record any adjustments at December 31, 2019. Wember estimates that the fair value of the patent is $42,000. The company estimates the fair value of the trade name to be $120,000 but decides that it now has a limited life of 6 years. The subsidiary…arrow_forwardFollowing are several figures reported for Allister and Barone as of December 31, 2018: Allister Barone Inventory $ 410,000 $ 210,000 Sales 820,000 620,000 Investment income not given Cost of goods sold 410,000 310,000 Operating expenses 185,000 255,000 Allister acquired 80 percent of Barone in January 2017. In allocating the newly acquired subsidiary's fair value at the acquisition date, Allister noted that Barone had developed a customer list worth $60,000 that was unrecorded on its accounting records and had a 4-year remaining life. Any remaining excess fair value over Barone's book value was attributed to goodwill. During 2018, Barone sells inventory costing $121,000 to Allister for $162,000. Of this amount, 10 percent remains unsold in Allister's warehouse at year-end. Determine balances for the following items that would appear on Allister's consolidated financial statements for 2018:arrow_forward
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College