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) |
Retained earnings (11/1/2017) | (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
Soft Bound Version for Advanced Accounting 13th Edition
- ABC Corporation purchased XYZ Inc. The latter has the following account balances: The noncurrent assets have a fair value of P4,500,000. ABC paid the owners of XYZ a total purchase price of P4,500,000. How much is the goodwill that ABC should record from this acquisition? *refer to attached photoarrow_forwardPanama Company acquired 60 % of Samoa Corporation on 1/2018. Fair values of Samoa's assets and liabilities approximated book values on that date. Panama uses the initial value method to account for its investment in Samoa. only answer D.) E.) F.) On 1/2019, Panama bought equipment from Samoa for $60,000 that had originally cost Samoa $120,000 and had $ 90,000 of Accumulated depreciation at the time. The equipment had a five-year remaining life and was being depreciated using the straight line method. You are preparing the worksheet for the 2020 fiscal year. a. Was this equipment sale upstream or downstream?b. How much unrealized net gain from the equipment transfer remains at the beginning of 2020? (this is the amount you will need for the *TA entry at 1/2020.)c. Which company's Retained earnings account will be adjusted in the *TA entry in part a? (Which company was the “initiator” of the transaction?)d. How much excess depreciation will there be in each of the first five years after…arrow_forwardPanama Company acquired 60% of Samoa Corporation on 1/2018. Fair values of Samoa's assets and liabilities approximated book values on that date. Panama uses the initial value method to account for its investment in Samoa. On 1/2019, Panama bought equipment from Samoa for $60,000 that had originally cost Samoa $120,000 and had $ 110,000of Accumulated depreciation at the time. The equipment had a five-year remaining life and was being depreciated using the straight-line method. You are preparing the worksheet for the 2020 fiscal year. a. Was this equipment sale upstream or downstream?b. How much unrealized net gain from the equipment transfer remains at the beginning of 2020? (this is the amount you will need for the *TA entry at 1/2020.)c. Which company's Retained earnings account will be adjusted in the *TA entry in part a? (Which company was the "initiator" of the transaction?)d. How much excess depreciation will there be in each of the first five years after the transfer?e. Panama's…arrow_forward
- Panama Company acquired 60 %of Samoa Corporation on 1/2018. Fair values of Samoa's assets and liabilitiesapproximated book values on that date. Panama uses the initial value methodto account for its investment in Samoa.On 1/2019, Panama bought equipment from Samoa for $60,000 that hadoriginally cost Samoa $120,000 and had $ 90,000of Accumulated depreciation at the time. The equipment had a five-yearremaining life and was being depreciated using the straight line method.You are preparing the worksheet for the 2020 fiscal year.a. Was this equipment sale upstream or downstream?b. How much unrealized net gain from the equipment transfer remains at thebeginning of 2020? (this is the amount you will need for the *TA entry at 1/2020.)c. Which company's Retained earnings account will be adjusted in the *TA entryin part a? (Which company was the “initiator” of the transaction?)d. How much excess depreciation will there be in each of the first five yearsafter the transfer?e. Panama's 2020 net…arrow_forwardPanama Company acquired 60 %of Samoa Corporation on 1/2018. Fair values of Samoa's assets and liabilitiesapproximated book values on that date. Panama uses the initial value methodto account for its investment in Samoa.On 1/2019, Panama bought equipment from Samoa for $60,000 that hadoriginally cost Samoa $120,000 and had $ 90,000of Accumulated depreciation at the time. The equipment had a five-yearremaining life and was being depreciated using the straight line method.You are preparing the worksheet for the 2020 fiscal year.d. How much excess depreciation will there be in each of the first five yearsafter the transfer?e. Panama's 2020 net income, without including any investment income, was$ 360,000 and Samoa reported net income of $ 115,000 in 2020.What consolidated income will be reported before removing the noncontrollinginterest's share of the subsidiary's net income? (This includes the effectof the ED entry.)f. What will the noncontrolling interest's share of the subsidiary's net…arrow_forwardDuring 2022, Twenti Company, had the following transactions: On January 2, Twenti purchased the net assets of Terti Company for P360,000. The fair value of Terti’sidentifiable net assets was P172,000, Twenti believes that, due to the popularity of Terti’s consumerproducts, the life of the resulting goodwill is unlimited. On February 1, Twenti purchased a franchise to operate a ferry service from the state government forP60,000 and an annual fee of 1% of ferry revenues. The franchise expires after five years. Twentireceived P20,000 of ferry revenues in 2022. On April 5, Twenti granted a patent that had been applied for by Terti. During 2022, Twenti incurredlegal costs of P51,000 to register the patent and an additional of P85,000 to successfully prosecute apatent infringement suit against a competitor. Twenti estimates the patent’s economic life to be tenyears.Twenti has determine that it is appropriate to amortize these intangibles on the straight line basis over themaximum period…arrow_forward
- Palm Resorts acquired its 70 percent interest in Sun City on January 1, 2017, for $41,750,000. The fair value of the 30 percent noncontrolling interest at the date of acquisition was $14,750,000. Sun City’s date-of-acquisition reported net assets of $5,000,000 were carried at amounts approximating fair value, but it had unrecorded identifiable intangibles, capitalizable per ASC Topic 805, valued at $7,500,000. These intangibles are determined to have limited lives, amortized on a straight-line basis over five years. It is now December 31, 2020, and Sun City reports net income of $10,000,000. Required: Calculate the amount of goodwill originally reported for this acquisition, and its allocation to the controlling and noncontrolling interests. Calculate equity in net income and the noncontrolling interest in net income for 2020, assuming goodwill from this acquisition is impaired by $2,000,000 in 2020.arrow_forwardDuring the current year, USACo (a domestic corporation) sold equipment to FrenchCo, a non-U.S. corporation, for $350,000 with title passing to the buyer in France. USACO purchased the equipment several years ago for $100,000 and took $80,000 of depreciation deductions on the equipment, all of which were allocated to U.S.-source income. USACo's adjusted basis in the equipment is $20,000 on the date of sale. What is the sourcing of the $330,000 gain on the sale of this equipment? a. $250,000 foreign source and $80,000 U.S. source. b. $250,000 U.S. source and $80,000 foreign source. c. $330,000 foreign source. d. $330,000 U.S. source. 0000arrow_forwardSnowy Ltd acquires Pax Ltd on 1 July 2018 for $5,000,000 being the fair value of the consideration transferred. At that date, Pax Ltd’s net identifiable assets have a fair value of $4,400,000. Goodwill of $600,000 is therefore the difference between the aggregate of the consideration transferred and the net identifiable assets acquired.The fair value of the net identifiable assets of Pax Limited are determined as follows:($000)Patent rights 200Machinery 1,000Buildings 1,500Land 2,3005,000Less: Bank loan 600Net assets 4,400At the end of the reporting period of 30 June 2019, the management of Snowy Ltd determines that the recoverable amount of the cash-generating unit, which is considered to be Pax Ltd, totals $4,500,000. The carrying amount of the net identifiable assets of Pax Ltd, excluding goodwill, is unchanged and remains at $4,400,000.Required:a) Prepare the journal entry to account for any impairment of goodwill.b) Assume instead that at the end of the reporting period the…arrow_forward
- Snowy Ltd acquires Pax Ltd on 1 July 2018 for $5,000,000 being the fair value of the considerationtransferred. At that date, Pax Ltd’s net identifiable assets have a fair value of $4,400,000. Goodwill of$600,000 is therefore the difference between the aggregate of the consideration transferred and the net identifiable assets acquired. The fair value of the net identifiable assets of Pax Limited are determined as follows: ($000) Patent rights Machinery Buildings Land Less: Bank loan Net assets 200 1,000 1,500 2,300 5,000 600 4,400 At the end of the reporting period of 30 June 2019, the management of Snowy Ltd determines that the recoverable amount of the cash-generating unit, which is considered to be Pax Ltd, totals $4,500,000. The carrying amount of the net identifiable assets of Pax Ltd, excluding goodwill, is unchanged and remains at $4,400,000. Required: a) Prepare the journal entry to account for any impairment of goodwill. b) Assume instead that at the end of the…arrow_forwardSnowy Ltd acquires Pax Ltd on 1 July 2018 for $5,000,000 being the fair value of the consideration transferred. At that date, Pax Ltd’s net identifiable assets have a fair value of $4,400,000. Goodwill of $600,000 is therefore the difference between the aggregate of the consideration transferred and the net identifiable assets acquired. The fair value of the net identifiable assets of Pax Limited are determined as follows: ($000) Patent rights:- 200 Machinery:- 1000 Buildings:- 1500 Land:- 2300 Total:- 5000 Less: Bank loan:- 5000-600 = 4400 Net assets:- 4400 At the end of the reporting period of 30 June 2019, the management of Snowy Ltd determines that the recoverable amount of the cash-generating unit, which is considered to be Pax Ltd, totals $4,500,000. The carrying amount of the net identifiable assets of Pax Ltd, excluding goodwill, is unchanged and remains at $4,400,000.…arrow_forwardB Ltd owns various apartment blocks as investment property in terms of IAS 40 – Investmentproperty. On 1 October 2021, B Ltd decided to sell one of its commercial properties - AlphaBlock.This property had a fair value of R15 million and was reflected as such in the financial statementsdated 31 December 2020. The fair value on 1 October 2021 was R17.5million. The directors haddecided to redevelop the Alphablock before selling it. B Ltd measures all investment propertyusing the fair value method.Required:• Explain how B Ltd should classify Alphablock in the financial statements up until 1 October2021 and how, if at all, this would change thereafter.• As part of your explanation, state at what value Alphablock should be reflected in thefinancial statements at both 1 October 2021 and thereafterarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education