Prepare the consolidated group financial statements and consolidation journal entries.

User Generated

zygxq84

Business Finance

Description

Hi Guys,

I am looking for who can help my assignments.

It is divided two parts.

1. Prepare the consolidated group financial statements. (Phase 1)

2. Prepare consolidation journal entries. (Phase 2)

The questions from Advanced Financial Accounting major.

Please let me know if you have more questions.

I look forward to meet a best person who can solve these tasks.


Unformatted Attachment Preview

Enter your figures here Consolidated ($) Sales Beginning inventory Purchases Ending inventory Cost of goods sold Operating expenses (incl. Interest & Impairment) Operating profit Other income (incl. Interest) Income Tax Net Income Non controlling interest in earnings Opening Retained earnings Dividends paid Closing retained earnings Share capital Non-controlling interest Total equity Accounts Payable Non-current liabilities Deferred tax Total liabilities Total liabilities and equity Cash Accounts Receivable Inventory Other investments Investment in Squash (at Cost) Brand Goodwill (net) Plant (net) Total assets Marks Allocated 0.5 0.5 0.5 0.5 0.5 1.5 2.0 0.5 3.0 3.0 0.5 0.5 3.0 0.5 0.5 3.0 0.5 0.5 0.5 0.5 2.0 2.0 3.0 0.5 30.0 Cost of goods sold Accounts: Sales Beginning inventory Purchases Ending inventory Operating expenses (incl. Interest & Impairment) Other income (incl. Interest) Income Tax Non controlling interest in earnings Opening Retained earnings Dividends paid Closing retained earnings DR #1 CR DR #2 CR Share capital Non-controlling interest Accounts Payable Non-current liabilities Deferred tax Cash Accounts Receivable Inventory Other investments Investment in Squash (at Cost) Brand Goodwill Plant (net) Marks Allocated 1 1 Enter your adjustments in the DR and CR columns below DR #3 CR 1 DR #4a CR 4 DR #4b CR 4 DR #5a CR 4 #5b DR 2 #5b CR 2 DR #6 CR 1 DR #7 CR 2 Total Marks Allocated 20 Subject: Company financial information for group accounts – Additional information on Cost of Goods Sold Date: 4 April 2019 Kia Ora Subsequent to my earlier email to you, I realised that you may need the breakdown of the Cost of goods sold figures I supplied you with for 31 December 2018. Please see below for the additional information: Pumpkin Beginning inventory 120,000 100,000 Purchases 1,640,000 620,000 Ending inventory (160,000) (240,000) Cost of goods sold 1,600,000 480,000 Head of Group Accounting Pumpkin Group Squash ADVANCED FINANCIAL ACCOUNTING Part A (50 marks) Pumpkin Group – Consolidated financial statements Pumpkin Ltd is a large successful agricultural company based in Morrinsville. You are the assistant accountant with the company and have been asked to draft the company’s group accounts. Tom Ato, head of group accounting briefed you as follows and followed up with emailed information for you to work with. Tom has stressed that the company has a staff code of conduct, which requires staff to treat all company information as strictly confidential. The code permits reviewing reference material, conducting research, and discussing and seeking advice about accounting procedures with others but does not allow sharing any financial information with anyone including unauthorised staff. He suggests that similar ethics apply, to those you would have experienced with regard to your university assignments. The emailed information should not be shared with your ex-classmates, the press or on social media. He warned that breaches of this code lead to disciplinary action and immediate dismissal. PHASE 1 Tom Ato emailed the following information: From: Tom Ato Subject: Company financial information for group accounts Date: 4 March 2019 Kia ora, I hope you enjoy this new challenge of drafting the group accounts, here is all the information you need. Consolidation accounting policies The consolidated financial statements incorporate the financial statements of the subsidiary (Squash Limited) of Pumpkin Limited (“Parent”) as at the reporting date. Pumpkin Limited and its subsidiary together are referred to in these financial statements as the “Group” or the consolidated entity. The subsidiary is an entity over which the Parent has control. The Parent controls an entity when it is exposed to, or has rights to, variable returns from its involvement with the entity and has the ability to affect those returns through its power over the entity. The subsidiary is included in the consolidated financial statements using the acquisition method of consolidation. It is fully consolidated from the date on which control is transferred to the Parent. The Group recognises non-controlling interest at its proportionate share of subsidiary net identifiable assets. The Subsidiary, Squash On 31 December 2014, Pumpkin Limited acquired 70% of the shares in Squash Limited. On that date, the equity of Squash Limited comprised: $ Share capital 640,000 Retained earnings 300,000 Equity $940,000 At acquisition, the book value of the assets and liabilities of Squash Limited were considered to be at fair value, except that there were brand names (considered to be part of net identifiable assets) that had a book value of zero and where Pumpkin assessed the fair value to be $120,000. There has been no change to assessed value of these brand names since acquisition. Goodwill impairment At the most recent balance date (31 December 2018), the returns from Squash were not as high as expected. The directors of Pumpkin considered that acquired goodwill had been impaired by $65,000. Tax and Deferred Tax Assume a tax rate of 30% wherever relevant (i.e., for both Phase 1 and Phase 2). Financial statements Income statement for year end 31 December & Balance sheet as at 31 December 2018 Pumpkin Squash Sales Cost of goods sold Operating expenses (incl. Interest & Impairment) Operating profit Other income (incl. Dividends and Interest) (3,200,000) (1,040,000) 1,600,000 480,000 320,000 160,000 (1,280,000) (400,000) (232,000) (16,000) Income Tax 480,000 160,000 Net Income (1,032,000) (256,000) Opening Retained earnings (1,440,000) (320,000) (2,472,000) (576,000) 800,000 144,000 Closing retained earnings (1,672,000) (432,000) Share capital (1,600,000) (640,000) Total equity (3,272,000) (1,072,000) Accounts Payable (800,000) (360,000) Non-current liabilities (800,000) (650,000) Deferred tax (760,000) (30,000) Total liabilities (2,360,000) (1,040,000) Total liabilities and equity (5,632,000) (2,112,000) 80,000 96,000 Accounts Receivable 160,000 240,000 Inventory 160,000 240,000 Other investments 640,000 Dividends paid Cash Investment in Squash (at Cost) 1400,000 Plant (net) 3,192,000 1,536,000 Total assets 5,632,000 2,112,000 Kind regards, TA Phase 1 Required: Prepare the consolidated group financial statements for Pumpkin and Squash as at 31 December 2018, using the “Phase 1” tab on the Excel template provided. PHASE 2 The auditors questioned why there were no consolidation adjustments for intra-group transactions. Tom Ato suggested that all such transactions between group companies are at normal market prices and therefore he thought that no adjustments were necessary. However, the auditors have pointed out that this overstates profits and affected accounts, including consolidated sales (and therefore revenue growth). Normal profit on merchandise sales was 65% for Pumpkin and 60% for Squash. Tom wants to visualise the impact of these adjustments on the consolidated financial statements. He has therefore asked you to provide him with a spreadsheet showing the consolidation adjustments (in journal form) for the following intra-group transactions during 2018: 1. Pumpkin sold Squash merchandise at a price of $230,000 2. Squash sold Pumpkin merchandise at a price of $130,000 3. $23,000 remained owing by Pumpkin at 31 December 2018 for the merchandise sold to it by Squash. 4. Pumpkin’s inventories of merchandise (bought from Squash) were: a. $43,000 at the beginning of 2018, and b. $23,000 at the end of 2018. 5. Squash’s beginning and closing inventories (of merchandise bought from Pumpkin) for 2018 were: a. Beginning: $33,000, and b. Closing: $13,000. 6. The ‘other investment’ on Pumpkin’s balance sheet is actually a 10-year loan to Squash. 7. The terms of the 10-year loan to Squash require 5% annual interest payments. The loan was made on 1 January 2018 and interest was paid on 31 December 2018. Phase 2 Required: Prepare the consolidation journal entries only for the above intragroup transactions for the year ended 31 December 2018. Please use the “Phase 2” tab on the Excel template provided and adhere strictly to the following instructions: a) You will need to choose the most appropriate accounts to which to post each journal adjustment. b) Post a separate numbered journal entry for each numbered piece of information above i.e., your journal entries should be posted to the corresponding columns for the above numbers 1 – 7. For example, you will need to post a separate journal entry (Dr and Cr) for #3 and a separate journal entry (Dr and Cr) for #4a. c) You are only required to prepare journal entries for Phase 2 i.e., Tom does not want you to adjust the Phase 1 figures until he has reviewed and authorised the journal entries. ASSIGNMENT INSTRUCTIONS 1. Assume a tax rate of 30% wherever relevant. 2. Round to the nearest dollar value. 3. Use of template: a) You MUST complete the assignment on this template. b) Only the highlighted cells in the original template will be marked. c) You must NOT delete ANY cell names, as that will result in a loss of marks. Note: If you cut from any cell and paste into a ‘named cell’ the name will be overwritten and lost. d) You may add / insert rows or columns. e) You should NOT delete / remove rows or columns or cells as this may result in the deletion of cell names, which would mean a loss of marks. f) You must not use negative numbers, numbers in brackets, commas or decimal points. g) You may use formulae or numbers in these cells, as long as it results in an absolute number i.e., no negative numbers in the spreadsheet please. h) Where there is a line item in the template, you must input a value even if this value is 0. If you leave a line item blank i.e., leaving a cell blank will not be marked, whereas inputting a value of 0 will be marked.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi there, kindly check on the attached file and let me know if you've got any queries

Enter your figures here

Consolidated ($)
Sales

4,240,000.00

Beginning inventory
Purchases
Ending inventory

220,000.00
2,260,000.00
400,000.00

Cost of goods sold
Operating expenses (incl. Interest & Impairment)
Operating profit

2,080,000.00
545,000.00
1,615,000.00

Other income (incl. Interest)
Income Tax
Net Income
Non controlling interest in earnings
Opening Retained earnings

147,200.00
640,000.00
1,122,200.00
76,800.00
1,454,000.00

Dividends paid
Closing retained earnings

800,000.00
1,699,400.00

Share capital
Non-controlling interest
Total equity

1,600,000.00
210,000.00
1,810,000.00

Accounts Payable
Non-current liabilities
Deferred tax
Total liabilities

1,160,000.00
1,450,000.00
2,481,000.00
3,400,000.00

Total liabilities and equity

6,901,000.00

Cash
Accounts Receivable
Inventory

176,000.00
400,000.00
400,000.00

Other investments
Investment in Squash (at Cost)
Brand
Goodwill (net)
Plant (net)
Total assets

640,000.00
557,000.00
4,728,000.00
6,901,000.00

Marks Allocated
0.5
0.5
0.5
0.5
0.5
1.5

2.0
0.5
3.0
3.0
0.5

0.5
3.0

0.5
0.5
3.0

0.5
0.5
0.5
0.5
2.0
2.0
3.0
0.5
30.0

Cost of
goods
sold

Accounts:
Sales
Beginning inventory
Purchases
Ending inventory
Operating expenses (incl. Interest & Impairmen...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags