Using the information below and on the next two pages, prepare the following as at 30th June 2015:

PART A: Consolidation adjustment/elimination journal entries that are required at the above financial year end date (i.e. for one year only); and

PART B: A detailed calculation of non-controlling interest balance and consolidation worksheet; and

PART C: Consolidated financial statements and statements of changes in equity for both the the group and parent.

ADDITIONAL INFORMATION:

The company tax rate is currently 30% and it has been this rate for many years.

Lian Ltd has the following accounting policies for the group:

(i) Revaluation adjustments on acquisition are to be made on consolidation only, not in the books of any subsidiary;

(ii) Intragroup sales of inventory to be at a selling price of cost plus a mark-up of 30%;

(iii) Plant is depreciated using the straight-line method with no residual value. For part-years, depreciation is to be calculated on the number of months the asset is held in the relevant year.

(iv) All calculated amounts are to be rounded to the nearest whole dollar. Companies in the group do not show cents in any journals, worksheets, or financial statements.

(v) The management of Lian Ltd values any non-controlling interest at the proportionate share of Rose Ltd?s identifiable net assets.

It must be prepared using Excel Using the information below and on the next two pages, prepare the following as at 30th June 2015: PART A: PART B: PART C: Consolidation adjustment/elimination journal entries that are required at the above financial year end date (i.e. for one year only); and A detailed calculation of non-controlling interest balance and consolidation worksheet; and Consolidated financial statements and statements of changes in equity for both the the group and parent. THE FOLLOWING EVENTS OCCURRED: During the year ended 30 June 2013: 1. On 1 September 2012 Lian Ltd created a group entity when it purchased 65% of the issued capital of Rose Ltd. On acquisition, Rose's Ltd's accounts showed: Share capital $200,000 and Retained earnings $46,000. All assets and liabilities appearing in Rose Ltd's financial statements were fairly valued, except: One of their blocks of land was recorded at $40,000 when its fair value was judged by the group to be $90,000. During the following financial year this land was sold for $120,000 cash. An item of plant was undervalued by $30,000. At that time it had a remaining life of 5 years and accumulated depreciation of $20,000. The plant is still an asset of Rose Ltd at 30 June 2015. A contingent liability relating to an unsettled legal claim with a fair value of $60,000 was recorded in the notes to the financial statements. This amount will be tax deductible when paid. The court case is still in progress at 30 June 2015. During the year ended 30 June 2014: 2. On 1 July 2013 Rose Ltd sold an item of plant to Lian Ltd for $60,000. The plant had cost $64,000 when purchased on 31 December 2012. It's expected useful life was originally 5 years and this original estimate is still considered to be valid. The plant is still an asset of Lian Ltd at 30 June 2015. 3. During the year Lian Ltd made sales of inventory to Rose Ltd of $62,000. The inventory balance of Rose Ltd at the end of the year included stock of $52,000 acquired from Lian Ltd. 4. Lian Ltd declared and paid dividends of $70,000 for the year. Rose Ltd did not declare or pay any dividends for the year. During the year ended 30 June 2015: 5. On 1 November 2014 Lian Ltd sold an item of plant to Rose Ltd for $90,000 when its carrying value in Lian's books on that date was $108,000 (original cost $180,000 and original estimated life of 5 years). The plant is still an asset of Rose Ltd at 30 June 2015. 6. During the year Rose Ltd made sales of inventory to Lian Ltd of $44,400. The inventory balance of Lian Ltd at the end of the year included stock of $21,200 acquired from Rose Ltd. 7. The management of Lian Ltd believes that the goodwill acquired on acquisition of Rose Ltd was impaired by $9,000 in the current year. This is in addition to a total of $15,000 of impairment in previous years. 8. Lian Ltd charged management fees to Rose Ltd. 9. Dividends were declared/paid by both companies. 10. Non-controlling interests in Rose Ltd to be recognised. This is the only subsidiary in the group. ADDITIONAL INFORMATION: The company tax rate is currently 30% and it has been this rate for many years. Lian Ltd has the following accounting policies for the group: (i) Revaluation adjustments on acquisition are to be made on consolidation only, not in the books of any subsidiary; (ii) Intragroup sales of inventory to be at a selling price of cost plus a mark-up of 30%; (iii) Plant is depreciated using the straight-line method with no residual value. For part-years, depreciation is to be calculated on the number of months the asset is held in the relevant year. (iv) All calculated amounts are to be rounded to the nearest whole dollar. Companies in the group do not show cents in any journals, worksheets, or financial statements. (v) The management of Lian Ltd values any non-controlling interest at the proportionate share of Rose Ltd's identifiable net assets. AT 30 JUNE 2015 INCOME STATEMENTS Sales revenue Cost of goods sold Gross profit Other income Management fee revenue Dividend revenue Expenses Depreciation expense Management fee expense Loss on sale of asset Other expenses Profit before tax Income tax expense Profit for the year after tax Retained earnings at start of year Dividend paid/declared Retained earnings at year end BALANCE SHEETS Equity Share capital Retained earnings Current Liabilities Accounts payable Income tax payable Dividends payable Non-Current Liabilities Bank Loans Provision for employee benefits Deferred tax liability Current Assets Accounts receivable Less: Allowance for doubtful debts Dividends receivable Inventory Non-Current Assets Land and buildings Plant - at cost Accumulated depreciation - plant Deferred tax asset Shares in Joey Pty Ltd Investment in Rose Ltd LIAN LTD ROSE LTD $ $ 3,230,650 1,934,000 1,296,650 867,000 480,200 386,800 36,000 96,000 - -178000 -18,000 -644,220 588,430 -59,000 529,430 392,400 -125,000 796,830 -41,000 -36,000 -97,010 212,790 -24,110 188,680 178,600 -48,200 319,080 500,000 796,830 200,000 319,080 520,600 24,000 37,000 189,000 18,000 18,000 712,000 45,100 8,200 2,643,730 340,000 11,100 1,095,180 575,300 -56,000 48,000 209,000 205,000 -20,500 104,000 1,060,000 577,470 -189,000 18,960 400,000 2,643,730 502,000 408,480 -105,000 1,200 1,095,180