Translate Simbel’s 2017 financial statements into US Dollar and prepare a consolidation worksheet for Cayce and its Egyptian subsidiary. Assume that the Egyptian pound is the subsidiary functional currency.
Explanation of Solution
Translate foreign currency financial statement and prepare consolidation worksheet:
Simbel’s financial statements are first translated into US Dollar after reclassification of 10,000 pounds expenditure for rent from rent expenses to prepaid rent and accordingly. The balances as follows:
Translation Worksheet | |||
Accounts | Pounds | Rate | Dollars |
Sales | 800,000 | 0.274 | (219,200) |
Cost of goods sold | 420,000 | 0.274 | 115,080 |
Salary expenses | 74,000 | 0.274 | 20,276 |
Rent expenses( Adjusted) | 36,000 | 0.274 | 9,864 |
Other expenses | 59,000 | 0.274 | 1,617 |
Gain on sale of fixed assets (10/1/2017)( Building) | (30,000) | 0.274 | (8,190) |
Net income | 241,000 | 0.273 | (66,004) |
(133,000) | |||
Net income | (241,000) | (66,004) | |
Dividend paid | 50,000 | 0.275 | 13,750 |
Retained earnings (12/31/2017) | (324,000) | (90,498) | |
Cash and receivables | 146,000 | 0.27 | 39,420 |
Inventory | 297,000 | 0.27 | 80,190 |
Prepaid rent ( adjusted) | 10,000 | 0.27 | 2,700 |
Fixed assets | 455,000 | 0.27 | 122,850 |
Total | 908,000 | 245,160 | |
Accounts Payable | (54,000) | ||
Notes Payable | (140,000) | ||
Common stock | (240,000) | ||
Additional paid in capital | (150,000) | ||
Retained earnings ( 12/31/2017) | (324,000) | (90,498) | |
Subtotal | (259,878) | ||
Cumulative translation adjustment ( negative) | 14,718 | ||
Total | 908,000 | (245,160) |
Table: (1)
Schedule 1: Translation of 1/1/2017 retained earnings:
Accounts | Pounds | Rate | Dollars |
Retained earnings ( 1/1/2016) | 0 | 0 | 0 |
Net income,2016 | (163,000) | 0.288 | (46,944) |
Dividend 6/1/2016 | 30,000 | 0.290 | 8,700 |
Retained earnings ( 1/1/2017) | 133,000 | (38,244) |
Table: (2)
Schedule 2: Calculation of cumulative Translation adjustment at 12/31/2017:
Accounts | Pounds | Rate | Dollars |
Net assets ( 1/1/2016) | (390,000) | 0.3 | (117,000) |
Net income,2016 | (163,000) | 0.288 | (46,944) |
Dividend 6/1/2016 | 30,000 | 0.290 | 8,700 |
Net assets 12/31/2016 | 523,000 | (155,244) | |
Net assets 12/31/2016 at current exchange rate | 146,440 | ||
Translation adjustment 2016 ( Negative) | 8,804 |
Table: (3)
Accounts | Pounds | Rate | Dollars |
Net assets ( 1/1/2017) | (523,000) | 0.280 | (146,440) |
Net income,2017 | (241,000) | (66004) | |
Dividend 6/1/2016 | 50,000 | 0.275 | 13750 |
Net assets 12/31/2017 | 714,000 | 198,694 | |
Net assets 12/31/2017 at current exchange rate | 192,780 | ||
Translation adjustment 2017 ( Negative) | 8,804 | ||
Cumulative Translation adjustment 12/31/2017 ( Negative) | (14,718) |
Table: (4)
Cayce and Simbel’s US Dollar accounts are then consolidated:
Consolidation Worksheet | |||||
Accounts | Cayce Dollar | Simbel Dollar | Adjustment and Elimination | Consolidation Balance | |
Debit | Credit | ||||
Sales | ($200,000) | ($219,200) | ($419,200) | ||
Cost of goods sold | $93,800 | $115,080 | $208,880 | ||
Salary expenses | $19,000 | $20,276 | $39,276 | ||
Rent expenses | $7,000 | $9,864 | $16,864 | ||
Other expenses | $21,000 | $16,166 | $37,166 | ||
Dividend income | ($13,750) | $0 | $13,750 | $0 | |
Gain (10/1/2017) | $0 | ($8,190) | ($8,190) | ||
Net income | ($72,950) | ($66,004) | ($125,204) | ||
Retained earnings (1/1/2017) | ($318,000) | ($38,244) | $38,244 | ($38,244) | ($356,244) |
Net income | ($72,950) | ($66,004) | ($125,204) | ||
Dividend paid | $24,000 | $13,750 | ($13,750) | $24,000 | |
Retained earnings (12/31/2017) | ($366,950) | ($90,498) | ($457,448) | ||
Cash and receivables | $110,750 | $39,420 | $150,170 | ||
Inventory | $98,000 | $80,190 | |||
Prepaid rent | $30,000 | $2,700 | |||
Investment | $126,000 | $0 | $38,244 | ($164,244) | $6 |
Fixed assets | $398,000 | $122,850 | $9,000 | $900 | $528,950 |
Total | $762,750 | $245,160 | $890,010 | ||
Accounts Payable | ($60,800) | $39,420 | ($75,380) | ||
Notes Payable | ($132,000) | ($37,800) | ($169,800) | ||
Common stock | ($120,000) | ($72,000) | $72,000 | ($120,000) | |
Additional paid in capital | ($83,000) | ($45,000) | $45,000 | ($83,000) | |
Retained earnings ( 12/31/2017) | ($366,950) | ($90,498) | ($457,448) | ||
Subtotal | ($259,878) | ||||
Cumulative translation adjustment ( negative) | $14,718 | $900 | $15,618 | ||
Total | $762,750 | ($245,160) | $217,138 | $217,138 | $890,010 |
Table: (5)
Explanation entries:
Date | Accounts title and Explanation | Post Ref. | Debit($) | Credit($) |
1. | Dividend income | 13,750 | ||
Dividend paid | 13,750 | |||
( To eliminate intercompany dividend payments recorded by parent as income) | ||||
2. | Common stock ( Simbel) | 72,000 | ||
Additional PIC ( Simbel) | 45,000 | |||
Retained earnings (1/1/2017)(Simbel) | 38,244 | |||
Fixed assets ( Revaluation) | 9,000 | |||
Investment in Simbel | 164,244 | |||
(To eliminate subsidiary’s | ||||
Table: (6)
The excess of cost over book value is calculated as follows:
Particulars | Amounts ( $) |
Purchase Price | 126,000 |
Book value,(1/1/2017): | |
Common stock | (72,000) |
Additional paid in capital | ( 45,000) |
Excess of purchase price over book value | 9,000 |
Table: (7)
The excess of cost over the book value is pounds 30,000. This US & will be
Explanatory entries:
Date | Accounts title and Explanation | Post Ref. | Debit($) | Credit($) |
3. | Investment in Simbel | 38,244 | ||
Retained earnings ( 1/1/2017) | 38,244 | |||
( To accrue 2017 increase in | ||||
4. | Cumulative Translation adjustment | 900 | ||
Fixed assets( realization) | 900 | |||
( To revalue the excess of cost over book value for the change in exchange rate since the date of acquisition with the consolidated cumulative transition adjustment) | ||||
Table: (8)
The revalution of ‘’excess’’ is calculated as follows:
Particulars | Amounts ( $) |
Excess of cost over book value US Dollar equivalent at 12/31/2017 | 8,100 |
US Dollar equivalent at 1/1/2017 | 9,000 |
Cumulative translation adjustment related to excess (1/31/2017) | (900) |
Table: (9)
Want to see more full solutions like this?
Chapter 10 Solutions
ACNT 2333 PRINT UPGRADE
- 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_forwardMighty Company purchased a 60 percent interest in Lowly Company on January 1, 2017, for $567,600 in cash. Lowly's book value at that date was reported as $760,000 and the fair value of the noncontrolling interest was assessed at $378,400. Any excess acquisition-date fair value over Lowly's book value is assigned to trademarks to be amortized over 20 years. Subsequently, on January 1, 2018, Lowly acquired a 20 percent interest in Mighty. The price of $440,000 was equivalent to 20 percent of Mighty's book and fair value. Neither company has paid dividends since these acquisitions occurred. On January 1, 2018, Lowly's book value was $992,000, a figure that rises to $1,054,500 (common stock of $300,000 and retained earnings of $754,500) by year-end. Mighty's book value was $2.20 million at the beginning of 2018 and $2.30 million (common stock of $1 million and retained earnings of $1,300,000) at December 31, 2018. No intra-entity transactions have occurred and no additional stock has been…arrow_forwardOn January 1, 2018, it purchased an additional 30 percent of Barta for $661,000 which resulted in significant influence over Barta. On that date, the fair value of Barta’s common stock was $2,030,000 in total. Barta’s January 1, 2018 book value equaled $1,880,000, although land was undervalued by $135,000. Any additional excess fair value over Barta's book value was attributable to a trademark with an 8-year remaining life. During 2018, Barta reported income of $345,000 and declared and paid dividends of $100,000. Prepare the 2018 journal entries for Legan related to its investment in Barta. Legan, Inc., acquired 10 percent of Barta Corporation on January 1, 2017, for $186,000 and appropriately accounted for the investment using the fair-value method. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)arrow_forward
- Mighty Company purchased a 60 percent interest in Lowly Company on January 1, 2017, for $558,900 in cash. Lowly's book value at that date was reported as $817,500 and the fair value of the noncontrolling interest was assessed at $372,600. Any excess acquisition-date fair value over Lowly's book value is assigned to trademarks to be amortized over 20 years. Subsequently, on January 1, 2018, Lowly acquired a 20 percent interest in Mighty. The price of $362,000 was equivalent to 20 percent of Mighty's book and fair value. Neither company has paid dividends since these acquisitions occurred. On January 1, 2018, Lowly's book value was $1,060,500, a figure that rises to $1,105,750 (common stock of $300,000 and retained earnings of $805,750) by year-end. Mighty's book value was $1.81 million at the beginning of 2018 and $1.91 million (common stock of $1 million and retained earnings of $910,000) at December 31, 2018. No intra-entity transactions have occurred and no additional stock has been…arrow_forwardMighty Company purchased a 60 percent interest in Lowly Company on January 1, 2017, for $420,000 in cash. Lowly’s book value at that date was reported as $600,000 and the fair value of the noncontrolling interest was assessed at $280,000. Any excess acquisition-date fair value over Lowly’s book value is assigned to trademarks to be amortized over 20 years. Subsequently, on January 1, 2018, Lowly acquired a 20 percent interest in Mighty. The price of $240,000 was equivalent to 20 percent of Mighty’s book and fair value.Neither company has paid dividends since these acquisitions occurred. On January 1, 2018, Lowly’s book value was $800,000, a figure that rises to $840,000 (common stock of $300,000 and retained earnings of $540,000) by year-end. Mighty’s book value was $1.7 million at the beginning of 2018 and $1.8 million (common stock of $1 million and retained earnings of $800,000) at December 31, 2018. No intra-entity transactions have occurred and no additional stock has been sold.…arrow_forwardOn January 1, 2018, Brooks Corporation exchanged $1,183,000 fair-value consideration for all of the outstanding voting stock of Chandler, Inc. At the acquisition date, Chandler had a book value equal to $1,105,000. Chandler’s individual assets and liabilities had fair values equal to their respective book values except for the patented technology account, which was undervalued by $204,000 with an estimated remaining life of six years. The Chandler acquisition was Brooks’s only business combination for the year. In case expected synergies did not materialize, Brooks Corporation wished to prepare for a potential future spin-off of Chandler, Inc. Therefore, Brooks had Chandler maintain its separate incorporation and independent accounting information system as elements of continuing value. On December 31, 2018, each company submitted the following financial statements for consolidation. Dividends were declared and paid in the same period. Parentheses indicated credit balances. a. Show…arrow_forward
- On January 1, 2017, Palka, Inc., acquired 70 percent of the outstanding shares of Sellinger Company for $1,666,000 in cash. The price paid was proportionate to Sellinger’s total fair value, although at the acquisition date, Sellinger had a total book value of $2,070,000. All assets acquired and liabilities assumed had fair values equal to book values except for a patent (six-year remaining life) that was undervalued on Sellinger’s accounting records by $300,000. On January 1, 2018, Palka acquired an additional 25 percent common stock equity interest in Sellinger Company for $656,250 in cash. On its internal records, Palka uses the equity method to account for its shares of Sellinger. During the two years following the acquisition, Sellinger reported the following net income and dividends: 2017 2018 $525,000 $701,000 Net…arrow_forwardProForm acquired 70 percent of ClipRite on June 30, 2017, for $910,000 in cash. Based on Clip- Rite’s acquisition-date fair value, an unrecorded intangible of $400,000 was recognized and is being amortized at the rate of $10,000 per year. No goodwill was recognized in the acquisition.The noncontrolling interest fair value was assessed at $390,000 at the acquisition date. The 2018 financial statements are as follows:ProForm sold ClipRite inventory costing $72,000 during the last six months of 2017 for $120,000. At year-end, 30 percent remained. ProForm sells ClipRite inventory costing $200,000 during 2018 for $250,000. At year-end, 10 percent is left. With these facts, determine the consolidated balances for the following:SalesCost of Goods SoldOperating ExpensesDividend IncomeNet Income Attributable to Noncontrolling InterestInventoryNoncontrolling Interest in Subsidiary, 12/31/18arrow_forwardOn January 1, 2024, Brooks Corporation exchanged $1,194,000 fair-value consideration for all of the outstanding voting stock of Chandler, Incorporated. At the acquisition date, Chandler had a book value equal to $1,150,000. Chandler’s individual assets and liabilities had fair values equal to their respective book values except for the patented technology account, which was undervalued by $216,000 with an estimated remaining life of six years. The Chandler acquisition was Brooks’s only business combination for the year. In case expected synergies did not materialize, Brooks Corporation wished to prepare for a potential future spin-off of Chandler, Incorporated. Therefore, Brooks had Chandler maintain its separate incorporation and independent accounting information system as elements of continuing value. On December 31, 2024, each company submitted the following financial statements for consolidation. Dividends were declared and paid in the same period. Accounts Brooks Corporation…arrow_forward
- Padre, Inc., buys 80 percent of the outstanding common stock of Sierra Corporation on January 1, 2018, for $802,720 cash. At the acquisition date, Sierra’s total fair value, including the noncontrolling interest, was assessed at $1,003,400 although Sierra’s book value was only $690,000. Also, several individual items on Sierra’s financial records had fair values that differed from their book values as follows: Book Value Fair Value Land $ 65,000 $ 290,000 Buildings andequipment (10-year remaining life) 287,000 263,000 Copyright (20-year remaining life) 122,000 216,000 Notes payable (due in 8 years) (176,000) (157,600) For internal reporting purposes, Padre, Inc., employs the equity method to account for this investment. The following account balances are for the year ending December 31, 2018, for both companies. Padre Sierra Revenues $(1,394,980) $ (684,900) Cost of goods sold 774,000 432,000 Depreciation expense 274,000 11,600…arrow_forwardOn January 1, 2021, Brooks Corporation exchanged $1,235,000 fair-value consideration for all of the outstanding voting stock of Chandler, Inc. At the acquisition date, Chandler had a book value equal to $1,185,000. Chandler’s individual assets and liabilities had fair values equal to their respective book values except for the patented technology account, which was undervalued by $246,000 with an estimated remaining life of six years. The Chandler acquisition was Brooks’s only business combination for the year. In case expected synergies did not materialize, Brooks Corporation wished to prepare for a potential future spin-off of Chandler, Inc. Therefore, Brooks had Chandler maintain its separate incorporation and independent accounting information system as elements of continuing value. On December 31, 2021, each company submitted the following financial statements for consolidation. Dividends were declared and paid in the same period. Brooks Corp. Chandler Inc. Income…arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning