
Types of Consolidation Model: Full, Proportionate and Equity Explained
A consolidation model is the method a parent company uses to combine another entity's financial results with its own. There are three types: full consolidation for subsidiaries the parent controls, proportionate consolidation for certain jointly controlled arrangements, and the equity method for associates and joint ventures. In India, Ind AS 110, Ind AS 111 and Ind AS 28 set the rules. In financial modeling, the term also means the Excel workbook that rolls up these statements. This guide explains each type, shows when it applies, works through one example in rupees, and walks you through building a consolidation model in Excel.
What Is a Consolidation Model?
The word comes from the Latin consolidare, "to make firm or solid". In finance it is used in two closely related ways.
Consolidation as an Accounting Method
When one company invests in another, it has to decide how that investment shows up in its own financial statements. The answer depends on how much say the investor has over the other company, not just how many shares it owns.
- If the investor controls the other company, it adds that company's figures line by line.
- If it shares control, it may take only its own share of each line.
- If it only has significant influence, it shows one investment line and its share of profit.
These three treatments are the three types of consolidation model. Together they decide what a group's revenue, assets, debt and profit look like to investors and lenders.
Consolidation Model in Financial Modeling
Analysts also use "consolidation model" for a spreadsheet that combines the financial statements of a parent and its subsidiaries. It removes transactions between group companies, calculates non-controlling interest, and produces one set of group statements. This kind of model is common in M&A work, group budgeting and equity research, and it sits alongside other models analysts build every day (see why companies use financial models).
The 3 Types of Consolidation Model at a Glance
The right method depends on the relationship between the two companies. The table below sums up each one before we look at them in detail.
| Method | Relationship | Typical Stake | Standard (Ind AS / Indian GAAP) | Balance Sheet | Profit and Loss |
|---|---|---|---|---|---|
| Full consolidation | Subsidiary: the parent has control | Usually above 50% of voting rights | Ind AS 110 / AS 21 | 100% of assets and liabilities, with non-controlling interest shown in equity | 100% of income and expenses, with the non-controlling share of profit shown separately |
| Proportionate consolidation | Joint operation (Ind AS 111); jointly controlled entity (AS 27) | Control shared with other parties | Ind AS 111 / AS 27 | The investor's share of each asset and liability | The investor's share of each income and expense line |
| Equity method | Associate (significant influence) or joint venture | Usually 20% to 50% | Ind AS 28 / AS 23 | One line: investment in associate or joint venture | One line: share of profit of associate or joint venture |
The stake ranges are rules of thumb. Under Ind AS, the test is always the substance of the relationship (control, joint control or significant influence), not the percentage alone.
Full Consolidation
Full consolidation is used when the parent controls the other company, which then becomes its subsidiary. The parent adds 100% of the subsidiary's assets, liabilities, income and expenses to its own, even if it owns less than 100% of the shares.
When Full Consolidation Applies
Under Ind AS 110 (the Indian version of IFRS 10), an investor controls an investee when it has all three of the following:
- Power over the investee's relevant activities, such as its operating, financing and investment decisions.
- Exposure to variable returns from the investee, such as dividends, profit shares or changes in the value of its investment.
- The ability to use that power to affect those returns.
Owning more than 50% of the voting rights usually gives control, but not always. An investor with 45% can still have control if the other shareholders are many and scattered. An investor with 60% may lack control if an agreement gives the key decisions to someone else.
Companies that do not follow Ind AS apply AS 21, Consolidated Financial Statements, which uses a simpler ownership-and-board-control test.
How Full Consolidation Works
- Add the statements line by line. The parent's and subsidiary's revenue, expenses, assets and liabilities are added together.
- Eliminate the investment. The parent's "investment in subsidiary" is cancelled against the subsidiary's share capital and reserves at the date of acquisition. Any excess paid over the fair value of net assets becomes goodwill.
- Eliminate intra-group items. Sales, loans, interest, dividends and balances between group companies are removed, along with any profit still sitting in group inventory.
- Show non-controlling interest. The part of the subsidiary the parent does not own is shown as non-controlling interest (NCI) within equity, and the NCI share of profit is shown separately in the P&L.
What Is Non-Controlling Interest?
Non-controlling interest, earlier called minority interest, is the outside shareholders' claim on a subsidiary. If a parent owns 80%, the other 20% belongs to NCI. Under Ind AS 103, NCI at acquisition can be measured either at fair value or at its proportionate share of the subsidiary's identifiable net assets.
Proportionate Consolidation
Proportionate consolidation means the investor adds only its share of each line item of a jointly controlled arrangement. If it holds 50%, it adds 50% of the revenue, 50% of the expenses, 50% of the assets and 50% of the liabilities. No non-controlling interest is shown, because only the investor's own share was added.
Where Proportionate Consolidation Is Still Used
This method has become much narrower over the last decade.
- Indian GAAP (AS 27): Companies that do not follow Ind AS still use proportionate consolidation for interests in jointly controlled entities in their consolidated statements.
- Ind AS 111 and IFRS 11: Joint arrangements are split into two kinds. A joint venture, where the parties have rights to the net assets, must use the equity method. A joint operation, where the parties have direct rights to the assets and obligations for the liabilities, recognises its own share of each asset, liability, income and expense. That gives a similar result to proportionate consolidation.
- US GAAP: Proportionate consolidation is largely not allowed, apart from narrow exceptions such as undivided interests in some extractive and construction activities.
Example of a Joint Arrangement
Two infrastructure companies form an arrangement to build and run a toll road, sharing control 50:50. If each party has direct rights to the road and shares the obligations, it is a joint operation, and each company shows half of the road, half of the debt and half of the toll revenue. If the road sits in a separate company and the parties only have rights to its net assets, it is a joint venture and each uses the equity method.
Equity Method
The equity method is used when the investor has significant influence over a company (an associate) or joint control of a joint venture, but not control. The investment appears as a single line on the balance sheet, and the investor's share of the investee's profit appears as a single line in the P&L.
Significant Influence and the 20% Presumption
Significant influence is the power to take part in a company's financial and operating decisions without controlling them. Under Ind AS 28, holding 20% or more of the voting power is presumed to give significant influence unless it can be clearly shown otherwise. Holding less than 20% is presumed not to, unless there is other evidence.
Common signs of significant influence include:
- A seat on the board of directors
- Taking part in policy decisions, including dividends
- Material transactions between the two companies
- An exchange of senior managers
- Supply of essential technical information
How the Equity Method Works
- The investment is first recorded at cost.
- Each year, the investor adds its share of the investee's profit (or deducts its share of losses). The same amount goes into the investor's P&L as "share of profit of associates".
- Dividends received reduce the carrying amount of the investment. They are not shown as income, because the profit was already counted in step 2.
Companies not on Ind AS apply AS 23, Accounting for Investments in Associates in Consolidated Financial Statements, which follows the same basic approach. Holdings below significant influence are treated as financial assets and, under Ind AS 109, are usually carried at fair value.
Which Consolidation Method Applies?
Ask these questions in order. The first "yes" decides the method.
- Does the investor control the investee on its own? If yes, it is a subsidiary. Use full consolidation (Ind AS 110).
- Is control shared, with key decisions needing the agreement of all parties? If yes, it is a joint arrangement (Ind AS 111). Then:
- Rights to specific assets and obligations for liabilities = joint operation. Recognise your share of each line.
- Rights only to the net assets = joint venture. Use the equity method.
- Does the investor have significant influence (usually 20% or more)? If yes, it is an associate. Use the equity method (Ind AS 28).
- None of the above? It is a financial investment. Carry it at fair value under Ind AS 109.
Under Indian GAAP, the same questions point to AS 21 for subsidiaries, AS 27 (proportionate consolidation) for jointly controlled entities, and AS 23 for associates.
Worked Example: One Company, Three Methods
The same investee looks very different in the investor's statements under each method. Assume S Ltd reports the following for the year (all figures in ₹ crore):
- Revenue 150, expenses 130, profit 20
- Total assets 180, total liabilities 60, net assets 120 at year end
Now look at three investors, each with a different stake and relationship:
- P Ltd owns 80% and controls S Ltd (subsidiary)
- J Ltd shares control 50:50 in a joint operation
- A Ltd owns 30% with significant influence (associate)
| What Gets Added (₹ crore) | Full Consolidation: P Ltd, 80% | Proportionate: J Ltd, 50% | Equity Method: A Ltd, 30% |
|---|---|---|---|
| Revenue | 150 | 75 | 0 |
| Expenses | 130 | 65 | 0 |
| Profit added | 20 (16 to parent, 4 to NCI) | 10 | 6 (one line: share of profit) |
| Assets | 180 | 90 | One investment line |
| Liabilities | 60 | 30 | 0 |
| Non-controlling interest | 24 (20% × 120) | None | None |
Goodwill Under Full Consolidation
Say P Ltd paid ₹90 crore for its 80% when S Ltd's net assets were ₹100 crore, and measured NCI at its share of net assets (20% × ₹100 crore = ₹20 crore).
Goodwill = consideration ₹90 crore + NCI ₹20 crore − net assets ₹100 crore = ₹10 crore
At year end, S Ltd adds ₹180 crore of assets, ₹10 crore of goodwill and ₹60 crore of liabilities, so ₹130 crore of net assets enters the group.
Of that, NCI owns ₹24 crore and P Ltd's shareholders own ₹106 crore, which is the ₹90 crore paid plus their ₹16 crore share of this year's profit.
Equity Method Carrying Amount
If A Ltd paid ₹33 crore for its 30% at the start of the year, its investment rises to ₹33 crore + ₹6 crore = ₹39 crore at year end. If S Ltd then pays a dividend and A Ltd receives ₹2 crore, the investment falls to ₹37 crore and no dividend income is recorded.
What this shows: full consolidation makes the group look much bigger (all ₹150 crore of revenue and ₹60 crore of debt), while the equity method leaves revenue and debt untouched. Analysts comparing companies need to know which method sits behind the numbers, because it changes margins, leverage and return ratios.
How to Build a Consolidation Model in Excel
A good consolidation model keeps each entity's raw numbers separate from the adjustments, so every elimination can be traced and checked. Here is a structure that works for most groups.
Step 1: Set Up the Workbook
Create separate tabs for:
- Inputs: group structure, ownership %, method for each entity, exchange rates
- Entity trial balances: one tab per company, pasted as reported
- Mapping: links each company's ledger accounts to one common chart of accounts
- Adjustments and eliminations: one block per adjustment, each with a short note
- Consolidated statements: P&L, balance sheet and cash flow
- Checks: balance sheet balances, intra-group balances net to zero, NCI reconciles
Step 2: Align Policies, Year-Ends and Currency
Make sure every entity uses the same accounting policies and reporting date. Translate foreign subsidiaries into rupees: assets and liabilities at the closing rate, income and expenses at the transaction-date rate (an average rate is often used as an approximation), with the difference going to a translation reserve.
Step 3: Add Up the Entities
Use SUMIFS on the mapped accounts to build an aggregate column. For a proportionate-type interest, multiply that entity's lines by the ownership %.
Step 4: Eliminate Intra-Group Transactions
Remove sales, purchases, loans, interest and dividends between group companies. For example, if P Ltd sold goods to S Ltd for ₹10 crore, cut ₹10 crore from both group revenue and group cost of sales. If S Ltd still holds goods carrying ₹2 crore of P Ltd's profit at year end, reduce inventory and profit by ₹2 crore.
Step 5: Eliminate the Investment and Record Goodwill
Cancel the parent's investment against the subsidiary's equity at the acquisition date. Record the difference as goodwill, or as a gain on a bargain purchase if negative.
Step 6: Calculate Non-Controlling Interest
Multiply the subsidiary's net assets and profit by the NCI %. Present NCI within equity and show the profit split between the parent's owners and NCI.
Step 7: Apply the Equity Method to Associates and Joint Ventures
Add the investor's share of profit to the investment line, and subtract dividends received. Keep this outside the line-by-line totals.
Step 8: Run the Checks
The consolidated balance sheet must balance, intra-group receivables and payables must net to zero, and NCI should reconcile from opening to closing. Build these as live flags at the top of the model so an error shows up at once.
If you want to build models like this with guidance, the IIM SKILLS Financial Modelling Course covers three-statement, valuation and M&A modeling in Excel with hands-on case studies.
Consolidation Under US GAAP: VOE vs VIE
If you work with US companies, you will see "consolidation model" used in a different sense. Under ASC 810, US GAAP has two models for deciding whether to consolidate:
| Model | When It Applies | Who Consolidates |
|---|---|---|
| Variable interest entity (VIE) model | Checked first. Applies to entities where voting rights don't show who is really in control, such as some special-purpose vehicles | The primary beneficiary: the party with power over the key activities and exposure to significant losses or benefits |
| Voting interest entity (VOE) model | Applies when the entity is not a VIE | The party holding a controlling financial interest, usually more than 50% of voting shares |
Once consolidation is required under either model, the mechanics are the same as full consolidation. IFRS and Ind AS use a single control model instead of two.
Common Mistakes in Consolidation Models
Most consolidation errors come from adjustments that were missed, not from complex accounting.
- Judging by percentage alone. A 51% stake does not always mean control, and a 45% stake can. Check the substance first.
- Missing unrealised profit. Removing the intra-group sale but not the profit left in closing inventory overstates group profit.
- Eliminating only one side. A receivable cut without the matching payable leaves the balance sheet out of balance.
- Mixing accounting policies. Combining a subsidiary on a different depreciation or revenue policy without adjusting it distorts the group figures.
- Wrong exchange rates. Translating a foreign subsidiary's balance sheet at the average rate instead of the closing rate.
- Forgetting NCI's share of losses. Under Ind AS, losses are shared with NCI even if that makes NCI negative.
- Hard-coding adjustments. Typed-in numbers with no source cannot be checked or updated next period.
Business Consolidation vs Accounting Consolidation
"Consolidation" is also used for business deals and operations, which is a different topic from the accounting methods above.
- Business consolidation is when two or more companies combine, through a merger, an amalgamation or an acquisition. In India, the 2023 merger of HDFC Ltd into HDFC Bank is a well-known example. Sector-wide consolidation happens when larger players absorb smaller ones and the number of competitors falls.
- Operational consolidation means combining functions inside a company, such as merging departments, centralising purchasing or reducing the number of suppliers.
- Accounting consolidation is what happens after a deal: the buyer uses full consolidation, the equity method or proportionate treatment to show the investment in its financial statements.
Business consolidations can bring cost savings, wider reach and stronger bargaining power. They can also bring high integration costs, culture clashes, job losses and scrutiny from the Competition Commission of India when market power rises. Whatever the deal, the accounting method is decided by the control test, not by what the deal is called.
FAQs
What Are the 3 Types of Consolidation?
The three types are full consolidation, proportionate consolidation and the equity method. Full consolidation is for subsidiaries the parent controls. Proportionate consolidation is for certain jointly controlled arrangements. The equity method is for associates and joint ventures.
When Is Proportionate Consolidation Used?
In India it is used under AS 27 by companies that do not follow Ind AS, for jointly controlled entities. Under Ind AS 111 and IFRS 11, a similar line-by-line share is used only for joint operations; joint ventures must use the equity method.
What Is the Difference Between Full Consolidation and the Equity Method?
Full consolidation adds 100% of a subsidiary's revenue, assets and liabilities and shows the outside shareholders' part as non-controlling interest. The equity method adds no revenue or liabilities; it shows one investment line and one line for the investor's share of profit.
Is Consolidation Mandatory in India?
Yes. Section 129(3) of the Companies Act, 2013 requires a company with one or more subsidiaries, associates or joint ventures to prepare consolidated financial statements alongside its standalone statements.
What Is Non-Controlling Interest in Consolidation?
Non-controlling interest is the share of a subsidiary owned by shareholders other than the parent. If the parent owns 80%, the remaining 20% of the subsidiary's net assets and profit is shown as non-controlling interest.
How Do You Build a Consolidation Model in Excel?
Map each entity's trial balance to a common chart of accounts, align policies and currencies, add the entities, eliminate intra-group items and the parent's investment, calculate goodwill and NCI, then build the group statements with balance checks.
Conclusion
There are three types of consolidation model, and the relationship decides which one applies: full consolidation for control, proportionate treatment for joint operations (and jointly controlled entities under AS 27), and the equity method for significant influence and joint ventures. The choice changes how big a group looks, how much debt it shows and how its ratios read, so analysts need to know which method sits behind any set of group accounts.
For finance professionals, understanding these methods is the first step. Building them into a clean, checkable Excel model is the skill employers pay for. To see where these models are used day to day, read who uses financial models, or build your own with the IIM SKILLS Financial Modelling Course.

Seasoned valuation specialist with 10+ years across PwC, TresVista, and Moody's Analytics. Focuses on building institutional-grade models completely from a blank sheet.

Over a decade of hands-on transaction advisory experience with Cube Highways, EY, and Macquarie. Expert in complex multi-currency cash flow forecasting and project feasibility.

Chartered Financial Analyst (CFA) and FMVA certified expert. Leads transaction mandates at Wodehouse Capital Advisors, with prior research tenure at SG Analytics.
Get Course Brochure
Detailed curriculum, placement report & fee structure.
100% Privacy Protected. No Spam Guarantee.



