Example: How to Consolidate

HowToConsolidateIFRS

HowToConsolidateIFRS

Let’s be more practical today and learn some advanced accounting techniques.

After summaries of standards related to consolidation and group accounts, I’d like to show you how to prepare consolidated financial statements step by step.

I’ll do it on a case study, with explaining what I do and why. If you don’t like reading, you can skip to the end of this article and watch my video.

If you’d like to revise a theory first, then please read my summary of IFRS 3 Business Combinations and IFRS 10 Consolidated Financial Statements, both of them contain video in the end.

What’s the situation?

Here’s the question:

Mommy Corp has owned 80% shares of Baby Ltd since Baby’s incorporation.

Below there are statements of financial positions of both Mommy and Baby at 31 December 20X4.

Prepare consolidated statement of financial position of Mommy Group as at 31 December 20X4. Measure NCI at its proportionate share of Baby’s net assets.

Please note here that in the above statements of financial position, all assets are with “+” and all liabilities are with “-“. I use it this way because for me it’s easier to verify and identify mistakes, but it’s up to you.

 

3 Steps in Consolidation Procedures

I have described the consolidation procedures and their 3-step process in my previous article with the summary of IFRS 10 Consolidated financial statements, but let me repeat it here and follow these steps:

  1. Combine like items of assets, liabilities, equity, income, expenses and cash flows of the parent with those of its subsidiaries;
  2. Offset (eliminate):
    • the carrying amount of the parent’s investment in each subsidiary; and
    • the parent’s portion of equity of each subsidiary;
  3. Eliminate in full intragroup assets and liabilities, equity, income, expenses and cash flows relating to transactions between entities of the group.

 

Step 1: Combine

After you make sure that all subsidiary’s assets and liabilities are stated at fair values and all the other conditions are met, you can combine, or add up like items.

It’s very easy when a parent (Mommy) and a subsidiary (Baby) use the same format of the statement of financial position – you just add Mommy’s PPE and Baby’s PPE, Mommy’s cash and Baby’s cash balance, etc.

Special For You! Have you already checked out the  IFRS Kit ? It’s a full IFRS learning package with more than 40 hours of private video tutorials, more than 140 IFRS case studies solved in Excel, more than 180 pages of handouts and many bonuses included. If you take action today and subscribe to the IFRS Kit, you’ll get it at discount! Click here to check it out!
 
In reality, companies use their own format for presenting their financial position and therefore it can be difficult to combine. That’s exactly WHY so many groups use their “consolidation packages” and subsidiaries’ accountants must fill them up along with preparing own financial statements.

Therefore, when a group controller calls you every five minutes to remind you the consolidation package, you’ll know why!

In our case study, combined numbers looks as follows:

Of course, there are some strange and redundant numbers, for example both Mommy’s and Baby’s share capital, but we haven’t finished yet!

Step 2: Eliminate

After combining like items, we need to offset (eliminate):

and of course, recognize any non-controlling interest and goodwill.

So let’s proceed. The first two items are easy – just remove Mommy’s investment into Baby (CU – 70 000), and remove Baby’s share capital in full (CU + 80 000).

As there is some non-controlling interest of 20% (please see below), you need to remove its share in Baby’s post-acquisition retained earnings of CU 9 000 (20%*CU 45 000).

Wait a second – how do we know that all Baby’s reserves (retained earnings) of CU 45 000 are post-acquisition?

Well, the question says that Mommy has owned Baby’s shares since its incorporation, therefore full Baby’s retained earnings are post-acquisition.

Be careful here, because you absolutely need to differentiate pre-acquisition retained earnings from post-acquisition retained earnings, but here, we’re not going to complicate the things.

Then we need to recognize any non-controlling interest and goodwill.

Non-controlling interest at 31 December 20X4

Mommy has owned 80% of Baby’s share and therefore, non-controlling interest owns remaining 20% of Baby’s net assets.

The question asks to measure non-controlling interest at proportionate share on Baby’s net assets, so here’s how it looks like at the end of the reporting period:

Baby’s net assets are CU 125 000 as at 31 December 20X4, including Baby’s share capital of CU 80 000 and Baby’s post-acquisition reserves of CU 45 000.

Non-controlling interest at 31 December 20X4 is 20% of Baby’s net assets of CU 125 000, which is CU 25 000. Recognize it with minus, as we are crediting equity with non-controlling interest.

Initial recognition of goodwill

There might be some goodwill arisen on initial recognition. If you’d like to learn more about goodwill, please refer to the article about IFRS 3 Business Combinations.

Let’s calculate it. Please don’t forget that we calculate goodwill based on numbers on acquisition, not on 31 December 20X4.

The goodwill is calculated as:

Goodwill acquired in a business combination comes to CU 6 000 (70 000 + 16 000 – 80 000).

The elimination entry looks as follows (sign “+” indicates a debit entry; sign “-“ indicates a credit entry):

Description Amount Debit Credit
Remove Mommy’s investment in Baby -70 000 FP – Investment in Baby
Remove Baby’s share capital in full +80 000 FP – Baby’s share capital
Remove 20% (NCI) of Baby’s post-acquisition retained earnings +9 000 FP – Retained earnings
Recognize non-controlling interest on 31 December 20X4 -25 000 FP – Non-controlling interest
Recognize goodwill acquired in a business combination +6 000 FP – Intangible assets (goodwill)
Check 0

I have transferred this journal entry into our consolidation worksheet and it looks as follows:

 

Eliminate Intragroup Transactions

Parents and subsidiaries trade with each other very often.

However, when you look at both parent and subsidiary as at 1 company, which is the purpose of consolidation, then you find out that there’s no transaction at all.

In other words, group has not performed any transaction from the view of some external user.

Therefore you need to eliminate all transactions happening within the group, between a parent and its subsidiaries.

Looking to above individual statements of financial position of Mommy and Baby you see that Mommy has a receivable to Baby of CU 8 000 and Baby has a payable to Mommy of CU 8 000. Perhaps these 2 items relate to the same transaction between them and we need to eliminate them, by debiting payables and crediting receivables:

Final steps

After we have completed all steps or consolidation procedures, we can add up all the combined numbers with our adjustments and thus we arrive at consolidated statement of financial position.

You can revise all the steps and formulas in Excel file that you can download at the end of this article.

Here’s how it looks like:

Please note the following facts:

 

Exam-style consolidation

I know that many of you prepare for your exams and this is NOT the way how you learned consolidation during exam preparation courses.

OK, I understand.

I prefer this way of making consolidation by far, because here, you go systematically, step by step. You can deal with each adjustment in a separate column and as a result, your numbers will always balance. You will never forget anything.

The “exam-style” of making consolidated financial statements is good and easy when there are just a few issues or complications.

Special For You! Have you already checked out the  IFRS Kit ? It’s a full IFRS learning package with more than 40 hours of private video tutorials, more than 140 IFRS case studies solved in Excel, more than 180 pages of handouts and many bonuses included. If you take action today and subscribe to the IFRS Kit, you’ll get it at discount! Click here to check it out!
 
But when you need to deal with more complex situations, then you can forget or omit the things very easily. Trust me, I did it too.

However, to make you happy, you can find the same case study solved “by the exam-style” in the attached excel file that you can download in the end of this article.

Is consolidation really easy?

Sometimes.

But in most cases, there is lots of issues or circumstances that you need to take into account and exactly their significance and amount makes it all difficult.

What issues? For example:

I can go on and on, but I don’t want to discourage you. However, if you need to know more about all these issues, I have covered them fully in my premium learning package the IFRS Kit, so please check out if interested.

DOWNLOAD EXCEL FILE HERE

Please watch the video here:

Further reading: Here’s the example of consolidation where a subsidiary has different functional currency than its parent. You’ll learn how to translate the subsidiary’s financial statements.

Here, you can learn the opposite process – disposal of subsidiary (deconsolidation).

If you like this example and explanations, please help me spread a word about it and share it with your friends. Thank you!

Related posts

IFRS 17 Example: Initial Measurement of Insurance Contracts

by Silvia
9 months ago

IFRS 9 Hedge accounting example: why and how to do it

by Silvia
7 months ago

How to Prepare Statement of Changes in Equity under IFRS 18 (with excel and video)

by Silvia
5 months ago
Exit mobile version