Learn about the complex process of balance sheet consolidation in finance, which involves incorporating the financial statements of all subsidiaries into the parent company's financial statements. This includes creating a standard-form income statement, balance sheet, and cash flow statement as part of a set of consolidated financial statements.
Key insights
- Consolidation in finance refers to incorporating the financial statements of all subsidiaries into the financial statements of the parent company.
- The process requires the parent company to integrate and combine all its financials.
- To create a consolidated balance sheet, the balance sheet values of the investor and investee are added together.
- After adding the balance sheet values, transaction effects are applied.
- Consolidation results in a standard-form income statement, balance sheet, and cash flow statement.
- An example of balance sheet consolidation in Excel is provided in the video.
Financial Modeling Essentials
-
Three-Statement Model
Income statement, balance sheet, cash flow — linked.
-
Forecasting Drivers
Revenue: price × quantity. Costs: % of revenue or per-unit.
-
Sensitivity Analysis
Data tables for what-if on key inputs.
-
Returns Analysis
IRR, NPV, payback — investment decision metrics.
Balance Sheet Consolidation
In finance terms, consolidation refers to the incorporation of the financial statements of all subsidiaries into the financial statements of the parent company.
Consolidation of financial statements requires the parent company to integrate and combine all its financials to create a standard-form income statement, balance sheet, and cash flow statement, as part of a set of consolidated financial statements.
In this video we will talk about the Balance Sheet Consolidation.
———————————
To create a consolidated BS we would take the BS values of the investor and investee and add them together. And then apply transaction effects.
We will take a look at the Example of BS Consolidation in Excel in the following video.
Video Transcription:
Full Video Transcript
Understanding Balance Sheet Consolidation
In finance terms, consolidation refers to the incorporation of the financial statements of all subsidiaries into the financial statements of the parent company. Consolidation of financial statements requires the parent company to integrate and combine all its financials to create a standard form income statement, balance sheet, and cash flow statement as part of a set of consolidated financial statements. In this video, we will talk about balance sheet consolidation.
To create a consolidated balance sheet, we would take the balance sheet values of the investor and the investee and add them together, and then apply transaction effects. Transaction effects in this case scenario would be: the shareholders of the investee have been bought out, so we need to zero out the investee's shareholders' equity on consolidation. Secondly, the transaction must be financed, so we need to summarize in the sources and uses of funds table. Last but not least, we need to calculate the premium paid above book amount and allocate component parts: step-ups, step-downs, and goodwill.
Goodwill Calculation for Consolidated Balance Sheets
Let's take a look at goodwill calculation as well, as it's an important part and you need to understand how to assign goodwill for the consolidated balance sheet. Consolidated goodwill would be a sum of investor goodwill and investee goodwill, plus or minus investee goodwill as we zero it out, plus the deal goodwill.
When we're calculating the deal goodwill, we need to take the equity purchase price of the investee and subtract shareholders' equity bought at fair value. Here it has to be only the proportion that has been purchased in terms of percentage. To calculate shareholder equity at fair value, we will take investee shareholder equity at book value, add asset step-ups and liability step-downs, and subtract asset step-downs and liability step-ups. We always step down pre-existing goodwill to zero. Let's take a look at the example of balance sheet consolidation in Excel in the following video.
