Use the following financial statements and additional information.
SANCHEZ INC.
Comparative Balance Sheets
June 30, 2017 and 2016
2017
2016
Assets
Cash
$
101,300
$
48,900
Accounts receivable, net
68,000
53,000
Inventory
69,000
96,000
Prepaid expenses
5,700
7,100
Total current assets
244,000
205,000
Equipment
179,000
166,000
Accum. depreciationâEquipment
(45,000
)
(15,000
)
Total assets
$
378,000
$
356,000
Liabilities and Equity
Accounts payable
$
33,000
$
40,000
Wages payable
7,000
17,000
Income taxes payable
3,600
4,000
Total current liabilities
43,600
61,000
Notes payable (long term)
43,000
85,000
Total liabilities
86,600
146,000
Equity
Common stock, $5 par value
250,000
180,000
Retained earnings
41,400
30,000
Total liabilities and equity
$
378,000
$
356,000
SANCHEZ INC.
Income Statement
For Year Ended June 30, 2017
Sales
$
940,000
Cost of goods sold
575,000
Gross profit
365,000
Operating expenses
Depreciation expense
$
77,000
Other expenses
93,000
Total operating expenses
170,000
195,000
Other gains (losses)
Gain on sale of equipment
5,200
Income before taxes
200,200
Income taxes expense
61,280
Net income
$
138,920
Additional Information
a. A $43,000 note payable is retired at its $43,000 carrying (book) value in exchange for cash.
b. The only changes affecting retained earnings are net income and cash dividends paid.
c. New equipment is acquired for $75,000 cash.
d. Received cash for the sale of equipment that had cost $62,000, yielding a $5,200 gain.
e. Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement.
f. All purchases and sales of inventory are on credit.
Make a Journal entry worksheet
1. Reconstruct the journal entry for cash receipts from customers, incorporating the change in the related balance sheet account(s), if any.
2. Reconstruct the journal entry for cash payments for inventory, incorporating the change in the related balance sheet account(s), if any.
3. Reconstruct the journal entry for depreciation expense, incorporating the change in the related balance sheet account(s), if any.
4. Reconstruct the journal entry for cash paid for operating expenses, incorporating the change in the related balance sheet account(s), if any.
5. Reconstruct the journal entry for the sale of equipment at a gain, incorporating the change in the related balance sheet account(s), if any.
6. Reconstruct the journal entry for income taxes expense, incorporating the change in the related balance sheet account(s), if any.
7. Reconstruct the entry to record the retirement of the $43,000 note payable at its $43,000 carrying (book) value in exchange for cash.
8. Reconstruct the entry for the purchase of new equipment.
9. Reconstruct the entry for the issuance of common stock.
10. Close all revenue and gain accounts to income summary.
11. Close all expense accounts to income summary.
12. Close Income Summary to Retained Earnings.
13. Reconstruct the journal entry for cash dividends paid.
Use the following financial statements and additional information.
| SANCHEZ INC. | ||||||||
| 2017 | 2016 | |||||||
| Assets | ||||||||
| Cash | $ | 101,300 | $ | 48,900 | ||||
| Accounts receivable, net | 68,000 | 53,000 | ||||||
| Inventory | 69,000 | 96,000 | ||||||
| Prepaid expenses | 5,700 | 7,100 | ||||||
| Total current assets | 244,000 | 205,000 | ||||||
| Equipment | 179,000 | 166,000 | ||||||
| Accum. depreciationâEquipment | (45,000 | ) | (15,000 | ) | ||||
| Total assets | $ | 378,000 | $ | 356,000 | ||||
| Liabilities and Equity | ||||||||
| Accounts payable | $ | 33,000 | $ | 40,000 | ||||
| Wages payable | 7,000 | 17,000 | ||||||
| Income taxes payable | 3,600 | 4,000 | ||||||
| Total current liabilities | 43,600 | 61,000 | ||||||
| Notes payable (long term) | 43,000 | 85,000 | ||||||
| Total liabilities | 86,600 | 146,000 | ||||||
| Equity | ||||||||
| Common stock, $5 par value | 250,000 | 180,000 | ||||||
| Retained earnings | 41,400 | 30,000 | ||||||
| Total liabilities and equity | $ | 378,000 | $ | 356,000 | ||||
| SANCHEZ INC. | ||||||
| Sales | $ | 940,000 | ||||
| Cost of goods sold | 575,000 | |||||
| Gross profit | 365,000 | |||||
| Operating expenses | ||||||
| Depreciation expense | $ | 77,000 | ||||
| Other expenses | 93,000 | |||||
| Total operating expenses | 170,000 | |||||
| 195,000 | ||||||
| Other gains (losses) | ||||||
| Gain on sale of equipment | 5,200 | |||||
| Income before taxes | 200,200 | |||||
| Income taxes expense | 61,280 | |||||
| Net income | $ | 138,920 | ||||
Additional Information
a. A $43,000 note payable is retired at its $43,000 carrying (book) value in exchange for cash.
b. The only changes affecting retained earnings are net income and cash dividends paid.
c. New equipment is acquired for $75,000 cash.
d. Received cash for the sale of equipment that had cost $62,000, yielding a $5,200 gain.
e. Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement.
f. All purchases and sales of inventory are on credit.
Make a Journal entry worksheet
1. Reconstruct the journal entry for cash receipts from customers, incorporating the change in the related balance sheet account(s), if any.
2. Reconstruct the journal entry for cash payments for inventory, incorporating the change in the related balance sheet account(s), if any.
3. Reconstruct the journal entry for depreciation expense, incorporating the change in the related balance sheet account(s), if any.
4. Reconstruct the journal entry for cash paid for operating expenses, incorporating the change in the related balance sheet account(s), if any.
5. Reconstruct the journal entry for the sale of equipment at a gain, incorporating the change in the related balance sheet account(s), if any.
6. Reconstruct the journal entry for income taxes expense, incorporating the change in the related balance sheet account(s), if any.
7. Reconstruct the entry to record the retirement of the $43,000 note payable at its $43,000 carrying (book) value in exchange for cash.
8. Reconstruct the entry for the purchase of new equipment.
9. Reconstruct the entry for the issuance of common stock.
10. Close all revenue and gain accounts to income summary.
11. Close all expense accounts to income summary.
12. Close Income Summary to Retained Earnings.
13. Reconstruct the journal entry for cash dividends paid.
Related questions
On 1 July 2017, Panda Ltd acquired all the issued shares ofSmarty Ltd. Panda Ltd paid $250,000 more than the equity itacquired in the fair value of Smarty Ltdâs net assets. At the dateof acquisition, the shareholderâs equity of S
On 1 July 2017, Panda Ltd acquired all the issued shares ofSmarty Ltd. Panda Ltd paid $250,000 more than the equity itacquired in the fair value of Smarty Ltdâs net assets. At the dateof acquisition, the shareholderâs equity of Smarty Ltd was asfollows.
$
Share capital
100,000
Retained earnings
175,000
Total
275,000
All the assets and liabilities of Smarty Ltd were recorded atamounts equal to their fair values at the acquisition date, exceptfor some assets detailed below.
Remaining useful life
Cost
Carrying amount
Fair value
$
$
$
Plant
5 years
180,000
90,000
120,000
Computer equipment
5 years
90,000
40,000
60,000
Required:
Prepare the acquisition analysis at 1 July 2017.
Prepare the consolidation worksheet entries for Panda Ltdâs groupat 1 July 2017.
Prepare the consolidation worksheet entries for Panda Ltdâs groupat 30 June 2018.
Question 1
Max. marks allocated
Acquisition analysis
3
Consolidation entries at 1 July 2017
6
Consolidation entries at 30 June 2018
10
Presentation
1
Total
20
Question 2 [35 marks]
Topic 2: Consolidation: Intra-group transactions
On 1 July 2015, Ping Pong Ltd acquired all the issued shares ofSing Song Ltd. At the date of acquisition, the shareholdersâ equityof Sing Song Ltd consisted of share capital $120,000; generalreserve $25,000 and retained earnings $55,000. The identifiable netassets of Sing Song Ltd were recorded at amounts equal to theirfair values, except for the following assets:
Carrying amount
Fair value
$
$
Land
100,000
130,000
Inventories
78,500
86,100
Machinery (cost $86,000)
52,000
56,000
Vehicles (cost $58,000)
47,000
53,000
The assets of Sing Song Ltd at acquisition date includedgoodwill recorded at $15,000 arising from a business combinationtransaction in 2011. As at the date of acquisition, the vehiclesand machinery were expected to have a further useful life of 6 and8 years respectively, with benefits to be received evenly overthose periods. Inventories on hand on 1 July 2015 was all sold by31 January 2016. The land owned at 1 July 2015 was sold inSeptember 2016 for $150,000. The machinery on hand at 1 July 2015was sold on 1 January 2018 for $38,000.
Adjustments for the differences between carrying amount and fairvalues of assets and liabilities on hand at acquisition date arerecognised on consolidation. When assets are sold or derecognised,any related valuation reserves are transferred to retainedearnings.
At 1 July 2015, Sing Song Ltd owned but had not recorded aninternally generated brand name, an identifiable asset included aspart of the business combination transaction. This brand name wasconsidered by Ping Pong Ltd to have a fair value of $29,000 and anindefinite useful life. An impairment test conducted with respectto the brand name on 30 June 2018 concluded that its recoverableamount at that date was $2,000 less than its carrying amount.
In June 2017, Sing Song Ltd paid a share dividend worth $20,000from the general reserve on hand at 1 July 2015.
The trial balances of both companies at 30 June 2018 showed thefollowing balances:
Ping Pong Ltd
Sing Song Ltd
Dr ($)
Cr ($)
Dr ($)
Cr ($)
Sales revenue
450,000
320,000
Dividend revenue
17,000
-
Other income
11,400
17,000
Proceeds on sale of equipment
18,000
-
Proceeds on sale of machinery
-
38,000
Cost of sales
210,000
192,550
Income tax expense
30,000
32,000
Depreciation and other expenses
39,000
36,000
Carrying amount of equipment sold
21,000
-
Carrying amount of machinery sold
-
30,500
Dividend paid
10,000
5,000
Dividend declared
20,000
12,000
Transfer to general reserve
10,000
5,000
Share capital
200,000
140,000
General reserve
35,000
10,000
Retained earnings (1 July 2017)
51,300
67,500
Accounts payable
69,500
36,000
Loan payable (due 30 June 2022)
25,000
15,000
Dividend payable
20,000
12,000
Provisions
12,500
9,300
Current tax liability
43,000
34,000
Deferred tax liability
11,800
5,000
Accumulated depreciation-vehicles
16,400
60,000
Accumulated depreciation-equipment
-
34,500
8%Debentures (matures 30 June 2021)
25,000
-
Cash
2,500
1,250
Receivables
27,000
13,000
Inventories
39,700
24,500
Other current assets
15,200
8,200
Deferred tax assets
7,500
3,500
Vehicles
88,000
158,000
Equipment
-
42,000
Land
140,000
180,000
Financial assets
68,000
14,800
Goodwill
28,000
15,000
Shares in Sing Song Ltd
250,000
-
Debentures in Ping Pong Ltd
-
25,000
1,005,900
1,005,900
798,300
798,300
Additional information:
On 1 January 2018, Ping Pong Ltd sold an item of equipment toSing Song Ltd for $18,000. The equipment had a carrying amount atthe date of sale of $21,000. Both companies depreciate equipment at20% on a straight line basis.
On 1 May 2017, Sing Song Ltd sold a machine to Ping Pong Ltd for$7,800. The machine had a carrying amount of $7,000 at the date ofsale. Ping Pong Ltd recorded the machine as inventories. Theinventories item was sold to an external party in November 2017 for$8,200.
All interests on the 8% debentures has been paid and brought toaccount in the records of both companies.
During the 2017-2018 financial year, Ping Pong Ltd sold inventoriesto Sing Song Ltd for $75,000. The cost of these inventories to SingSong Ltd was $70,000. Of these inventories, 25% is still on hand at30 June 2018.
The transfer to the general reserve recorded by Sing Song Ltd inthe current year was from retained earnings recorded at 1 July2015.
The tax rate is 30%.
Required:
Prepare an acquisition analysis.
Prepare the consolidation worksheet entries necessary to preparethe consolidated financial statements for the year ending 30 June2018 for the group comprising Ping Pong Ltd and Sing Song Ltd.
Note: you are not required to prepare the consolidationworksheet and the consolidated financial statements.
marty Ltd was as follows.
$ | |
Share capital | 100,000 |
Retained earnings | 175,000 |
Total | 275,000 |
All the assets and liabilities of Smarty Ltd were recorded atamounts equal to their fair values at the acquisition date, exceptfor some assets detailed below.
Remaining useful life | Cost | Carrying amount | Fair value | |
$ | $ | $ | ||
Plant | 5 years | 180,000 | 90,000 | 120,000 |
Computer equipment | 5 years | 90,000 | 40,000 | 60,000 |
Required:
Prepare the acquisition analysis at 1 July 2017.
Prepare the consolidation worksheet entries for Panda Ltdâsgroup at 1 July 2017.
Prepare the consolidation worksheet entries for Panda Ltdâsgroup at 30 June 2018.
Question 1 | Max. marks allocated |
Acquisition analysis | 3 |
Consolidation entries at 1 July 2017 | 6 |
Consolidation entries at 30 June 2018 | 10 |
Presentation | 1 |
Total | 20 |
Question 2 [35 marks]
Topic 2: Consolidation: Intra-grouptransactions
On 1 July 2015, Ping Pong Ltd acquired all the issued shares ofSing Song Ltd. At the date of acquisition, the shareholdersâ equityof Sing Song Ltd consisted of share capital $120,000; generalreserve $25,000 and retained earnings $55,000. The identifiable netassets of Sing Song Ltd were recorded at amounts equal to theirfair values, except for the following assets:
Carrying amount | Fair value | |
$ | $ | |
Land | 100,000 | 130,000 |
Inventories | 78,500 | 86,100 |
Machinery (cost $86,000) | 52,000 | 56,000 |
Vehicles (cost $58,000) | 47,000 | 53,000 |
The assets of Sing Song Ltd at acquisition date includedgoodwill recorded at $15,000 arising from a business combinationtransaction in 2011. As at the date of acquisition, the vehiclesand machinery were expected to have a further useful life of 6 and8 years respectively, with benefits to be received evenly overthose periods. Inventories on hand on 1 July 2015 was all sold by31 January 2016. The land owned at 1 July 2015 was sold inSeptember 2016 for $150,000. The machinery on hand at 1 July 2015was sold on 1 January 2018 for $38,000.
Adjustments for the differences between carrying amount and fairvalues of assets and liabilities on hand at acquisition date arerecognised on consolidation. When assets are sold or derecognised,any related valuation reserves are transferred to retainedearnings.
At 1 July 2015, Sing Song Ltd owned but had not recorded aninternally generated brand name, an identifiable asset included aspart of the business combination transaction. This brand name wasconsidered by Ping Pong Ltd to have a fair value of $29,000 and anindefinite useful life. An impairment test conducted with respectto the brand name on 30 June 2018 concluded that its recoverableamount at that date was $2,000 less than its carrying amount.
In June 2017, Sing Song Ltd paid a share dividend worth $20,000from the general reserve on hand at 1 July 2015.
The trial balances of both companies at 30 June 2018 showed thefollowing balances:
Ping Pong Ltd | Sing Song Ltd | |||
Dr ($) | Cr ($) | Dr ($) | Cr ($) | |
Sales revenue | 450,000 | 320,000 | ||
Dividend revenue | 17,000 | - | ||
Other income | 11,400 | 17,000 | ||
Proceeds on sale of equipment | 18,000 | - | ||
Proceeds on sale of machinery | - | 38,000 | ||
Cost of sales | 210,000 | 192,550 | ||
Income tax expense | 30,000 | 32,000 | ||
Depreciation and other expenses | 39,000 | 36,000 | ||
Carrying amount of equipment sold | 21,000 | - | ||
Carrying amount of machinery sold | - | 30,500 | ||
Dividend paid | 10,000 | 5,000 | ||
Dividend declared | 20,000 | 12,000 | ||
Transfer to general reserve | 10,000 | 5,000 | ||
Share capital | 200,000 | 140,000 | ||
General reserve | 35,000 | 10,000 | ||
Retained earnings (1 July 2017) | 51,300 | 67,500 | ||
Accounts payable | 69,500 | 36,000 | ||
Loan payable (due 30 June 2022) | 25,000 | 15,000 | ||
Dividend payable | 20,000 | 12,000 | ||
Provisions | 12,500 | 9,300 | ||
Current tax liability | 43,000 | 34,000 | ||
Deferred tax liability | 11,800 | 5,000 | ||
Accumulated depreciation-vehicles | 16,400 | 60,000 | ||
Accumulated depreciation-equipment | - | 34,500 | ||
8%Debentures (matures 30 June 2021) | 25,000 | - | ||
Cash | 2,500 | 1,250 | ||
Receivables | 27,000 | 13,000 | ||
Inventories | 39,700 | 24,500 | ||
Other current assets | 15,200 | 8,200 | ||
Deferred tax assets | 7,500 | 3,500 | ||
Vehicles | 88,000 | 158,000 | ||
Equipment | - | 42,000 | ||
Land | 140,000 | 180,000 | ||
Financial assets | 68,000 | 14,800 | ||
Goodwill | 28,000 | 15,000 | ||
Shares in Sing Song Ltd | 250,000 | - | ||
Debentures in Ping Pong Ltd | - | 25,000 | ||
1,005,900 | 1,005,900 | 798,300 | 798,300 | |
Additional information:
On 1 January 2018, Ping Pong Ltd sold an item of equipment toSing Song Ltd for $18,000. The equipment had a carrying amount atthe date of sale of $21,000. Both companies depreciate equipment at20% on a straight line basis.
On 1 May 2017, Sing Song Ltd sold a machine to Ping Pong Ltd for$7,800. The machine had a carrying amount of $7,000 at the date ofsale. Ping Pong Ltd recorded the machine as inventories. Theinventories item was sold to an external party in November 2017 for$8,200.
All interests on the 8% debentures has been paid and brought toaccount in the records of both companies.
During the 2017-2018 financial year, Ping Pong Ltd soldinventories to Sing Song Ltd for $75,000. The cost of theseinventories to Sing Song Ltd was $70,000. Of these inventories, 25%is still on hand at 30 June 2018.
The transfer to the general reserve recorded by Sing Song Ltd inthe current year was from retained earnings recorded at 1 July2015.
The tax rate is 30%.
Required:
Prepare an acquisition analysis.
Prepare the consolidation worksheet entries necessary to preparethe consolidated financial statements for the year ending 30 June2018 for the group comprising Ping Pong Ltd and Sing Song Ltd.
Note: you are not required to prepare the consolidationworksheet and the consolidated financial statements.
