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 |
Account receivable | 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?
- Tyler Company acquired all of Jasmine Company’s outstanding stock on January 1, 2016, for $206,000 in cash. Jasmine had a book value of only $140,000 on that date. However, equipment (having an eight-year remaining life) was undervalued by $54,400 on Jasmine’s financial records. A building with a 20-year remaining life was overvalued by $10,000. Subsequent to the acquisition, Jasmine reported the following: Net Income Dividends Declared 2016 $ 50,000 $ 10,000 2017 60,000 40,000 2018 30,000 20,000 In accounting for this investment, Tyler has used the equity method. Selected accounts taken from the financial records of these two companies as of December 31, 2018, follow: Tyler Company Jasmine Company Revenues—operating $ (310,000 ) $ (104,000 ) Expenses 198,000 74,000 Equipment (net) 320,000 50,000 Buildings (net) 220,000 68,000 Common stock (290,000 ) (50,000 ) Retained earnings, 12/31/18…arrow_forwardTyler Company acquired all of Jasmine Company’s outstanding stock on January 1, 2016, for $206,000 in cash. Jasmine had a book value of only $140,000 on that date. However, equipment (having an eight-year remaining life) was undervalued by $54,400 on Jasmine’s financial records. A building with a 20-year remaining life was overvalued by $10,000. Subsequent to the acquisition, Jasmine reported the following: In accounting for this investment, Tyler has used the equity method. Selected accounts taken from the financial records of these two companies as of December 31, 2018, follow: Determine and explain the following account balances as of December 31, 2018: a. Investment in Jasmine Company (on Tyler’s individual financial records). b. Equity in Subsidiary Earnings (on Tyler’s individual financial records). c. Consolidated Net Income. d. Consolidated Equipment (net). e. Consolidated Buildings (net). f. Consolidated Goodwill (net). g. Consolidated Common Stock. h. Consolidated Retained…arrow_forwardHeartland Telecom provides communication services in Iowa, Nebraska, the Dakotas, and Montana. Heartland Telecom purchased goodwill as part of the acquisition of Samson Wireless Enterprises, which had the following figures: Data table: Book value of assets $800,000 Market value of assets 900,000 Market value of liabilities 510,000 Requirements: 1. Journalize the entry to record Heartland Telecom's purchase of SamsonSamson Wireless for $400,000cash plus a $600,000 note payable. 2. What special asset does Heartland Telecom'sHeartland Telecom's acquisition of SamsonSamson Wirelessidentify? How should HeartlandHeartland Telecom account for this asset after acquiring SamsonSamson Wireless? Explain in detail.arrow_forward
- Dontelli 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_forwardOn October 1, 2017, the Puppy Eyes Company acquired the net assets of The Cat Love Company when the fair value of Cat Love’s net assets was P116 million and their carrying amount was P120 million. The consideration transferred comprised P200 million in cash transferred at acquisition date, plus another P60 million in cash to be transferred 11 months after the acquisition date if a specified profit target being met by Cat Love. At the acquisition date there was only a low probability of the profit target being met, so the fair value of the additional consideration liability was P10 million. In the event the profit target was met and the P60 million cash was transferred, what amount should Puppy Eyes present for Goodwill in its statement of Financial position on December 31, 2017, according to IFRS 3 Business Combinations?arrow_forwardOn October 1, 2017, the Puppy Eyes Company acquired the net assets of The Cat Love Company when the fair value of Cat Love’s net assets was P116 million and their carrying amount was P120 million. The consideration transferred comprised P200 million in cash transferred at acquisition date, plus another P60 million in cash to be transferred 11 months after the acquisition date if a specified profit target being met by Cat Love. At the acquisition date there was only a low probability of the profit target being met, so the fair value of the additional consideration liability was P10 million. In the event the profit target was met and the P60 million cash was transferred, what amount should Puppy Eyes present for Goodwill in its statement of Financial position on December 31, 2017, according to IFRS 3 Business Combinations? Group of answer choices 84 million 144 million 94 million 140 millionarrow_forward
- At the beginning of 2016, Metatec Inc. acquired Ellison Technology Corporation for $600 million. In addition tocash, receivables, and inventory, the following assets and their fair values were also acquired:Plant and equipment (depreciable assets) $150 millionPatent 40 millionGoodwill 100 millionThe plant and equipment are depreciated over a 10-year useful life on a straight-line basis. There is no estimated residual value. The patent is estimated to have a 5-year useful life, no residual value, and is amortizedusing the straight-line method.At the end of 2018, a change in business climate indicated to management that the assets of Ellison might beimpaired. The following amounts have been determined:Plant and equipment:Undiscounted sum of future cash flows $ 80 millionFair value 60 millionPatent:Undiscounted sum of future cash flows $ 20 millionFair value 13 millionGoodwill:Fair value of Ellison Technology Corporation $450 millionFair value of Ellison’s net assets (excluding goodwill)…arrow_forwardAsaparrow_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. Gain on sale Dr 10 000 Plant Cr 10 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 000 Accumulated…arrow_forward
- 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_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_forwardTomato co. Purchased 40% of MU corp. On april 1,2017, for 500,000 when MU's book value was 1,260,000. On the date of acquisition, the market value of MU's net asset equaled their book values, except for the following: •MU's equipment has a fair value of 50,000 less than it's books value. The equip. Has a remaining useful life of 10 years. •MU's building has a fair value of 40,000 more than it's book value. The building has a remaining useful life of 20 years. MU's results of operation for 2017 and 2018 are as follows: •2017 net income 150,000 •2018 net loss 30,000 MU's cash dividends of 20,000 and 10,000 respectively for 2017 and 2018. Required: journal entries and balances for the following 1. Investment income 2017 2. Investment loss 2018 3. Investment Carrying value for 2017 and 2018arrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College