200109 Corporate Accounting Systems
Consolidated Financial Statements with Non-Controlling Interests
Spring 2015
INSTRUCTIONS
1. The assignment is to be submitted as an individual attempt. It must be prepared using Excel spreadsheet and be entirely your own work from this semester only – i.e. do not use or copy any file, in whole or in part, from any previous semester or from any other person. Each student must individually create a new excel file for this assignment and use their student number as the file name.
2. The assignment cover sheet and marking guide can be found as the last two pages of this document. Print these pages and complete the appropriate details. Use the marking guide sheet to see what is expected and how your work will be marked. Significant emphasis is placed on the correctness of the journal entries so ensure you spend adequate time on these. Review your work before submission and consider how well have met the expected standards (performance levels) for the criteria identified.
3. Your submission needs to be printed on A4 paper, single-sided, and the pages must be stapled at the top left hand corner only. Do not bind your assignment, nor put it in a folder or a plastic sleeve. The first page must be the completed and signed cover sheet and the last page should be the marking sheet with your student ID and name shown. The marker will use the marking sheet to calculate your assignment result and provide you with feedback on the standard you achieved against each of the criteria. Assignments which do not have these two completed sheets attached will not be accepted.
4. The printed assignment is to be submitted to your tutor during the first 10 minutes of your usual tutorial class in Week 11 beginning 28 September 2015. Submissions made during the tutorial, but after the 10 minute deadline, will be penalised by the deduction of 1 mark. Assignments not submitted at the registered tutorial class will be regarded as “late”. Students will need to contact the unit coordinator about the process for late submission, if necessary. All late submissions will be penalised as per UWS policy – a deduction of 2 marks (being, 10% of the possible mark) for each day, or part day, late. Submissions will not be accepted by email. If you cannot attend at your normal tutorial time you need to either send it along with a fellow classmate or personally hand it to your tutor before the class in which it is due - you would need to make arrangements directly with them about organising this.
5. After handing in the printed copy, the excel file must also be uploaded to vUWS by 5pm on Friday 2nd October 2015 at the latest. Further instructions on this process will be provided on vUWS closer to the due date. The excel file MUST EXACTLY MATCH the printed version and not be modified after the submitted version was printed. Uploading a file that doesn’t match exactly, or failing to upload the excel file on time, will result in a significant penalty! The file will be checked against other students’ submissions for potential plagiarism.
6. Marks will be lost for poor quality presentation, for incorrect work, and for missing work. The presentation of the financial statements must follow the format of the examples and end-of-chapter exercise in chapter 29 of the textbook.
7. Staff will not assist students with their answers, nor review draft answers to confirm if students are “on the right track” or not. Any queries about the requirements of the assignment must be directed to the Unit Coordinator only, not to other teaching staff.
8. All students will be required to self-mark their assignment and submit their marking sheet with their hard copy failure to do so will result in a 2 mark deduction to their overall result.

QUESTION
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.
THE FOLLOWING EVENTS OCCURRED:
During the year ended 30 June 2013:
1. On 1 September 2012 Adam Ltd created a group entity when it purchased 70% of the issued capital of Eve Ltd. On acquisition, Eve’s Ltd’s accounts showed: Share capital $200,000 and Retained earnings $46,000. All assets and liabilities appearing in Eve Ltd’s financial statements were fairly valued, except:
• One of their blocks of land was recorded at $50,000 when its fair value was judged by the group to be $110,000. During the following financial year this land was sold for $140,000 cash.
• An item of plant was undervalued by $40,000. At that time it had a remaining life of 5 years and accumulated depreciation of $30,000. The plant is still an asset of Eve Ltd at 30 June 2015.
• A contingent liability relating to an unsettled legal claim with a fair value of $50,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 Eve Ltd sold an item of plant to Adam Ltd for $50,000. The plant had cost $54,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 Adam Ltd at 30 June 2015.
3. During the year Adam Ltd made sales of inventory to Eve Ltd of $72,000. The inventory balance of Eve Ltd at the end of the year included stock of $62,000 acquired from Adam Ltd.
4. Adam Ltd declared and paid dividends of $80,000 for the year. Eve Ltd did not declare or pay any dividends for the year.
During the year ended 30 June 2015:
5. On 1 November 2014 Adam Ltd sold an item of plant to Eve Ltd for $80,000 when its carrying value in Adam’s books on that date was $109,500 (original cost $182,500 and original estimated life of 5 years). The plant is still an asset of Eve Ltd at 30 June 2015.
6. During the year Eve Ltd made sales of inventory to Adam Ltd of $66,600. The inventory balance of Adam Ltd at the end of the year included stock of $33,400 acquired from Eve Ltd.
7. The management of Adam Ltd believes that the goodwill acquired on acquisition of Eve Ltd was impaired by $3,000 in the current year. This is in addition to a total of $5,000 of impairment in previous years.
8. Adam Ltd charged management fees to Eve Ltd.
9. Dividends were declared/paid by both companies.
10. Non-controlling interests in Eve 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.
• Adam 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) Non-controlling interests are measured at fair value;
(iii) Intragroup sales of inventory to be at a selling price of cost plus a mark-up of 40%;
(iv) Plant is depreciated using the straight-line method with no residual value. For part-years, depreciation is to be calculated on the number of days the asset is held in the relevant year, with the day of acquisition counting as one day while the day of disposal does not count; and
(v) 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.
NOTE:
• You MUST number your journal entries and present them in the order as they relate to the number given for each “event”. Where more than one journal is needed for an “event” to be completely accounted for add the letters a,b,c,…etc to them as necessary. [For example, if three separate journal entries are required to fully record the information detailed in point number 1, then the first journal will be 1a and the second is to be 1b and the third 1c.] Short narrations are expected for each journal entry. Marks will be lost if journals are not presented in a clear and professional manner (i.e. poor or unclear presentation can include showing the debit entry on one page but the credit entry on another, or not clearly distinguishing between debit and credit entries).
• The required statements for both the group and the parent company are: the statement of comprehensive income, statement of financial position, and statement of changes in equity. Follow the formats shown in Chapter 29 of the textbook. Notes to the statements are not required. Marks will be lost if statements are not presented in a clear and professional manner (i.e. poor or unclear presentation can include splitting the reports over two pages, so start each statement on a new page!).
• You may “cut and paste” the financial information on the next page into your excel file, but no other information is to be copied into your file from anywhere else.
• You are expected to use at least the basic formula functions in Excel when preparing worksheets and financial statements (i.e. use Excel formulas to add totals and sub-totals etc, rather than calculating values manually and then just typing them in to the spreadsheet!).
• This is the final unit in the accounting major where you will have to produce complex journal entries and financial reports at a professional level. Therefore, a very high standard is expected. Approach it as if you are preparing it for your employer. The reports cannot be late for the board meeting and the directors carefully review all of the information you give them. They pay you well, but they expect quality work. It needs to be technically correct and presented well, otherwise you will need to look for another job!!!

AT 30 JUNE 2015 ADAM LTD EVE LTD
$ $
INCOME STATEMENTS
Sales revenue 2,150,123 667,000
Cost of goods sold 1,212,000 400,200
Gross profit 938,123 266,800
Other income
Management fee revenue 24,000 -
Dividend revenue 104,000 -
Expenses
Depreciation expense -182000 -47,000
Management fee expense - -24,000
Loss on sale of asset -29,500 -
Other expenses -547,012 -82,100
Profit before tax 307,611 113,700
Income tax expense -32,020 -34,110
Profit for the year after tax 275,591 79,590
Retained earnings at start of year 192,400 108,560
Dividend paid/declared -75,000 -73,200
Retained earnings at year end 392,991 114,950

BALANCE SHEETS
Equity
Share capital 500,000 200,000
Retained earnings 392,991 114,950
Current Liabilities
Accounts payable 212,360 218,330
Income tax payable 14,710 38,120
Dividends payable 27,500 39,600
Non-Current Liabilities
Bank Loans 670,000 620,000
Provision for employee benefits 31,200 12,300
Deferred tax liability 7,100 -
1,855,861 1,243,300
Current Assets
Accounts receivable 277,421 104,000
Less: Allowance for doubtful debts -27,000 -10,400
Dividends receivable 54,860 -
Inventory 108,300 101,200
Non-Current Assets
Land and buildings 820,000 780,000
Plant – at cost 445,600 402,100
Accumulated depreciation – plant -172,300 -135,400
Deferred tax asset - 1,800
Shares in Eden Pty Ltd 48,980 -
Investment in Eve Ltd 300,000 -
1,855,861 1,243,300

Assignment Cover Sheet
School of Business
Student name:

Student number:

Unit name and number:

200109 CORPORATE ACCOUNTING SYSTEMS
Tutorial day and time:

Tutor:

Title of assignment:

CONSOLIDATION WITH NON-CONTROLLING INTERESTS
Date due (in Week 10):

Date submitted:

Campus of enrolment:

BANKSTOWN / CAMPBELLTOWN / PARRAMATTA (circle one)
Declaration:
• I prepared this assignment using Excel and I hold a copy of the file if the printed original is lost or damaged or if I am required to submit the file for plagiarism checking.
• I hereby certify that no part of this assignment has been copied from any other student’s work or from any other source except where due acknowledgement is made in the assignment.
• No part of the assignment has been written or produced for me by any other person.
• I am aware that this work may be compared to work submitted by other students studying this unit this semester for the purpose of detecting possible plagiarism/collusion.
• I am aware that this work may be reproduced and submitted to plagiarism detection programs for the purpose of detecting possible plagiarism (which may retain a copy on its database for future plagiarism checking).
Signature:______________________________________
Note: An examiner or lecturer/tutor has the right to not mark this assignment if the above declaration has not been signed.
Plagiarism, Cheating & Collusion
Plagiarism, cheating or collusion is regarded as a serious breach of the University's academic standards. Students must carefully read the Academic Rules on Plagiarism, Cheating & Collusion. Refer to the School of Accounting Handbook for further details
RULES WILL BE STRICTLY ENFORCED

200109 CORPORATE ACCOUNTING SYSTEMS SELF -MARKED ASSIGNMENT MARKING CRITERIA & STANDARDS – SPRING 2015
CRITERIA UNSATISFACTORY BELOW EXPECTATIONS MEETS MINIMUM EXPECTATIONS FOR A PASS EXCEEDS MINIMUM EXPECTATIONS SIGNIFICANTLY EXCEEDS EXPECTATIONS
A. Journal entries:
Correctness and
Completeness
of journals Four+ events not correctly recorded and/or missing and/or included incorrectly
? 1 mark Three events not correctly recorded and/or missing and/or included incorrectly
? 3 marks Two events not correctly recorded and/or missing and/or included incorrectly
? 5 marks One event not correctly recorded and/or missing and/or included incorrectly
? 7 marks Every required journal is correct, with none missing or included incorrectly
? 9 marks
Presentation
Numbering
Narrations
of journals Three or more journals are not presented clearly and/or not complete and/or not numbered correctly
? 0 marks One or two journals not presented clearly and/or not complete and/or not numbered correctly
? ½ mark All journals are presented clearly and numbered correctly. All narrations are complete and informative
? 1 mark
B. Consolidation Worksheet and Non-Controlling Interest Calculation:
Non-Controlling Interest Calculation Four+ errors and/or total does not agree to the Balance Sheet
? 0 marks Three errors but total agrees to the Balance Sheet
? ½ mark Two errors but total agrees to the Balance Sheet
? 1½ marks One error but total agrees to the Balance Sheet
? 2½ marks Presented well, no errors and agrees to the Balance Sheet
? 3 marks
Consolidation Worksheet Poor presentation and/or not balanced due to errors and/or missing entries
? 0 marks Not clearly presented but does balance.
? 1 mark Clearly presented. No errors and/or missing entries
? 2 marks
C. Consolidated Financial Statements
Presentation of Comprehensive Income Statements & Balance Sheets
(for both Group and Parent) Poor presentation and/or more than three errors and/or missing headings or amounts
? 0 marks Not acceptably presented and/or three errors and/or missing headings or amounts
? ½ mark Acceptably presented, but with two errors and/or missing headings or amounts
? 1½ marks Acceptably presented, but with one error and/or missing heading or amount
? 2 marks Correctly presented. No errors and/or missing headings or amounts
? 3 marks
Statements of Changes in Equity
(for both Group and Parent) One or more errors and/or does not agree to the Balance Sheet
? 0 marks Could be presented more clearly but agrees to the Balance Sheet
? 1½ marks Clearly presented and agrees to the Balance Sheet
? 2 marks
Deductions: 1. Late submission of printed or electronic version ? -10% per day 2. Electronic version not same as printed version ? -50%
STUDENT ID: STUDENT NAME: FINAL MARK: / 20
[NOTE: Errors flowing from earlier incorrect journals, etc will not be treated as further errors]
200109 CORPORATE ACCOUNTING SYSTEMS ASSIGNMENT MARKING CRITERIA & STANDARDS – SPRING 2015
CRITERIA UNSATISFACTORY BELOW EXPECTATIONS MEETS MINIMUM EXPECTATIONS FOR A PASS EXCEEDS MINIMUM EXPECTATIONS SIGNIFICANTLY EXCEEDS EXPECTATIONS
D. Journal entries:
Correctness and
Completeness
of journals Four+ events not correctly recorded and/or missing and/or included incorrectly
? 1 mark Three events not correctly recorded and/or missing and/or included incorrectly
? 3 marks Two events not correctly recorded and/or missing and/or included incorrectly
? 5 marks One event not correctly recorded and/or missing and/or included incorrectly
? 7 marks Every required journal is correct, with none missing or included incorrectly
? 9 marks
Presentation
Numbering
Narrations
of journals Three or more journals are not presented clearly and/or not complete and/or not numbered correctly
? 0 marks One or two journals not presented clearly and/or not complete and/or not numbered correctly
? ½ mark All journals are presented clearly and numbered correctly. All narrations are complete and informative
? 1 mark
E. Consolidation Worksheet and Non-Controlling Interest Calculation:
Non-Controlling Interest Calculation Four+ errors and/or total does not agree to the Balance Sheet
? 0 marks Three errors but total agrees to the Balance Sheet
? ½ mark Two errors but total agrees to the Balance Sheet
? 1½ marks One error but total agrees to the Balance Sheet
? 2½ marks Presented well, no errors and agrees to the Balance Sheet
? 3 marks
Consolidation Worksheet Poor presentation and/or not balanced due to errors and/or missing entries
? 0 marks Not clearly presented but does balance.
? 1 mark Clearly presented. No errors and/or missing entries
? 2 marks
F. Consolidated Financial Statements
Presentation of Comprehensive Income Statements & Balance Sheets
(for both Group and Parent) Poor presentation and/or more than three errors and/or missing headings or amounts
? 0 marks Not acceptably presented and/or three errors and/or missing headings or amounts
? ½ mark Acceptably presented, but with two errors and/or missing headings or amounts
? 1½ marks Acceptably presented, but with one error and/or missing heading or amount
? 2 marks Correctly presented. No errors and/or missing headings or amounts
? 3 marks
Statements of Changes in Equity
(for both Group and Parent) One or more errors and/or does not agree to the Balance Sheet
? 0 marks Could be presented more clearly but agrees to the Balance Sheet
? 1½ marks Clearly presented and agrees to the Balance Sheet
? 2 marks
Deductions: 1. Late submission of printed or electronic version ? -10% per day 2. Electronic version not same as printed version ? -50% 3. Unmarked ? -2
STUDENT ID: STUDENT NAME: FINAL MARK: / 20
[NOTE: Errors flowing from earlier incorrect journals, etc will not be treated as further errors]