Ask Experts Questions for FREE Help !
Ask
    Streidos's Avatar
    Streidos Posts: 2, Reputation: 1
    New Member
     
    #1

    Sep 11, 2009, 06:11 PM
    Consolidated worksheet
    Prefect Ltd acquired all the issued capital of Adent Ltd on 1 July 20X5 for $850,000. At that date the shareholders’ equity of Adent Ltd was:
    $
    Share capital 500,000
    General reserve 150,000
    Retained Earnings 75,000


    At the date of acquisition, Adent Ltd had a declared, but unpaid, dividend for $25,000. This was paid on 28 August 20X5.

    Additional information for the year ended 30 June 20X7:
    (I) Inter company sales:
    • Prefect Ltd to Adent Ltd $15,000
    • Adent Ltd to Prefect Ltd $10,000

    (ii) Unrealised profits in closing inventory as at 30 June 20X7 is $1,000 for goods sold by Adent Ltd to Prefect Ltd and $2,500 for goods sold by Prefect Ltd to Adent Ltd.
    (iii) Unrealised profit in opening inventory for goods sold by Prefect Ltd to Adent Ltd as at 1 July 20X6 is $2,000 and for goods sold by Adent to Prefect is $1,500.
    (iv) Adent Ltd, a management consulting company, provides consulting services to Prefect Ltd. For these services, Prefect Ltd pays a consultancy fee of $30,000 per annum.
    (v) The final dividend of $15,000, declared as at 30 June 20X6, was paid by Adent Ltd in September 20X6. This dividend was paid out of post-acquisition profits.
    (vi) On 1 January 20X7, Prefect Ltd purchased computer equipment from Adent Ltd for $15,000. Adent Ltd made profit on this sale of $2,500. Both companies depreciate computer equipment at 30% per annum.
    (vii) Adent Ltd borrowed funds from Prefect Ltd by issuing 200, 8% Convertible Notes (each with a face value of $100) on 1 July 20X6 to Prefect Ltd. Interest is paid at the end of each quarter (and has been paid for the period ending 30 June 20X7).
    (viii) The directors review the balance of goodwill each year. They agree that: • For the year ended 30 June 20X6, goodwill was impaired by $10,000.
    • For the year ended 30 June 20X7, goodwill is to be impaired by $15,000.
    Consolidation Worksheet 30 June 20x7 Prefect Ltd Adent Ltd

    Sales 1,924,500 605,500
    Less Cost Of Sales
    Inventory 1.7.20x6 87,200 32,000
    Purchases 786,400 215,000
    873,600 247,000
    Inventory 30.6.20x7 81,200 33,000
    Cost of Goods Sold 792,400 214,000

    Gross Profit 1,132,100 391,500

    Add Consultancy Fees received - 30,000
    Gain in Sale of equipment - 2,500
    Dividends Received 27,000 -
    Interest received from Adent Ltd 1,600 -
    1,160,700 424,000
    Less: Expenses – selling expenses 166,000 45,000
    Admin Expenses 711,600 165,000
    Financial Expenses 72,500 12,000

    Total Expenses 950,100 222,000

    Operating Profit before Tax 210,600 202,000
    Less Tax Expenses 63,600 60,600
    Profit After Tax 147,000 141,400

    Retained Earnings 1.7.20x6 291,700 103,600
    Available Appropriation 438,700 245,000
    Appropriations
    Interim Dividend Paid 20,000 12,000
    Final Dividend Declared 35,000 16,000
    Total Appropriations 55,000 28,000
    Retained Earnings 30.6.20x7 383,700 217,000
    Share Capital 1,500,000 500,000
    General Reserve 125,000 150,000
    8% Convertible - 20,000
    Accounts Payable 78,800 28,300
    Dividends Payable 35,000 16,000
    Taxation Payable 15,000 22,800
    2,137,500 954,100

    Property Plant & equip (net) 965,000 545,000
    Computer Equip 15,000
    Shares in Adent Ltd 825,000 -
    8% Convertible Notes in Adent Ltd 20,000 -
    Other non-current assets 149,600 210,100
    Inventory 81,200 33,000
    Other current Assets 96,700 116,000
    Goodwill on Consolidation -
    Accumulated Impairment – goodwill
    2,137,500 954,100
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #2

    Sep 12, 2009, 05:31 AM

    We are NOT allowed to do homework for students.
    Streidos's Avatar
    Streidos Posts: 2, Reputation: 1
    New Member
     
    #3

    Sep 12, 2009, 11:00 PM

    This is an example so I can get my head around it. I will ow blog that your website is useless.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #4

    Sep 13, 2009, 04:13 AM

    The website is obviously not useless or it wouldn't still get so much traffic.

    The difficulty is that you apparently have some rather unrealistic expectations of a site full of people who are volunteering their time because they choose to, while still having lives, families, jobs, etc.

    That's a pretty long problem to just expect some volunteer to do for you, without even seeing any effort on your part to participate in it. You've got like a whole chapter there.
    ttuaimeiapi's Avatar
    ttuaimeiapi Posts: 1, Reputation: 1
    New Member
     
    #5

    Oct 14, 2009, 09:18 AM

    Where can I start to do.?
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #6

    Oct 14, 2009, 10:42 PM
    ttuaimeiapi,

    What you need is a personal tutor.
    You need to become more humble if you need the help of others.
    You start by introducing yourself to this wonderful website.
    You need to explain your present circumstances.
    You do not demand here, you ask nicely and endear yourself with an expert that
    Has plenty of time to devote to you.
    ttuaimeiapi, what is your relationship with STREIDOS.
    You cannot just jump on someone else's cart.
    Start your own questions and make sure they are not homework questions.
    If your questions are homework, explain to us what you do not understand.
    Attempt to do the work.
    We shall try and direct you to the right route.

    ROLCAM

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Consolidated worksheet and journal entries [ 2 Answers ]

CASE STUDY CONSOLIDATION WORKSHEET On 1 July 2007, Mickey Ltd acquired 80% of the shares of Mouse Ltd on an ex div basis. At this date, all the identifiable assets and liabilities of Mouse Ltd were recorded at amounts equal to fair value except for: Carrying Fair Amount Value...

Consolidated Entry's [ 4 Answers ]

King Corp. owns 85% of James Co. King uses the equity method to account for this investment. During 2009, King sells inventory to James for $500,000. The inventory originally cost King $420,000. At 12/31/09, 25% of the goods were still in James' inventory. -Prepare the consolidation Entry TI...

Consolidated Net Income [ 1 Answers ]

On January 1, 2009, Jannison Inc. acquired 90% of Techron Co. by paying $477,00 cash. Techron Co. reported a Common Stock account balance of $140,000 and Retained Earnings of $280,000 at that date. The fair value of Techron Co. was appraised at $530,000. The total annual amortization was $11,000...


View more questions Search