A Consolidation Model is constructed by combining the financial results of multiple business units into one single model. Typically, the first worksheet of the model is a summary or consolidation view that shows the highest-level figures (monthly and yearly revenues, profits, costs, productivity rate, etc.) in the form of tables, graphs or charts.
An Initial Public Offering (IPO) is the first sale of stocks issued by a company to the public. Prior to an IPO, a company is considered a private company, usually with a small number of investors (founders, friends, families, and business investors such as venture capitalists or angel investors).
Interviewer: What can lead to EPS dilution in an M&A acquisition? Expect to get questions pertaining to Merger Models during Investment Banking interviews. The whole purpose of a merger model is to show clients the impact of an acquisition to the acquirer’s EPS and how the new EPS compares with the status quo.
3) Sum-of-the-parts model. It is also referred to as the break-up analysis. This modeling involves valuation of a company by determining the value of its divisions if they were broken down and spun off or they were acquired by another company. 4) Leveraged Buy Out (LBO) model. Included in the types of Financial model is the LBO Model.
Three-statement financial models can be built in a variety of different layouts and designs. For example, the Income Statement, Balance Sheet, and Statement of Cash Flows can be combined on one excel tab, or each of the three financial statements can occur on separate tabs (i.e., worksheets within a single workbook).